GPIN_PSLP_ED

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIN_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: %GP_EDIT_FLD7
6	GPIN_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 Default Value: N
8	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID Prompt Table: GPIN_ENT_PSL_VW
9	GPIN_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 Default Value: N
10	GPIN_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 Default Value: N
11	GPIN_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 Default Value: N
12	GPIN_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 Default Value: N
13	GPIN_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: GPIN_ACM_SCH_VW
14	GPIN_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: GPIN_ACM_SCH_VW
15	GPIN_YTD_AC_AMT_YN	Character(1)	VARCHAR2(1) NOT NULL	This field controls the display of YTD amounts on the payslip inquiry Y/N Table Edit Default Value: N
16	GPIN_YTD_AC_UNT_YN	Character(1)	VARCHAR2(1) NOT NULL	This field controls the display of YTD units on the payslip inquiry Y/N Table Edit Default Value: N