| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
|
APPLY_STATUS
|
Apply Status
|
Exception apply status.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_APPLY_STATUS
|
|
AUDIT_CREATE_DATE
|
Audit create date
|
Created date.
|
DATE
|
DAP_EXCEPT_DTL
|
DAP_CREATE_DATE
|
|
AUDIT_CREATE_ID
|
Audit create ID
|
Created user id.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_CREATE_ID
|
|
AUDIT_CREATE_USER
|
Create User
|
Created user.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_CREATE_WHO
|
|
AUDIT_KEY
|
Audit key
|
Unique identication id.
|
NUMBER
|
DAP_EXCEPT_DTL
|
UNIQUE_ID
|
|
AUDIT_LAST_USER
|
Last user
|
Exception last modified user.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_USER_LAST
|
|
AUDIT_MODIFIED_DATE
|
Modified date
|
Exception modified date.
|
DATE
|
DAP_EXCEPT_DTL
|
DAP_MOD_DATE
|
|
AUDIT_MODIFIED_DETAIL
|
Modified detail
|
Exception modified details.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_WHAT
|
|
AUDIT_MODIFIED_ID
|
Modified ID
|
Exception modified user id.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_MOD_ID
|
|
AUDIT_MODIFIED_TIME
|
Modified time
|
Exception modified time.
|
DATE
|
DAP_EXCEPT_DTL
|
DAP_TIMESTAMP
|
|
BLOCK_DESC
|
Block Description
|
Block title.
|
VARCHAR2(255)
|
CONSTANT
|
'EXCEPTION'
|
|
BLOCK_ID
|
Block Id.
|
Block identification grouping a set of requirements.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_REQ_ID
|
|
DEGREE
|
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
|
Degree description.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
|
DEGREE_DESC_DW
|
Degree description from Degreeworks
|
Degree description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU307
|
UCX_VALUE
|
|
EXCEPTION_BUFFER
|
Buffer
|
Exception buffer.
|
VARCHAR2(255)
|
DAP_EXCEPT_DTL
|
DAP_EXC_BUFFER
|
|
EXCEPTION_CLUSTER
|
Exception Cluster.
|
Exception Cluster.
|
VARCHAR2(4)
|
DAP_EXCEPT_DTL
|
DAP_EXC_CLUSTER
|
|
EXCEPTION_DETAILS
|
Exception details.
|
Exception details.
|
VARCHAR2(255)
|
DAP_EXCEPT_DTL
|
DAP_EXC_DETAILS
|
|
EXCEPTION_LABEL
|
Exception label.
|
Exception label.
|
VARCHAR2(255)
|
DAP_EXCEPT_DTL
|
DAP_EXC_LABEL
|
|
EXCEPTION_NUMBER
|
Exception number.
|
Exception number.
|
NUMBER
|
DAP_EXCEPT_DTL
|
DAP_EXC_NUM
|
|
EXCEPTION_OLD_REQUEST
|
Exception old request
|
Exception old request.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_EXC_REQ_OLD
|
|
EXCEPTION_REMARK
|
Exception remark.
|
Exception remark.
|
VARCHAR2(255)
|
DAP_EXCEPT_DTL
|
DAP_EXC_REMARK
|
|
EXCEPTION_STATUS
|
Exception status.
|
Exception status.
|
VARCHAR2(2)
|
DAP_EXCEPT_DTL
|
DAP_EXC_STATUS
|
|
EXCEPTION_STATUS_DESC
|
Exception status description.
|
Exception status description.
|
VARCHAR2(255)
|
UCX_AUD015
|
UCX_VALUE
|
|
EXCEPTION_TYPE
|
Exception type.
|
Exception type.
|
VARCHAR2(2)
|
DAP_EXCEPT_DTL
|
DAP_EXC_TYPE
|
|
EXCEPTION_TYPE_DESC
|
Exception type description.
|
Exception type description.
|
VARCHAR2(255)
|
UCX_AUD014
|
UCX_VALUE
|
|
ID
|
Identification number
|
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
|
Label tag.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_LABEL_TAG
|
|
MULTI_SOURCE
|
Multi source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
NODE_ID
|
Node Id
|
Node identification number.
|
NUMBER
|
DAP_EXCEPT_DTL
|
DAP_NODE_ID
|
|
NODE_NUM
|
Node number
|
Node number.
|
NUMBER
|
DAP_EXCEPT_DTL
|
DAP_NOTE_NUM
|
|
NODE_TYPE
|
Node type
|
Node type.
|
NUMBER
|
DAP_EXCEPT_DTL
|
DAP_NODE_TYPE
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RAD_PRIMARY_MST
|
RAD_USER_DEF1
|
|
PROCESS_GROUP
|
Process group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
|
REQUEST_ID
|
Request ID
|
Exception request id.
|
VARCHAR2(63)
|
DAP_EXCEPT_DTL
|
DAP_STU_ID
|
|
STUDENT_LEVEL
|
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
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
|
STUDENT_LEVEL_DESC_DW
|
Student level description from Degreeworks
|
Student level description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU350
|
UCX_VALUE
|