GPAU_PSLP_LBLVW (SQL View)	Index Back
GP AUS - Payslip Acum Lbl GP AUS - Payslip accumulator labels defintion

GPAU_PSLP_LBLVW

(SQL View)

GP AUS - Payslip Acum Lbl

GP AUS - Payslip accumulator labels defintion

SELECT B.OPRID , A.EMPLID , E.GPAU_LBL_ACUM1 , E.GPAU_LBL_ACUM2 , E.GPAU_LBL_ACUM3 , E.GPAU_LBL_ACUM4 , E.GPAU_LBL_ACUM5 , E.GPAU_LBL_ACUM5 FROM PS_JOB_CURR_EFF_VW A , PSOPRDEFN B , PS_GP_PYE_SEG_STAT D , PS_GPAU_PSLP E WHERE A.EMPLID = B.EMPLID AND A.PER_ORG = 'EMP' AND A.EMPL_RCD = D.EMPL_RCD AND A.GP_PAYGROUP = D.GP_PAYGROUP AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GPAU_PSLP E1 WHERE E.GPAU_PAYSLIP_ID = E1.GPAU_PAYSLIP_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 GPAU_LBL_ACUM1 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 1 that will be used for on-line and hard-copy payslips.

4 GPAU_LBL_ACUM2 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 2 that will be used for on-line and hard-copy payslips.

5 GPAU_LBL_ACUM3 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 3 that will be used for on-line and hard-copy payslips.

6 GPAU_LBL_ACUM4 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 4 that will be used for on-line and hard-copy payslips.

7 GPAU_LBL_ACUM5 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 5 that will be used for on-line and hard-copy payslips.

8 GPAU_LBL_ACUM6 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 6 that will be used for on-line and hard-copy payslips.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	GPAU_LBL_ACUM1	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 1 that will be used for on-line and hard-copy payslips.
4	GPAU_LBL_ACUM2	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 2 that will be used for on-line and hard-copy payslips.
5	GPAU_LBL_ACUM3	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 3 that will be used for on-line and hard-copy payslips.
6	GPAU_LBL_ACUM4	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 4 that will be used for on-line and hard-copy payslips.
7	GPAU_LBL_ACUM5	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 5 that will be used for on-line and hard-copy payslips.
8	GPAU_LBL_ACUM6	Character(10)	VARCHAR2(10) NOT NULL	This field will be used to store the label for accumulator 6 that will be used for on-line and hard-copy payslips.