INF_CV_DEPARTMENTS
Back to current versionRestore this version

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation