Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
HIGHEST_DEGREE_AWARDED_IND	Identifies the highest award, certificate or degree earned by the person.	NUMBER	FUNCTION	ROW_NUMBER() OVER (PARTITION BY DRIVER.PERSON_UID ORDER BY DRIVER.POST_SECONDARY_DEGREE_DATE DESC NULLS LAST, DRIVER.AWARD_CATEGORY DESC NULLS LAST, DRIVER.POST_SECONDARY_ATTEND_FROM DESC N	NO	NO	POST SECONDARY SCHOOL
INSTITUTION_KEY	Key for the institution dimension.	NUMBER	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
LAST_POST_SECONDARY_IND	Identifies this post secondary school is that latest school attended by this person.	NUMBER	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
OUTCOME_AWARD_IND	First degree date associated with post secondary institution.	NUMBER	ACADEMIC_OUTCOME PREVIOUS_EDUCATION	OUTCOME_AWARDED_IND POST_SECONDARY_DEGREE_DATE	NO NO	NO	POST SECONDARY SCHOOL  POST SECONDARY SCHOOL
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ACADEMIC_OUTCOME PREVIOUS_EDUCATION	PERSON_UID PERSON_UID	NO NO	NO	POST SECONDARY SCHOOL  POST SECONDARY SCHOOL
POST_SECONDARY_ATTEND_FROM	Previous education first date of attendance.	DATE	PREVIOUS_EDUCATION	ATTEND_FROM_DATE	NO	NO	POST SECONDARY SCHOOL
POST_SECONDARY_ATTEND_TO	Previous education last date of attendance.	DATE	PREVIOUS_EDUCATION	ATTEND_TO_DATE	NO	NO	POST SECONDARY SCHOOL
POST_SECONDARY_CREDITS_EARNED	Post Secondary Credits Earned.	NUMBER				NO
POST_SECONDARY_DATA_SOURCE	Data Source (Banner or Recruiter) for this record.	VARCHAR2(63)				NO
POST_SECONDARY_DEGREE_DATE	Identifies the first degree date associated with post secondary institution.	DATE	PREVIOUS_EDUCATION	POST_SECONDARY_DEGREE_DATE	NO	NO	POST SECONDARY SCHOOL
POST_SECONDARY_GPA	Person's post secondary institution average or GPA.	NUMBER	ACADEMIC_OUTCOME	GPA	NO	NO	POST SECONDARY SCHOOL
POST_SECONDARY_NUMBER_KEY	Key for the post secondary school joined with the sequence number dimension.	NUMBER	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
POST_SECONDARY_SCHOOL_GRP_KEY	Unique identifier for all the post secondary schools recorded for this person.	NUMBER	ETL_GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
POST_SECONDARY_SCHOOL_KEY	Key for the post secondary school dimension.	NUMBER	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
POST_SECONDARY_TRANS_CREDITS	Number of transfer credits received from the previous post secondary institution.	NUMBER	PREVIOUS_EDUCATION	TOTAL_TRANSFER_CREDITS	NO	NO	POST SECONDARY SCHOOL
POST_SEC_SCHOOL_EXTENSION_KEY	Post Sec School Extension Key.	NUMBER				NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	POST SECONDARY SCHOOL

Ver: 9.0