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 General Ledger Star Graduation Completion Star Grant And Project Star Operating Ledger Star Receivable Customer Star Receivable Revenue Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_TIME

Description Time Dimension table provides information on the time frame for which the rest of the associated dimension and fact table are storing the information in the star. The time dimension may be based either on a calendar, academic, financial aid or fiscal year, The time frame will go down at least one and sometimes two layers to periods and or sub periods of time. 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
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. This can be taken directly from the Enrollment reporting view in the ODS or calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

ACADEMIC_PERIOD

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

ACADEMIC_PERIOD_LD Long description of the academic period. VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

ACADEMIC_PERIOD_DESC

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

ACADEMIC_PERIOD_SD Short description of the academic period. VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

ACADEMIC_PERIOD_DESC

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

ACADEMIC_PERIOD_SEQ Assigned in the EDW. Specifies order in that descriptions should be displayed (instead of alphabetical). NUMBER

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

ACADEMIC_YEAR Represents an academic year. Academic years in the Northern Hemisphere typically go from September through August and in the Southern Hemisphere from January to December. But there are many institution variations on the academic year. This can be taken directly from the Enrollment reporting view in the ODS or calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

ACADEMIC_YEAR

YEAR

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

FINANCIAL AID STUDENT

ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

ACADEMIC_YEAR_LD Long description of the academic year. VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

ACADEMIC_YEAR_DESC

YEAR_DESC

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

EMPLOYEE

ADVANCEMENT GIFT, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

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

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

ACADEMIC_YEAR_DESC

YEAR_DESC

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

EMPLOYEE

ADVANCEMENT GIFT, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

ACAD_PER_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

ACAD_YR_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

AID_PERIOD Represents a financial aid period or a portion of the aid year. Aid periods may follow the academic period or have a smaller time frame for tracking the aid awarded, accepted, paid, etc. This can be taken directly from the Award by person reporting view VARCHAR2(63)

AWARD_BY_PERSON

YEAR_TYPE_DEFINITION

AID_PERIOD

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

AID_PERIOD_LD Long description of the financial aid period. VARCHAR2(255)

AWARD_BY_PERSON

YEAR_TYPE_DEFINITION

AID_PERIOD_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

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

AWARD_BY_PERSON

YEAR_TYPE_DEFINITION

AID_PERIOD_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

AID_PER_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. This can be taken directly from the Award by person reporting view in the ODS or calculated using the Year type definition composite database VARCHAR2(63)

AWARD_BY_PERSON

YEAR_TYPE_DEFINITION

YEAR

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

AID_YEAR_LD Long description of the financial aid year. VARCHAR2(255)

AWARD_BY_PERSON

YEAR_TYPE_DEFINITION

YEAR_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

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

AWARD_BY_PERSON

YEAR_TYPE_DEFINITION

YEAR_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

AID_YR_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

CALENDAR_MONTH Month with in the calendar year. May be calculated using the CURRENT_HIRE_DATE from the EMPLOYEE view or the GIFT_DATE from the GIFT view. This can be calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

EMPLOYEE

EMPLOYEE_EARNING_CY

GIFT

HR_APPLICATION

PREVIOUS_EDUCATION

RECEIVABLE_ACCOUNT_DETAIL

YEAR_TYPE_DEFINITION

OUTCOME_GRADUATION_DATE

APPLICATION_DATE

CURRENT_HIRE_DATE

MONTH

GIFT_DATE

APPLICATION_DATE

POST_SECONDARY_DEGREE_DATE

TRANSACTION_DATE

CALENDAR_MONTH

NO

NO

EMPLOYEE DEGREE, GRADUATION COMPLETION

RECRUITING AND ADMISSION

EMPLOYEE

EMPLOYEE POSITION

ADVANCEMENT GIFT

EMPLOYMENT APPLICATION

EMPLOYEE DEGREE

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

CALENDAR_MONTH_LD Long description of the calendar month. 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

CALENDAR_MONTH_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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

CALENDAR_YEAR Year calculated using the CURRENT_HIRE_DATE from the EMPLOYEE view or the GIFT_DATE from the GIFT view. This can be calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

EMPLOYEE

EMPLOYEE_EARNING_CY

GIFT

HR_APPLICATION

PREVIOUS_EDUCATION

RECEIVABLE_ACCOUNT_DETAIL

YEAR_TYPE_DEFINITION

OUTCOME_GRADUATION_DATE

APPLICATION_DATE

CURRENT_HIRE_DATE

MONTH

GIFT_DATE

APPLICATION_DATE

POST_SECONDARY_DEGREE_DATE

TRANSACTION_DATE

CALENDAR_YEAR

NO

NO

EMPLOYEE DEGREE, GRADUATION COMPLETION

RECRUITING AND ADMISSION

EMPLOYEE

EMPLOYEE POSITION

ADVANCEMENT GIFT

EMPLOYMENT APPLICATION

EMPLOYEE DEGREE

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER

CALENDAR_YEAR_LD Long description of the calendar year. 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

CALENDAR_YEAR_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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

CAL_MM_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

CAL_YR_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

EVENT Event code given to this transformation and load process so it can be identified and selected. An example of how the event might be used is to label the time sliced information at Beginning of Year, Census Day, End of Year for registration data or bi-weekly for payroll data. VARCHAR2(63)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

EVENT_DATE Date that the data for this event was brought into the EDW. DATE

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

EVENT_LD Long description of the event. 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

EVENT_QUALIFIER Event code given to this transformation and load process so it can be identified and selected. An example of how the event might be used is to label the time sliced information at Beginning of Year, Census Day, End of Year for registration data or bi-weekly for payroll data. VARCHAR2(63)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

EVENT_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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

EVENT_SEQ Assigned in the EDW. Specifies order in that descriptions should be displayed (instead of alphabetical). NUMBER

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

FISCAL_PERIOD Represents a fiscal period or a portion of the fiscal year. Fiscal periods usually divide the year into months. This can be calculated by using the GIFT, GIFT_DATE. This may be taken from the Operating or General Ledger as appropriate. This can also be calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

GENERAL_LEDGER

GIFT

GRANT_LEDGER

OPERATING_LEDGER

YEAR_TYPE_DEFINITION

FISCAL_PERIOD

FUNCTION

FISCAL_PERIOD

FUNCTION

NO

NO

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

OPERATING LEDGER

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

FISCAL_PERIOD_LD Long description of the fiscal period. 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

FISCAL_PERIOD_SD Short description of the fiscal period. 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

FISCAL_PER_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

FISCAL_QTR_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

FISCAL_QUARTER Calculated fiscal quarter or a portion of the fiscal year. Fiscal quarters usually divide the year into three months segments. This may be taken from the Operating or General Ledger as appropriate. This can also be calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

EMPLOYEE_EARNING_FY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

YEAR_TYPE_DEFINITION

QUARTER

FISCAL_QUARTER

FUNCTION

NO

NO

EMPLOYEE, EMPLOYEE POSITION

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

FISCAL_QUARTER_LD Long description of the fiscal quarter. 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

FISCAL_QUARTER_SD Short description of the fiscal quarter. 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

FISCAL_YEAR Represents the fiscal year. Fiscal years typically go from July through June or September through August. This is usually determined by the reporting required to a parent group like a State or Province. There are many institution variations on the fiscal year. This may be taken from the Operating or General Ledger as appropriate. This can also be calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

EDW CLEANSING PROCESS

EMPLOYEE_EARNING_FY

GENERAL_LEDGER

GIFT

GRANT_LEDGER

OPERATING_LEDGER

YEAR_TYPE_DEFINITION

NA

FUNCTION

FISCAL_YEAR

FISCAL_YEAR_DESC

FISCAL_YEAR

FUNCTION

NO

NO

EMPLOYEE DEGREE

EMPLOYEE, EMPLOYEE POSITION

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

OPERATING LEDGER

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, EMPLOYEE, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

FISCAL_YEAR_LD Long description of the fiscal year. VARCHAR2(255)

EDW CLEANSING PROCESS

EMPLOYEE_EARNING_FY

GENERAL_LEDGER

GRANT_AND_PROJECT

OPERATING_LEDGER

NA

FUNCTION

FISCAL_YEAR_DESC

NO

NO

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

EMPLOYEE, EMPLOYEE POSITION

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

FISCAL_YEAR_SD Short description of the fiscal year. VARCHAR2(255)

EDW CLEANSING PROCESS

EMPLOYEE_EARNING_FY

GENERAL_LEDGER

GIFT

GRANT_AND_PROJECT

OPERATING_LEDGER

NA

FUNCTION

FISCAL_YEAR_DESC

NO

NO

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

EMPLOYEE, EMPLOYEE POSITION

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

OPERATING LEDGER

FISCAL_YR_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

MULTI_SOURCE_QUALIFIER Multi source parameter given to the transformation and load process to be able to identify and select the correct records VARCHAR2(63)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

SUB_ACADEMIC_PERIOD Represents an portion of an academic period. Sub academic periods may divide the year into months or portions of a term or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic period. This can be taken directly from the Enrollment reporting view in the ODS or calculated using the Year type definition composite database table in the ODS. VARCHAR2(63)

ACADEMIC_OUTCOME

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

SUB_ACADEMIC_PERIOD

NO

NO

GRADUATION COMPLETION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION

SUB_ACADEMIC_PERIOD_LD Long description of the sub academic period. VARCHAR2(255)

ACADEMIC_OUTCOME

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

SUB_ACADEMIC_PERIOD_DESC

NO

NO

GRADUATION COMPLETION

ENROLLMENT

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION

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

ACADEMIC_OUTCOME

ENROLLMENT

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

YEAR_TYPE_DEFINITION

SUB_ACADEMIC_PERIOD_DESC

NO

NO

GRADUATION COMPLETION

ENROLLMENT, GENERAL LEDGER

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION

SUB_ACAD_PER_LAST_EVENT_IND Indicates the latest event for this time frame and event code. VARCHAR2(6)

ETL GENERATED

NA

NA

NO

NO

ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ACADEMIC PROGRAM COURSE

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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

TIME_KEY Key for the time 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, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION



Ver: 3.1