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

SGHE Banner Operational Data Store
Composite View Target: AS_ADMISSIONS_ADDL_INFO_KSU

Description Source composite view contains additional application requirement fields for each application.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame this person applied to study at this institution. VARCHAR2(6)

SARCHKL

SARCHKL_TERM_CODE_ENTRY

APPLICATION_NUMBER Application number for the admission application record for a specific academic period. NUMBER(2)

SARCHKL

SARCHKL_APPL_NO

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)

SARCHKL

SARCHKL_PIDM

REQUIREMENT Document or other checklist requirement assigned to this type of applicant. VARCHAR2(4)

SARCHKL

SARCHKL_ADMR_CODE

REQUIREMENT_DESC Requirement description. VARCHAR2(30)

STVADMR

STVADMR_DESC

WAIVED_DESC Waived Description VARCHAR2(60)

STVCKST

STVCKST_DESC

WAIVED_IND Indicates whether the requirement was waived. VARCHAR2(15)

SARCHKL

SARCHKL_CKST_CODE



Ver: