SSFF4200 - Summary Person Transaction Inquiry

Purpose

This form displays an application user's Connect transactions

SubSystem

Connect

Normally Run By Connect Administrator Specialist
Anticipated Frequency As required
Structure  Blocks Person
Self Serve Transaction Log
Self Serve Transaction Log Details

Button

Find Person (ADMF1211)

 

An Administrator can use this function to view an application user’s Connect transactions.

The Prompts and the old and new values from a transaction are displayed in ascending sequence order.

An Administrator can control the transactions displayed by specifying the transaction application in a query. The Application User’s transactions is then displayed in descending date order.

Alternatively, Administrators can view all the users’ transactions regardless of the application. The Transaction Log Details have prompts that reflect their values and the fields Old and New values are displayed.

For more information on Transaction Management, see Maintain Self Serve Applications (SSFF1100) and Receipt Application (SSF_RECEIPT).

 

The Person block contains:

  • Person ID
  • Title
  • Surname
  • Given Names
  • Preferred Name
  • Gender (Pop)
  • Date of Birth
  • Email Address

Button

The Self Serve Transaction Log block contains:

  • Transaction ID
  • Self Serve Application (LOV)
  • Description
  • Receipt Used check box
  • Email Issued check box
  • Email Issued Address
  • Browser Details
  • IP Address
  • Transaction Date
  • Operating System

The Self Serve Transaction Log Details block contains:

  • Prompt
  • Old Value
  • New Value
  • Sequence Number

Rules/Notes:

The Prompt, Old Value and New Value field lengths are 2000 characters to accommodate the maximum size of the database column values.

 

Field Type

Label Field Source Field Type Format Comments

Person ID

PE.PERSON_ID

Text

Number

 

Title

PE.TITLE

Text

Varchar2(10)

 

Surname

PE.SURNAME

Text

Varchar2(30)

 

Given Names

PE.GIVEN_NAMES

Text

Varchar2(40)

 

Preferred Name

PE.PREFERRED_GIVEN_NAME

Text

Varchar2(30)

 

Gender

PE.SEX

Pop list

Varchar2(1)

 

Date Of Birth

PE.BIRTH_DT

Text

Date
DD/MM/YYYY

 

Email Address

PE.EMAIL_ADDR

Text

Varchar2(100)

 
 

SSTL SELF_SERVE_USER_ID

Text

Number

Non-display field

Transaction ID

SSTL TRANSACTION_ID

Text

Number

 

Self Serve Application

SSTL SELF_SERVE_APPLICATION

Text (with LOV)

Varchar2(10)

 

Description

 

Text

Varchar2(60)

Query not allowed. From self_serve_application

Receipt Issued

SSTL RECEIPT_ISSUED_IND

Check box

Varchar2(1)

 

Email Issued

SSTL EMAIL_ISSUED_IND

Check box

Varchar2(1)

 

Email Issued Address

SSTL EMAIL_ISSUED_ADDRESS

Text

Varchar2(500)

 

Browser Details

SSTL BROWSER_DETAILS

Text

Varchar2(100)

 

IP Address

SSTL IP_ADDRESS

Text

Varchar2(50)

 

Transaction Date

SSTL TRANSACTION_TIMESTAMP

Text

Date

 

Operating System

SSTL OPERATING_SYSTEM

Text

Varchar2(100)

 
 

SSTD TRANSACTION_ID

Text

Number

Non-display field

Prompt

SSTD PROMPT

Text

Varchar2(2000)

 

Old Value

SSTD OLD_VALUE

Text

Varchar2(2000)

 

New Value

SSTD NEW_VALUE

Text

Varchar2(2000)

 

Sequence Number

SSTD PARAMETER_SEQUENCE

Text

Number

 
   

Lamp

Varchar(1)

If old_value != new_value then display red ‘*’

 

Last Modified on 15-Aug-2014 1:30 PM

History Information

Release Information Project Change to Document
17.1 2055 - Gender Diversity Changed 'Sex' field label to 'Gender'.
10.1.0.0.0.0 1346 - Extended Fee Functionality Change Prompt, Old Value and New Value field length from 100/1000 to 2000.
10.0.0.0.0.0 1225 - Connect Transaction Management New form