RBF_CM_VW(SQL View) |
Index Back |
|---|---|
One view to get the CM IDOne view to get the CM ID |
| SELECT C.CM_ID , A.BO_ID_1 , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , C.CM_TYPE_ID FROM PS_BO_REL A , PS_BO_CM_USE B , PS_BO_CM C WHERE A.BO_REL_ID = B.BO_REL_ID AND B.PRIMARY_IND = 'Y' AND C. BO_ID = B.BO_ID AND C.PROFILE_CM_SEQ = B.PROFILE_CM_SEQ AND C.BO_CM_START_DT = B.CM_USE_START_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 2 | BO_ID_1 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 3 | BO_ID_2 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 2 |
| 4 | ROLE_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 5 | CM_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Contact Method Type ID |