GPIN_PSLP_SECT (SQL Table)	Index Back
Payslip Sections India Payslip Sections defintion India

GPIN_PSLP_SECT

(SQL Table)

Payslip Sections India

Payslip Sections defintion India

Parent Record Of GPIN_NRP_ABS_AD GPIN_NRP_ABS_VW GPIN_NRP_ED_AD GPIN_NRP_ED_VW GPIN_PSLP_ABS GPIN_PSLP_ED GPIN_PS_ABS_LAD GPIN_PS_ABS_LNG

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 GPIN_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.

6 GPIN_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.

7 GPIN_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.

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

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

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

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	GPIN_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.
6	GPIN_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.
7	GPIN_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.
8	GPIN_PIN_AC4_NUM	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin number of accumulator 4. This accumulator is used for on-line and hard-copy payslips.
9	GPIN_PIN_AC5_NUM	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin number of accumulator 5. This accumulator is used for on-line and hard-copy payslips.
10	GPIN_PIN_AC6_NUM	Number(8,0)	INTEGER NOT NULL	This field will be used to store the pin number of accumulator 6. This accumulator is used for on-line and hard-copy payslips.