GPSG_PSLP_ITMZD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPSG_PAYSLIP_ID	Character(18)	VARCHAR2(18) NOT NULL	Defines the payslip template ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	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
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPSG_ED_SRCH
7	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. Y/N Table Edit
8	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. Y/N Table Edit
9	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. Y/N Table Edit
10	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. Y/N Table Edit
11	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). Y/N Table Edit