| 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
|
AID_PERIOD
|
NO
|
NO
|
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)
|
YEAR_TYPE_DEFINITION
|
AID_PERIOD_DESC
|
NO
|
NO
|
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)
|
YEAR_TYPE_DEFINITION
|
AID_PERIOD_DESC
|
NO
|
NO
|
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.
|
VARCHAR2(63)
|
YEAR_TYPE_DEFINITION
|
YEAR_CODE
|
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_LD
|
Long description of the financial aid year.
|
VARCHAR2(255)
|
YEAR_TYPE_DEFINITION
|
YEAR_CODE_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, 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)
|
YEAR_TYPE_DEFINITION
|
YEAR_CODE_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, 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)
|
ADMISSIONS_APPLICATION
|
APPLICATION_DATE
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
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)
|
ADMISSIONS_APPLICATION
|
APPLICATION_DATE
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
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
|
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
|
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
|
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
|
FUNCTION
|
NO
|
NO
|
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)
|
FUNCTION
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, 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)
|
YEAR_TYPE_DEFINITION
|
FUNCTION
|
NO
|
NO
|
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
|
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_SD
|
Short description of the fiscal 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
|
|
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)
|
CALCULATION
|
FUNCTION
|
NO
|
NO
|
GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECRUITING AND ADMISSION
|
|
SUB_ACADEMIC_PERIOD_LD
|
Long description of the sub academic period.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
EMPLOYEE POSITION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, RECRUITING AND ADMISSION
|
|
SUB_ACADEMIC_PERIOD_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
EMPLOYEE POSITION, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, 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
|