OPRIDACV_NDTPL_IDACV_OPR_TPL_VW(SQL View) |
Index Back |
|---|
| SELECT O.OPRID , T.ACV_NDTPL_ID , T.AR_DESCR , T.ACV_NDTPL_ID %Concat '-' %Concat T.AR_DESCR FROM PSOPRDEFN O , PS_ACV_NODE_TEMPL T WHERE (T.ACV_NDTPL_LEVEL IN ('A', 'S') OR (T.ACV_NDTPL_LEVEL = 'U' AND T.ACV_NDTPL_LVL_VAL = O.OPRID) OR (T.ACV_NDTPL_LEVEL = 'R' AND T.ACV_NDTPL_LVL_VAL IN ( SELECT R.ROLENAME FROM PSROLEUSER R WHERE R.ROLEUSER = O.OPRID)) ) AND T.ACTIVE_FLG = 'Y' |
| # | 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 | ACV_NDTPL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node Template ID |
| 3 | AR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |