GPAU_PAYENT_VW

(SQL View)
 Index Back

Dynamic View to Pick up PayEnt

This view picks up Pay Entities based on the Cal Group ID entered.

SELECT DISTINCT A.CAL_RUN_ID ,A.PAY_ENTITY FROM PS_GP_CAL_RUN_DTL A

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

Prompt Table: GPAU_FIN_CAL_VW

2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity