DP_ARCH_CONFIGVIEWOPRIDDP_ARCH_CON2_VW(SQL View) |
Index Back |
|---|---|
Configview VW for ArchiveConfigview VW for Archive |
| SELECT DISTINCT(A.DP_CONFIGVIEW) , D.OPRID FROM PS_DP_VIEW1USER_VW A , PS_DPA_CONFIGVIEWS B , PS_DPA_USERVIEWS C , PSOPRDEFN D WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND A.DP_USERID = D.OPRID AND B.PSARCH_ID = C.PSARCH_ID AND B.DP_CONFIGVIEW = C.DP_CONFIGVIEW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_ARCH_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL | DP_ARCH_CONFIGVIEW |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |