Alias: IVDDP#

The INF_CV_DEPARTMENTS table is used to import department codes and their attendant data into the software data structures. Departments divide the organization into manageable areas, defining the organization structure from a human resources management point of view. Departments are usually a combination of functional areas of the organization such as sales, marketing and accounting, cost centers such as stores, warehouses, theaters, branches and offices, and production lines or product related processes such as forming, molding, finishing and quality assurance.

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
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top