RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star Advancement Gift Star Course Registration Star Employee Star Employee Degree Star Employee Position Star Employment Application Star Enrollment Star Financial Aid Pre-Student Star Financial Aid Student Star Graduation Completion Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_DEMOGRAPHIC

Description Demographic Dimension table provides information for the person that is consistent whether this is an employee, inquirer, applicant, student or graduand at the institution. This information includes gender, ethnicity, age range and family income range. It uses the cleansing rules in the EDW for the short and long descriptions as well as the definition of the ranges in this dimension.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
AGE_RANGE The system calculated age is placed into a date range per the rules defined for the age ranges. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

AGE_RANGE_LD Long description assigned during the EDW cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

AGE_RANGE_SD Short description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

ETHNICITY Identifies the institutional ethnic group for the person. VARCHAR2(63)

PERSON

PRIMARY_ETHNICITY

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

ETHNICITY_CATEGORY Identifies the governmental ethnic group for the person. VARCHAR2(63)

PERSON

PRIMARY_ETHNCITY_CATEGORY

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

ETHNICITY_CATEGORY_LD Long description for the governmental ethnic group. VARCHAR2(255)

PERSON

PRIM_ETHNICITY_CATEGORY_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

ETHNICITY_CATEGORY_SD Short description defined in the cleansing process. VARCHAR2(255)

PERSON

PRIM_ETHNICITY_CATEGORY_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

ETHNICITY_LD Long description for the institutional ethnic group. VARCHAR2(255)

PERSON

PRIMARY_ETHNICITY_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

ETHNICITY_SD Short description for the institutional ethnic group. VARCHAR2(255)

PERSON

PRIMARY_ETHNICITY_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

FAMILY_INCOME_RANGE Income for the family placed into a range via the cleansing process. This uses the Family Income value brought from the ODS Needs Analysis reporting view to determine the correct range based on EDW cleansing rules. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

FAMILY_INCOME_RANGE_LD Long description assigned during the EDW cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

FAMILY_INCOME_RANGE_SD Short description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

GENDER Identifies the gender for the person. VARCHAR2(63)

PERSON

GENDER

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

GENDER_LD Long description for the gender code. VARCHAR2(255)

PERSON

GENDER_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

GENDER_SD Short description defined in the cleansing process. VARCHAR2(255)

PERSON

GENDER_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

NATION_OF_CITIZENSHIP Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting. VARCHAR2(63)

PERSON

NATION_OF_CITIZENSHIP

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

NATION_OF_CITIZENSHIP_LD Long description for the nation of citizenship. VARCHAR2(255)

PERSON

NATION_OF_CITIZENSHIP_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

NATION_OF_CITIZENSHIP_SD Short description of the nation of citizenship. VARCHAR2(255)

PERSON

NATION_OF_CITIZENSHIP_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

PRIMARY_DISABILITY When listed, person's primary disability as stored in the ODS. VARCHAR2(63)

PERSON

PRIM_DISABILITY

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

PRIMARY_DISABILITY_LD Long description of the disability code. VARCHAR2(255)

PERSON

PRIM_DISABILITY_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

PRIMARY_DISABILITY_SD Short description defined in the cleansing process. VARCHAR2(255)

PERSON

PRIM_DISABILITY_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, 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

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

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

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

VETERAN_TYPE Identifies the veteran's type stored in the ODS for the person. This may indicate if the persons is a gulf war veteran, etc. VARCHAR2(63)

PERSON

VETERAN_TYPE

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

VETERAN_TYPE_LD Long description for the type of veteran. VARCHAR2(255)

PERSON

VETERAN_TYPE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

VETERAN_TYPE_SD Short description for the type of veteran. VARCHAR2(255)

PERSON

VETERAN_TYPE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

VISA_TYPE Person's current visa type. Important for some institutions, for understanding enrollment patterns or to identify nuances of residency. VARCHAR2(63)

PERSON

VISA_TYPE

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

VISA_TYPE_LD Long description of the visa type. VARCHAR2(255)

PERSON

VISA_TYPE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION

VISA_TYPE_SD Short description of the visa type. VARCHAR2(255)

PERSON

VISA_TYPE_DESC

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION



Ver: 3.1