| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
BIRTH_DATE
|
Date of birth for the person.
|
DATE
|
PERSON
|
BIRTH_DATE
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, FEEDBACK, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST
|
|
CONFIDENTIALITY_IND
|
Specifies whether the person has requested the institution keep some of their information confidential.
|
VARCHAR2(63)
|
PERSON
|
CONFIDENTIALITY_IND
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, FEEDBACK, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST
|
|
DECEASED_DATE
|
Date the person died.
|
DATE
|
PERSON
|
DECEASED_DATE
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, FEEDBACK, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST
|
|
EMAIL_ADDRESS
|
Preferred email address of the person.
|
VARCHAR2(255)
|
PERSON
|
EMAIL_ADDRESS
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, FEEDBACK, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST
|
|
FULL_NAME_LFMI
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
PERSON
|
FULL_NAME_LFMI
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, FEEDBACK, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST
|
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
PERSON
|
ID
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, FEEDBACK, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
TEST
|
PERSON_UID
|
NO
|
NO
|
TEST
|
|
PHONE_NUMBER_COMBINED
|
All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.
|
VARCHAR2(63)
|
TELEPHONE
|
PHONE_NUMBER_COMBINED
|
NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT PROGRESS, TEST
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT PROGRESS, TEST
|