OKC_ENTITLEMENT_INPUT_GT
Entitlement input global temporary table.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
OKC_ENTITLEMENT_INPUT_GT_PK |
SERVICE_REQUEST_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SERVICE_REQUEST_ID | NUMBER | 18 | Yes | Service Request Id | |
CUSTOMER_PARTY_ID | NUMBER | 18 | Customer Partty Id | ||
ASSET_ID | NUMBER | 18 | Asset Id | ||
SERVICE_REQUEST_REPORTED_DATE | DATE | Yes | service request reported date | ||
SEVERITY_CODE | VARCHAR2 | 120 | Severity code | ||
CHANNEL_CODE | VARCHAR2 | 120 | Channel Code |
Indexes
Index | Uniqueness | Columns |
---|---|---|
OKC_ENTITLEMENT_INPUT_GT_U1 | Unique | SERVICE_REQUEST_ID |