Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the Academic Time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
COMMENT_HEADCOUNT	A count distinct of students who have received a comment for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
COMMENT_IND	Indicates a student who has received a comment for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
COURSE_FEEDBACK_GROUP_KEY	Unique identifier for a student, term, CRN. Used to tie back to the Student Course Fact	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
COURSE_REFERENCE_NUMBER_KEY	Key for the Course Reference Number dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
ESTIMATED_GRADE_COUNT	A count of estimated grades that have been given to any student registered in a course in an academic period and faculty feedback session.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	FEEDBACK
ESTIMATED_GRADE_HEADCOUNT	A count distinct of students who have received an estimated grade for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
ESTIMATED_GRADE_IND	Indicates a student who has received an estimated grade for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
ESTIMATED_GRADE_KEY	Key for the estimated grade dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_COMMENT_COUNT	A count of comments that have been given to any student registered in a course in an academic period and faculty feedback session.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_COMMENT_KEY	Key for the feedback comment dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_COUNT	A count of feedback that has been given to any student registered in a course in an academic period and faculty feedback session.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_EXISTS_HEADCOUNT	A count distinct of students who have at least one or any combination of feedback (issue, recommendation, estimated grade and/or comment) for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_EXISTS_IND	Indicates a student who has any at least one or any combination of feedback; issue, recommendation, estimated grade, comment for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_GROUP_KEY	Unique identifier for a student, term	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_HEADCOUNT	A count distinct of students who have been provided feedback for a course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_IDENTIFIER	Unique identifier for a feedback record.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_INSTRUCTOR_KEY	Key for the Instructor dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_INSTRUCTOR_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_KEY	Key for the feedback dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_PROVIDER_TYPE	Identifier for the feedback provider (faculty/advisor/etc)	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_SESSION_KEY	Key for the feedback session dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
FEEDBACK_SUMMARY	A summary of all feedback received by a student in a faculty feedback session within an academic period.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	FEEDBACK
ISSUE_COUNT	A count of issues given to any student registered in a course in an academic period and faculty feedback session.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	FEEDBACK
ISSUE_HEADCOUNT	A count distinct of students who have received an issue for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
ISSUE_IND	Indicates a student who has received an issue for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
LAST_FEEDBACK_ACAD_TIME_KEY	Key for the Academic Time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
LATEST_COMMENT_FEEDBACK_DATE	Date of the latest comment and/or grade entered for a student in a faculty feedback session within an academic period	DATE	FACULTY_FEEDBACK	COMMENT_GRADE_ACTIVITY_DATE	NO	NO	FEEDBACK
LATEST_FEEDBACK_DATE	Date of the latest issue or recommendation entered for a student in a faculty feedback session within an academic period	DATE	FACULTY_FEEDBACK_DETAIL	FEEDBACK_ACTIVITY_DATE	NO	NO	FEEDBACK
MONITORED_COMPLETE_HEADCOUNT	A count distinct of monitored students who have received an issue and/or recommendation for a course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
MONITORED_COMPLETE_IND	Indicates if a monitored student who has received an issue or recommendation for a course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
MONITORED_STUDENT_HEADCOUNT	A count distinct of students who have been flagged to be monitored for a course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
MONITORED_STUDENT_IND	Indicates if a student has been flagged to be monitored for a course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
MULTI_SOURCE_KEY	Key for the Multi Source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
OPTIONAL_HEADCOUNT	A count disticnt of students who have not been flagged to be monitored for a course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
OPTIONAL_IND	Indicates if a student who has not been flagged to be monitored for a course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
RECOMMENDATION_COUNT	A count of recommendations given to any student registered in a course in an academic period and faculty feedback session.	VARCHAR2(255)	ETL_GENERATED	NA	NO	NO	FEEDBACK
RECOMMENDATION_HEADCOUNT	A count distinct of students who have received a recommendation for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
RECOMMENDATION_IND	Indicates a student who has received a recommendation for at least one course in a faculty feedback session within an academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	FEEDBACK
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	FEEDBACK
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	FEEDBACK

Ver: 9.0