GP_OPN_CLRUN_VW

(SQL View)
 Index Back

Open Calendar Groups

This view selects calendar groups with RUN OPEN IND set to Yes (meaning Identify has been kicked off for at least one stream, but the calendar group is not finalized)

SELECT B.OPRID , A.CAL_RUN_ID , A.DESCR , A.COUNTRY FROM PS_GP_CAL_RUN A , PS_GP_OPR_RULE_PRF B WHERE RUN_OPEN_IND='Y' AND (B.USED_BY= 'A' OR (B.USED_BY = 'C' AND 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country