| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
POST_SECONDARY_AWD_CATEGORY
|
Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.
|
VARCHAR2(63)
|
MST_PREVIOUS_EDUCATION
|
AWARD_CATEGORY
|
NO
|
NO
|
ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL
|
|
POST_SECONDARY_AWD_CATEGORY_LD
|
Long description for degree award category.
|
VARCHAR2(255)
|
MST_PREVIOUS_EDUCATION
|
AWARD_CATEGORY_DESC
|
NO
|
NO
|
ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL
|
|
POST_SECONDARY_AWD_CATEGORY_SD
|
Short description for degree award category.
|
VARCHAR2(255)
|
MST_PREVIOUS_EDUCATION
|
AWARD_CATEGORY_DESC
|
NO
|
NO
|
ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL
|
|
POST_SECONDARY_DEGREE
|
Identifies the degree or award associated with the previous post secondary school or internally awarded degree or other award from the ACADEMIC_OUTCOME reporting view.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PRE_STUDENT
|
DEGREE POST_SECONDARY_DEGREE POST_SECONDARY_DEGREE1 POST_SECONDARY_DEGREE1 POST_SECONDARY_DEGREE1
|
NO NO NO NO NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION POST SECONDARY SCHOOL EMPLOYEE DEGREE
EMPLOYMENT APPLICATION RECRUITING AND ADMISSION
|
|
POST_SECONDARY_DEGREE_LD
|
Long name of the degree or award.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PRE_STUDENT
|
DEGREE_DESC POST_SECONDARY_DEGREE_DESC POST_SECONDARY_DEGREE_DESC1 POST_SECONDARY_DEGREE_DESC1 POST_SECONDARY_DEGREE_DESC1
|
NO NO NO NO NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION POST SECONDARY SCHOOL EMPLOYEE DEGREE
EMPLOYMENT APPLICATION RECRUITING AND ADMISSION
|
|
POST_SECONDARY_DEGREE_SD
|
Short name of the degree or award.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PRE_STUDENT
|
DEGREE_DESC POST_SECONDARY_DEGREE_DESC POST_SECONDARY_DEGREE_DESC1 POST_SECONDARY_DEGREE_DESC_1 POST_SECONDARY_DEGREE_DESC1
|
NO NO NO NO NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION POST SECONDARY SCHOOL EMPLOYEE DEGREE
EMPLOYMENT APPLICATION RECRUITING AND ADMISSION
|
|
POST_SECONDARY_GPA_RANGE
|
Range of persons post secondary institution average or GPA.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION
|
GPA SCHOOL_GPA
|
NO NO
|
NO
|
POST SECONDARY SCHOOL POST SECONDARY SCHOOL
|
|
POST_SECONDARY_GPA_RANGE_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
POST_SECONDARY_GPA_RANGE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
POST_SECONDARY_MAJOR
|
Identifies the major or subject area associated with the previous post secondary school.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PRE_STUDENT
|
MAJOR POST_SECONDARY_DEGREE_MAJOR1 POST_SECONDARY_MAJOR1 POST_SECONDARY_MAJOR1_1 POST_SECONDARY_MAJOR1
|
NO NO NO NO NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION POST SECONDARY SCHOOL EMPLOYEE DEGREE
EMPLOYMENT APPLICATION RECRUITING AND ADMISSION
|
|
POST_SECONDARY_MAJOR_LD
|
Long name of the major or subject area.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION PRE_STUDENT
|
MAJOR_DESC POST_SECONDARY_MAJOR_DESC1 POST_SECONDARY_MAJOR_DESC1
|
NO NO NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL
RECRUITING AND ADMISSION
|
|
POST_SECONDARY_MAJOR_SD
|
Short name of the major or subject area.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME PREVIOUS_EDUCATION PRE_STUDENT
|
MAJOR_DESC POST_SECONDARY_MAJOR_DESC1 POST_SECONDARY_MAJOR_DESC1
|
NO NO NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL
RECRUITING AND ADMISSION
|
|
POST_SECONDARY_SCHOOL_KEY
|
Key for the post secondary dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, 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
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION
|
|
TRANSFER_CREDIT_RANGE
|
Range of number of transfer credits received from the previous post secondary institution.
|
VARCHAR2(63)
|
ETL GENERATED PREVIOUS_EDUCATION
|
NA TOTAL_TRANSFER_CREDITS
|
NO NO
|
NO
|
POST SECONDARY SCHOOL POST SECONDARY SCHOOL
|
|
TRANSFER_CREDIT_RANGE_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|
|
TRANSFER_CREDIT_RANGE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
POST SECONDARY SCHOOL
|