GP_GLGRP_SGPAU (SQL Table)	Index Back
Journal Types Journal types are used to identify transactions for the different journal types. OGIT users require these values for generating the QSP file.

GP_GLGRP_SGPAU

(SQL Table)

Journal Types

Journal types are used to identify transactions for the different journal types. OGIT users require these values for generating the QSP file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 GROUPING_CODE Character(15) VARCHAR2(15) NOT NULL Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes.

4 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	GROUPING_CODE	Character(15)	VARCHAR2(15) NOT NULL	Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes.
4	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