Reporting View Target: ADMISSIONS_ADDL_INFO

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

SGHE Banner Operational Data Store
Reporting View Target: ADMISSIONS_ADDL_INFO_KSU

Description Contains additional data specific to an application to study at the institution submitted by the person. Multiple academic years and or academic periods are available for comparison reporting.
Key & Frequency One row per person per academic period per application number per requirement.
Recommended Search Columns ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER,
REQUIREMENT

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(24)
SARCHKL

SARCHKL_TERM_CODE_ENTRY

APPLICATION_NUMBER Application number for the admission application record for a specific academic period. NUMBER
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
SARCHKL

SARCHKL_PIDM

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

SARCHKL_ADMR_CODE

REQUIREMENT_DESC Requirement description. VARCHAR2(120)
STVADMR

STVADMR_DESC

WAIVED_DESC Waived Description VARCHAR2(240)
STVCKST

STVCKST_DESC

WAIVED_IND Indicates whether the requirement was waived. VARCHAR2(60)
SARCHKL

SARCHKL_CKST_CODE

Ver: 8.4.1

Description	Contains additional data specific to an application to study at the institution submitted by the person. Multiple academic years and or academic periods are available for comparison reporting.
Key & Frequency	One row per person per academic period per application number per requirement.
Recommended Search Columns	ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER, REQUIREMENT

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(24)	SARCHKL	SARCHKL_TERM_CODE_ENTRY
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	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	SARCHKL	SARCHKL_PIDM
REQUIREMENT	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(16)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT_DESC	Requirement description.	VARCHAR2(120)	STVADMR	STVADMR_DESC
WAIVED_DESC	Waived Description	VARCHAR2(240)	STVCKST	STVCKST_DESC
WAIVED_IND	Indicates whether the requirement was waived.	VARCHAR2(60)	SARCHKL	SARCHKL_CKST_CODE