[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_IMP_PARTIES_INT |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.HZ_IMP_PARTIES_INT
|
| Subobject Name: | |
| Status: | VALID |
The TCA import interface table, HZ_IMP_PARTIES_INT, stores information for population into the HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES tables in TCA
Scope: public
Product: HZ
Lifecycle: active
Display Name: Party
Category: BUSINESS_ENTITY HZ_ORGANIZATION
Category: BUSINESS_ENTITY HZ_PERSON
Category: BUSINESS_ENTITY HZ_PARTY
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_IMP_PARTIES_INT_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 BATCH_ID
PARTY_ORIG_SYSTEM
INTERFACE_STATUS
PARTY_ORIG_SYSTEM_REFERENCE
PARTY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | (15) | Yes | Unique Identifier for a Batch |
| PARTY_ORIG_SYSTEM | VARCHAR2 | (30) | Yes | Original System ID for the Party |
| PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Yes | Original System Reference for the Party |
| INSERT_UPDATE_FLAG | VARCHAR2 | (1) | Indicates if a record should be explicitly inserted or updated | |
| PARTY_TYPE | VARCHAR2 | (30) | The party type can only be Person, Organization, Group or Relationship | |
| PARTY_ID | NUMBER | (15) | Unique Identifier for the party | |
| PARTY_NUMBER | VARCHAR2 | (30) | Unique identification number for this party | |
| SALUTATION | VARCHAR2 | (60) | Phrase used to address a party in any correspondence | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure definition | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ORGANIZATION_NAME | VARCHAR2 | (360) | Name of a party of the Organization party type | |
| ORGANIZATION_NAME_PHONETIC | VARCHAR2 | (320) | Japanese Kana, or phonetic representation of organization name | |
| ORGANIZATION_TYPE | VARCHAR2 | (30) | User-defined organization types such as region, division, and department | |
| ANALYSIS_FY | VARCHAR2 | (5) | Fiscal year used as the source for financial information | |
| BRANCH_FLAG | VARCHAR2 | (1) | Indicates if this is a branch location. Y for branch locations, N for all other locations | |
| BUSINESS_SCOPE | VARCHAR2 | (20) | The physical class of business in which a business participates. For example, local, national, or international. | |
| CEO_NAME | VARCHAR2 | (240) | Name of the chief executive officer | |
| CEO_TITLE | VARCHAR2 | (240) | Formal title of the chief executive officer | |
| CONG_DIST_CODE | VARCHAR2 | (2) | U.S. Congressional District | |
| CONTROL_YR | NUMBER | Year when current ownership gained control | ||
| CORPORATION_CLASS | VARCHAR2 | (60) | Taxation classification for corporation entities. For example, Chapter S in the US. | |
| CURR_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for this fiscal year | ||
| NEXT_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year | ||
| PREF_FUNCTIONAL_CURRENCY | VARCHAR2 | (30) | Organization's default currency code. | |
| DISADV_8A_IND | VARCHAR2 | (1) | Indicates if this company is considered disadvantaged by the US government under Title 8A. Y for a Title 8A disadvantaged firm, N for all other firms | |
| DO_NOT_CONFUSE_WITH | VARCHAR2 | (255) | Indicates existence of similarly named business | |
| DUNS_NUMBER_C | VARCHAR2 | (30) | DUNS_NUMBER in VARCHAR format. Column value not restricted to nine digit DUNS Number | |
| EMP_AT_PRIMARY_ADR | VARCHAR2 | (10) | Number of employees at the referenced address | |
| EMP_AT_PRIMARY_ADR_EST_IND | VARCHAR2 | (30) | Qualifies calculation of employees at the primary address as estimated | |
| EMP_AT_PRIMARY_ADR_MIN_IND | VARCHAR2 | (30) | Qualifies calculation of employees at the primary address as minimum | |
| EMP_AT_PRIMARY_ADR_TEXT | VARCHAR2 | (12) | Number of employees at the referenced address which cannot be mapped to a number | |
| EMPLOYEES_TOTAL | NUMBER | Total number of employees | ||
| DISPLAYED_DUNS | VARCHAR2 | (15) | Identifier used to query the Dun & Bradstreet data and the value displayed to the user. If a location is a branch, then in some countries the headquarters DUNS number is used to do the query. Otherwise it is the same as the DUNS number. | |
| EXPORT_IND | VARCHAR2 | (1) | Indicates if this company is an exporter. Y for an exporter, N for an organization that does not export. | |
| FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | Month that the fiscal year ends for organization | |
| GSA_INDICATOR_FLAG | VARCHAR2 | (1) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA. | |
| HQ_BRANCH_IND | VARCHAR2 | (30) | Status of this site. Identifies if the location is the HQ, a branch, or a single location. | |
| IMPORT_IND | VARCHAR2 | (1) | Indicates if this company is an importer. Y for an importer, N for an organization that does not import | |
| INCORP_YEAR | NUMBER | (4) | Year that the business was incorporated | |
| JGZZ_FISCAL_CODE | VARCHAR2 | (20) | Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe | |
| TAX_REFERENCE | VARCHAR2 | (50) | Taxpayer registration number, also known as the VAT number. | |
| KNOWN_AS | VARCHAR2 | (240) | An alias or other name by which an organization is known | |
| KNOWN_AS2 | VARCHAR2 | (240) | An alias or other name by which an organization is known | |
| KNOWN_AS3 | VARCHAR2 | (240) | An alias or other name by which an organization is known | |
| KNOWN_AS4 | VARCHAR2 | (240) | An alias or other name by which an organization is known | |
| KNOWN_AS5 | VARCHAR2 | (240) | An alias or other name by which an organization is known | |
| LABOR_SURPLUS_IND | VARCHAR2 | (1) | Indicates if this company operates in an area with a labor surplus. Y for a surplus, N for no surplus exists. | |
| LEGAL_STATUS | VARCHAR2 | (30) | Legal structure. For example, partnership, corporation, and so on. | |
| LINE_OF_BUSINESS | VARCHAR2 | (240) | Type of business activities performed at this site | |
| LOCAL_BUS_IDENTIFIER | VARCHAR2 | (60) | Primary identifier assigned to businesses by government agency, Chamber of Commerce, or other authority. Generally used outside US. | |
| LOCAL_BUS_IDEN_TYPE | VARCHAR2 | (30) | Lookup that represents most common business identifier in a country. For example, Chamber of Commerce Number in Italy, Government Registration Number in Taiwan. | |
| MINORITY_OWNED_IND | VARCHAR2 | (1) | Indicates if this company is primarily owned by women. Y for a women-owned firm, N for a firm that is not primarily owned by women. | |
| MINORITY_OWNED_TYPE | VARCHAR2 | (30) | The type of minority-owned firm | |
| MISSION_STATEMENT | VARCHAR2 | (2000) | Corporate charter of organization | |
| OOB_IND | VARCHAR2 | (30) | Indicates if this organization is out of business. Y for businesses that are out of business, N for active businesses. | |
| PARENT_SUB_IND | VARCHAR2 | (30) | Lookup that indicates if organization is a parent or subsidiary location | |
| PRINCIPAL_NAME | VARCHAR2 | (240) | Name of the highest ranking person in the company | |
| PRINCIPAL_TITLE | VARCHAR2 | (240) | Title of the highest ranking person in the company | |
| PUBLIC_PRIVATE_OWNERSHIP_FLAG | VARCHAR2 | (1) | Indicates if the organization is privately owned. Y for a privately owned organization, N for a publicly owned organization | |
| REGISTRATION_TYPE | VARCHAR2 | (30) | Lookup for type of registration, such as nonprofit | |
| RENT_OWN_IND | VARCHAR2 | (30) | Indicates if this company owns or rents its place of business. Lookup of values for rent, own, lease, and so on. | |
| SMALL_BUS_IND | VARCHAR2 | (1) | Indicates if this company is considered to be a small business. Y for small businesses, N for all other firms. | |
| TOTAL_EMP_EST_IND | VARCHAR2 | (30) | Lookup that indicates whether the employee total is estimated. A for estimated, N for not estimated or actual. | |
| TOTAL_EMP_MIN_IND | VARCHAR2 | (30) | Lookup that indicates whether the number is a minimum, maximum, or average number of total employees. A for minimum, B for maximum, and C for average | |
| TOTAL_EMPLOYEES_IND | VARCHAR2 | (30) | Lookup that indicates whether subsidiaries are included in the calculation of total employees A for totals without subsidiaries, B for totals with subsidiaries. | |
| TOTAL_EMPLOYEES_TEXT | VARCHAR2 | (60) | Total number of personnel employed if can not be mapped to numeric field. | |
| TOTAL_PAYMENTS | NUMBER | Total number of payment experiences | ||
| WOMAN_OWNED_IND | VARCHAR2 | (1) | Indicates if this company is primarily owned by women. Y for a women-owned firm, N for a firm that is not primarily owned by women. | |
| YEAR_ESTABLISHED | NUMBER | (4) | Year that the organization began doing business | |
| PERSON_FIRST_NAME | VARCHAR2 | (150) | First name of the person | |
| PERSON_LAST_NAME | VARCHAR2 | (150) | Last or surname of the person | |
| PERSON_MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
| PERSON_INITIALS | VARCHAR2 | (6) | Name initials | |
| PERSON_NAME_SUFFIX | VARCHAR2 | (30) | Indicates the place in a family structure. For example, in "Tom Jones III", the "III". | |
| PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | Salutary introduction such as Mr., Herr, etc | |
| PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | (150) | Previous last or surname of the person | |
| PERSON_TITLE | VARCHAR2 | (60) | A professional or family title. For example, Don or The Right Honorable. | |
| PERSON_FIRST_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of the person's first name | |
| PERSON_LAST_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of the person's last name | |
| PERSON_MIDDLE_NAME_PHONETIC | VARCHAR2 | (60) | Phonetic representation of the person's middle name | |
| PERSON_NAME_PHONETIC | VARCHAR2 | (320) | Japanese Kana, or phonetic representation of person name | |
| PERSON_ACADEMIC_TITLE | VARCHAR2 | (30) | Academic title that is part of the person's name such as Dr. Jane Smith | |
| DATE_OF_BIRTH | DATE | Date the person was born | ||
| PLACE_OF_BIRTH | VARCHAR2 | (60) | Where the person was born. Typically, the city and country. | |
| DATE_OF_DEATH | DATE | Date the person died | ||
| DECEASED_FLAG | VARCHAR2 | (1) | Indicates whether a person is deceased | |
| DECLARED_ETHNICITY | VARCHAR2 | (60) | The declared ethnicity of the person | |
| GENDER | VARCHAR2 | (30) | The gender (male, female, unknown) of the person | |
| HEAD_OF_HOUSEHOLD_FLAG | VARCHAR2 | (1) | Indicates if the person is the head of the household. Y for the head of a household, N for people who are not the head of a household. | |
| HOUSEHOLD_INCOME | NUMBER | Income of the household that this person is a part of | ||
| HOUSEHOLD_SIZE | NUMBER | The size of the household this person is a part of | ||
| MARITAL_STATUS | VARCHAR2 | (30) | Marital status of the person | |
| MARITAL_STATUS_EFFECTIVE_DATE | DATE | Date when the person's marital status changed. | ||
| PERSON_IDEN_TYPE | VARCHAR2 | (30) | Personal identifier type, such as driver's license or passport. Lookup type for PERSON_IDENTIFIER column | |
| PERSON_IDENTIFIER | VARCHAR2 | (60) | Personal identifier, such as driver's license or passport number, or country-specific identifier for person located or doing business in multiple countries | |
| PERSONAL_INCOME | NUMBER | The estimated gross annual income of the person | ||
| INTERFACE_STATUS | VARCHAR2 | (30) | Status for the data in the interface table | |
| DQM_ACTION_FLAG | VARCHAR2 | (1) | Indicates record category and action to take on records being imported, based on DQM de-duplication between those records and records already in TCA. D for duplicate, P for potential duplicate, and null for new or existing record | |
| DUP_WITHIN_INT_FLAG | VARCHAR2 | (1) | Not currently used | |
| ERROR_ID | NUMBER | (15) | Foreign Key to the Error Table | |
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
| PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
| PROGRAM_UPDATE_DATE | DATE | Last date this record was updated by a concurrent program | ||
| CREATED_BY_MODULE | VARCHAR2 | (30) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PARTY_ORIG_SYSTEM
, PARTY_ORIG_SYSTEM_REFERENCE
, INSERT_UPDATE_FLAG
, PARTY_TYPE
, PARTY_ID
, PARTY_NUMBER
, SALUTATION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ORGANIZATION_NAME
, ORGANIZATION_NAME_PHONETIC
, ORGANIZATION_TYPE
, ANALYSIS_FY
, BRANCH_FLAG
, BUSINESS_SCOPE
, CEO_NAME
, CEO_TITLE
, CONG_DIST_CODE
, CONTROL_YR
, CORPORATION_CLASS
, CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE
, PREF_FUNCTIONAL_CURRENCY
, DISADV_8A_IND
, DO_NOT_CONFUSE_WITH
, DUNS_NUMBER_C
, EMP_AT_PRIMARY_ADR
, EMP_AT_PRIMARY_ADR_EST_IND
, EMP_AT_PRIMARY_ADR_MIN_IND
, EMP_AT_PRIMARY_ADR_TEXT
, EMPLOYEES_TOTAL
, DISPLAYED_DUNS
, EXPORT_IND
, FISCAL_YEAREND_MONTH
, GSA_INDICATOR_FLAG
, HQ_BRANCH_IND
, IMPORT_IND
, INCORP_YEAR
, JGZZ_FISCAL_CODE
, TAX_REFERENCE
, KNOWN_AS
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, LABOR_SURPLUS_IND
, LEGAL_STATUS
, LINE_OF_BUSINESS
, LOCAL_BUS_IDENTIFIER
, LOCAL_BUS_IDEN_TYPE
, MINORITY_OWNED_IND
, MINORITY_OWNED_TYPE
, MISSION_STATEMENT
, OOB_IND
, PARENT_SUB_IND
, PRINCIPAL_NAME
, PRINCIPAL_TITLE
, PUBLIC_PRIVATE_OWNERSHIP_FLAG
, REGISTRATION_TYPE
, RENT_OWN_IND
, SMALL_BUS_IND
, TOTAL_EMP_EST_IND
, TOTAL_EMP_MIN_IND
, TOTAL_EMPLOYEES_IND
, TOTAL_EMPLOYEES_TEXT
, TOTAL_PAYMENTS
, WOMAN_OWNED_IND
, YEAR_ESTABLISHED
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, PERSON_MIDDLE_NAME
, PERSON_INITIALS
, PERSON_NAME_SUFFIX
, PERSON_PRE_NAME_ADJUNCT
, PERSON_PREVIOUS_LAST_NAME
, PERSON_TITLE
, PERSON_FIRST_NAME_PHONETIC
, PERSON_LAST_NAME_PHONETIC
, PERSON_MIDDLE_NAME_PHONETIC
, PERSON_NAME_PHONETIC
, PERSON_ACADEMIC_TITLE
, DATE_OF_BIRTH
, PLACE_OF_BIRTH
, DATE_OF_DEATH
, DECEASED_FLAG
, DECLARED_ETHNICITY
, GENDER
, HEAD_OF_HOUSEHOLD_FLAG
, HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE
, MARITAL_STATUS
, MARITAL_STATUS_EFFECTIVE_DATE
, PERSON_IDEN_TYPE
, PERSON_IDENTIFIER
, PERSONAL_INCOME
, INTERFACE_STATUS
, DQM_ACTION_FLAG
, DUP_WITHIN_INT_FLAG
, ERROR_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY_MODULE
FROM AR.HZ_IMP_PARTIES_INT;
AR.HZ_IMP_PARTIES_INT does not reference any database object
AR.HZ_IMP_PARTIES_INT is referenced by following:
APPS
HZ_IMP_PARTIES_INT
|
|
|
|