Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
APPLY_STATUS	Exception apply status.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_APPLY_STATUS
AUDIT_CREATE_DATE	Created date.	DATE	DAP_EXCEPT_DTL	DAP_CREATE_DATE
AUDIT_CREATE_ID	Created user id.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_CREATE_ID
AUDIT_CREATE_USER	Created user.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_CREATE_WHO
AUDIT_KEY	Unique identication id.	NUMBER	DAP_EXCEPT_DTL	UNIQUE_ID
AUDIT_LAST_USER	Exception last modified user.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_USER_LAST
AUDIT_MODIFIED_DATE	Exception modified date.	DATE	DAP_EXCEPT_DTL	DAP_MOD_DATE
AUDIT_MODIFIED_DETAIL	Exception modified details.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_WHAT
AUDIT_MODIFIED_ID	Exception modified user id.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_MOD_ID
AUDIT_MODIFIED_TIME	Exception modified time.	DATE	DAP_EXCEPT_DTL	DAP_TIMESTAMP
BLOCK_DESC	Block title.	VARCHAR2(255)	CONSTANT	'EXCEPTION'
BLOCK_ID	Block identification grouping a set of requirements.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_REQ_ID
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_DEGREE
DEGREE_DESC	Degree description.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC
DEGREE_DESC_DW	Degree description from Degree Works.	VARCHAR2(255)	UCX_STU307	UCX_VALUE
EXCEPTION_BUFFER	Exception buffer.	VARCHAR2(255)	DAP_EXCEPT_DTL	DAP_EXC_BUFFER
EXCEPTION_CLUSTER	Exception Cluster.	VARCHAR2(4)	DAP_EXCEPT_DTL	DAP_EXC_CLUSTER
EXCEPTION_DETAILS	Exception details.	VARCHAR2(255)	DAP_EXCEPT_DTL	DAP_EXC_DETAILS
EXCEPTION_LABEL	Exception label.	VARCHAR2(255)	DAP_EXCEPT_DTL	DAP_EXC_LABEL
EXCEPTION_NUMBER	Exception number.	NUMBER	DAP_EXCEPT_DTL	DAP_EXC_NUM
EXCEPTION_OLD_REQUEST	Exception old request.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_EXC_REQ_OLD
EXCEPTION_REMARK	Exception remark.	VARCHAR2(255)	DAP_EXCEPT_DTL	DAP_EXC_REMARK
EXCEPTION_STATUS	Exception status.	VARCHAR2(2)	DAP_EXCEPT_DTL	DAP_EXC_STATUS
EXCEPTION_STATUS_DESC	Exception status description.	VARCHAR2(255)	UCX_AUD015	UCX_VALUE
EXCEPTION_TYPE	Exception type.	VARCHAR2(2)	DAP_EXCEPT_DTL	DAP_EXC_TYPE
EXCEPTION_TYPE_DESC	Exception type description.	VARCHAR2(255)	UCX_AUD014	UCX_VALUE
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
LABEL_TAG	Label tag.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_LABEL_TAG
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NODE_ID	Node identification number.	NUMBER	DAP_EXCEPT_DTL	DAP_NODE_ID
NODE_NUM	Node number.	NUMBER	DAP_EXCEPT_DTL	DAP_NOTE_NUM
NODE_TYPE	Node type.	NUMBER	DAP_EXCEPT_DTL	DAP_NODE_TYPE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RAD_PRIMARY_MST	RAD_USER_DEF1
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
REQUEST_ID	Exception request id.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_STU_ID
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	DAP_EXCEPT_DTL	DAP_SCHOOL
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
STUDENT_LEVEL_DESC_DW	Student level description from Degree Works.	VARCHAR2(255)	UCX_STU350	UCX_VALUE

Ver: 9.1