GPMY_PSLP_ED

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPMY_PAYSLIP_ID	Character(18)	VARCHAR2(18) NOT NULL	This field is used to uniquely identify a payslip template.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPMY_ED_SRCH
6	GPMY_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 Default Value: 10
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	GPMY_BSE_COMP_IND	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 Default Value: N
9	GPMY_PCT_COMP_IND	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 Default Value: N
10	GPMY_RTE_COMP_IND	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 Default Value: N
11	GPMY_UNT_COMP_IND	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 Default Value: N
12	GPMY_YTD_AC_AMT	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin num of the year-to-date amount accumulator that will be included on the on-line and hard-copy payslips. Prompt Table: GPMY_ACM_SCH_VW
13	GPMY_YTD_AC_UNITS	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin num of the year-to-date unit accumulator that will be included on the on-line and hard-copy payslips. Prompt Table: GPMY_ACM_SCH_VW
14	GPMY_YTD_ACAMT_IND	Character(1)	VARCHAR2(1) NOT NULL	This field controls the display of YTD amounts on the payslip inquiry Y/N Table Edit Default Value: Y
15	GPMY_YTD_ACUNT_IND	Character(1)	VARCHAR2(1) NOT NULL	This field controls the display of YTD units on the payslip inquiry Y/N Table Edit Default Value: Y