RETURN TO DIMENSION TABLE REPORTS LIST
Employment Application Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_EMPLOYMENT_HISTORY

Description Employment History Dimension table provides information on the employers for the person that are stored in the system. This information includes employer name and type of industry for the company. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
EMPLOYER_INDUSTRIAL_TYPE Identifies the type of industry and the type of experience the employee had with this employer. VARCHAR2(63)

EMPLOYMENT_HISTORY

EMPLOYER_INDUSTRIAL_TYPE

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYER_INDUSTRIAL_TYPE_LD Long description of the industry type. VARCHAR2(255)

EMPLOYMENT_HISTORY

EMPLOYER_INDUSTRIAL_DESC

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYER_INDUSTRIAL_TYPE_SD Short description of the industry type. VARCHAR2(255)

EMPLOYMENT_HISTORY

EMPLOYER_INDUSTRIAL_DESC

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYER_NAME Name of the employer for this employment history record. VARCHAR2(255)

EMPLOYMENT_HISTORY

EMPLOYER_NAME

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYMENT_HISTORY_KEY Key for the employment history dimension NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION



Ver: 3.1