GPGB_CO_EDST_VW

(SQL View)
Index Back

Update CO End Date View

This view fetches the finalized calender id.

SELECT DISTINCT CAL_RUN_ID FROM PS_GP_CAL_RUN WHERE RUN_FINALIZED_IND='Y' AND COUNTRY ='GBR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id