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	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
CONFIDENTIALITY_IND	Specifies whether the person has requested the institution keep some of their information confidential.	VARCHAR2(63)	PERSON	CONFIDENTIALITY_IND	NO	NO	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
DECEASED_DATE	Date the person died.	DATE	PERSON	DECEASED_DATE	NO	NO	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
EMAIL_ADDRESS	Preferred email address of the person.	VARCHAR2(255)	PERSON	EMAIL_ADDRESS	NO	NO	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, 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	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	PERSON PERSON	ID ID_NUMBER	NO NO	NO	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST  FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_RATING ADMISSIONS_REQUIREMENT CONTACT HOLD INTEREST PERSON PREVIOUS_EDUCATION RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION SECONDARY_SCHOOL_SUBJECT TEST	PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO	NO	ADMINISTRATOR  ADMISSIONS APPLICATION, PROSPECTIVE STUDENT  APPLICATION ATTRIBUTE  APPLICATION COHORT  APPLICATION DECISION  APPLICATION RATING  APPLICATION REQUIREMENT  CONTACT  HOLD  INTEREST  FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR  POST SECONDARY SCHOOL  RECRUITMENT ATTRIBUTE  RECRUITMENT COHORT  ADMISSIONS RECRUITMENT  SECONDARY SCHOOL SUBJECT  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	ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
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, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST  FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
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, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST  FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR

Ver: 8.1