INSTALL_CDH(SQL Table) |
Index Back |
|---|---|
Install Options for BORM/CDMInstall Option Record for BORM/CDM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RDH_SMART_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
This field specifies whether the system allows to perform Smart Search against CDH.
Y/N Table Edit Default Value: Y |
| 2 | CDH_DUP | Character(4) | VARCHAR2(4) NOT NULL |
This is the field for the Allow Duplication Prevention on/off switch.
N=No Duplicate Prevention NOTI=Enable with Notification Y=Enable Duplicate Prevention Default Value: Y |
| 3 | CDH_DUP_NOTI_ROLE | Character(30) | VARCHAR2(30) NOT NULL |
This is the field for the Allow Duplication Prevention on/off switch.
N=No Y=Yes Prompt Table: PSROLEDEFN |
| 4 | CDH_MRG_PRM_RULE | Character(4) | VARCHAR2(4) NOT NULL |
This is the field for the CDH Merge Field Preference---primary merge rule.
MST=Use Merge-To Object Attributes Default Value: MST |
| 5 | CDH_MRG_SND_RULE | Character(4) | VARCHAR2(4) NOT NULL |
This is the field for the CDH Merge Field Preference---secondary merge rule.
EARL=Use the Earliest Attribute LATE=Use the Latest Attribute Default Value: EARL |
| 6 | CDH_SCM | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates whether SCM is integrated with CRM through CDH. This affects how CRM obtains CUST_ID for a new customer.
There are several possibilities:
o Integrated to CRM through CDH. Obtain CUST_ID from SCM.
o Integrated directly to CRM using EIP. Obtain CUST_ID from SCM.
o Not integrated
Note: For the first choice, although CRM obtaining customer ID from SCM vis CDH, it is still possible that there is still transactional EIP integration between CRM and SCM. Transactional EIP uses the information in the two reference tables (RB_INT_CUSTOMER and RB_INT_CUST_AD) popualated by the customer integration between CRM and SCM configured above. But the existance of Transaction EIP integration does not affect the bahavior of incremental sync.
Y/N Table Edit Default Value: N |
| 7 | RDH_SRC_SYS_CD | Character(30) | VARCHAR2(30) NOT NULL | Source system code for CDH integration |
| 8 | RC_MAINT_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft 1=PeopleSoft / Customer Modified 2=Customer Default Value: 2 |
| 9 | SYSD_APPLICATION01 | Character(1) | VARCHAR2(1) NOT NULL |
PS CRM Core
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 10 | SYSD_APPLICATION02 | Character(1) | VARCHAR2(1) NOT NULL |
Financial Services
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 11 | SYSD_APPLICATION03 | Character(1) | VARCHAR2(1) NOT NULL |
Telecommunications
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 12 | SYSD_APPLICATION04 | Character(1) | VARCHAR2(1) NOT NULL |
Government
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 13 | SYSD_APPLICATION05 | Character(1) | VARCHAR2(1) NOT NULL |
Energy
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 14 | SYSD_APPLICATION06 | Character(1) | VARCHAR2(1) NOT NULL |
Insurance
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 15 | SYSD_APPLICATION07 | Character(1) | VARCHAR2(1) NOT NULL |
High Technology
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 16 | SYSD_APPLICATION08 | Character(1) | VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 17 | SYSD_APPLICATION09 | Character(1) | VARCHAR2(1) NOT NULL |
System Data Field for Application 9. Application 9 is used for Wealth Management.
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 18 | SYSD_APPLICATION10 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application 10
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 19 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 20 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 21 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 22 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 23 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 24 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |