Reporting View Target: APP_QUESTIONS

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

SGHE Banner Operational Data Store
Reporting View Target: APP_QUESTIONS_KSU

Description Contains data specific to an application's questions to study at the institution submitted by the person.
Key & Frequency One row per person per academic period per application number per sequence number
Recommended Search Columns ACADEMIC_PERIOD PERSON_UID PERSON_UID,ACADEMIC_PERIOD,APPLICATION_NUMBER PERSON_UID,ACADEMIC_PERIOD,APPLICATION_NUMBER,SEQUENCE_NUMBER ACADEMIC_PERIOD,PERSON_UID

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)
SARQUAN

SARQUAN_TERM_CODE_ENTRY

ACADEMIC_PERIOD_DESC Academic period description VARCHAR2(120)
STVTERM

STVTERM_DESC

ACTIVITY_DATE This field identifies the most recent date a record was created DATE
SARQUAN

SARQUAN_ACTIVITY_DATE

ADMISSION_REQUEST This field indicates the checklist code associated with this question. VARCHAR2(16)
SARQUAN

SARQUAN_ADMR_CODE

ADMISSION_REQUEST_DESC This field specifies the documents/materials (e.g. high school transcripts, residency papers, etc.) associated with the request code, which are required to support an application for admission. VARCHAR2(120)
STVADMR

STVADMR_DESC

APPLICANT_ANSWER Free format applicant response to application question. VARCHAR2(4000)
SARQUAN

SARQUAN_ANSWER

APPLICANT_QUESTION Free format application question. VARCHAR2(4000)
SARQUAN

SARQUAN_QUESTION

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

SARQUAN_APPL_NO

DISPLAY_ON_WEB Indicator the question/answer can be displayed on the Admissions Web Display page. VARCHAR2(4)
SARQUAN

SARQUAN_DISPLAY_WEB_IND

ESSAY_ANSWER This field contains the personal essay statement, which is an answer to an application essay question. CLOB
SARQUAN

SARQUAN_LONG_ANSWER

LOAD_DATE Date information was last updated in ODS DATE
NA

SYSDATE

ORIGINATED_FROM_WEB Indicator the question/answer originated from Admissions Web page. VARCHAR2(4)
SARQUAN

SARQUAN_WEB_IND

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

SARQUAN_PIDM

SEQUENCE_NUMBER Sequence number of question for application. NUMBER
SARQUAN

SARQUAN_SEQNO

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

SARQUAN_USER_ID

WEB_APPLICATION_CODE The web application code associated with the question. VARCHAR2(8)
SARQUAN

SARQUAN_WAPP_CODE

WEB_APPLICATION_DESC Application Description VARCHAR2(120)
STVWAPP

STVWAPP_DESC

Ver: 8.4.1

Description	Contains data specific to an application's questions to study at the institution submitted by the person.
Key & Frequency	One row per person per academic period per application number per sequence number
Recommended Search Columns	ACADEMIC_PERIOD PERSON_UID PERSON_UID,ACADEMIC_PERIOD,APPLICATION_NUMBER PERSON_UID,ACADEMIC_PERIOD,APPLICATION_NUMBER,SEQUENCE_NUMBER ACADEMIC_PERIOD,PERSON_UID

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)	SARQUAN	SARQUAN_TERM_CODE_ENTRY
ACADEMIC_PERIOD_DESC	Academic period description	VARCHAR2(120)	STVTERM	STVTERM_DESC
ACTIVITY_DATE	This field identifies the most recent date a record was created	DATE	SARQUAN	SARQUAN_ACTIVITY_DATE
ADMISSION_REQUEST	This field indicates the checklist code associated with this question.	VARCHAR2(16)	SARQUAN	SARQUAN_ADMR_CODE
ADMISSION_REQUEST_DESC	This field specifies the documents/materials (e.g. high school transcripts, residency papers, etc.) associated with the request code, which are required to support an application for admission.	VARCHAR2(120)	STVADMR	STVADMR_DESC
APPLICANT_ANSWER	Free format applicant response to application question.	VARCHAR2(4000)	SARQUAN	SARQUAN_ANSWER
APPLICANT_QUESTION	Free format application question.	VARCHAR2(4000)	SARQUAN	SARQUAN_QUESTION
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SARQUAN	SARQUAN_APPL_NO
DISPLAY_ON_WEB	Indicator the question/answer can be displayed on the Admissions Web Display page.	VARCHAR2(4)	SARQUAN	SARQUAN_DISPLAY_WEB_IND
ESSAY_ANSWER	This field contains the personal essay statement, which is an answer to an application essay question.	CLOB	SARQUAN	SARQUAN_LONG_ANSWER
LOAD_DATE	Date information was last updated in ODS	DATE	NA	SYSDATE
ORIGINATED_FROM_WEB	Indicator the question/answer originated from Admissions Web page.	VARCHAR2(4)	SARQUAN	SARQUAN_WEB_IND
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARQUAN	SARQUAN_PIDM
SEQUENCE_NUMBER	Sequence number of question for application.	NUMBER	SARQUAN	SARQUAN_SEQNO
USER_ID	This field identifies the most recent user who updated the record	VARCHAR2(120)	SARQUAN	SARQUAN_USER_ID
WEB_APPLICATION_CODE	The web application code associated with the question.	VARCHAR2(8)	SARQUAN	SARQUAN_WAPP_CODE
WEB_APPLICATION_DESC	Application Description	VARCHAR2(120)	STVWAPP	STVWAPP_DESC