RBTACCTIDRBT_BACT_CM_VW(SQL View) |
Index Back |
|---|---|
Contact Method for Bus ObjectSELECT B.BO_ID , B.PROFILE_CM_SEQ , B.CM_USE_START_DT , CASE WHEN B.CM_USE_END_DT > %CurrentDateIn THEN 'A' ELSE 'I' END , B.CM_USE_ID , B.ROLE_TYPE_ID , B.BO_REL_ID , B.BO_REL_POSITION , B.BO_CM_USE_TYPE , B.CM_USE_START_DT , B.CM_USE_END_DT , B.PRIMARY_IND , B.ROW_LASTMANT_OPRID , B.ROW_LASTMANT_DTTM FROM PS_BO_CM_USE B |
| SELECT T.RBTACCTID ,B.BO_ID , B.PROFILE_CM_SEQ ,B.CM_ID ,C.CM_CONCAT , B.BO_CM_START_DT , B.BO_CM_END_DT FROM PS_BO_CM B , PS_CM C , PS_RBT_ACCOUNT T WHERE B.BO_ID = T.BO_ID AND B.CM_TYPE_ID = 1 AND B.CM_ID = C.CM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTACCTID |
Character(15) | VARCHAR2(15) NOT NULL | Unique service account indentifier |
| 2 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | PROFILE_CM_SEQ | Number(31,0) | DECIMAL(31) NOT NULL | The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables. |
| 4 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 5 | CM_CONCAT | Character(100) | VARCHAR2(100) NOT NULL | Concatenated Contact Method |
| 6 | BO_CM_START_DT | Date(10) | DATE | The date that a Contact Method of a Business Object takes effect. |
| 7 | BO_CM_END_DT | Date(10) | DATE | End date of a Contact Method of a Business Object |