1. Tables and Views for Sales and Fusion Service
  2. HZ_IMP_ADDTNLPARTYNAMES_T

HZ_IMP_ADDTNLPARTYNAMES_T

The import interface table, HZ_IMP_ADDTNLPARTYNAMES_T, stores information for population into the HZ_ ADDTNL_PARTY_NAMES table.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments Status
ADDTNLPARTYNAME_T_ID NUMBER 18 Unique identifier of the HZ_IMP_ADDTNLPARTYNAMES_T interface record. Internal use only.
INTERFACE_ROW_ID NUMBER 18 Unique identifier of the HZ_IMP_ADDTNLPARTYNAMES_T interface record. Internal use only.
BATCH_ID NUMBER 18 Yes Unique Identifier for a Batch Active
PARTY_ORIG_SYSTEM VARCHAR2 30 Original System ID for the Party Active
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 255 Original System Reference for the Party Active
ADDTNL_NAME_ORIG_SYSTEM VARCHAR2 30 Original System ID for the Additional Party Name Active
ADDTNL_NAME_ORIG_SYSTEM_REF VARCHAR2 255 Original System Reference for the Additional Party Name Active
INSERT_UPDATE_FLAG VARCHAR2 1 Indicates if a record should be explicitly inserted or updated Active
ACTION_FLAG VARCHAR2 1 Indicates the action of 'insert' or 'update' based on matching outcome. Active
PARTY_ID NUMBER 18 Party that owns the additional party name Active
PARTY_TYPE VARCHAR2 30 The party type can only be Person, Organization, Group or Relationship
PARTY_NAME_ID NUMBER 18 Additional Party Name Id Active
PREFERRED_FLAG VARCHAR2 1 Identify the name as preferred name for this party within this name type. Possible values are Y and N. Default is N. Active
GLOBAL_PREFERRED_FLAG VARCHAR2 1 Identify the name as preferred name for this party across all name types. Active
PARTY_NAME_TYPE VARCHAR2 30 Type of the name. It is a value defined by the Additional Party Name and Identifier Type entity The party type should be consistent with the party type that the PARTY_NAME_TYPE can be applied to. Active
PARTY_NAME VARCHAR2 360 Typically used to store the additional name for the party. In the case of Persons it will be used to store the formatted name if necessary for the name type. Active
PERSON_TITLE VARCHAR2 60 A professional or family title. For example, Don or The Right Honorable. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used Active
PERSON_ACADEMIC_TITLE VARCHAR2 30 Used to capture the Academic title for a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used Corresponds to the field Degree in HL7.
PERSON_PRE_NAME_ADJUNCT VARCHAR2 30 Used to capture the name prefix (Mr. Ms, Dr., etc.) for a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Prefix in HL7. Validate against lookup CONTACT_TITLE Active
PERSON_FIRST_NAME VARCHAR2 150 Used to capture the first name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used Corresponds to the field Given Name in HL7. Active
PERSON_MIDDLE_NAME VARCHAR2 60 Used to capture the middle name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used Corresponds to the field Middle Initial or Name in HL7. Active
PERSON_LAST_NAME_PREFIX VARCHAR2 30 Used to capture the Last name prefix (e.g. ?fon?, ?van?, etc.) for a person. It is used in the same way the new field PERSON_LAST_NAME_PREFIX in HZ_PERSON_PROFILES is used Corresponds to the field Last Name Prefix in HL7. Active
PERSON_LAST_NAME VARCHAR2 150 Used to capture the last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used Corresponds to the field Family Name in HL7. Active
PERSON_SECOND_LAST_NAME VARCHAR2 150 Used to capture the second last name for a person. In some cultures it is not uncommon to have double last name. It is used in the same way the new field PERSON_SECOND_LAST_NAME in HZ_PERSON_PROFILES is used. Active
PERSON_PREVIOUS_LAST_NAME VARCHAR2 150 Used to capture the previous last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used It has no mapping in HL7. Active
PERSON_NAME_SUFFIX VARCHAR2 30 Used to capture the name suffix (e.g. Junior. Sr, the third, etc.) for a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. Corresponds to the field Suffix in HL7. Active
TRANSLITERATION_LANG VARCHAR2 4 Used to capture the language used for the name. It is validated against FND_LANGUAGES.LANGUAGE_CODE. Default value is the Session Language. Active
DESCRIPTION VARCHAR2 240 Free text comment/description. Active
INTERFACE_STATUS VARCHAR2 30 Status for the data in the interface table Active
ERROR_ID NUMBER 18 Foreign Key to the Error Table Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
FILE_RECORD_NUM NUMBER 10 This column is required by import wizard to related record in the interface table to the file row.
ACTION_CODE VARCHAR2 30 Indicates delete action entered by user
IMPORT_STATUS_CODE VARCHAR2 30 Status for the data in the interface table
FILE_NAME_SYSTASK_ID NUMBER 18 Stores systask id for each import csv file.
PARTY_NUMBER VARCHAR2 30 Unique identification number for this party

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_IMP_ADDTNLPARTYNAMES_T hz_imp_batch_summary BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_IMP_ADDTNLPARTYNAMES_T_N1 Non Unique Default BATCH_ID, ADDTNLPARTYNAME_T_ID
HZ_IMP_ADDTNLPARTYNAMES_T_N2 Non Unique Default BATCH_ID, ADDTNL_NAME_ORIG_SYSTEM, ADDTNL_NAME_ORIG_SYSTEM_REF, INTERFACE_STATUS
HZ_IMP_ADDTNLPARTYNAMES_T_N3 Non Unique Default BATCH_ID, FILE_RECORD_NUM, INTERFACE_STATUS
HZ_IMP_ADDTNLPARTYNAMES_T_N4 Non Unique Default BATCH_ID, PARTY_NAME_ID, INTERFACE_STATUS
HZ_IMP_ADDTNLPARTYNAMES_T_N5 Non Unique Default BATCH_ID, PARTY_NUMBER
HZ_IMP_ADDTNLPARTYNAMES_T_N6 Non Unique Default PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE
HZ_IMP_ADDTNLPARTYNAMES_T_N7 Non Unique Default BATCH_ID, PARTY_ID
HZ_IMP_ADDTNLPARTYNAMES_T_U1 Unique Default ADDTNLPARTYNAME_T_ID