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