RG_BO_MGR_NP_VW(SQL View) |
Index Back |
|---|---|
Manager Name and PhoneManger's name and phone view for Change Management |
| SELECT A.BO_ID , A.PERSON_ID , B.SUPERVISOR_ID , M.BO_ID , M.BO_NAME_DISPLAY , P.PHONE , P.EXTENSION FROM PS_RD_PERSON A , PS_RB_WORKER B , PS_RB_WORKER C , PS_RB_PRSN_P_NM_VW M , PS_RG_BO_WRKR_PH_V P WHERE A.PERSON_ID = B.PERSON_ID AND C.PERSON_ID = B.SUPERVISOR_ID AND M.PERSON_ID = C.PERSON_ID AND M.BO_ID = P.BO_ID_WRKR (+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_WRKR | Signed Number(32,0) | DECIMAL(31) NOT NULL | Worker BO_ID for Change Management |
| 2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | SUPERVISOR_ID | Character(15) | VARCHAR2(15) NOT NULL | ID of a worker's supervisor. |
| 4 | BO_ID_MGR | Signed Number(32,0) | DECIMAL(31) NOT NULL | Manager BO_ID for Change Management |
| 5 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 6 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | This field stores the Telephone number. |
| 7 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |