INF_CV_WORKAREAS
Back to current versionRestore this version

Alias: IVTWA#

(INF_CV_WORKAREAS)
Work Areas

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
WORK_DIVISION_CODEVarchar2(16)CODEY
WORK_AREA_CODEVarchar2(16)CODEY
WORK_AREA_STANDINGVarchar2(30)VARCHAR30
EFFECTIVEDate()EFFECTIVE
EXPIRYDate()EXPIRY
WORK_AREA_STATUSVarchar2(30)VARCHAR30
WORK_AREA_TYPEVarchar2(30)VARCHAR30
DESCRIPTIONVarchar2(50)DESCRIPTION
TS_APPROVAL_RULEVarchar2(30)VARCHAR30
MINIMUM_HOURS_OFFNumber(9)AMT5V4
CHANGE_CODEVarchar2(16)CODE
PERSON_CODEVarchar2(16)CODE
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30