GPAU_PENT_EC_VW

(SQL View)
 Index Back

View to Pick up PayEntity

Used by pay ComSuper/SuperEC run control page for AUS

SELECT DISTINCT A.OPRID ,B.PAY_ENTITY FROM PS_GP_OPR_RULE_PRF A ,PS_GP_CAL_RUN_DTL B WHERE (A.USED_BY = 'A' OR A.COUNTRY = B.COUNTRY)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity