GPAU_BAT_TMP (SQL Table)	Index Back
QSP Batch Header description This is a temporary table created during the QSP File Creation process. It stores the batch reference and description for each journal type.

GPAU_BAT_TMP

(SQL Table)

QSP Batch Header description

This is a temporary table created during the QSP File Creation process. It stores the batch reference and description for each journal type.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 GPAU_JOURNAL_TYPE Character(2) VARCHAR2(2) NOT NULL This field is used to identify the transactions for the different journal types. The QSP file is reported by journal types.
10=Salary
20=Accrual
30=Employee Entitlement
40=Terminated EE's Entitlement
50=Statistical

3 GPAU_BATCH_REF Character(10) VARCHAR2(10) NOT NULL Batch Reference

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPAU_JOURNAL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field is used to identify the transactions for the different journal types. The QSP file is reported by journal types. 10=Salary 20=Accrual 30=Employee Entitlement 40=Terminated EE's Entitlement 50=Statistical
3	GPAU_BATCH_REF	Character(10)	VARCHAR2(10) NOT NULL	Batch Reference
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description