Query 3rd Party Payment Audit Trail {FSATPP-4}

The purpose of the option is to query 3rd party report information generated, by {FSATPP-5}, referred to as 3rd party payment audit trail data. This is a query only option.

The option consist of two blocks namely:

Sort Order of Audit Information
Audit Information

Fields in the option:

Block 1: 3rd Party Payment Audit Trail: Sort Order

The purpose of the first block of this application is to allow the user to enter a sort order for records to be queried in block 2. This is helpful when querying as it allows the user to define the sort order in which records are returned in block 2. It is not mandatory to enter a sort order, except the default sort order and the user can go directly to block 2 to enter and/or execute a query. The sort order is distinct values between 1 and 12 in the different fields below.

Example: the default.

Block 2: 3rd Party Payment Audit Trail: Audit Trail

Field	Type & Length	Description
GL Journal No	A12	General Ledger journal number. This is the 3rd party payable journal number, the income/commission/lost journal number is normally one number more or less. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: List Of Value Query General Ledger Journals {FGLO-22}
GL Sequence	N10	The transaction sequence number of a General Ledger Journal <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: List Of Value Query General Ledger Journals {FGLO-22}
GL Detail Line	N3	The line number of detail for the General Ledger journal and sequence
Student No	N9	The student number selected by the 3rd party Information / Payment report for the rule code used for which a GL journal and audit trail record was created. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: Surname and Name of the student List Of Value Query Student Account {FSAO-7}.
Year Academic	YYYY	The academic year of the transaction <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: List Of Value
Record Type	A2	The 3rd party audit trail record type. Can also be seen as the classifications that was assigned to the record. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: The description of the record type List Of Value Query 3rd Party Record Types {FSAC-22}
New Record Type	A2	This new record type was assigned by the user in option {FSATPP-9}. If this value is not null then the record will be highlighted pink and there will be a new audit trail record for the new record type in field record type, if the Recalculated Date is not null.
Rollback	A1	This rollback indicator was assigned by the user in option {FSATPP-9}. If this value is not null then the record will be highlighted pink. After the Recalculated Date is not null this record will be re-used in future calculations of option {FSATPP-5} and might return to the audit report with a different record type.
Indicator	A1	The basis on records was selected by the 3rd party payment report {FSATPP-5} in respect of which the transaction was generated namely Qualification - Q, Subject - S, Student - T or Awarded – A. If Qualification or Subject then next field will be qualification or subject code
Qualification or Subject Code	N4	The qualification or subject code of the record selected by the 3rd party payment report {FSATPP-5} in respect of which the transaction was generated. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: The description of the qualification or subject. List Of Value General Study Record Enquiry {SSTUDY-21}
Qualification or Subject Sequence	N2	The qualification or subject sequence of the record as assign during registration of the qualification or subject.
3rd Party Report Code	A4	The 3rd party report code and/or rule that was used to defined the report. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: The description of the report code. List Of Value Maintain 3rd Part Report Code {FSATPP-3}
Process Date	DD-MON-YYYY HHMS	The system date and time on which the audit trail record was created. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: List Of Value
GL Transaction Type	N4	The payable GL transaction type used to process the GL transaction. If the next field, Amount, is null then the record does not have a 3rd party payment. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: The description of the transaction type. List Of Value Maintain Transaction Type {FSAO-7}
Amount	N17.2	The 3rd party payment transaction amount. If null then the record does not have a 3rd party payment.
Subject/Curriculum Module	N4	Was the Subject or Curriculum Module rule used to create the record.
Service Request No	A12	If the data was the result of a service request then the service request number will be displayed. No Number <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: List Of Value Student Service Request Detail. {SSTUDS-3}
Service Number	N3	The service number of service request.
Originating Sequence	N10	The originating sequence is a key that linked student registration data to the student account records for the qualification or subject registration. Each qualification and subject registration has a unique sequence value.
Originating Transaction Type	N4	The transaction type of the accrual transaction that was used to create the 3rd party payment. If there was an accrual but it was write-off, no information will be displayed. <List of Values> function is available and can be used in query mode only. Pop Up Menu that has the following: The description of the transaction type. List Of Value Maintain Transaction Type {FSAO-7}
Originating Reference	A10	The reference number of the the accrual transaction that was used.
Originating Subsystem	A2	The originating subsystem code of the accrual transaction that was used. Pop Up Menu that has the following: The description of the subsystem.
User	A8	If new record type or rollback is not null then this value indicate which user maid the change in option {FSATPP-9}.
Change Date	DD-MON-YYYY	If new record type or rollback is not null then this value indicate on what date the change was maid in option {FSATPP-9}.
Recalculated Date	DD-MON-YYYY	If new record type or rollback is not null then this value indicate weather the change that was maid in option {FSATPP-9} was recalculated by {FSATPP-8}.
Version	A1	Valid values are B/A. Was the 3rd party audit record created Before or After the update/change functionality of option {FSATPP-9}.

Example:

Example: The first two records are an example of a changed record of option {FSATPP-9}.

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
17-May-2007	v01.0.0.0	Amanda Nell	t134768	New manual format.
22-Jun-2009	v01.0.0.1	Ernie van den Berg	t157364	Review the manual.