NAMERA_MC_OPR_NM_VW(SQL View) |
Index Back |
|---|---|
Marketing Center Name SearchMarketing Center operator name search view |
| SELECT C.NAME , B.OPRID , A.RA_MKT_CENTER , A.DESCR50 , C.BO_ID FROM PS_RA_MC_SEARCH_VW A , PS_RA_UD_MC_OPR B , PS_RD_PRSN_OPR_VW C WHERE A.RA_MKT_CENTER=B.RA_MKT_CENTER AND B.OPRID = C.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME |
Character(50) | VARCHAR2(50) NOT NULL | Name |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RA_MKT_CENTER | Character(10) | VARCHAR2(10) NOT NULL | Marketing Center code |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |