RETURN TO DIMENSION TABLE REPORTS LIST
Employee Position Star Employment Application Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_POSITION

Description Position Dimension table provides information on the position as defined for the applicant or employee. This information includes position status, position class, contract type and campus, etc. . 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
APPOINTMENT_PERCENTAGE Percent of the budget assigned to this position. NUMBER

POSITION_DEFINITION

POSITION_APPOINTMENT_PCT

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION Position for an employment requisition or an employment assigned by the institution Human Resource department. VARCHAR2(63)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_CAMPUS Campus code that identifies the location for the employment. VARCHAR2(63)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_LOCATION

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_CAMPUS_LD Long name of the campus. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_LOCATION

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_CAMPUS_SD Short name of the campus. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_LOCATION

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_CLASS Position class associated with this position. VARCHAR2(63)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_CLASS

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_CLASS_LD Long description for the position class. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_CLASS_DESC

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_CLASS_SD Short description for the position class. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_CLASS_DESC

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_CONTRACT_TYPE Indicates whether this is the primary, secondary, or overload type of employment. VARCHAR2(63)

EMPLOYEE_POSITION

POSITION_CONTRACT_TYPE

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION_CONTRACT_TYPE_LD Long description of the contract type VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_CONTRACT_TYPE

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION_CONTRACT_TYPE_SD Short description of the contract type VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_CONTRACT_TYPE

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION_EEO_SKILL Codes for reporting as defined by the federal government that identifies the skill group for the position. VARCHAR2(63)

POSITION_DEFINITION

EEO_SKILL

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION_EEO_SKILL_LD Long description of the EEO skill. VARCHAR2(255)

POSITION_DEFINITION

EEO_SKILL_DESC

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION_EEO_SKILL_SD Short description of the EEO skill. VARCHAR2(255)

POSITION_DEFINITION

EEO_SKILL_DESC

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION_KEY Key for the position dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

POSITION_LD Long description for the position. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_TITLE

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_SD Short description for the position. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_TITLE

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_STATUS Status of the position. VARCHAR2(63)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_STATUS

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_STATUS_LD Long description of the status for the position. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_STATUS_DESC

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

POSITION_STATUS_SD Short description of the status for the position. VARCHAR2(255)

EMPLOYEE_POSITION

POSITION_DEFINITION

POSITION_STATUS_DESC

NO

NO

EMPLOYEE POSITION

EMPLOYMENT APPLICATION

PROGRAM_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of instruction and used for governmental reporting. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

EMPLOYEE POSITION

PROGRAM_CLASSIFICATION_LD Long text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

EMPLOYEE POSITION

PROGRAM_CLASSIFICATION_SD Short text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

EMPLOYEE POSITION

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

ETL GENERATED

NA

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION

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

ETL GENERATED

NA

NO

NO

EMPLOYEE POSITION, EMPLOYMENT APPLICATION



Ver: 3.1