GPIN_NRP_SCT_VW (SQL View)	Index Back
Non Rules Pkg for Sections GP IND - Payslip Sections defintion

GPIN_NRP_SCT_VW

(SQL View)

Non Rules Pkg for Sections

GP IND - Payslip Sections defintion

SELECT A.GPIN_PAYSLIP_ID , A.EFFDT , A.SEQ_NUM , A.DESCR , A.GPIN_PIN_AC1_NUM+50000000 , A.GPIN_PIN_AC2_NUM+50000000 , A.GPIN_PIN_AC3_NUM+50000000 , A.GPIN_PIN_AC4_NUM+50000000 , A.GPIN_PIN_AC5_NUM+50000000 , A.GPIN_PIN_AC6_NUM+50000000 FROM PS_GPIN_PSLP_SECT A

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