Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_COMP_TERM_WITHDRAWAL_KSU

Description Contains data specific to a student who has gone thru complete term withdrawal

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period VARCHAR2(6)

SZBTWRN

SZBTWRN_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description VARCHAR2(30)

STVTERM

STVTERM_DESC

ACTIVITY_DATE Date of last update DATE

SZBTWRN

SZBTWRN_ACTIVITY_DATE

COMMENT_LINE1 Comment Line 1 VARCHAR2(256)

SZBTWRN

SZBTWRN_COMMENT_LINE1

COMMENT_LINE2 Comment Line 2 VARCHAR2(256)

SZBTWRN

SZBTWRN_COMMENT_LINE2

CONTACT_EMAIL_ADDRESS Contact Email Address VARCHAR2(90)

SZBTWRN

SZBTWRN_CONTACT_EMAIL_ADDR

CONTACT_METHOD Method of Contact VARCHAR2(20)

SZBTWRN

SZBTWRN_CONTACT_METHOD

CONTACT_PHONE_NUMBER Contact Phone Number VARCHAR2(12)

SZBTWRN

SZBTWRN_CONTACT_PHONE_NUM

CONTACT_TIMING Contact Timing VARCHAR2(20)

SZBTWRN

SZBTWRN_CONTACT_TIMING

FUTURE_TERM_CODE Future Academic Period Code VARCHAR2(20)

SZBTWRN

SZBTWRN_FUT_TERM_CODE

LOAD_DATE Date information was last updated in ODS DATE

NA

SYSDATE

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

SZBTWRN

SZBTWRN_PIDM

PLAN_TO_RETURN Plan to Return VARCHAR2(5)

SZBTWRN

SZBTWRN_PLAN_TO_RETURN

REASON_CODE Reason for Withdrawal VARCHAR2(2)

SZBTWRN

SZBTWRN_REASON_CODE

REASON_CODE_DESC Reason for Withdrawal Description VARCHAR2(80)

SZVTWRN

SZVTWRN_REASON_DESC

USER_ID This field identifies the most recent user who updated the record VARCHAR2(30)

SZBTWRN

SZBTWRN_USER_ID



Ver: