OKC_ENTITLEMENT_OUTPUT_GT
Entitlements Output Global Temporary Table
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OKC_ENTITLEMENT_OUTPUT_GT_PK |
ENTITLEMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTITLEMENT_ID | NUMBER | 18 | Yes | Entitlement Id | |
| SERVICE_REQUEST_ID | NUMBER | 18 | Service equest Id | ||
| ENTITLEMENT_SOURCE_CODE | VARCHAR2 | 120 | Entitlement Source Code | ||
| ENTITLEMENT_SOURCE | VARCHAR2 | 120 | Entitlement Source | ||
| COVERAGE_ID | NUMBER | 18 | Coverage Id | ||
| COVERAGE_NAME | VARCHAR2 | 120 | Coverage Name | ||
| COVERAGE_DESCRIPTION | VARCHAR2 | 320 | Coverage Description | ||
| CONTRACT_ID | NUMBER | 18 | Contract Id | ||
| CONTRACT_VERSION | NUMBER | 18 | Contract Version | ||
| CONTRACT_NUMBER | VARCHAR2 | 120 | Contract Number | ||
| CONTRACT_NUMBER_MODIFIER | VARCHAR2 | 120 | Contract Number Modifier | ||
| CONTRACT_TYPE | VARCHAR2 | 120 | Contract Type | ||
| CONTRACT_INTENT | VARCHAR2 | 120 | Contract Intent | ||
| CONTRACT_COVERAGE_LINE_ID | NUMBER | 18 | Contract Coverage Line Id | ||
| CONTRACT_COVERAGE_LINE_NUMBER | VARCHAR2 | 120 | Contract Coverage Line Number | ||
| CONTRACT_COVERAGE_LINE_TYPE | VARCHAR2 | 120 | Contract Coverage Line Type | ||
| CONTRACT_COVERAGE_PRODUCT_NAME | VARCHAR2 | 120 | Contract Coverage Product Name | ||
| CONTRACT_COVERAGE_PRODUCT_DESC | VARCHAR2 | 120 | Contract Coverage Product Description | ||
| CONTRACT_COVERED_ASSET_ID | NUMBER | 18 | Contract Covered Asset Id | ||
| CONTRACT_COVERED_ASSET_LINENUM | VARCHAR2 | 120 | Contract Covered Asset Line Number | ||
| CONTRACT_COVERED_AST_PROD_NAME | VARCHAR2 | 200 | Contract Covered Asset Product Name | ||
| CONTRACT_COVERED_AST_PROD_DESC | VARCHAR2 | 320 | Contract Covered Asset Product Description | ||
| CONTRACT_COVERD_AST_START_DATE | DATE | Contract Covered Asset Start Date | |||
| CONTRACT_COVERED_AST_END_DATE | DATE | Contract Covered Asset End Date | |||
| CONTRACT_COVERED_AST_CLS_DATE | DATE | Contract Covered Asset Close Date | |||
| MATRIX_ID | NUMBER | 18 | Matrix id | ||
| IS_TRANSFERRED_COVERAGE | VARCHAR2 | 120 | Transferred Coverage Flag | ||
| IS_CONTRACT_ENTITLED | VARCHAR2 | 120 | Contract Entitled Flag | ||
| CUSTOMER_PARTY_NAME | VARCHAR2 | 120 | Customer Party Name | ||
| ENTITLEMENT_RULE_ID | NUMBER | 18 | Entitlement Rule Id | ||
| START_DATE | DATE | Start Date | |||
| END_DATE | DATE | End Date | |||
| MESSAGE | VARCHAR2 | 320 | Message | ||
| SEVERITY_CODE | NUMBER | 18 | Severity Code | ||
| RULE_START_DATE | DATE | Rule Start Date | |||
| RULE_END_DATE | DATE | Rule End Date | |||
| ENTITLEMENT_RESULT_ID | NUMBER | 18 | Entitlement Result Id | ||
| CALENDAR_ID | NUMBER | 18 | Calendar Id | ||
| RESULT_NAME | VARCHAR2 | 120 | Result Name | ||
| RESULT_VALUE | VARCHAR2 | 120 | Result Value | ||
| RESULT_THRESHOLD_VALUE | VARCHAR2 | 120 | Result Threshold Value | ||
| PRIORITY_CODE | VARCHAR2 | 120 | Priority Code | ||
| CHANNEL_CODE | VARCHAR2 | 120 | Channel Code |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| OKC_ENTITLEMENT_OUTPUT_GT_U1 | Unique | ENTITLEMENT_ID |