| 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 ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD
|
NO NO NO NO NO 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 ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC
|
NO NO NO NO NO 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 ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC
|
NO NO NO NO NO 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
|
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
|
|
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 YEAR_TYPE_DEFINITION
|
ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR YEAR
|
NO NO NO NO NO NO 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 YEAR_TYPE_DEFINITION
|
ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC YEAR_DESC
|
NO NO NO NO NO NO 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 YEAR_TYPE_DEFINITION
|
ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC YEAR_DESC
|
NO NO NO NO NO NO 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
|
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
|
|
ACAD_YR_LAST_EVENT_IND
|
Indicates the latest event for this time frame and event code.
|
VARCHAR2(6)
|
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
|
|
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 AID_PERIOD
|
NO 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 AID_PERIOD_DESC
|
NO 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 AID_PERIOD_DESC
|
NO 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
|
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
|
|
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 YEAR
|
NO 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 YEAR_DESC
|
NO 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 YEAR_DESC
|
NO 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
|
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
|
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 NO NO NO NO NO NO 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 NO NO NO NO NO NO 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
|
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_YR_LAST_EVENT_IND
|
Indicates the latest event for this time frame and event code.
|
VARCHAR2(6)
|
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
|
|
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
|
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_DATE
|
Date that the data for this event was brought into the EDW.
|
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
|
|
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
|
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
|
|
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
|
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
|
|
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 FISCAL_PERIOD FUNCTION
|
NO NO NO NO 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
|
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_QTR_LAST_EVENT_IND
|
Indicates the latest event for this time frame and event code.
|
VARCHAR2(6)
|
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
|
|
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 FISCAL_QUARTER FISCAL_QUARTER FUNCTION
|
NO NO NO NO 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 FISCAL_YEAR FUNCTION
|
NO NO NO NO NO NO 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 FISCAL_YEAR_DESC FISCAL_YEAR_DESC
|
NO NO NO NO 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 FISCAL_YEAR_DESC FISCAL_YEAR_DESC FISCAL_YEAR_DESC
|
NO NO NO NO NO 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
|
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
|
|
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
|
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
|
|
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 SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD
|
NO NO NO NO 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 SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC
|
NO NO NO NO 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 SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC
|
NO NO NO NO 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
|
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_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
|