Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_DESC_DW	Current academic period description from Degree Works.	VARCHAR2(255)	UCX_STU016	UCX_VALUE
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ADVICE_DESC	Advice description.	VARCHAR2(255)	DAP_RESULT_DTL	DAP_FREETEXT
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	Current audit academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
AUDIT_ACADEMIC_PERIOD_DESC_DW	Current academic period description from Degree Works.	VARCHAR2(255)	UCX_STU016	UCX_VALUE
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.	VARCHAR2(255)	STVACYR	STVACYR_DESC
AUDIT_COURSE_KEY	Unique system generated sequence number associated to each audit course result row.	NUMBER	DAP_RESCLASS_DTL	UNIQUE_ID
AUDIT_RESULT_CREATE_DATE	Date the audit results were created.	DATE	DAP_RESULT_DTL	DAP_CREATE_DATE
AUDIT_RESULT_KEY	Unique system generated sequence number associated to each audit result row.	NUMBER	DAP_RESULT_DTL	UNIQUE_ID
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.	VARCHAR2(255)	CALCULATION	CASE WHEN DAP_RESULT_TYPE
AUDIT_RUN_DATE	Date the audit was run.	DATE	CALCULATION	DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'
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.	VARCHAR2(255)	CALCULATION	CASE WHEN DAP_AUDIT_TYPE
BLOCK_DESC	Block title.	VARCHAR2(255)	CONSTANT CONSTANT CONSTANT DAP_REQ_BLOCK	'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' TITLE
BLOCK_ID	Block identification grouping a set of requirements.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_REQ_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	Label text uniquely identifying the rule within the block.	VARCHAR2(255)	CONSTANT DAP_RESULT_DTL	'NA' DAP_FREETEXT
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
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
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
CAMPUS_DESC_DW	Institution campus name for Degree Works.	VARCHAR2(255)	UCX_STU576	UCX_VALUE
COURSE_APPLIED_IND	Indicates whether this course was applied in the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED'
COURSE_CREDITS	Credits associated with this course.	NUMBER	DAP_RESCLASS_DTL	DAP_SS_CREDITS
COURSE_CREDITS_DW	Credits associated with this course audited in Degree Works.	NUMBER	DAP_RESCLASS_DTL	DAP_AUD_CREDITS
COURSE_CREDIT_TYPE	Course credit type.	VARCHAR2(63)	DAP_RESCLASS_DTL	DAP_TRANSFER_TYPE
COURSE_CREDIT_TYPE_DESC	Course credit type description.	VARCHAR2(255)	DAP_RESCLASS_DTL	DAP_TRANSFER_TYPE
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'
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(63)	CALCULATION	DAP_VALUE1 || DAP_VALUE2
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'
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
COURSE_NEEDED_IND	Indicates whether this course was needed in the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED'
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2
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'
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
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(63)	NA	NULL
COURSE_SOURCE	Indicates the source of the course	VARCHAR2(63)	CALCULATION	CASE WHEN (C.DAP_TRANSFER = 'C') AND (C.DAP_INPROGRESS = 'N')
COURSE_SOURCE_DESC	Course source description.	VARCHAR2(255)	CALCULATION	CASE WHEN (C.DAP_TRANSFER = 'C') AND (C.DAP_INPROGRESS = 'N')
COURSE_STATUS	Course status.	VARCHAR2(63)	DAP_RESCLASS_DTL	DAP_CLASS_STATUS
COURSE_STATUS_DESC	Course status description.	VARCHAR2(255)	DAP_RESCLASS_DTL	DAP_CLASS_STATUS
COURSE_TITLE_SHORT	Course title short.	VARCHAR2(255)	DAP_RESCLASS_DTL	DAP_COURSE_TITLE
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.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC
DEGREE_DESC_DW	Degree description from Degree Works.	VARCHAR2(255)	UCX_STU307	UCX_VALUE
FINAL_GRADE	Grade earned by the student for this course.	VARCHAR2(63)	DAP_RESCLASS_DTL	DAP_GRADE
GPA_CREDITS	Credits associated with this course counted toward the GPA.	NUMBER	DAP_RESCLASS_DTL	DAP_GPA_CREDITS
GPA_QUALITY_POINTS		NUMBER	DAP_RESCLASS_DTL	DAP_GPA_GRD_PTS
GRADE_TYPE	Grade mode associated with this section or offering of the course.	VARCHAR2(63)	DAP_RESCLASS_DTL	DAP_GRADE_TYPE
GRADE_TYPE_DESC	Grade type description.	VARCHAR2(255)	STVGMOD	STVGMOD_DESC
GRADE_TYPE_DESC_DW	Grade type description for Degree Works.	VARCHAR2(255)	UCX_STU356	UCX_VALUE
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
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
INCOMPLETE_GRADE_IND	Indicates whether the grade is an incomplete grade.	VARCHAR2(1)	DAP_RESCLASS_DTL	DAP_INCOMPLETE
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'
INSUFFICIENT_REASON	Reason why the course is in the insufficient section.	VARCHAR2(255)	DAP_RESCLASS_DTL	DAP_REASON_INSUF
INSUFFICIENT_REASON_DESC	Insufficient reason description.	VARCHAR2(255)	CALCULATION	CASE WHEN DAP_REASON_INSUF
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'
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the student (Last name, First name Middle Initial format).	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PASS_FAIL_GRADE_IND	Indicates whether the grade mode is specified as pass/fail.	VARCHAR2(1)	DAP_RESCLASS_DTL	DAP_PASSFAIL
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RAD_PRIMARY_MST	RAD_USER_DEF1
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'
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
QUALITY_POINTS	Quality points associated with the grade.	NUMBER	DAP_RESCLASS_DTL	DAP_GRADE_POINTS
REPEAT_COURSE_NUMBER	Course number that was repeated.	VARCHAR2(63)	DAP_RESCLASS_DTL	DAP_REPEAT_NUM
REPEAT_POLICY	Determines how repeated courses are processed.	VARCHAR2(63)	DAP_RESCLASS_DTL	DAP_REPEAT_PLCY1
REPEAT_POLICY_DESC	Repeat policy description.	VARCHAR2(255)	UCX_AUD047	DAP_VALUE
REPEAT_SUBJECT	Course that was repeated		DAP_RESCLASS_DTL	DAP_REPEAT_DISC
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_COURSES_NEEDED	Number of courses still needed on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2
RULE_COURSE_REQUIRED	Number of courses originally required on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2
RULE_CREDITS_NEEDED	Number of credits still needed on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1
RULE_CREDITS_REQUIRED	Number of credits originally required on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1
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
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
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.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
STUDENT_CLASSIFICATION_DESC_DW	Student classification description from Degree Works.	VARCHAR2(255)	CONSTANT	NULL
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	Course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
STUDENT_LEVEL_DESC_DW	Student level description from Degree Works.	VARCHAR2(255)	UCX_STU350	UCX_VALUE
SUBJECT	Main instructional subject area for this course.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1
SUBJECT_DESC	Subject code description.	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC
SUBJECT_DESC_DW	Subject/discipline code description from Degree Works.	VARCHAR2(255)	UCX_STU352	UCX_VALUE
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	Course take type description.	VARCHAR2(255)	FUNCTION	CASE WHEN DAP_VALUE4
TRANSFER_COURSE_IDENTIFICATION	Course subject and course number combined from the transfer institution.	VARCHAR2(63)	DAP_RESCLASS_DTL	DAP_TR_COURSE
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'
TRANSFER_COURSE_INST_DESC	Name of the post secondary transfer institution.	VARCHAR2(255)	DAP_RESCLASS_DTL	DAP_TR_SCHL_NAME
TRANSFER_COURSE_TITLE	Transfer institution course title.	VARCHAR2(255)	DAP_RESCLASS_DTL	DAP_TR_TITLE
WITH_ADVICE	Advice information.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3

Ver: 9.1