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	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
ACCREDITATION_TYPE_LD	Accreditation type long description.	VARCHAR2(255)	INSTITUTION_DEMOGRAPHIC	ACCREDITATION_TYPE_DESC	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
ACCREDITATION_TYPE_SD	Accreditation type short description.	VARCHAR2(255)	INSTITUTION_DEMOGRAPHIC	ACCREDITATION_TYPE_DESC	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
APPROVED_IND	Institution approved indicator.	VARCHAR2(63)	INSTITUTION_DEMOGRAPHIC	APPROVED_IND	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
DEMOGRAPHIC_CALENDAR_YEAR	Calendar year for which the characteristics are associated with the institution.	VARCHAR2(63)	INSTITUTION_DEMOGRAPHIC	CALENDAR_YEAR	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
FICE_CODE	Institution FICE code assigned for electronic data transfer or EDI.	VARCHAR2(63)	INSTITUTION	FICE_CODE	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
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
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
INSTITUTION	Source/background institution code.	VARCHAR2(63)	INSTITUTION	INSTITUTION	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
INSTITUTION_KEY	Key of the institution dimension.	NUMBER	ETL GENERATED	NA	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
INSTITUTION_LD	Source/background institution long description.	VARCHAR2(255)	INSTITUTION	NAME	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
INSTITUTION_SD	Source/background institution short description.	VARCHAR2(255)	INSTITUTION	NAME	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
INSTITUTION_TYPE	Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(63)	INSTITUTION	INSTITUTION_TYPE	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
INSTITUTION_TYPE_LD	Institution type description.	VARCHAR2(255)	INSTITUTION	INSTITUTION_TYPE_DESC	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
INSTITUTION_TYPE_SD	Institution type short description.	VARCHAR2(255)	INSTITUTION	INSTITUTION_TYPE_DESC	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
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
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
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT
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

Ver: 8.1