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

VIEW: IMC.IMC_CSV_INTERFACE_FIELDS#

Object Details
Object Name: IMC_CSV_INTERFACE_FIELDS#
Object Type: VIEW
Owner: IMC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER (15) Yes
BATCH_ID NUMBER (15)
PARTY_REC_ID NUMBER (15)
REC_STATUS VARCHAR2 (15)
PARTY_TYPE VARCHAR2 (30)
ORGANIZATION_NAME VARCHAR2 (360)
CEO_NAME VARCHAR2 (240)
CEO_TITLE VARCHAR2 (240)
PRINCIPAL_NAME VARCHAR2 (240)
PRINCIPAL_TITLE VARCHAR2 (240)
LEGAL_STATUS VARCHAR2 (30)
CONTROL_YR VARCHAR2 (100)
EMPLOYEES_TOTAL VARCHAR2 (100)
HQ_BRANCH_IND VARCHAR2 (30)
BRANCH_FLAG VARCHAR2 (1)
OOB_IND VARCHAR2 (30)
TAX_REFERENCE VARCHAR2 (50)
GSA_INDICATOR_FLAG VARCHAR2 (1)
JGZZ_FISCAL_CODE VARCHAR2 (20)
ANALYSIS_FY VARCHAR2 (5)
FISCAL_YEAREND_MONTH VARCHAR2 (240)
CURR_FY_POTENTIAL_REVENUE VARCHAR2 (100)
NEXT_FY_POTENTIAL_REVENUE VARCHAR2 (100)
YEAR_ESTABLISHED VARCHAR2 (100)
MISSION_STATEMENT VARCHAR2 (1996)
ORGANIZATION_TYPE VARCHAR2 (30)
BUSINESS_SCOPE VARCHAR2 (20)
KNOWN_AS VARCHAR2 (240)
KNOWN_AS2 VARCHAR2 (240)
KNOWN_AS3 VARCHAR2 (240)
KNOWN_AS4 VARCHAR2 (240)
KNOWN_AS5 VARCHAR2 (240)
LOCAL_BUS_IDEN_TYPE VARCHAR2 (30)
LOCAL_BUS_IDENTIFIER VARCHAR2 (60)
PREF_FUNCTIONAL_CURRENCY VARCHAR2 (30)
REGISTRATION_TYPE VARCHAR2 (30)
PARENT_SUB_IND VARCHAR2 (30)
INCORP_YEAR VARCHAR2 (100)
LINE_OF_BUSINESS VARCHAR2 (240)
PUBLIC_PRIVATE_OWNERSHIP_FLAG VARCHAR2 (1)
TOTAL_PAYMENTS VARCHAR2 (100)
DUNS_NUMBER_C VARCHAR2 (30)
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
PERSON_FIRST_NAME VARCHAR2 (150)
PERSON_MIDDLE_NAME VARCHAR2 (60)
PERSON_LAST_NAME VARCHAR2 (150)
PERSON_NAME_SUFFIX VARCHAR2 (30)
PERSON_TITLE VARCHAR2 (60)
PERSON_ACADEMIC_TITLE VARCHAR2 (150)
PERSON_PREVIOUS_LAST_NAME VARCHAR2 (150)
PERSON_INITIALS VARCHAR2 (6)
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
PERSON_NAME_PHONETIC VARCHAR2 (360)
PERSON_MIDDLE_NAME_PHONETIC VARCHAR2 (60)
PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
PERSON_IDEN_TYPE VARCHAR2 (30)
PERSON_IDENTIFIER VARCHAR2 (60)
DATE_OF_BIRTH VARCHAR2 (100)
PLACE_OF_BIRTH VARCHAR2 (60)
DATE_OF_DEATH VARCHAR2 (100)
GENDER VARCHAR2 (30)
DECLARED_ETHNICITY VARCHAR2 (60)
MARITAL_STATUS VARCHAR2 (30)
MARITAL_STATUS_EFFECTIVE_DATE VARCHAR2 (100)
PERSONAL_INCOME VARCHAR2 (100)
HEAD_OF_HOUSEHOLD_FLAG VARCHAR2 (1)
HOUSEHOLD_INCOME VARCHAR2 (100)
HOUSEHOLD_SIZE VARCHAR2 (100)
RENT_OWN_IND VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
STATE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
ADDRESS_LINES_PHONETIC VARCHAR2 (560)
DESCRIPTION VARCHAR2 (1996)
LANGUAGE VARCHAR2 (4)
PARTY_SITE_NAME VARCHAR2 (240)
CONTACT_POINT_TYPE VARCHAR2 (30)
EMAIL_FORMAT VARCHAR2 (30)
EMAIL_ADDRESS VARCHAR2 (1996)
PHONE_AREA_CODE VARCHAR2 (10)
PHONE_COUNTRY_CODE VARCHAR2 (10)
PHONE_NUMBER VARCHAR2 (40)
PHONE_EXTENSION VARCHAR2 (20)
PHONE_LINE_TYPE VARCHAR2 (30)
WEB_TYPE VARCHAR2 (60)
URL VARCHAR2 (1996)
RAW_PHONE_NUMBER VARCHAR2 (60)
CONTACT_POINT_PURPOSE VARCHAR2 (30)
CLASS_CATEGORY VARCHAR2 (30)
CLASS_CODE VARCHAR2 (30)
DEPARTMENT_CODE VARCHAR2 (30)
DEPARTMENT VARCHAR2 (60)
TITLE VARCHAR2 (30)
JOB_TITLE VARCHAR2 (100)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
TELEX_NUMBER VARCHAR2 (50)
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# references the following:

SchemaIMC
TableIMC_CSV_INTERFACE_FIELDS
IMC.IMC_CSV_INTERFACE_FIELDS# is referenced by following:

SchemaAPPS
SynonymIMC_CSV_INTERFACE_FIELDS