GPMY_NRP_ABS_AD (SQL Table)	Index Back
GP MYS - Payslip Abs Def GP MYS - Payslip absence

GPMY_NRP_ABS_AD

(SQL Table)

GP MYS - Payslip Abs Def

GP MYS - Payslip absence

Related Language Record: GPMY_NRP_LNG_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 GPMY_PAYSLIP_ID Character(18) VARCHAR2(18) NOT NULL This field is used to uniquely identify a payslip template.

3 EFFDT Date(10) DATE Effective Date

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 GPMY_PIN_ENTL_NUM Number(8,0) INTEGER NOT NULL Element name for Pin Number to hold Absence Entitlement

6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

7 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

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

9 GPMY_PIN_AC1_NUM Number(8,0) INTEGER NOT NULL This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.

10 GPMY_PIN_AC2_NUM Number(8,0) INTEGER NOT NULL This field will be used to store the pin number of accumulator 2. This accumulator is used for on-line and hard-copy payslips.

11 GPMY_PIN_AC3_NUM Number(8,0) INTEGER NOT NULL This field will be used to store the pin number of accumulator 3. This accumulator is used for on-line and hard-copy payslips.

#	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	GPMY_PAYSLIP_ID	Character(18)	VARCHAR2(18) NOT NULL	This field is used to uniquely identify a payslip template.
3	EFFDT	Date(10)	DATE	Effective Date
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	GPMY_PIN_ENTL_NUM	Number(8,0)	INTEGER NOT NULL	Element name for Pin Number to hold Absence Entitlement
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
7	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
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	GPMY_PIN_AC1_NUM	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.
10	GPMY_PIN_AC2_NUM	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin number of accumulator 2. This accumulator is used for on-line and hard-copy payslips.
11	GPMY_PIN_AC3_NUM	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin number of accumulator 3. This accumulator is used for on-line and hard-copy payslips.