OPRIDCAL_RUN_IDGPUS_BNDCALC_VW(SQL View) |
Index Back |
|---|---|
Finalized CAL RUNs by OPRIDSearch record limiting rows to finalized calendar groups based on operators country. |
| SELECT B.OPRID , A.CAL_RUN_ID , A.DESCR FROM PS_GP_CAL_RUN A , PS_GP_OPR_RULE_PRF B WHERE A.RUN_FINALIZED_IND = 'Y' AND (B.USED_BY= 'A' OR (B.USED_BY = 'C' AND A.COUNTRY = B.COUNTRY)) AND A.CAL_RUN_ID NOT IN ( SELECT C.CAL_RUN_ID FROM PS_GPUS_BND_RUN C) |
| # | 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 |