| 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.
|
VARCHAR2(63)
|
ADMISSIONS_APPLICATION
|
ACADEMIC_PERIOD
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
ACADEMIC_PERIOD_LD
|
Long description of the academic period.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION
|
ACADEMIC_PERIOD_DESC
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
ACADEMIC_PERIOD_SD
|
Short description of the academic period.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION
|
ACADEMIC_PERIOD_DESC
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
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)
|
ADMISSIONS_APPLICATION
|
ACADEMIC_YEAR
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
ACADEMIC_YEAR_LD
|
Long description for the academic year.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION
|
ACADEMIC_YEAR_DESC
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
ACADEMIC_YEAR_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ADMISSIONS_APPLICATION
|
ACADEMIC_YEAR_DESC
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
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 portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc.
|
VARCHAR2(63)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
AID_PERIOD AID_PERIOD
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
AID_PERIOD_LD
|
Long description of the financial aid period.
|
VARCHAR2(255)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
AID_PERIOD_DESC AID_PERIOD_DESC
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
AID_PERIOD_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
AID_PERIOD_DESC AID_PERIOD_DESC
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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.
|
VARCHAR2(63)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
YEAR_CODE YEAR_CODE
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
AID_YEAR_LD
|
Long description of the financial aid year.
|
VARCHAR2(255)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
YEAR_CODE_DESC YEAR_CODE_DESC
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
AID_YEAR_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
YEAR_CODE_DESC YEAR_CODE_DESC
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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)
|
ADMISSIONS_APPLICATION
|
APPLICATION_DATE
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
CALENDAR_MONTH_LD
|
Long description of the calendar month.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
CALENDAR_MONTH_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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)
|
ADMISSIONS_APPLICATION
|
APPLICATION_DATE
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
CALENDAR_YEAR_LD
|
Long description of the calendar year.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
CALENDAR_YEAR_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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 EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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
|
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_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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
|
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
|
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)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
FUNCTION FUNCTION
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
FISCAL_PERIOD_LD
|
Long description of the fiscal period.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
FISCAL_PERIOD_SD
|
Short description of the fiscal period.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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)
|
FUNCTION FUNCTION
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
FISCAL_QUARTER_LD
|
Long description of the fiscal quarter.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
FISCAL_QUARTER_SD
|
Short description of the fiscal quarter.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, 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)
|
YEAR_TYPE_DEFINITION YEAR_TYPE_DEFINITION
|
FUNCTION FUNCTION
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
FISCAL_YEAR_LD
|
Long description of the fiscal year.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
FISCAL_YEAR_SD
|
Short description of the fiscal year.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
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
|
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
|
|
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_STUDY ACADEMIC_STUDY
|
SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD
|
NO NO
|
NO
|
ADVANCEMENT GIFT, ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ADVANCEMENT GIFT, ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
SUB_ACADEMIC_PERIOD_LD
|
Long description of the sub academic period.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ACADEMIC_STUDY
|
SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC
|
NO NO
|
NO
|
ADVANCEMENT GIFT, ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ADVANCEMENT GIFT, ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
SUB_ACADEMIC_PERIOD_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ACADEMIC_STUDY
|
SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD_DESC
|
NO NO
|
NO
|
ADVANCEMENT GIFT, ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
ADVANCEMENT GIFT, ADVANCEMENT GIFT, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, OPERATING LEDGER, OPERATING LEDGER, RECRUITING AND ADMISSION, 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
|