DBA Data[Home] [Help] [Dependency Information]

TABLE: IMC.IMC_CSV_INTERFACE_FIELDS

Object Details
Object Name: IMC_CSV_INTERFACE_FIELDS
Object Type: TABLE
Owner: IMC
Subobject Name:
Status: VALID


This table stores the all the data from the File in the appropriate TCA interface Columns.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER (15) Yes Number that uniquely identifies the Load Batch
BATCH_ID NUMBER (15)
The BATCH_ID in HZ_IMP_BATCH_SUMMARY Table that this CSV load maps to
PARTY_REC_ID NUMBER (15)
Number uniquely identifies the Party Record in the File
REC_STATUS VARCHAR2 (15)
Record Status whether inserted or not
PARTY_TYPE VARCHAR2 (30)
Type of the Party
ORGANIZATION_NAME VARCHAR2 (360)
Organization Name
CEO_NAME VARCHAR2 (240)
Chief Executive Officer Name
CEO_TITLE VARCHAR2 (240)
Title of Chief Executive Officer
PRINCIPAL_NAME VARCHAR2 (240)
Principal Name
PRINCIPAL_TITLE VARCHAR2 (240)
Principal Title
LEGAL_STATUS VARCHAR2 (30)
Legal Status
CONTROL_YR VARCHAR2 (100)
Control Year
EMPLOYEES_TOTAL VARCHAR2 (100)
Total Number Of Employees
HQ_BRANCH_IND VARCHAR2 (30)
Branch Indicator for Head Quarter
BRANCH_FLAG VARCHAR2 (1)
Branch Indicator for Head Quarter
OOB_IND VARCHAR2 (30)
Out of Business Indicator
TAX_REFERENCE VARCHAR2 (50)
Tax Reference
GSA_INDICATOR_FLAG VARCHAR2 (1)
GSA Indicator Flag
JGZZ_FISCAL_CODE VARCHAR2 (20)
JGZZ Fiscal Code
ANALYSIS_FY VARCHAR2 (5)
Analysis of Financial Year
FISCAL_YEAREND_MONTH VARCHAR2 (240)
Month of Fiscal Year Ending
CURR_FY_POTENTIAL_REVENUE VARCHAR2 (100)
Potential Revenue for current Fiscal Year
NEXT_FY_POTENTIAL_REVENUE VARCHAR2 (100)
Potential Revenue for next Fiscal year
YEAR_ESTABLISHED VARCHAR2 (100)
Year Established
MISSION_STATEMENT VARCHAR2 (1996)
Mission Statement for the Organization
ORGANIZATION_TYPE VARCHAR2 (30)
Type of Organization
BUSINESS_SCOPE VARCHAR2 (20)
Scope of Business
KNOWN_AS VARCHAR2 (240)
Alias
KNOWN_AS2 VARCHAR2 (240)
Alias 2
KNOWN_AS3 VARCHAR2 (240)
Alias 3
KNOWN_AS4 VARCHAR2 (240)
Alias 4
KNOWN_AS5 VARCHAR2 (240)
Alias 5
LOCAL_BUS_IDEN_TYPE VARCHAR2 (30)
Local Business Identifying Type
LOCAL_BUS_IDENTIFIER VARCHAR2 (60)
Local Business Identifier
PREF_FUNCTIONAL_CURRENCY VARCHAR2 (30)
Functional Currency Preferred
REGISTRATION_TYPE VARCHAR2 (30)
Registration Type
PARENT_SUB_IND VARCHAR2 (30)
Parent Indicator
INCORP_YEAR VARCHAR2 (100)
Year of Incorporation
LINE_OF_BUSINESS VARCHAR2 (240)
Line of Business
PUBLIC_PRIVATE_OWNERSHIP_FLAG VARCHAR2 (1)
Ownership Flag whether Public or Private
TOTAL_PAYMENTS VARCHAR2 (100)
Total Payments made
DUNS_NUMBER_C VARCHAR2 (30)
Duns Number
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
Pre-Name Adjunct of the Person Name
PERSON_FIRST_NAME VARCHAR2 (150)
Person First Name
PERSON_MIDDLE_NAME VARCHAR2 (60)
Person Middle Name
PERSON_LAST_NAME VARCHAR2 (150)
Person Last Name
PERSON_NAME_SUFFIX VARCHAR2 (30)
Suffix of the Person Name
PERSON_TITLE VARCHAR2 (60)
Person Title
PERSON_ACADEMIC_TITLE VARCHAR2 (150)
Person�s Academic Title
PERSON_PREVIOUS_LAST_NAME VARCHAR2 (150)
Person�s Previous Last name
PERSON_INITIALS VARCHAR2 (6)
Person Name Initials
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
Pronunciation of Person�s First Name
PERSON_NAME_PHONETIC VARCHAR2 (360)
Pronunciation of Person�s Name
PERSON_MIDDLE_NAME_PHONETIC VARCHAR2 (60)
Pronunciation of Person�s middle Name
PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
Pronunciation of Person�s Last Name
PERSON_IDEN_TYPE VARCHAR2 (30)
Type of Person Identification
PERSON_IDENTIFIER VARCHAR2 (60)
Identifier for the Person
DATE_OF_BIRTH VARCHAR2 (100)
Date Of Birth
PLACE_OF_BIRTH VARCHAR2 (60)
Place Of Birth
DATE_OF_DEATH VARCHAR2 (100)
Date of Death
GENDER VARCHAR2 (30)
Gender of the Person
DECLARED_ETHNICITY VARCHAR2 (60)
Declared Ethnicity of the Person
MARITAL_STATUS VARCHAR2 (30)
Marital Status of the Person
MARITAL_STATUS_EFFECTIVE_DATE VARCHAR2 (100)
Effective Date of Marriage
PERSONAL_INCOME VARCHAR2 (100)
Personal Income
HEAD_OF_HOUSEHOLD_FLAG VARCHAR2 (1)
Head of Household Indicator
HOUSEHOLD_INCOME VARCHAR2 (100)
Household Income
HOUSEHOLD_SIZE VARCHAR2 (100)
Size of Household
RENT_OWN_IND VARCHAR2 (30)
Rent/Own Indicator
COUNTRY VARCHAR2 (60)
Country
ADDRESS1 VARCHAR2 (240)
Primary Address
ADDRESS2 VARCHAR2 (240)
Secondary Address
ADDRESS3 VARCHAR2 (240)
Address 3
ADDRESS4 VARCHAR2 (240)
Address 4
CITY VARCHAR2 (60)
City
POSTAL_CODE VARCHAR2 (60)
Postal Code
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
ADDRESS_LINES_PHONETIC VARCHAR2 (560)
Pronunciation of the Address Lines
DESCRIPTION VARCHAR2 (1996)
Description of the Address
LANGUAGE VARCHAR2 (4)
Language
PARTY_SITE_NAME VARCHAR2 (240)
Party Site Name
CONTACT_POINT_TYPE VARCHAR2 (30)
Primary Contact Point Type
EMAIL_FORMAT VARCHAR2 (30)
Format of the Email Address
EMAIL_ADDRESS VARCHAR2 (1996)
Email Address
PHONE_AREA_CODE VARCHAR2 (10)
Area Code for the Phone Number
PHONE_COUNTRY_CODE VARCHAR2 (10)
Country Code for the Phone Number
PHONE_NUMBER VARCHAR2 (40)
Telephone Number
PHONE_EXTENSION VARCHAR2 (20)
Telephone Extension
PHONE_LINE_TYPE VARCHAR2 (30)
Phone Line Type
WEB_TYPE VARCHAR2 (60)
Web Type
URL VARCHAR2 (1996)
URL
RAW_PHONE_NUMBER VARCHAR2 (60)
Raw Phone Number
CONTACT_POINT_PURPOSE VARCHAR2 (30)
Purpose of the Contact Point
CLASS_CATEGORY VARCHAR2 (30)
Customer Category
CLASS_CODE VARCHAR2 (30)
SIC Code
DEPARTMENT_CODE VARCHAR2 (30)
Department Code of the Contact
DEPARTMENT VARCHAR2 (60)
Department of the Contact
TITLE VARCHAR2 (30)
Contact Title
JOB_TITLE VARCHAR2 (100)
Job Title of the Contact
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TELEX_NUMBER VARCHAR2 (50)
Telex Number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOAD_ID
,      BATCH_ID
,      PARTY_REC_ID
,      REC_STATUS
,      PARTY_TYPE
,      ORGANIZATION_NAME
,      CEO_NAME
,      CEO_TITLE
,      PRINCIPAL_NAME
,      PRINCIPAL_TITLE
,      LEGAL_STATUS
,      CONTROL_YR
,      EMPLOYEES_TOTAL
,      HQ_BRANCH_IND
,      BRANCH_FLAG
,      OOB_IND
,      TAX_REFERENCE
,      GSA_INDICATOR_FLAG
,      JGZZ_FISCAL_CODE
,      ANALYSIS_FY
,      FISCAL_YEAREND_MONTH
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      YEAR_ESTABLISHED
,      MISSION_STATEMENT
,      ORGANIZATION_TYPE
,      BUSINESS_SCOPE
,      KNOWN_AS
,      KNOWN_AS2
,      KNOWN_AS3
,      KNOWN_AS4
,      KNOWN_AS5
,      LOCAL_BUS_IDEN_TYPE
,      LOCAL_BUS_IDENTIFIER
,      PREF_FUNCTIONAL_CURRENCY
,      REGISTRATION_TYPE
,      PARENT_SUB_IND
,      INCORP_YEAR
,      LINE_OF_BUSINESS
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      TOTAL_PAYMENTS
,      DUNS_NUMBER_C
,      PERSON_PRE_NAME_ADJUNCT
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PREVIOUS_LAST_NAME
,      PERSON_INITIALS
,      PERSON_FIRST_NAME_PHONETIC
,      PERSON_NAME_PHONETIC
,      PERSON_MIDDLE_NAME_PHONETIC
,      PERSON_LAST_NAME_PHONETIC
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      DATE_OF_BIRTH
,      PLACE_OF_BIRTH
,      DATE_OF_DEATH
,      GENDER
,      DECLARED_ETHNICITY
,      MARITAL_STATUS
,      MARITAL_STATUS_EFFECTIVE_DATE
,      PERSONAL_INCOME
,      HEAD_OF_HOUSEHOLD_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      RENT_OWN_IND
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      ADDRESS_LINES_PHONETIC
,      DESCRIPTION
,      LANGUAGE
,      PARTY_SITE_NAME
,      CONTACT_POINT_TYPE
,      EMAIL_FORMAT
,      EMAIL_ADDRESS
,      PHONE_AREA_CODE
,      PHONE_COUNTRY_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      PHONE_LINE_TYPE
,      WEB_TYPE
,      URL
,      RAW_PHONE_NUMBER
,      CONTACT_POINT_PURPOSE
,      CLASS_CATEGORY
,      CLASS_CODE
,      DEPARTMENT_CODE
,      DEPARTMENT
,      TITLE
,      JOB_TITLE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TELEX_NUMBER
FROM IMC.IMC_CSV_INTERFACE_FIELDS;

Dependencies

[top of page]

IMC.IMC_CSV_INTERFACE_FIELDS does not reference any database object

IMC.IMC_CSV_INTERFACE_FIELDS is referenced by following:

SchemaIMC
ViewIMC_CSV_INTERFACE_FIELDS#