Alias: IVDDP#

(INF_CV_DEPARTMENTS)
Date sensitive department information.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODE_SUB_DIVISIONVarchar2(16)CODEY
ENTITY_CODE_LEGALVarchar2(16)CODE
DEPARTMENT_CODEVarchar2(16)CODEY
STANDINGVarchar2(30)VARCHAR30
GENERIC_CODEVarchar2(16)CODE
EFFECTIVEDate()EFFECTIVE
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
DEPARTMENT_NAMEVarchar2(50)VARCHAR50Y
LOCATION_CODE_LOCATED_INVarchar2(16)CODE
WORK_RULE_CODEVarchar2(16)CODE
PERSON_CODEVarchar2(16)CODE
LOCATION_CODE_PAYDESTVarchar2(16)CODE
AUTHORIZATION_CODEVarchar2(16)CODE
POSITION_CODEVarchar2(16)CODE
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
BURDEN_PERCENTNumber(5)PERCENT
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
EEOC_FUNCTIONVarchar2(30)VARCHAR30
BATCH_CODEVarchar2(16)CODE
INDUSTRY_CODEVarchar2(16)CODE
OFFICE_CODEVarchar2(16)CODE
BURDEN_METHODVarchar2(30)VARCHAR30
DEPARTMENT_CODE_REPORTING_TOVarchar2(16)CODE
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30