Reporting View Target: ADMISSIONS_REQ_SLOT

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

SGHE Banner Operational Data Store
Reporting View Target: ADMISSIONS_REQ_SLOT_KSU

Description Uses data from the ADMISSIONS_REQUIREMENT reporting view. Displays up to the first 15 sets of values for a person_uid, academic_period and application_number sorted by requirement ascending.
Key & Frequency One row per person per academic_period per application number
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD Academic period or time frame associated with this application requirement record. VARCHAR2(63)
SARCHKL

SARCHKL_TERM_CODE_ENTRY

ACTIVITY_DATE Date record was inserted or updated DATE
NA

SYSDATE

APPLICATION_NUMBER Application number for the admission application record for a specific academic period. NUMBER
SARCHKL

SARCHKL_APPL_NO

MORE_EXISTS Indicates if there are more than 15 sarchkl records for this person_uid, academic_period and application_number combination VARCHAR2(1)
NA

NA

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER
SARCHKL

SARCHKL_PIDM

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

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

SARCHKL_ADMR_CODE

REQUIREMENT_COMMENT1 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT10 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT11 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT12 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT13 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT14 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT15 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT2 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT3 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT4 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT5 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT6 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT7 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT8 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_COMMENT9 Checklist requirement comment VARCHAR2(30)
SARCHKL

SARCHKL_COMMENT

REQUIREMENT_MANDATORY_IND1 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND10 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND11 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND12 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND13 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND14 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND15 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND2 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND3 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND4 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND5 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND6 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND7 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND8 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_MANDATORY_IND9 Indicates whether this requirement is mandatory or optional. VARCHAR2(1)
SARCHKL

SARCHKL_MANDATORY_IND

REQUIREMENT_RECEIVED_DATE1 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE10 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE11 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE12 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE13 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE14 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE15 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE2 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE3 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE4 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE5 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE6 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE7 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE8 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_RECEIVED_DATE9 Date the requirement was received from the applicant. DATE
SARCHKL

SARCHKL_RECEIVE_DATE

REQUIREMENT_WAIVED_IND1 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND10 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND11 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND12 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND13 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND14 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND15 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND2 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND3 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND4 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND5 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND6 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND7 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND8 Currently not populated VARCHAR2(1)
NA

NA

REQUIREMENT_WAIVED_IND9 Currently not populated VARCHAR2(1)
NA

NA

Ver: 8.4.1

Description	Uses data from the ADMISSIONS_REQUIREMENT reporting view. Displays up to the first 15 sets of values for a person_uid, academic_period and application_number sorted by requirement ascending.
Key & Frequency	One row per person per academic_period per application number
Recommended Search Columns	PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with this application requirement record.	VARCHAR2(63)	SARCHKL	SARCHKL_TERM_CODE_ENTRY
ACTIVITY_DATE	Date record was inserted or updated	DATE	NA	SYSDATE
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SARCHKL	SARCHKL_APPL_NO
MORE_EXISTS	Indicates if there are more than 15 sarchkl records for this person_uid, academic_period and application_number combination	VARCHAR2(1)	NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARCHKL	SARCHKL_PIDM
REQUIREMENT1	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT10	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT11	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT12	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT13	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT14	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT15	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT2	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT3	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT4	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT5	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT6	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT7	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT8	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT9	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT_COMMENT1	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT10	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT11	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT12	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT13	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT14	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT15	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT2	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT3	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT4	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT5	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT6	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT7	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT8	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_COMMENT9	Checklist requirement comment	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT
REQUIREMENT_MANDATORY_IND1	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND10	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND11	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND12	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND13	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND14	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND15	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND2	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND3	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND4	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND5	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND6	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND7	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND8	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_MANDATORY_IND9	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_RECEIVED_DATE1	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE10	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE11	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE12	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE13	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE14	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE15	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE2	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE3	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE4	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE5	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE6	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE7	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE8	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_RECEIVED_DATE9	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_WAIVED_IND1	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND10	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND11	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND12	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND13	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND14	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND15	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND2	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND3	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND4	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND5	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND6	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND7	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND8	Currently not populated	VARCHAR2(1)	NA	NA
REQUIREMENT_WAIVED_IND9	Currently not populated	VARCHAR2(1)	NA	NA