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. |