RA_MC_OPRANC_VW(SQL View) |
Index Back |
|---|---|
Operator AncestryMarketing Center Operator Ancestry / Hierarchy By marketing centers, show all oprid of all parents |
| SELECT DISTINCT M.RA_MKT_CENTER , O.OPRID FROM PS_RA_UD_MC_OPR O , PS_RA_MC_ANCESTOR1 M WHERE O.RA_MKT_CENTER = M.RA_PARENT_MKTCTR UNION SELECT DISTINCT M.RA_MKT_CENTER , O.OPRID FROM PS_RA_UD_MC_OPR O , PS_RA_MC_ANCESTOR1 M WHERE O.RA_MKT_CENTER = M.RA_MKT_CENTER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_MKT_CENTER | Character(10) | VARCHAR2(10) NOT NULL | Marketing Center code |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |