GPSG_NRP_PS5_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	GPSG_PAYSLIP_ID	Character(18)	VARCHAR2(18) NOT NULL	Defines the payslip template ID
3	EFFDT	Date(10)	DATE	Effective Date
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	GPSG_DESC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered). 10=Description 20=Custom 30=Element Name
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
8	GPSG_UNT_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the unit component of an earning or deduction will be included on the on-line and hard-copy payslips.
9	GPSG_RTE_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the rate component of an earning or deduction will be included on the on-line and hard-copy payslips.
10	GPSG_BSE_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the base component of an earning or deduction will be included on the on-line and hard-copy payslips.
11	GPSG_PCT_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the percent component of an earning or deduction will be included on the on-line and hard-copy payslips.
12	GPSG_DATES_COMP_YN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify if the Arrears From and To Dates of an earning or deduction will be included on the payslips under Arrears Section (as part of Itemized payslip).