SSFF4200 - Summary Person Transaction Inquiry

Purpose

This form displays a Student Connect user's transactions

SubSystem

Student 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 Student Connect user’s 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 in this form by specifying the transaction application in a query. The Student Connect User’s transactions are then displayed in descending date order.

Alternatively, Administrators can view all the Connect user's 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).

To inquire on a Student Connect or Staff Connect user's activity log, use SSFF4000.

 

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
22.1.0.3 & 23.0.0.2 2448 - Student Connect 2020 Added reference to SSFF4200
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