Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: DESTINATION_KENT_KSU

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVE_DATE   DATE    
ACTIVITY_DATE   DATE    
ADDED_BY   NUMBER    
ADMIN_PAGE_TEXT   CLOB    
ADVISOR   VARCHAR2(200)    
APPOINTMENT_DESCRIPTION   CLOB    
APPOINTMENT_END_DATE   DATE    
APPOINTMENT_END_TIME   DATE    
APPOINTMENT_START_DATE   DATE    
APPOINTMENT_START_TIME   DATE    
APPOINTMENT_STATUS   VARCHAR2(8)    
APPOINTMENT_TYPE_APPTPASTSTU   VARCHAR2(200)    
APPOINTMENT_TYPE_GROUPS   CLOB    
APPTPASTSTU_ID   NUMBER    
COLL_CODE   VARCHAR2(16)    
CONFIRMATION_EMAIL_TEXT   CLOB    
CONFIRMATION_PAGE_TEXT   CLOB    
CONFIRMATION_TYPE   CLOB    
CONTACT_TYPE   VARCHAR2(200)    
DATE_ADDED   DATE    
DEACT_DATE   DATE    
DEACT_MESSAGE_TEXT   CLOB    
DESCRIPTION   VARCHAR2(200)    
DKAR_APPOINTMENT   VARCHAR2(12)    
FIRST_NAME   VARCHAR2(60)

SPRIDEN

SPRIDEN_FIRST_NAME

GROUPS   NUMBER    
GROUP_CODE_APPTPASTSTU   VARCHAR2(16)    
GROUP_ID   NUMBER    
GROUP_NAME   VARCHAR2(1020)    
HONORS   VARCHAR2(12)    
ID   VARCHAR2(36)

SPRIDEN

SPRIDEN_ID

LAST_NAME   VARCHAR2(240)

SPRIDEN

SPRIDEN_LAST_NAME

LOAD_DATE   DATE    
MAJR_CODE   VARCHAR2(16)    
MINIMUM_APPOINTMENT_LENGTH   NUMBER    
NOTE   CLOB    
NUMBER_OF_WEEKS   NUMBER    
PERSON_UID   NUMBER    
PILLAR   VARCHAR2(200)    
QUESTION_1   VARCHAR2(2000)    
QUESTION_10   VARCHAR2(2000)    
QUESTION_10_AMOUNT   NUMBER    
QUESTION_10_GROUP_ID   VARCHAR2(20)    
QUESTION_10_ID   NUMBER    
QUESTION_10_QSTDKAR   VARCHAR2(12)    
QUESTION_10_QUESTION   CLOB    
QUESTION_10_REQUIRED   VARCHAR2(12)    
QUESTION_10_TITLE   VARCHAR2(600)    
QUESTION_10_TYPE   VARCHAR2(80)    
QUESTION_11   VARCHAR2(2000)    
QUESTION_11_AMOUNT   NUMBER    
QUESTION_11_GROUP_ID   VARCHAR2(20)    
QUESTION_11_ID   NUMBER    
QUESTION_11_QSTDKAR   VARCHAR2(12)    
QUESTION_11_QUESTION   CLOB    
QUESTION_11_REQUIRED   VARCHAR2(12)    
QUESTION_11_TITLE   VARCHAR2(600)    
QUESTION_11_TYPE   VARCHAR2(80)    
QUESTION_12   VARCHAR2(2000)    
QUESTION_12_AMOUNT   NUMBER    
QUESTION_12_GROUP_ID   VARCHAR2(20)    
QUESTION_12_ID   NUMBER    
QUESTION_12_QSTDKAR   VARCHAR2(12)    
QUESTION_12_QUESTION   CLOB    
QUESTION_12_REQUIRED   VARCHAR2(12)    
QUESTION_12_TITLE   VARCHAR2(600)    
QUESTION_12_TYPE   VARCHAR2(80)    
QUESTION_13   VARCHAR2(2000)    
QUESTION_13_AMOUNT   NUMBER    
QUESTION_13_GROUP_ID   VARCHAR2(20)    
QUESTION_13_ID   NUMBER    
QUESTION_13_QSTDKAR   VARCHAR2(12)    
QUESTION_13_QUESTION   CLOB    
QUESTION_13_REQUIRED   VARCHAR2(12)    
QUESTION_13_TITLE   VARCHAR2(600)    
QUESTION_13_TYPE   VARCHAR2(80)    
QUESTION_14   VARCHAR2(2000)    
QUESTION_14_AMOUNT   NUMBER    
QUESTION_14_GROUP_ID   VARCHAR2(20)    
QUESTION_14_ID   NUMBER    
QUESTION_14_QSTDKAR   VARCHAR2(12)    
QUESTION_14_QUESTION   CLOB    
QUESTION_14_REQUIRED   VARCHAR2(12)    
QUESTION_14_TITLE   VARCHAR2(600)    
QUESTION_14_TYPE   VARCHAR2(80)    
QUESTION_15   VARCHAR2(2000)    
QUESTION_15_AMOUNT   NUMBER    
QUESTION_15_GROUP_ID   VARCHAR2(20)    
QUESTION_15_ID   NUMBER    
QUESTION_15_QSTDKAR   VARCHAR2(12)    
QUESTION_15_QUESTION   CLOB    
QUESTION_15_REQUIRED   VARCHAR2(12)    
QUESTION_15_TITLE   VARCHAR2(600)    
QUESTION_15_TYPE   VARCHAR2(80)    
QUESTION_16   VARCHAR2(2000)    
QUESTION_16_AMOUNT   NUMBER    
QUESTION_16_GROUP_ID   VARCHAR2(20)    
QUESTION_16_ID   NUMBER    
QUESTION_16_QSTDKAR   VARCHAR2(12)    
QUESTION_16_QUESTION   CLOB    
QUESTION_16_REQUIRED   VARCHAR2(12)    
QUESTION_16_TITLE   VARCHAR2(600)    
QUESTION_16_TYPE   VARCHAR2(80)    
QUESTION_17   VARCHAR2(2000)    
QUESTION_17_AMOUNT   NUMBER    
QUESTION_17_GROUP_ID   VARCHAR2(20)    
QUESTION_17_ID   NUMBER    
QUESTION_17_QSTDKAR   VARCHAR2(12)    
QUESTION_17_QUESTION   CLOB    
QUESTION_17_REQUIRED   VARCHAR2(12)    
QUESTION_17_TITLE   VARCHAR2(600)    
QUESTION_17_TYPE   VARCHAR2(80)    
QUESTION_18   VARCHAR2(2000)    
QUESTION_18_AMOUNT   NUMBER    
QUESTION_18_GROUP_ID   VARCHAR2(20)    
QUESTION_18_ID   NUMBER    
QUESTION_18_QSTDKAR   VARCHAR2(12)    
QUESTION_18_QUESTION   CLOB    
QUESTION_18_REQUIRED   VARCHAR2(12)    
QUESTION_18_TITLE   VARCHAR2(600)    
QUESTION_18_TYPE   VARCHAR2(80)    
QUESTION_19   VARCHAR2(2000)    
QUESTION_19_AMOUNT   NUMBER    
QUESTION_19_GROUP_ID   VARCHAR2(20)    
QUESTION_19_ID   NUMBER    
QUESTION_19_QSTDKAR   VARCHAR2(12)    
QUESTION_19_QUESTION   CLOB    
QUESTION_19_REQUIRED   VARCHAR2(12)    
QUESTION_19_TITLE   VARCHAR2(600)    
QUESTION_19_TYPE   VARCHAR2(80)    
QUESTION_1_AMOUNT   NUMBER    
QUESTION_1_GROUP_ID   VARCHAR2(20)    
QUESTION_1_ID   NUMBER    
QUESTION_1_QSTDKAR   VARCHAR2(12)    
QUESTION_1_QUESTION   CLOB    
QUESTION_1_REQUIRED   VARCHAR2(12)    
QUESTION_1_TITLE   VARCHAR2(600)    
QUESTION_1_TYPE   VARCHAR2(80)    
QUESTION_2   VARCHAR2(2000)    
QUESTION_20   VARCHAR2(2000)    
QUESTION_20_AMOUNT   NUMBER    
QUESTION_20_GROUP_ID   VARCHAR2(20)    
QUESTION_20_ID   NUMBER    
QUESTION_20_QSTDKAR   VARCHAR2(12)    
QUESTION_20_QUESTION   CLOB    
QUESTION_20_REQUIRED   VARCHAR2(12)    
QUESTION_20_TITLE   VARCHAR2(600)    
QUESTION_20_TYPE   VARCHAR2(80)    
QUESTION_2_AMOUNT   NUMBER    
QUESTION_2_GROUP_ID   VARCHAR2(20)    
QUESTION_2_ID   NUMBER    
QUESTION_2_QSTDKAR   VARCHAR2(12)    
QUESTION_2_QUESTION   CLOB    
QUESTION_2_REQUIRED   VARCHAR2(12)    
QUESTION_2_TITLE   VARCHAR2(600)    
QUESTION_2_TYPE   VARCHAR2(80)    
QUESTION_3   VARCHAR2(2200)    
QUESTION_3_AMOUNT   NUMBER    
QUESTION_3_GROUP_ID   VARCHAR2(20)    
QUESTION_3_ID   NUMBER    
QUESTION_3_QSTDKAR   VARCHAR2(12)    
QUESTION_3_QUESTION   CLOB    
QUESTION_3_REQUIRED   VARCHAR2(12)    
QUESTION_3_TITLE   VARCHAR2(600)    
QUESTION_3_TYPE   VARCHAR2(80)    
QUESTION_4   VARCHAR2(2000)    
QUESTION_4_AMOUNT   NUMBER    
QUESTION_4_GROUP_ID   VARCHAR2(20)    
QUESTION_4_ID   NUMBER    
QUESTION_4_QSTDKAR   VARCHAR2(12)    
QUESTION_4_QUESTION   CLOB    
QUESTION_4_REQUIRED   VARCHAR2(12)    
QUESTION_4_TITLE   VARCHAR2(600)    
QUESTION_4_TYPE   VARCHAR2(80)    
QUESTION_5   VARCHAR2(2000)    
QUESTION_5_AMOUNT   NUMBER    
QUESTION_5_GROUP_ID   VARCHAR2(20)    
QUESTION_5_ID   NUMBER    
QUESTION_5_QSTDKAR   VARCHAR2(12)    
QUESTION_5_QUESTION   CLOB    
QUESTION_5_REQUIRED   VARCHAR2(12)    
QUESTION_5_TITLE   VARCHAR2(600)    
QUESTION_5_TYPE   VARCHAR2(80)    
QUESTION_6   VARCHAR2(2000)    
QUESTION_6_AMOUNT   NUMBER    
QUESTION_6_GROUP_ID   VARCHAR2(20)    
QUESTION_6_ID   NUMBER    
QUESTION_6_QSTDKAR   VARCHAR2(12)    
QUESTION_6_QUESTION   CLOB    
QUESTION_6_REQUIRED   VARCHAR2(12)    
QUESTION_6_TITLE   VARCHAR2(600)    
QUESTION_6_TYPE   VARCHAR2(80)    
QUESTION_7   VARCHAR2(2000)    
QUESTION_7_AMOUNT   NUMBER    
QUESTION_7_GROUP_ID   VARCHAR2(20)    
QUESTION_7_ID   NUMBER    
QUESTION_7_QSTDKAR   VARCHAR2(12)    
QUESTION_7_QUESTION   CLOB    
QUESTION_7_REQUIRED   VARCHAR2(12)    
QUESTION_7_TITLE   VARCHAR2(600)    
QUESTION_7_TYPE   VARCHAR2(80)    
QUESTION_8   VARCHAR2(2000)    
QUESTION_8_AMOUNT   NUMBER    
QUESTION_8_GROUP_ID   VARCHAR2(20)    
QUESTION_8_ID   NUMBER    
QUESTION_8_QSTDKAR   VARCHAR2(12)    
QUESTION_8_QUESTION   CLOB    
QUESTION_8_REQUIRED   VARCHAR2(12)    
QUESTION_8_TITLE   VARCHAR2(600)    
QUESTION_8_TYPE   VARCHAR2(80)    
QUESTION_9   VARCHAR2(2000)    
QUESTION_9_AMOUNT   NUMBER    
QUESTION_9_GROUP_ID   VARCHAR2(20)    
QUESTION_9_ID   NUMBER    
QUESTION_9_QSTDKAR   VARCHAR2(12)    
QUESTION_9_QUESTION   CLOB    
QUESTION_9_REQUIRED   VARCHAR2(12)    
QUESTION_9_TITLE   VARCHAR2(600)    
QUESTION_9_TYPE   VARCHAR2(80)    
SPECIAL_NOTE   CLOB    
STUDENT_PAGE_TEXT   CLOB    
USER_CODE   VARCHAR2(120)    


Ver: 8.4.1