OKC_ENTITLEMENT_RESULT_GT
Entitlement Result Global Temporary Table
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OKC_ENTITLEMENT_RESULT_GT_PK |
ENTITLEMENT_RESULT_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ENTITLEMENT_RESULT_ID | NUMBER | Yes | Entitlement Result Id | |
| ENTITLEMENT_ID | NUMBER | Yes | Entitlement Id | |
| CALENDAR_ID | NUMBER | Calendar Id | ||
| RESULT_NAME | VARCHAR2 | 120 | Result Name | |
| RESULT_VALUE | VARCHAR2 | 120 | Result Value | |
| RESULT_THRESHOLD_VALUE | VARCHAR2 | 20 | Result Threshold Value |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| OKC_ENTITLEMENT_RESULT_GT_U1 | Unique | ENTITLEMENT_RESULT_ID |