HTS_SCHED_REQUESTS

Table to store schedule requests

Details

• Schema: FUSION

• Object owner: HTS

• Object type: TABLE

• Tablespace: FUSION_TS_INTERFACE

Primary Key

Name	Columns
HTS_SCHED_REQUESTS_PK	SCHED_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SCHED_REQUEST_ID	NUMBER		18	Yes	Primary Key column containing a random generated number. This column is not updateable.
SCHEDULE_REQUEST_NUMBER	VARCHAR2	120			Identifier of the request as specified by the exporter
REQUEST_TIME	TIMESTAMP				Submission time of the request
REQUEST_TIME_STR	VARCHAR2	80			REQUEST_TIME_STR
REQUEST_SOURCE	VARCHAR2	30			Exporter code or name of the request sender
STATUS_IMP	NUMBER		2		Status for the import phase
STATUS_INT	NUMBER		2		Status for the internalization phase
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
ENTERPRISE_ID	NUMBER		18	Yes	ENTERPRISE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
hts_sched_events	hts_sched_requests	SCHED_REQUEST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
HTS_SCHED_REQUESTS_N1	Non Unique	FUSION_TS_INTERFACE	STATUS_INT
HTS_SCHED_REQUESTS_PK	Unique	FUSION_TS_INTERFACE	SCHED_REQUEST_ID
HTS_SCHED_REQUESTS_U1	Unique	FUSION_TS_INTERFACE	SCHEDULE_REQUEST_NUMBER