Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVE_DATE		DATE	GROUPS	ACTIVEDATE
ACTIVITY_DATE	Date of last update	DATE	SWTCLOC	SWTCLOC_ACTIVITY_DATE
ADDED_BY	Added By	NUMBER(10)	APPTPASTSTU	ADDEDBY
ADMIN_PAGE_TEXT		CLOB
ADVISOR	Advisor	VARCHAR2(50)	SWTCLOC	SWTCLOC_LOC_ADVR
APPOINTMENT_DESCRIPTION	Appointment Description	CLOB	APPTPASTSTU	APPTDESCR
APPOINTMENT_END_DATE	Appointment End Date	DATE	APPTPASTSTU	APPTENDDATE
APPOINTMENT_END_TIME	Appointment End Time	DATE	APPTPASTSTU	APPTENDTIME
APPOINTMENT_START_DATE	Appointment Start Date	DATE	APPTPASTSTU	APPTSTARTDATE
APPOINTMENT_START_TIME	Appointment Start Time	DATE	APPTPASTSTU	APPTSTARTTIME
APPOINTMENT_STATUS	Appointment Status	VARCHAR2(2)	APPTPASTSTU	APPTSTATUS
APPOINTMENT_TYPE_APPTPASTSTU	Appointment Type	VARCHAR2(50)	APPTPASTSTU	APPTTYPE
APPOINTMENT_TYPE_GROUPS		CLOB
APPTPASTSTU_ID	Past Appointment Student ID	NUMBER(10)	APPTPASTSTU	APPTPASTSTU_ID
COLL_CODE		VARCHAR2(4)
CONFIRMATION_EMAIL_TEXT		CLOB
CONFIRMATION_PAGE_TEXT		CLOB
CONFIRMATION_TYPE		CLOB
CONTACT_TYPE		VARCHAR2(50)
DATE_ADDED	The Date added to the database	DATE	APPTPASTSTU	DATEADDED
DEACT_DATE		DATE
DEACT_MESSAGE_TEXT		CLOB
DESCRIPTION		VARCHAR2(50)
DKAR_APPOINTMENT		VARCHAR2(3)
FIRST_NAME	Person's first or given name.	VARCHAR2(15)	SPRIDEN	SPRIDEN_FIRST_NAME
GROUPS		NUMBER(10)
GROUP_CODE_APPTPASTSTU		VARCHAR2(4)
GROUP_ID		NUMBER(10)
GROUP_NAME		VARCHAR2(255)
HONORS		VARCHAR2(3)
ID	Person's identification number used to access the records associated with the person.	VARCHAR2(9)	SPRIDEN	SPRIDEN_ID
LAST_NAME	Last Name	VARCHAR2(60)	SPRIDEN	SPRIDEN_LAST_NAME
LOAD_DATE		DATE
MAJR_CODE		VARCHAR2(4)
MINIMUM_APPOINTMENT_LENGTH		NUMBER(10)
NOTE		CLOB
NUMBER_OF_WEEKS		NUMBER(10)
PERSON_UID	Student's Internally generated number by the system to uniquely identify the person or entity.	NUMBER(10)	APPTPASTSTU	STUPIDM
PILLAR	Location of pillar session	VARCHAR2(50)	SWTCLOC	SWTCLOC_LOC_PILL
QUESTION_1	Answer to Question 1 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD1
QUESTION_10	Answer to Question 10 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD10
QUESTION_10_AMOUNT	Question 10 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_10_GROUP_ID	Question 10 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_10_ID	Question 10 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_10_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_10_QUESTION	Question 10 Question	CLOB	QUESTIONS	QUESTION
QUESTION_10_REQUIRED	Question 10 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_10_TITLE	Question 10 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_10_TYPE	Question 10 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_11	Answer to Question 11 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD11
QUESTION_11_AMOUNT	Question 11 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_11_GROUP_ID	Question 11 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_11_ID	Question 11 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_11_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_11_QUESTION	Question 11 Question	CLOB	QUESTIONS	QUESTION
QUESTION_11_REQUIRED	Question 11 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_11_TITLE	Question 11 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_11_TYPE	Question 11 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_12	Answer to Question 12 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD12
QUESTION_12_AMOUNT	Question 12 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_12_GROUP_ID	Question 12 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_12_ID	Question 12 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_12_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_12_QUESTION		CLOB	QUESTIONS	QUESTION
QUESTION_12_REQUIRED	Question 12 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_12_TITLE	Question 12 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_12_TYPE	Question 12 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_13	Answer to Question 13 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD13
QUESTION_13_AMOUNT	Question 13 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_13_GROUP_ID	Question 13 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_13_ID	Question 13 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_13_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_13_QUESTION	Question 13 Question	CLOB	QUESTIONS	QUESTION
QUESTION_13_REQUIRED	Question 13 required	VARCHAR2(3)	QUESTIONS	QSTITLE
QUESTION_13_TITLE	Question 13 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_13_TYPE	Question 13 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_14	Answer to Question 14 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD14
QUESTION_14_AMOUNT	Question 14 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_14_GROUP_ID	Question 14 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_14_ID	Question 14 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_14_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_14_QUESTION	Question 14 Question	CLOB	QUESTIONS	QSTITLE
QUESTION_14_REQUIRED	Question 14 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_14_TITLE	Question 14 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_14_TYPE	Question 14 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_15	Answer to Question 15 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD15
QUESTION_15_AMOUNT	Question 15 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_15_GROUP_ID	Question 15 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_15_ID	Question 15 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_15_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_15_QUESTION	Question 15 Question	CLOB	QUESTIONS	QSTITLE
QUESTION_15_REQUIRED	Question 15 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_15_TITLE	Question 15 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_15_TYPE	Question 15 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_16	Answer to Question 16 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD16
QUESTION_16_AMOUNT	Question 16 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_16_GROUP_ID	Question 16 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_16_ID	Question 16 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_16_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_16_QUESTION	Question 16 Question	CLOB	QUESTIONS	QSTITLE
QUESTION_16_REQUIRED	Question 16 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_16_TITLE	Question 16 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_16_TYPE	Question 16 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_17	Answer to Question 17 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD17
QUESTION_17_AMOUNT	Question 17 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_17_GROUP_ID	Question 17 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_17_ID	Question 17 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_17_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_17_QUESTION	Question 17 Question	CLOB	QUESTIONS	QUESTION
QUESTION_17_REQUIRED	Question 17 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_17_TITLE	Question 17 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_17_TYPE		VARCHAR2(20)
QUESTION_18	Answer to Question 18 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD18
QUESTION_18_AMOUNT	Question 18 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_18_GROUP_ID	Question 18 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_18_ID	Question 18 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_18_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_18_QUESTION	Question 18 Question	CLOB	QUESTIONS	QUESTION
QUESTION_18_REQUIRED	Question 18 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_18_TITLE	Question 18 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_18_TYPE		VARCHAR2(20)
QUESTION_19	Answer to Question 19 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD19
QUESTION_19_AMOUNT	Question 19 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_19_GROUP_ID	Question 19 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_19_ID	Question 19 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_19_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_19_QUESTION	Question 19 Question	CLOB	QUESTIONS	QUESTION
QUESTION_19_REQUIRED	Question 19 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_19_TITLE	Question 19 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_19_TYPE		VARCHAR2(20)
QUESTION_1_AMOUNT	Question 1 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_1_GROUP_ID	Question 1 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_1_ID	Question 1 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_1_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_1_QUESTION	Question 1 question	CLOB	QUESTIONS	QUESTION
QUESTION_1_REQUIRED	Question 1 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_1_TITLE	Question 1 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_1_TYPE	Question 1 type	VARCHAR2(20)	QUESTIONS	QSTYPE
QUESTION_2	Answer to Question 2 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD2
QUESTION_20	Answer to Question 20 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD20
QUESTION_20_AMOUNT	Question 20 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_20_GROUP_ID	Question 20 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_20_ID	Question 20 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_20_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_20_QUESTION	Question 20 Question	CLOB	QUESTIONS	QUESTION
QUESTION_20_REQUIRED	Question 20 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_20_TITLE	Question 20 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_20_TYPE		VARCHAR2(20)
QUESTION_2_AMOUNT	Question 2 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_2_GROUP_ID	Question 2 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_2_ID	Question 2 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_2_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_2_QUESTION	Question 2 Question	CLOB	QUESTIONS	QUESTION
QUESTION_2_REQUIRED	Question 2 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_2_TITLE	Question 2 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_2_TYPE		VARCHAR2(20)
QUESTION_3	Answer to Question 3 on advising	VARCHAR2(550)	APPTPASTSTU	FIELD3
QUESTION_3_AMOUNT	Question 3 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_3_GROUP_ID	Question 3 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_3_ID	Question 3 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_3_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_3_QUESTION	Question 3 Question	CLOB	QUESTIONS	QUESTION
QUESTION_3_REQUIRED	Question 3 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_3_TITLE	Question 3 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_3_TYPE		VARCHAR2(20)
QUESTION_4	Answer to Question 4 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD4
QUESTION_4_AMOUNT	Question 4 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_4_GROUP_ID	Question 4 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_4_ID	Question 4 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_4_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_4_QUESTION	Question 4 Question	CLOB	QUESTIONS	QSTITLE
QUESTION_4_REQUIRED	Question 4 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_4_TITLE	Question 4 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_4_TYPE		VARCHAR2(20)
QUESTION_5	Answer to Question 5 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD5
QUESTION_5_AMOUNT	Question 5 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_5_GROUP_ID	Question 5 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_5_ID	Question 5 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_5_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_5_QUESTION	Question 5 Question	CLOB	QUESTIONS	QUESTION
QUESTION_5_REQUIRED	Question 5 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_5_TITLE	Question 5 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_5_TYPE		VARCHAR2(20)
QUESTION_6	Answer to Question 6 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD6
QUESTION_6_AMOUNT	Question 6 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_6_GROUP_ID	Question 6 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_6_ID	Question 6 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_6_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_6_QUESTION	Question 6 Question	CLOB	QUESTIONS	QUESTION
QUESTION_6_REQUIRED	Question 6 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_6_TITLE	Question 6 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_6_TYPE		VARCHAR2(20)
QUESTION_7	Answer to Question 7 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD7
QUESTION_7_AMOUNT	Question 7 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_7_GROUP_ID	Question 7 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_7_ID	Question 7 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_7_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_7_QUESTION	Question 7 Question	CLOB	QUESTIONS	QUESTION
QUESTION_7_REQUIRED	Question 7 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_7_TITLE	Question 7 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_7_TYPE		VARCHAR2(20)
QUESTION_8	Answer to Question 8 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD8
QUESTION_8_AMOUNT	Question 8 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_8_GROUP_ID	Question 8 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_8_ID	Question 8 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_8_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_8_QUESTION	Question 8 Question	CLOB	QUESTIONS	QUESTION
QUESTION_8_REQUIRED	Question 8 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_8_TITLE	Question 8 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_8_TYPE		VARCHAR2(20)
QUESTION_9	Answer to Question 9 on advising	VARCHAR2(500)	APPTPASTSTU	FIELD9
QUESTION_9_AMOUNT	Question 9 Amount	NUMBER(5, 2)	QUESTIONS	QSTAMOUNT
QUESTION_9_GROUP_ID	Question 9 Group ID	VARCHAR2(5)	QUESTIONS	GRPID
QUESTION_9_ID	Question 9 ID	NUMBER(10)	QUESTIONS	QUESTIONS_ID
QUESTION_9_QSTDKAR	Display on web page	VARCHAR2(3)	QUESTIONS	QSTDKAR
QUESTION_9_QUESTION	Question 9 Question	CLOB	QUESTIONS	QUESTION
QUESTION_9_REQUIRED	Question 9 required	VARCHAR2(3)	QUESTIONS	QSTREQUIRED
QUESTION_9_TITLE	Question 9 title	VARCHAR2(150)	QUESTIONS	QSTITLE
QUESTION_9_TYPE		VARCHAR2(20)
SPECIAL_NOTE		CLOB
STUDENT_PAGE_TEXT		CLOB
USER_CODE		VARCHAR2(30)

Ver: