INF_CV_WORKAREAS
Back to current versionRestore this version

Alias: IVTWA#

(INF_CV_WORKAREAS)
Work Areas

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)Y
WORK_DIVISION_CODEVarchar2(16)Y
WORK_AREA_CODEVarchar2(16)Y
WORK_AREA_STANDINGVarchar2(30)
EFFECTIVEDate()
EXPIRYDate()
WORK_AREA_STATUSVarchar2(30)
WORK_AREA_TYPEVarchar2(30)
DESCRIPTIONVarchar2(50)
TS_APPROVAL_RULEVarchar2(30)
MINIMUM_HOURS_OFFNumber(9)
CHANGE_CODEVarchar2(16)
PERSON_CODEVarchar2(16)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.