CE_ORG_PROFILE_VAL_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
ORGANIZATION_NAME | VARCHAR2 | 360 | Oracle internal use only. | |
TEMP_ID | NUMBER | 18 | Oracle internal use only. | |
TEMP_PARTY_ID | NUMBER | 18 | Oracle internal use only. | |
DUNS_NUMBER_C | VARCHAR2 | 30 | Oracle internal use only. | |
ENQUIRY_DUNS | VARCHAR2 | 15 | Oracle internal use only. | |
CEO_NAME | VARCHAR2 | 240 | Oracle internal use only. | |
CEO_TITLE | VARCHAR2 | 240 | Oracle internal use only. | |
PRINCIPAL_NAME | VARCHAR2 | 240 | Oracle internal use only. | |
PRINCIPAL_TITLE | VARCHAR2 | 240 | Oracle internal use only. | |
LEGAL_STATUS | VARCHAR2 | 30 | Oracle internal use only. | |
CONTROL_YR | NUMBER | Oracle internal use only. | ||
EMPLOYEES_TOTAL | NUMBER | Oracle internal use only. | ||
HQ_BRANCH_IND | VARCHAR2 | 30 | Oracle internal use only. | |
BRANCH_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
OOB_IND | VARCHAR2 | 30 | Oracle internal use only. | |
LINE_OF_BUSINESS | VARCHAR2 | 240 | Oracle internal use only. | |
CONG_DIST_CODE | VARCHAR2 | 2 | Oracle internal use only. | |
SIC_CODE | VARCHAR2 | 30 | Oracle internal use only. | |
IMPORT_IND | VARCHAR2 | 30 | Oracle internal use only. | |
EXPORT_IND | VARCHAR2 | 30 | Oracle internal use only. | |
LABOR_SURPLUS_IND | VARCHAR2 | 30 | Oracle internal use only. | |
DEBARMENT_IND | VARCHAR2 | 30 | Oracle internal use only. | |
MINORITY_OWNED_IND | VARCHAR2 | 30 | Oracle internal use only. | |
MINORITY_OWNED_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
WOMAN_OWNED_IND | VARCHAR2 | 30 | Oracle internal use only. | |
DISADV_8A_IND | VARCHAR2 | 30 | Oracle internal use only. | |
SMALL_BUS_IND | VARCHAR2 | 30 | Oracle internal use only. | |
RENT_OWN_IND | VARCHAR2 | 30 | Oracle internal use only. | |
DEBARMENTS_COUNT | NUMBER | Oracle internal use only. | ||
DEBARMENTS_DATE | DATE | Oracle internal use only. | ||
FAILURE_SCORE | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_NATNL_PERCENTILE | NUMBER | Oracle internal use only. | ||
FAILURE_SCORE_OVERRIDE_CODE | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY | VARCHAR2 | 30 | Oracle internal use only. | |
GLOBAL_FAILURE_SCORE | VARCHAR2 | 5 | Oracle internal use only. | |
DB_RATING | VARCHAR2 | 5 | Oracle internal use only. | |
CREDIT_SCORE | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY | VARCHAR2 | 30 | Oracle internal use only. | |
PAYDEX_SCORE | VARCHAR2 | 3 | Oracle internal use only. | |
PAYDEX_THREE_MONTHS_AGO | VARCHAR2 | 3 | Oracle internal use only. | |
PAYDEX_NORM | VARCHAR2 | 3 | Oracle internal use only. | |
BEST_TIME_CONTACT_BEGIN | DATE | Oracle internal use only. | ||
BEST_TIME_CONTACT_END | DATE | Oracle internal use only. | ||
ORGANIZATION_NAME_PHONETIC | VARCHAR2 | 320 | Oracle internal use only. | |
TAX_REFERENCE | VARCHAR2 | 50 | Oracle internal use only. | |
GSA_INDICATOR_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
JGZZ_FISCAL_CODE | VARCHAR2 | 20 | Oracle internal use only. | |
ANALYSIS_FY | VARCHAR2 | 5 | Oracle internal use only. | |
FISCAL_YEAREND_MONTH | VARCHAR2 | 30 | Oracle internal use only. | |
CURR_FY_POTENTIAL_REVENUE | NUMBER | Oracle internal use only. | ||
NEXT_FY_POTENTIAL_REVENUE | NUMBER | Oracle internal use only. | ||
YEAR_ESTABLISHED | NUMBER | Oracle internal use only. | ||
MISSION_STATEMENT | VARCHAR2 | 2000 | Oracle internal use only. | |
ORGANIZATION_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
BUSINESS_SCOPE | VARCHAR2 | 20 | Oracle internal use only. | |
CORPORATION_CLASS | VARCHAR2 | 60 | Oracle internal use only. | |
KNOWN_AS | VARCHAR2 | 240 | Oracle internal use only. | |
KNOWN_AS2 | VARCHAR2 | 240 | Oracle internal use only. | |
KNOWN_AS3 | VARCHAR2 | 240 | Oracle internal use only. | |
KNOWN_AS4 | VARCHAR2 | 240 | Oracle internal use only. | |
KNOWN_AS5 | VARCHAR2 | 240 | Oracle internal use only. | |
LOCAL_BUS_IDEN_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
LOCAL_BUS_IDENTIFIER | VARCHAR2 | 60 | Oracle internal use only. | |
PREF_FUNCTIONAL_CURRENCY | VARCHAR2 | 30 | Oracle internal use only. | |
REGISTRATION_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
TOTAL_EMPLOYEES_TEXT | VARCHAR2 | 60 | Oracle internal use only. | |
TOTAL_EMPLOYEES_IND | VARCHAR2 | 30 | Oracle internal use only. | |
TOTAL_EMP_EST_IND | VARCHAR2 | 30 | Oracle internal use only. | |
TOTAL_EMP_MIN_IND | VARCHAR2 | 30 | Oracle internal use only. | |
PARENT_SUB_IND | VARCHAR2 | 30 | Oracle internal use only. | |
INCORP_YEAR | NUMBER | Oracle internal use only. | ||
SIC_CODE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
PUBLIC_PRIVATE_OWNERSHIP_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
INTERNAL_FLAG | VARCHAR2 | 30 | Oracle internal use only. | |
LOCAL_ACTIVITY_CODE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
LOCAL_ACTIVITY_CODE | VARCHAR2 | 30 | Oracle internal use only. | |
EMP_AT_PRIMARY_ADR | VARCHAR2 | 10 | Oracle internal use only. | |
EMP_AT_PRIMARY_ADR_TEXT | VARCHAR2 | 12 | Oracle internal use only. | |
EMP_AT_PRIMARY_ADR_EST_IND | VARCHAR2 | 30 | Oracle internal use only. | |
EMP_AT_PRIMARY_ADR_MIN_IND | VARCHAR2 | 30 | Oracle internal use only. | |
HIGH_CREDIT | NUMBER | Oracle internal use only. | ||
AVG_HIGH_CREDIT | NUMBER | Oracle internal use only. | ||
TOTAL_PAYMENTS | NUMBER | Oracle internal use only. | ||
CREDIT_SCORE_CLASS | NUMBER | Oracle internal use only. | ||
CREDIT_SCORE_NATL_PERCENTILE | NUMBER | Oracle internal use only. | ||
CREDIT_SCORE_INCD_DEFAULT | NUMBER | Oracle internal use only. | ||
CREDIT_SCORE_AGE | NUMBER | Oracle internal use only. | ||
CREDIT_SCORE_DATE | DATE | Oracle internal use only. | ||
CREDIT_SCORE_COMMENTARY2 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY3 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY4 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY5 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY6 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY7 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY8 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY9 | VARCHAR2 | 30 | Oracle internal use only. | |
CREDIT_SCORE_COMMENTARY10 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_CLASS | NUMBER | Oracle internal use only. | ||
FAILURE_SCORE_INCD_DEFAULT | NUMBER | Oracle internal use only. | ||
FAILURE_SCORE_AGE | NUMBER | Oracle internal use only. | ||
FAILURE_SCORE_DATE | DATE | Oracle internal use only. | ||
FAILURE_SCORE_COMMENTARY2 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY3 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY4 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY5 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY6 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY7 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY8 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY9 | VARCHAR2 | 30 | Oracle internal use only. | |
FAILURE_SCORE_COMMENTARY10 | VARCHAR2 | 30 | Oracle internal use only. | |
MAXIMUM_CREDIT_RECOMMENDATION | NUMBER | Oracle internal use only. | ||
MAXIMUM_CREDIT_CURRENCY_CODE | VARCHAR2 | 240 | Oracle internal use only. | |
DISPLAYED_DUNS_PARTY_ID | NUMBER | Oracle internal use only. | ||
CONTENT_SOURCE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
CONTENT_SOURCE_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
CREATED_BY_MODULE | VARCHAR2 | 150 | Oracle internal use only. | |
APPLICATION_ID | NUMBER | Oracle internal use only. |