Summary Person Transaction Inquiry

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
Sex (Pop)
Date of Birth
Email Address

Button

Find Person (ADMF1211)

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)
Sex	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 17 June, 2008 5:01 PM

History Information

Release Information	Project	Change to Document
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