PROCESS_INSTANCEBATCH_IDBO_IDPARTY_ORIG_SYSTEMPARTY_ORIG_SYS_REF1=Single
2=Married
3=Married but Separated
4=Divorced
5=Widow
IMP_PARTIES_INT(SQL Table) |
Index Back |
|---|---|
CDH HZ_IMP_PARTIES_INTCDH INTERFACE TABLE - HZ_IMP_PARTIES_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 | PARTY_ORIG_SYSTEM |
Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_ORIG_SYSTEM |
| 5 | PARTY_ORIG_SYS_REF |
Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_ORIG_SYSTEM_REFERENCE |
| 6 | INTERFACE_STATUS | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - INTERFACE_STATUS |
| 7 | PARTY_ID | Number(15,0) | DECIMAL(15) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_ID |
| 8 | INSERT_UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | CDH INTERFACE TABLE FIELD - INSERT_UPDATE_FLAG |
| 9 | PARTY_TYPE | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_TYPE |
| 10 | PARTY_NUMBER | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - PARTY_NUMBER |
| 11 | SALUTATION | Character(30) | VARCHAR2(30) NOT NULL | Salutation. E.g., Mr., Mrs., Ms., Dr. |
| 12 | ORGANIZATION_NAME | Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE TABLE FIELD - ORGANIZATION_NAME |
| 13 | ORG_NAME_PHONETIC | Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE FIELD - ORGANIZATION_NAME_PHONETIC |
| 14 | ORGANIZATION_TYPE | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - ORGANIZATION_TYPE |
| 15 | BRANCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Branch Flag |
| 16 | HQ_BRANCH_IND | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - HQ_BRANCH_IND |
| 17 | PUBLIC_PRIVATE_OWN | Character(1) | VARCHAR2(1) NOT NULL | CDH INTERFACE FIELD - PUBLIC_PRIVATE_OWNERSHIP_FLAG |
| 18 | BUSINESS_SCOPE | Character(20) | VARCHAR2(20) NOT NULL | CDH INTERFACE TABLE FIELD - BUSINESS_SCOPE |
| 19 | CORPORATION_CLASS | Character(60) | VARCHAR2(60) NOT NULL | CDH INTERFACE TABLE FIELD - CORPORATION_CLASS |
| 20 | PREF_FUNCTIONAL_CU | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - PREF_FUNCTIONAL_CURRENCY |
| 21 | DUNS_NUMBER_C | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - DUNS_NUMBER_C |
| 22 | EMPLOYEES_TOTAL | Number(6,0) | INTEGER NOT NULL | CDH INTERFACE TABLE FIELD - EMPLOYEES_TOTAL |
| 23 | DISPLAYED_DUNS | Character(15) | VARCHAR2(15) NOT NULL | CDH INTERFACE TABLE FIELD - DISPLAYED_DUNS |
| 24 | FISCAL_YEAREND_MON | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - FISCAL_YEAREND_MONTH |
| 25 | TAX_REFERENCE | Character(50) | VARCHAR2(50) NOT NULL | CDH INTERFACE TABLE FIELD - TAX_REFERENCE |
| 26 | JGZZ_FISCAL_CODE | Character(20) | VARCHAR2(20) NOT NULL | CDH INTERFACE TABLE FIELD - JGZZ_FISCAL_CODE |
| 27 | KNOWN_AS | Character(240) | VARCHAR2(240) NOT NULL | CDH INTERFACE TABLE FIELD - KNOWN_AS |
| 28 | KNOWN_AS2 | Character(240) | VARCHAR2(240) NOT NULL | CDH INTERFACE TABLE FIELD - KNOWN_AS2 |
| 29 | KNOWN_AS3 | Character(240) | VARCHAR2(240) NOT NULL | CDH INTERFACE TABLE FIELD - KNOWN_AS3 |
| 30 | KNOWN_AS4 | Character(240) | VARCHAR2(240) NOT NULL | CDH INTERFACE TABLE FIELD - KNOWN_AS4 |
| 31 | KNOWN_AS5 | Character(240) | VARCHAR2(240) NOT NULL | CDH INTERFACE TABLE FIELD - KNOWN_AS5 |
| 32 | LEGAL_STATUS | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - LEGAL_STATUS |
| 33 | YEAR_ESTABLISHED | Number(4,0) | SMALLINT NOT NULL | CDH INTERFACE TABLE FIELD - YEAR_ESTABLISHED |
| 34 | INCORP_YEAR | Number(4,0) | SMALLINT NOT NULL | CDH INTERFACE TABLE FIELD - INCORP_YEAR |
| 35 | MINORITY_OWNED_IND | Character(1) | VARCHAR2(1) NOT NULL | Minority Owned Indicator. |
| 36 | CURR_FY_POTENTIAL | Number(27,3) | DECIMAL(26,3) NOT NULL | CDH INTERFACE TABLE FIELD - CURR_FY_POTENTIAL_REVENUE |
| 37 | PERSON_FIRST_NAME | Character(150) | VARCHAR2(150) NOT NULL | CDH INTERFACE TABLE FIELD - PERSON_FIRST_NAME |
| 38 | PERSON_LAST_NAME | Character(150) | VARCHAR2(150) NOT NULL | CDH INTERFACE TABLE FIELD - PERSON_LAST_NAME |
| 39 | PERSON_MIDDLE_NAME | Character(60) | VARCHAR2(60) NOT NULL | CDH INTERFACE TABLE FIELD - PERSON_MIDDLE_NAME |
| 40 | PERSON_INITIALS | Character(6) | VARCHAR2(6) NOT NULL | CDH INTERFACE TABLE FIELD - PERSON_INITIALS |
| 41 | PERSON_NAME_SUFFIX | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - PERSON_NAME_SUFFIX |
| 42 | PERSON_TITLE | Character(60) | VARCHAR2(60) NOT NULL | CDH INTERFACE TABLE FIELD - PERSON_TITLE |
| 43 | DATE_OF_BIRTH | Date(10) | DATE | CDH INTERFACE TABLE FIELD - DATE_OF_BIRTH |
| 44 | PLACE_OF_BIRTH | Character(60) | VARCHAR2(60) NOT NULL | CDH INTERFACE TABLE FIELD - PLACE_OF_BIRTH |
| 45 | DATE_OF_DEATH | Date(10) | DATE | CDH INTERFACE TABLE FIELD - DATE_OF_DEATH |
| 46 | GENDER30 | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - GENDER 30 CHAR |
| 47 | MARITAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Marital Status
1=Single 2=Married 3=Married but Separated 4=Divorced 5=Widow |
| 48 | PERSON_IDENTIFIER | Character(60) | VARCHAR2(60) NOT NULL | CDH INTERFACE TABLE FIELD - PERSON_IDENTIFIER |
| 49 | CREATED_BY_MODULE | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - CREATED_BY_MODULE |