| 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)
|
ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_RATING ADMISSIONS_REQUIREMENT AWARD_BY_PERSON RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION
|
ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD ACADEMIC_PERIOD
|
NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
ADMINISTRATOR ADMISSIONS APPLICATION APPLICATION ATTRIBUTE APPLICATION COHORT APPLICATION DECISION APPLICATION RATING
APPLICATION REQUIREMENT FINANCIAL AID AWARD BY ACADEMIC PERIOD RECRUITMENT ATTRIBUTE RECRUITMENT COHORT ADMISSIONS RECRUITMENT
|
|
ACADEMIC_PERIOD_BEGIN_DATE
|
Start date for the academic period.
|
DATE
|
YEAR_TYPE_DEFINITION
|
START_DATE
|
NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT
|
|
ACADEMIC_PERIOD_END_DATE
|
End date for the academic period.
|
DATE
|
YEAR_TYPE_DEFINITION
|
END_DATE
|
NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, FINANCIAL AID AWARD BY ACADEMIC PERIOD, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT
|
|
ACADEMIC_PERIOD_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_RATING ADMISSIONS_REQUIREMENT AWARD_BY_PERSON RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION
|
ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC 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 NO NO NO NO
|
NO
|
ADMINISTRATOR ADMISSIONS APPLICATION APPLICATION ATTRIBUTE APPLICATION COHORT APPLICATION DECISION APPLICATION RATING
APPLICATION REQUIREMENT FINANCIAL AID AWARD BY ACADEMIC PERIOD RECRUITMENT ATTRIBUTE RECRUITMENT COHORT ADMISSIONS RECRUITMENT
|
|
ACADEMIC_PERIOD_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_RATING ADMISSIONS_REQUIREMENT AWARD_BY_PERSON RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION
|
ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC ACADEMIC_PERIOD_DESC 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 NO NO NO NO
|
NO
|
ADMINISTRATOR ADMISSIONS APPLICATION APPLICATION ATTRIBUTE APPLICATION COHORT APPLICATION DECISION APPLICATION RATING
APPLICATION REQUIREMENT FINANCIAL AID AWARD BY ACADEMIC PERIOD RECRUITMENT ATTRIBUTE RECRUITMENT COHORT ADMISSIONS RECRUITMENT
|
|
ACADEMIC_TIME_KEY
|
Key of the Academic Time dimension.
|
NUMBER
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT
FINANCIAL AID AWARD BY ACADEMIC PERIOD
|
|
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)
|
ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_RATING ADMISSIONS_REQUIREMENT RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION YEAR_TYPE_DEFINITION
|
ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR ACADEMIC_YEAR
|
NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
ADMINISTRATOR ADMISSIONS APPLICATION APPLICATION ATTRIBUTE APPLICATION COHORT APPLICATION DECISION APPLICATION RATING
APPLICATION REQUIREMENT RECRUITMENT ATTRIBUTE RECRUITMENT COHORT ADMISSIONS RECRUITMENT FINANCIAL AID AWARD BY ACADEMIC PERIOD
|
|
ACADEMIC_YEAR_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_RATING ADMISSIONS_REQUIREMENT RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION YEAR_TYPE_DEFINITION
|
ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC
|
NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
ADMINISTRATOR ADMISSIONS APPLICATION APPLICATION ATTRIBUTE APPLICATION COHORT APPLICATION DECISION APPLICATION RATING
APPLICATION REQUIREMENT RECRUITMENT ATTRIBUTE RECRUITMENT COHORT ADMISSIONS RECRUITMENT FINANCIAL AID AWARD BY ACADEMIC PERIOD
|
|
ACADEMIC_YEAR_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_RATING ADMISSIONS_REQUIREMENT RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION YEAR_TYPE_DEFINITION
|
ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC
|
NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
ADMINISTRATOR ADMISSIONS APPLICATION APPLICATION ATTRIBUTE APPLICATION COHORT APPLICATION DECISION APPLICATION RATING
APPLICATION REQUIREMENT RECRUITMENT ATTRIBUTE RECRUITMENT COHORT ADMISSIONS RECRUITMENT FINANCIAL AID AWARD BY ACADEMIC PERIOD
|
|
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, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT
FINANCIAL AID AWARD BY ACADEMIC PERIOD
|
|
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, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT
FINANCIAL AID AWARD BY ACADEMIC PERIOD
|