Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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_RESCLASS_DTL
|
DAP_TERM
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC_DW
|
Current academic period description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU016
|
UCX_VALUE
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ADVICE_DESC
|
Advice description.
|
VARCHAR2(255)
|
DAP_RESULT_DTL
|
DAP_FREETEXT
|
NO
|
NO
|
AUDIT_ACADEMIC_PERIOD
|
Student's active academic period used in Degree Works for audits.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_ACTIVE_TERM
|
NO
|
NO
|
AUDIT_ACADEMIC_PERIOD_DESC
|
Current audit academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
AUDIT_ACADEMIC_PERIOD_DESC_DW
|
Current academic period description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU016
|
UCX_VALUE
|
NO
|
NO
|
AUDIT_ACADEMIC_YEAR
|
Audit academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
AUDIT_ACADEMIC_YEAR_DESC
|
Audit academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
AUDIT_COURSE_KEY
|
Unique system generated sequence number associated to each audit course result row.
|
NUMBER
|
DAP_RESCLASS_DTL
|
UNIQUE_ID
|
NO
|
NO
|
AUDIT_RESULT_CREATE_DATE
|
Date the audit results were created.
|
DATE
|
DAP_RESULT_DTL
|
DAP_CREATE_DATE
|
NO
|
NO
|
AUDIT_RESULT_KEY
|
Unique system generated sequence number associated to each audit result row.
|
NUMBER
|
DAP_RESULT_DTL
|
UNIQUE_ID
|
NO
|
NO
|
AUDIT_RESULT_TYPE
|
Result type identified in the student audit such as CLASSAPPLIED or FALLCLASSNEEDED.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_RESULT_TYPE
|
NO
|
NO
|
AUDIT_RESULT_TYPE_DESC
|
Audit result type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE
|
NO
|
NO
|
AUDIT_RUN_DATE
|
Date the audit was run.
|
DATE
|
CALCULATION
|
DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'
|
NO
|
NO
|
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
|
NO
|
NO
|
AUDIT_TYPE_DESC
|
Audit type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN DAP_AUDIT_TYPE
|
NO
|
NO
|
BLOCK_DESC
|
Block title.
|
VARCHAR2(255)
|
CONSTANT CONSTANT CONSTANT DAP_REQ_BLOCK
|
'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' TITLE
|
NO NO NO NO
|
NO
|
BLOCK_ID
|
Block identification grouping a set of requirements.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_REQ_ID
|
NO
|
NO
|
BLOCK_RULE_ID
|
Rule identification associated with a rule used in a scribed block.
|
VARCHAR2(63)
|
CONSTANT DAP_RESULT_DTL
|
'NA' DAP_RULE_ID
|
NO NO
|
NO
|
BLOCK_RULE_LABEL
|
Label text uniquely identifying the rule within the block.
|
VARCHAR2(255)
|
CONSTANT DAP_RESULT_DTL
|
'NA' DAP_FREETEXT
|
NO NO
|
NO
|
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
|
NO
|
NO
|
CAMPUS
|
Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_LOCATION
|
NO
|
NO
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
CAMPUS_DESC_DW
|
Institution campus name for Degree Works.
|
VARCHAR2(255)
|
UCX_STU576
|
UCX_VALUE
|
NO
|
NO
|
COURSE_APPLIED_IND
|
Indicates whether this course was applied in the audit.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED'
|
NO
|
NO
|
COURSE_CREDITS
|
Credits associated with this course.
|
NUMBER
|
DAP_RESCLASS_DTL
|
DAP_SS_CREDITS
|
NO
|
NO
|
COURSE_CREDITS_DW
|
Credits associated with this course audited in Degree Works.
|
NUMBER
|
DAP_RESCLASS_DTL
|
DAP_AUD_CREDITS
|
NO
|
NO
|
COURSE_CREDIT_TYPE
|
Course credit type.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_TRANSFER_TYPE
|
NO
|
NO
|
COURSE_CREDIT_TYPE_DESC
|
Course credit type description.
|
VARCHAR2(255)
|
DAP_RESCLASS_DTL
|
DAP_TRANSFER_TYPE
|
NO
|
NO
|
COURSE_FALLTHROUGH_IND
|
Indicates whether this course was placed in the fall-through section for the audit.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'FALLCLASSAPPLIED'
|
NO
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(63)
|
CALCULATION
|
DAP_VALUE1 || DAP_VALUE2
|
NO
|
NO
|
COURSE_INSUFFICIENT_IND
|
Indicates whether this course was placed in the insufficient section for the audit. Counted toward the degree GPA.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'INSUFFCLASSAPPLIED'
|
NO
|
NO
|
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
|
NO
|
NO
|
COURSE_NEEDED_IND
|
Indicates whether this course was needed in the audit.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED'
|
NO
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE2
|
NO
|
NO
|
COURSE_OVER_THE_LIMIT_IND
|
Indicates whether this course was placed in the over-the-limit section for the audit.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'OTLCLASSAPPLIED'
|
NO
|
NO
|
COURSE_PASSED_IND
|
Indicates whether the course section counts as a passed course and the course credits are added to the passed credits based on the final grade assigned to the person.
|
VARCHAR2(1)
|
DAP_RESCLASS_DTL
|
DAP_PASS
|
NO
|
NO
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(63)
|
NA
|
NULL
|
NO
|
NO
|
COURSE_SOURCE
|
Indicates the source of the course
|
VARCHAR2(63)
|
CALCULATION
|
CASE WHEN (C.DAP_TRANSFER = 'C') AND (C.DAP_INPROGRESS = 'N')
|
NO
|
NO
|
COURSE_SOURCE_DESC
|
Course source description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN (C.DAP_TRANSFER = 'C') AND (C.DAP_INPROGRESS = 'N')
|
NO
|
NO
|
COURSE_STATUS
|
Course status.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_CLASS_STATUS
|
NO
|
NO
|
COURSE_STATUS_DESC
|
Course status description.
|
VARCHAR2(255)
|
DAP_RESCLASS_DTL
|
DAP_CLASS_STATUS
|
NO
|
NO
|
COURSE_TITLE_SHORT
|
Course title short.
|
VARCHAR2(255)
|
DAP_RESCLASS_DTL
|
DAP_COURSE_TITLE
|
NO
|
NO
|
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
|
NO
|
NO
|
DEGREE_DESC
|
Degree description.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
NO
|
NO
|
DEGREE_DESC_DW
|
Degree description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU307
|
UCX_VALUE
|
NO
|
NO
|
FINAL_GRADE
|
Grade earned by the student for this course.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_GRADE
|
NO
|
NO
|
GPA_CREDITS
|
Credits associated with this course counted toward the GPA.
|
NUMBER
|
DAP_RESCLASS_DTL
|
DAP_GPA_CREDITS
|
NO
|
NO
|
GPA_QUALITY_POINTS
|
|
NUMBER
|
DAP_RESCLASS_DTL
|
DAP_GPA_GRD_PTS
|
NO
|
NO
|
GRADE_TYPE
|
Grade mode associated with this section or offering of the course.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_GRADE_TYPE
|
NO
|
NO
|
GRADE_TYPE_DESC
|
Grade type description.
|
VARCHAR2(255)
|
STVGMOD
|
STVGMOD_DESC
|
NO
|
NO
|
GRADE_TYPE_DESC_DW
|
Grade type description for Degree Works.
|
VARCHAR2(255)
|
UCX_STU356
|
UCX_VALUE
|
NO
|
NO
|
GRADE_VALUE
|
Numeric value assigned to a grade symbol to be used to measure course performance statistics. This will only be present if a final grade has been recorded for either in progress or grades rolled to history for the student course.
|
NUMBER
|
DAP_RESCLASS_DTL
|
DAP_GRADE_NUM
|
NO
|
NO
|
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
|
NO
|
NO
|
INCOMPLETE_GRADE_IND
|
Indicates whether the grade is an incomplete grade.
|
VARCHAR2(1)
|
DAP_RESCLASS_DTL
|
DAP_INCOMPLETE
|
NO
|
NO
|
INSTITUTION_COURSE_IND
|
Indicates whether the subject or course was taken at this institution and is in academic history.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_TRANSFER = 'C' AND DAP_INPROGRESS = 'N'
|
NO
|
NO
|
INSUFFICIENT_REASON
|
Reason why the course is in the insufficient section.
|
VARCHAR2(255)
|
DAP_RESCLASS_DTL
|
DAP_REASON_INSUF
|
NO
|
NO
|
INSUFFICIENT_REASON_DESC
|
Insufficient reason description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN DAP_REASON_INSUF
|
NO
|
NO
|
IN_PROGRESS_COURSE_IND
|
Indicates whether the course is in progress and not yet graded.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN R.DAP_RESULT_TYPE = 'CLASSNEEDED' THEN 'N' WHEN R.DAP_RESULT_TYPE <> 'CLASSNEEDED' AND R.DAP_AUDIT_TYPE = 'PL'
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the student (Last name, First name Middle Initial format).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PASS_FAIL_GRADE_IND
|
Indicates whether the grade mode is specified as pass/fail.
|
VARCHAR2(1)
|
DAP_RESCLASS_DTL
|
DAP_PASSFAIL
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RAD_PRIMARY_MST
|
RAD_USER_DEF1
|
NO
|
NO
|
PLANNED_COURSE_IND
|
Indicates whether the course is planned for an audit type of planning.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' AND AUDIT_TYPE = 'PL'
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
QUALITY_POINTS
|
Quality points associated with the grade.
|
NUMBER
|
DAP_RESCLASS_DTL
|
DAP_GRADE_POINTS
|
NO
|
NO
|
REPEAT_COURSE_NUMBER
|
Course number that was repeated.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_REPEAT_NUM
|
NO
|
NO
|
REPEAT_POLICY
|
Determines how repeated courses are processed.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_REPEAT_PLCY1
|
NO
|
NO
|
REPEAT_POLICY_DESC
|
Repeat policy description.
|
VARCHAR2(255)
|
UCX_AUD047
|
DAP_VALUE
|
NO
|
NO
|
REPEAT_SUBJECT
|
Course that was repeated
|
|
DAP_RESCLASS_DTL
|
DAP_REPEAT_DISC
|
NO
|
NO
|
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
|
NO
|
NO
|
RULE_COURSES_NEEDED
|
Number of courses still needed on the rule.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE2
|
NO
|
NO
|
RULE_COURSE_REQUIRED
|
Number of courses originally required on the rule.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE2
|
NO
|
NO
|
RULE_CREDITS_NEEDED
|
Number of credits still needed on the rule.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE1
|
NO
|
NO
|
RULE_CREDITS_REQUIRED
|
Number of credits originally required on the rule.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE1
|
NO
|
NO
|
RULE_OPERATOR_NEEDED
|
Determines if the relationship between the courses and credits is an AND relationship or an OR relationship.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE3
|
NO
|
NO
|
RULE_OPERATOR_REQUIRED
|
Determines if the relationship between the courses and credits is an AND relationship or an OR relationship.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE3
|
NO
|
NO
|
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
|
NO
|
NO
|
STUDENT_CLASSIFICATION_DESC
|
Student classification description.
|
VARCHAR2(255)
|
STVCLAS
|
STVCLAS_DESC
|
NO
|
NO
|
STUDENT_CLASSIFICATION_DESC_DW
|
Student classification description from Degree Works.
|
VARCHAR2(255)
|
CONSTANT
|
NULL
|
NO
|
NO
|
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
|
NO
|
NO
|
STUDENT_LEVEL_DESC
|
Course level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
STUDENT_LEVEL_DESC_DW
|
Student level description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU350
|
UCX_VALUE
|
NO
|
NO
|
SUBJECT
|
Main instructional subject area for this course.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE1
|
NO
|
NO
|
SUBJECT_DESC
|
Subject code description.
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
SUBJECT_DESC_DW
|
Subject/discipline code description from Degree Works.
|
VARCHAR2(255)
|
UCX_STU352
|
UCX_VALUE
|
NO
|
NO
|
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
|
NO
|
NO
|
TAKE_TYPE_DESC
|
Course take type description.
|
VARCHAR2(255)
|
FUNCTION
|
CASE WHEN DAP_VALUE4
|
NO
|
NO
|
TRANSFER_COURSE_IDENTIFICATION
|
Course subject and course number combined from the transfer institution.
|
VARCHAR2(63)
|
DAP_RESCLASS_DTL
|
DAP_TR_COURSE
|
NO
|
NO
|
TRANSFER_COURSE_IND
|
Indicates whether this course was taken at and transferred from another post secondary institution.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN DAP_TRANSFER = 'T'
|
NO
|
NO
|
TRANSFER_COURSE_INST_DESC
|
Name of the post secondary transfer institution.
|
VARCHAR2(255)
|
DAP_RESCLASS_DTL
|
DAP_TR_SCHL_NAME
|
NO
|
NO
|
TRANSFER_COURSE_TITLE
|
Transfer institution course title.
|
VARCHAR2(255)
|
DAP_RESCLASS_DTL
|
DAP_TR_TITLE
|
NO
|
NO
|
WITH_ADVICE
|
Advice information.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_VALUE3
|
NO
|
NO
|