GPBR_CAL_ID_VW

(SQL View)
Index Back

Calendar Run ID,Cal ID Search

The purpose is to retrieve and select the CAL_RUN_ID and CAL_ID for which the end-user wants to create the Flat File

SELECT DISTINCT(A.CAL_RUN_ID) , A.CAL_ID FROM PS_GPBR_PAYMENT A

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