Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACCREDITATION_TYPE	Identifies the type of accreditation held by the institution. Examples, may include north central, southern states, etc.	VARCHAR2(63)	INSTITUTION_DEMOGRAPHIC	ACCREDITATION_TYPE	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
ACCREDITATION_TYPE_LD	Accreditation type long description.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
ACCREDITATION_TYPE_SD	Accreditation type short description.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
APPROVED_IND	Institution approved indicator.	VARCHAR2(63)	INSTITUTION_DEMOGRAPHIC	APPROVED_IND	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
DEMOGRAPHIC_CALENDAR_YEAR	Calendar year for which the characteristics are associated with the institution.	VARCHAR2(63)	INSTITUTION_DEMOGRAPHIC	CALENDAR_YEAR	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
FICE_CODE	Institution FICE code assigned for electronic data transfer or EDI.	VARCHAR2(63)	INSTITUTION	FICE_CODE	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
FOUR_YEAR_INSTITUTION_IND	Indicates that the institution is a four-year institution.	VARCHAR2(63)	INSTITUTION_CHARACTERISTIC	DECODE(INST_CHARACTERISTIC, FOUR_YEAR_REC.MTVPARM_EXTERNAL_CODE, 1, 0)	NO	NO	STUDENT PROGRESS
HOMESCHOOL_IND	Indicates that the institution is a homeschool institution.	VARCHAR2(63)	INSTITUTION_CHARACTERISTIC	DECODE(INST_CHARACTERISTIC, HOMESCHOOL_REC.MTVPARM_EXTERNAL_CODE, 1, 0)	NO	NO	STUDENT PROGRESS
INSTITUTION	Source/background institution code.	VARCHAR2(63)	INSTITUTION	INSTITUTION	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
INSTITUTION_KEY	Key of the institution dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
INSTITUTION_LD	Source/background institution long description.	VARCHAR2(255)	INSTITUTION	NAME	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
INSTITUTION_SD	Source/background institution short description.	VARCHAR2(255)	INSTITUTION	NAME	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
INSTITUTION_TYPE	Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(63)	INSTITUTION	INSTITUTION_TYPE	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
INSTITUTION_TYPE_LD	Institution type description.	VARCHAR2(255)	INSTITUTION	INSTITUTION_TYPE_DESC	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
INSTITUTION_TYPE_SD	Institution type short description.	VARCHAR2(255)	INSTITUTION	INSTITUTION_TYPE_DESC	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
PRIVATE_INSTITUTION_IND	Indicates that the institution is a private institution.	VARCHAR2(63)	INSTITUTION_CHARACTERISTIC	DECODE(INST_CHARACTERISTIC, PRIVATE_REC.MTVPARM_EXTERNAL_CODE, 1, 0)	NO	NO	STUDENT PROGRESS
PUBLIC_INSTITUTION_IND	Indicates that the institution is a public institution.	VARCHAR2(63)	INSTITUTION_CHARACTERISTIC	DECODE(INST_CHARACTERISTIC, PUBLIC_REC.MTVPARM_EXTERNAL_CODE, 1, 0)	NO	NO	STUDENT PROGRESS
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	COMBINED ADMISSIONS SOURCE, EMPLOYMENT APPLICATION, ENROLLMENT, GRADUATION COMPLETION, INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, SECONDARY SCHOOL SUBJECT, STUDENT PROGRESS
TWO_YEAR_INSTITUTION_IND	Indicates that the institution is a two-year institution.	VARCHAR2(63)	INSTITUTION_CHARACTERISTIC	DECODE(INST_CHARACTERISTIC, TWO_YEAR_REC.MTVPARM_EXTERNAL_CODE, 1, 0))	NO	NO	STUDENT PROGRESS

Ver: 9.0