PROCESS_INSTANCEBATCH_IDBO_IDCP_ORIG_SYSTEMCP_ORIG_SYS_REF0=Text
1=HTML
IMP_CONTPTS_INT(SQL Table) |
Index Back |
|---|---|
CDH HZ_IMP_CONTACTPTS_INTCDH INTERFACE TABLE - HZ_IMP_CONTACTPTS_INT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BATCH_ID |
Number(15,0) | DECIMAL(15) NOT NULL | CDH INTERFACE TABLE FIELD - BATCH_ID |
| 3 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 4 | CP_ORIG_SYSTEM |
Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - CP_ORIG_SYSTEM |
| 5 | CP_ORIG_SYS_REF |
Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE TABLE FIELD - CP_ORIG_SYSTEM_REFERENCE |
| 6 | PARTY_ORIG_SYSTEM | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_ORIG_SYSTEM |
| 7 | PARTY_ORIG_SYS_REF | Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_ORIG_SYSTEM_REFERENCE |
| 8 | SITE_ORIG_SYSTEM | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - SITE_ORIG_SYSTEM |
| 9 | SITE_ORIG_SYS_REF | Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE TABLE FIELD - SITE_ORIG_SYSTEM_REFERENCE |
| 10 | INSERT_UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | CDH INTERFACE TABLE FIELD - INSERT_UPDATE_FLAG |
| 11 | CONTACT_POINT_TYPE | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - CONTACT_POINT_TYPE |
| 12 | CONTACT_POINT_PURP | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - CONTACT_POINT_PURPOSE |
| 13 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 14 | EMAIL_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Email Format - Either Text or HTML for Online Marketing
0=Text 1=HTML |
| 15 | PHONE_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | CDH INTERFACE TABLE FIELD - PHONE_AREA_CODE |
| 16 | PHONE_COUNTRY_CODE | Character(10) | VARCHAR2(10) NOT NULL | CDH INTERFACE TABLE FIELD - PHONE_COUNTRY_CODE |
| 17 | PHONE_EXTENSION | Character(20) | VARCHAR2(20) NOT NULL | CDH INTERFACE TABLE FIELD - PHONE_EXTENSION |
| 18 | PHONE_LINE_TYPE | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - PHONE_LINE_TYPE |
| 19 | PHONE_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | CDH INTERFACE TABLE FIELD - PHONE_NUMBER |
| 20 | TIMEZONE_CODE | Character(50) | VARCHAR2(50) NOT NULL | CDH INTERFACE TABLE FIELD - TIMEZONE_CODE |
| 21 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 22 | INTERFACE_STATUS | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - INTERFACE_STATUS |
| 23 | CREATED_BY_MODULE | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - CREATED_BY_MODULE |
| 24 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Primary |
| 25 | PARTY_ID | Number(15,0) | DECIMAL(15) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_ID |
| 26 | 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. |