BO_IDBO_CM_START_DTY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
RDH_CM_Q(SQL Table) |
Index Back |
|---|---|
Future Dated CM QueueThe table queues future dated CM data. When these CM's become current active, they will be picked up by the RDH_BO_CM process which is scheduled to run montly. The process synchronizes the current active contact methods to Oracle Customer Data Hub. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | BO_CM_START_DT |
Date(10) | DATE | The date that a Contact Method of a Business Object takes effect. |
| 3 | RDH_ADDRESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Address flag to indicate if a Business Object has future dated address that must be synchronized to CDH later.
Y/N Table Edit Default Value: N |
| 4 | RDH_PHONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Phone flag to indicate if a Business Object has future dated Phone that must be synchronized to CDH later.
Y/N Table Edit Default Value: N |
| 5 | RDH_EMAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Email flag to indicate if a Business Object has future dated email address that must be synchronized to CDH later.
Y/N Table Edit Default Value: N |
| 6 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 7 | BO_TYPE_ID | Number(6,0) | INTEGER NOT NULL | ID Type |