Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(63)
|
DAP_RESNONCR_DTL
|
DAP_TERM
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_PERIOD_DESC_DW
|
Academic Period Description Dw
|
Current academic period description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU016
|
UCX_VALUE
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Audit academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AUDIT_ACADEMIC_PERIOD
|
Audit Academic Period
|
Student's active academic period used in Degree Works for audits.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_ACTIVE_TERM
|
AUDIT_ACADEMIC_PERIOD_DESC
|
Audit Academic Period Description
|
Current audit academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
AUDIT_ACADEMIC_PERIOD_DESC_DW
|
Audit Academic Period Description Dw
|
Current academic period description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU016
|
UCX_VALUE
|
AUDIT_ACADEMIC_YEAR
|
Audit Academic Year
|
Audit academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
AUDIT_ACADEMIC_YEAR_DESC
|
Audit Academic Year Description
|
Audit academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
AUDIT_NON_COURSE_KEY
|
Audit Non Course KEY
|
Unique system generated sequence number associated to each audit non-course result row.
|
NUMBER
|
DAP_RESNONCR_DTL
|
UNIQUE_ID
|
AUDIT_RESULT_CREATE_DATE
|
Audit Result Create Date
|
Date the audit results were created.
|
DATE
|
DAP_RESULT_DTL
|
DAP_CREATE_DATE
|
AUDIT_RESULT_KEY
|
Audit Result KEY
|
Unique system generated sequence number associated to each audit result row.
|
NUMBER
|
DAP_RESULT_DTL
|
UNIQUE_ID
|
AUDIT_RESULT_TYPE
|
Audit Result Type
|
Result type identified in the student audit such as CLASSAPPLIED or FALLCLASSNEEDED.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_RESULT_TYPE
|
AUDIT_RESULT_TYPE_DESC
|
Audit Result Type Description
|
Audit result type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE
|
AUDIT_RUN_DATE
|
Audit Run Date
|
Date the audit was run.
|
DATE
|
CALCULATION
|
DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'
|
AUDIT_TYPE
|
Audit Type
|
Audit type determining if this is an academic audit, financial aid audit or athletic eligibility audit.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_AUDIT_TYPE
|
AUDIT_TYPE_DESC
|
Audit Type Description
|
Audit type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN DAP_AUDIT_TYPE
|
BLOCK_DESC
|
Block Description
|
Block title.
|
VARCHAR2(255)
|
CONSTANT DAP_REQ_BLOCK
|
'FALL-THROUGH NON-COURSES' TITLE
|
BLOCK_ID
|
Block ID
|
Block identification grouping a set of requirements.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_REQ_ID
|
BLOCK_RULE_ID
|
Block Rule ID
|
Rule identification associated with a rule used in a scribed block.
|
VARCHAR2(63)
|
CONSTANT DAP_RESULT_DTL
|
'NA' DAP_RULE_ID
|
BLOCK_RULE_LABEL
|
Block Rule Label
|
Label text uniquely identifying the rule within the block.
|
VARCHAR2(255)
|
CONSTANT DAP_RESULT_DTL
|
'NA' DAP_FREETEXT
|
BLOCK_SEQUENCE_NUMBER
|
Block Sequence Number
|
One up system generated sequence number associated to the block id in the order in which blocks are processed for the audit.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_BLOCK_SEQ_NUM
|
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_RESULT_DTL
|
DAP_DEGREE
|
DEGREE_DESC
|
Degree Description
|
Degree description.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
DEGREE_DESC_DW
|
Degree Description Dw
|
Degree description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU307
|
UCX_VALUE
|
ID
|
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
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name
|
Name of the student (Last name, First name Middle Initial format).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NONCOURSE_APPLIED_IND
|
Noncourse Applied Indicator
|
Indicates whether this non-course was applied in the audit.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED'
|
NONCOURSE_FALLTHROUGH_IND
|
Noncourse Fallthrough Indicator
|
Indicates whether this non-course was placed in the fall-through section for the audit.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED'
|
NONCOURSE_NEEDED_IND
|
Noncourse Needed Indicator
|
Indicates whether this non-course was needed in the audit.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED'
|
NON_COURSE
|
Non Course
|
Non-course.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE1
|
NON_COURSE_DESC
|
Non Course Description
|
Non-course description.
|
VARCHAR2(255)
|
STVNCRQ STVQPTP
|
STVNCRQ_DESC STVQPTP_DESC
|
NON_COURSE_DESC_DW
|
Non Course Description Dw
|
Non-course description from Degree Works.
|
VARCHAR2(255)
|
DAP_RESNONCR_DTL
|
DAP_COURSE_TITLE
|
NON_COURSE_INTERNAL_KEY
|
Non Course Internal KEY
|
Unique system generated sequence number associated to each course or non-course for that student.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE3
|
NON_COURSE_OPERATOR
|
Non Course Operator
|
Operator like > or = used with the non-course and non-course value.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE2
|
NON_COURSE_STATUS
|
Non Course Status
|
Non-course requirement status.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE2
|
NON_COURSE_STATUS_DESC
|
Non Course Status Description
|
Non-course requirement status description.
|
VARCHAR2(255)
|
STVNCST
|
STVNCST_DESC
|
NON_COURSE_VALUE
|
Non Course Value
|
Non-course value.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE3
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RAD_PRIMARY_MST
|
RAD_USER_DEF1
|
PLANNED_NON_COURSE_IND
|
Planned Non Course Indicator
|
Indicates whether the non-course is planned for an audit type of planning. Functional after Degree Works upgrade to 4.1.4.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN'
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
RESULT_SEQUENCE_NUMBER
|
Result Sequence Number
|
One up system generated sequence number associated to each result recorded for the block id in the order in which rules are processed for the audit.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_RESULT_SEQ_NUM
|
RULE_NON_COURSES_NEEDED
|
Rule Non Courses Needed
|
Number of non-courses still needed on the rule.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE2
|
STUDENT_CLASSIFICATION
|
Student Classification
|
Identifies the student's current class at the institution. The typical VALUES are first year, second year, or freshman, sophomore, etc..
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_CLASS_CALC_FNC
|
STUDENT_CLASSIFICATION_DESC
|
Student Classification Description
|
Student classification description.
|
VARCHAR2(255)
|
STVLCLAS
|
STVCLAS_DESC
|
STUDENT_CLASSIFICATION_DESC_DW
|
Student Classification Description Dw
|
Student classification description.
|
VARCHAR2(255)
|
CONSTANT
|
NULL
|
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_RESULT_DTL
|
DAP_SCHOOL
|
STUDENT_LEVEL_DESC
|
Student Level Description
|
Course level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
STUDENT_LEVEL_DESC_DW
|
Student Level Description Dw
|
Student level description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU350
|
UCX_VALUE
|
TAKE_TYPE
|
Take Type
|
Determines if the course must be taken, or may be taken or can't be taken.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE4
|
TAKE_TYPE_DESC
|
Take Type Description
|
Course take type description.
|
VARCHAR2(255)
|
FUNCTION
|
CASE WHEN DAP_VALUE4
|