GPGB_CALSOY_VW1

(SQL View)
Index Back

Calendar view for NIC

calendar view based on Paye Entity

SELECT DISTINCT B.PAY_ENTITY ,A.CAL_RUN_ID ,A.DESCR FROM PS_GP_CAL_RUN A , PS_GP_PYENT_OPR_VW B , PS_GP_CAL_RUN_DTL C WHERE A.RUN_FINALIZED_IND <> 'Y' AND A.COUNTRY = 'GBR' AND A.CAL_RUN_ID = C.CAL_RUN_ID AND C.PAY_ENTITY = B.PAY_ENTITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT_OPR_VW

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

Prompt Table: GPGB_CAL_SOY_VW

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