Alias: IVTAJ#

(INF_CV_AUTHORIZEDJOBS)

Authorized Jobs

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
UNIT_CODEVarchar2(16)Y
JOB_CODEVarchar2(16)Y
DEPARTMENT_CODEVarchar2(16)Y
PERSON_CODEVarchar2(16)Y
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
AUTHORIZED_TYPEVarchar2(30)Y
START_DATEDate()
END_DATEDate()
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.