RETURN TO BANNER EDW META DATA REPORTS LIST
Feedback Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FEEDBACK

Description Feedback Dimension provides information about feedback type, feedback and feedback status.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
FEEDBACK Code for a specific issue or recommendation. VARCHAR2(63)

FACULTY_FEEDBACK_DETAIL

FEEDBACK

NO

NO FEEDBACK
FEEDBACK_KEY Key for the feedback dimension. NUMBER

ETL_GENERATED

NA

NO

NO FEEDBACK
FEEDBACK_LD Long description for the specific issue or recommendation. VARCHAR2(255)

FACULTY_FEEDBACK_DETAIL

FEEDBACK_DESC

NO

NO FEEDBACK
FEEDBACK_SD Short description for the specific issue or recommendation. VARCHAR2(255)

FACULTY_FEEDBACK_DETAIL

FEEDBACK_DESC

NO

NO FEEDBACK
FEEDBACK_STATUS Feedback status of a student for a course in a feedback session within an academic period. VARCHAR2(63)

FACULTY_FEEDBACK

FEEDBACK_STATUS

NO

NO FEEDBACK
FEEDBACK_STATUS_LD Long description for the feedback status. VARCHAR2(255)

FACULTY_FEEDBACK

FEEDBACK_STATUS_DESC

NO

NO FEEDBACK
FEEDBACK_STATUS_SD Short description for the feedback status. VARCHAR2(255)

FACULTY_FEEDBACK

FEEDBACK_STATUS_DESC

NO

NO FEEDBACK
FEEDBACK_TYPE Code indicating if the feedback is an issue or a recommendation. VARCHAR2(63)

FACULTY_FEEDBACK_DETAIL

FEEDBACK_TYPE

NO

NO FEEDBACK
FEEDBACK_TYPE_LD Long description for Issue/Recommendation type. VARCHAR2(255)

FACULTY_FEEDBACK_DETAIL

FEEDBACK_TYPE_DESC

NO

NO FEEDBACK
FEEDBACK_TYPE_SD Short description for Issue/Recommendation type. VARCHAR2(255)

FACULTY_FEEDBACK_DETAIL

FEEDBACK_TYPE_DESC

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