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)	SARQUAN	SARQUAN_TERM_CODE_ENTRY
ACADEMIC_PERIOD_DESC	Academic period description	VARCHAR2(30)	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(4)	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(30)	STVADMR	STVADMR_DESC
APPLICANT_ANSWER	Free format applicant response to application question.	VARCHAR2(2000)	SARQUAN	SARQUAN_ANSWER
APPLICANT_QUESTION	Free format application question.	VARCHAR2(2000)	SARQUAN	SARQUAN_QUESTION
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER(3)	SARQUAN	SARQUAN_APPL_NO
DISPLAY_ON_WEB	Indicator the question/answer can be displayed on the Admissions Web Display page.	VARCHAR2(1)	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(1)	SARQUAN	SARQUAN_WEB_IND
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	SARQUAN	SARQUAN_PIDM
SEQUENCE_NUMBER	Sequence number of question for application.	NUMBER(4)	SARQUAN	SARQUAN_SEQNO
USER_ID	This field identifies the most recent user who updated the record	VARCHAR2(30)	SARQUAN	SARQUAN_USER_ID
WEB_APPLICATION_CODE	The web application code associated with the question.	VARCHAR2(2)	SARQUAN	SARQUAN_WAPP_CODE
WEB_APPLICATION_DESC	Application Description	VARCHAR2(30)	STVWAPP	STVWAPP_DESC

Ver: