INTVSCHED

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
INTVSCHED_IDINTEGER NOT NULLReserved for HCL internal use.
INITIATIVE_IDINTEGER NOT NULLReserved for HCL internal use.
EMSPOT_IDINTEGER NOT NULLReserved for HCL internal use.
STARTDATETIMESTAMP NOT NULLReserved for HCL internal use.
ENDDATETIMESTAMP NOT NULLReserved for HCL internal use.
PRIORITYINTEGERReserved for HCL internal use.
STOREENT_IDINTEGERReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>INTVSCHED_IDPrimary Key
I0000313EMSPOT_IDNon-Unique Index
I0000314INITIATIVE_IDNon-Unique Index
I0000590STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_386INITIATIVE_IDESMAPOBJESMAPOBJ_IDCascade
F_387EMSPOT_IDEMSPOTEMSPOT_IDCascade
F_956STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1095INTVSCHED_IDSHDCACRMSCHED_IDCascade