Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_OUTCOME_KEY	Key for the academic outcome dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC OUTCOME
ACADEMIC_OUTCOME_STATUS	Current status of the academic outcome. For example, pending, awarded, etc.	VARCHAR2(63)	ACADEMIC_OUTCOME	STATUS	NO	NO	ACADEMIC OUTCOME
ACADEMIC_OUTCOME_STATUS_LD	Long description for the outcome status.	VARCHAR2(255)	ACADEMIC_OUTCOME	STATUS_DESC	NO	NO	ACADEMIC OUTCOME
ACADEMIC_OUTCOME_STATUS_SD	Short description for the outcome status.	VARCHAR2(255)	ACADEMIC_OUTCOME	STATUS_DESC	NO	NO	ACADEMIC OUTCOME
APPLIED_FOR_OUTCOME_IND	Indicates whether the person has applied to officially receive this specific degree or award as an academic outcome.	NUMBER	ACADEMIC_OUTCOME	APPLIED_FOR_OUTCOME_IND	NO	NO	ACADEMIC OUTCOME
APPLIED_FOR_OUTCOME_IND_LD	Long description for applied for academic outcome indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME
APPLIED_FOR_OUTCOME_IND_SD	Short description for applied for academic outcome indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME
BULLETIN_YEAR	Academic year or catalog year associated with the documented requirements to be completed for this academic outcome to be confirmed.	VARCHAR2(63)	ACADEMIC_OUTCOME	BULLETIN_YEAR	NO	NO	ACADEMIC OUTCOME
BULLETIN_YEAR_LD	Long description for the bulletin or catalog academic year associated with the outcome.	VARCHAR2(255)	ACADEMIC_OUTCOME	BULLETIN_YEAR_DESC	NO	NO	ACADEMIC OUTCOME
BULLETIN_YEAR_SD	Short description for the bulletin or catalog academic year associated with the outcome.	VARCHAR2(255)	ACADEMIC_OUTCOME	BULLETIN_YEAR_DESC	NO	NO	ACADEMIC OUTCOME
GRADUATION_STATUS	Identifies that a graduation status has been recorded for this academic outcome in this academic period.	VARCHAR2(63)	ACADEMIC_OUTCOME	GRADUATION_STATUS	NO	NO	ACADEMIC OUTCOME
GRADUATION_STATUS_LD	Long description for the graduation status code that was last entered.	VARCHAR2(255)	ACADEMIC_OUTCOME	GRADUATION_STATUS_DESC	NO	NO	ACADEMIC OUTCOME
GRADUATION_STATUS_SD	Short description for the graduation status code that was last entered.	VARCHAR2(255)	ACADEMIC_OUTCOME	GRADUATION_STATUS_DESC	NO	NO	ACADEMIC OUTCOME
OUTCOME_AWARDED_IND	Identifies whether the academic outcome, award or degree has been officially awarded to the person. Based on the Banner indicator on the academic outcome status which controls when an outcome is available to be printed on a transcript.	NUMBER	ACADEMIC_OUTCOME	OUTCOME_AWARDED_IND	NO	NO	ACADEMIC OUTCOME
OUTCOME_AWARDED_IND_LD	Long description for the outcome awarded indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME
OUTCOME_AWARDED_IND_SD	Short description for the outcome awarded indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME
OUTCOME_REQ_COMPLETED_IND	Identifies the academic period when all outcome requirements were completed or will be completed.	NUMBER	ACADEMIC_OUTCOME	GRAD_REQ_COMPLETED_ACAD_PER	NO	NO	ACADEMIC OUTCOME
OUTCOME_REQ_COMPLETED_IND_LD	Long description for the outcome requirements completed indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME
OUTCOME_REQ_COMPLETED_IND_SD	Short description for the outcome requirements completed indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ACADEMIC OUTCOME
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ACADEMIC OUTCOME
TRANSFER_WORK_EXISTS_IND	Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.	NUMBER	ACADEMIC_OUTCOME	TRANSFER_WORK_EXISTS_IND	NO	NO	ACADEMIC OUTCOME
TRANSFER_WORK_EXISTS_IND_LD	Long description for the transfer work exists indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME
TRANSFER_WORK_EXISTS_IND_SD	Short description for the transfer work exists indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC OUTCOME

Ver: 9.0