GPAU_STP_UPDVW

(SQL View)
 Index Back

Update Event Level 0 Record

Update Event Level 0 Record

SELECT A.EMPLID , A.BALANCE_GRP_NUM , A.GPAU_TAX_YEAR , A.PAY_ENTITY , A.GP_PAYGROUP , A.CAL_RUN_ID , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.PRC_ORD_TS FROM PS_GPAU_STP_UPDL0 A WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPAU_STP_PAYTBL B WHERE A.EMPLID = B.EMPLID AND A.BALANCE_GRP_NUM = B.BALANCE_GRP_NUM AND A.GPAU_TAX_YEAR = B.GPAU_TAX_YEAR AND A.PAY_ENTITY = B.PAY_ENTITY AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.CAL_ID = B.CAL_ID AND B.PYMT_DT >= ( SELECT MIN(B1.EFFDT) FROM PS_GPAU_STP_REC_MP B1))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.
3 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT_SGPAU

5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GPAU_PYGRP_VW

6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GPAU_UPD_CALRUN

7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

Prompt Table: GPAU_UPD_CALID

8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp