| 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)
|
STUDENT
|
ACADEMIC_PERIOD
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
|
ACADEMIC_PERIOD_BEGIN_DATE
|
Start date for the academic period.
|
DATE
|
YEAR_TYPE_DEFINITION
|
START_DATE
|
NO
|
NO
|
ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, COURSE INSTRUCTOR, COURSE SECTION, ENROLLMENT, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, GRADUATION COMPLETION, MEETING TIME, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS
|
|
ACADEMIC_PERIOD_END_DATE
|
End date for the academic period.
|
DATE
|
YEAR_TYPE_DEFINITION
|
END_DATE
|
NO
|
NO
|
ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, COURSE INSTRUCTOR, COURSE SECTION, ENROLLMENT, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, GRADUATION COMPLETION, MEETING TIME, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS
|
|
ACADEMIC_PERIOD_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
STUDENT
|
ACADEMIC_PERIOD_DESC
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
|
ACADEMIC_PERIOD_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
STUDENT
|
ACADEMIC_PERIOD_DESC
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
|
ACADEMIC_TIME_KEY
|
Key of the Academic Time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, ENROLLMENT, GRADUATION COMPLETION, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, STUDENT, STUDENT PROGRESS
|
|
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.
|
VARCHAR2(63)
|
STUDENT
|
ACADEMIC_YEAR
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
|
ACADEMIC_YEAR_LD
|
Long description for the academic year.
|
VARCHAR2(255)
|
STUDENT
|
ACADEMIC_YEAR_DESC
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
|
ACADEMIC_YEAR_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
STUDENT
|
ACADEMIC_YEAR_DESC
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, ENROLLMENT, GRADUATION COMPLETION, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, STUDENT, STUDENT PROGRESS
ACADEMIC OUTCOME, ADVISOR, ATHLETIC, COMBINED ADMISSIONS SOURCE, COURSE INSTRUCTOR, COURSE SECTION, FEEDBACK, FINANCIAL AID AWARD BY ACADEMIC PERIOD, GRADE CHANGE, MEETING TIME, RETENTION MULTI YEAR, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED ETL GENERATED
|
NA NA
|
NO NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, ENROLLMENT, GRADUATION COMPLETION, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, STUDENT, STUDENT PROGRESS, STUDENT PROGRESS
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, ENROLLMENT, GRADUATION COMPLETION, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, STUDENT, STUDENT PROGRESS, STUDENT PROGRESS
|