Reporting View Source: DAP_RESULT_DTL

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: DAP_RESULT_DTL Degree Works Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
DAP_ACTIVE_TERM	CLASSNEEDED	REPORTING VIEW	AUDIT_COURSE_NEEDED AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_COURSE AUDIT_STUDENT_BLOCK	AUDIT_ACADEMIC_PERIOD AUDIT_ACADEMIC_PERIOD AUDIT_ACADEMIC_PERIOD AUDIT_ACADEMIC_PERIOD
DAP_AUDIT_TYPE	NA	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_BLOCK AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE	AUDIT_TYPE AUDIT_TYPE AUDIT_TYPE AUDIT_TYPE
DAP_BLOCK_SEQ_NUM	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_BLOCK AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED	BLOCK_SEQUENCE_NUMBER BLOCK_SEQUENCE_NUMBER BLOCK_SEQUENCE_NUMBER BLOCK_SEQUENCE_NUMBER
DAP_CREATE_DATE	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE	AUDIT_RESULT_CREATE_DATE AUDIT_RESULT_CREATE_DATE AUDIT_RESULT_CREATE_DATE
DAP_DEGREE	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED	DEGREE DEGREE DEGREE DEGREE
DAP_FREETEXT	LABEL	REPORTING VIEW	AUDIT_COURSE_NEEDED AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_COURSE	BLOCK_RULE_LABEL ADVICE_DESC BLOCK_RULE_LABEL BLOCK_RULE_LABEL ADVICE_DESC
DAP_NUMBER1	BLOCKCRCLNEEDED	REPORTING VIEW	AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK	CREDITS_NEEDED CREDITS_APPLIED REQUIRE_PERCENT_COMPLETE
DAP_NUMBER2	BLOCKCRCLNEEDED	REPORTING VIEW	AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK	COURSES_APPLIED MINIMUM_GPA COURSES_REQUIRED COURSES_NEEDED CREDITS_REQUIRED BLOCK_GPA
DAP_NUMBER3	BLOCKGPA	REPORTING VIEW	AUDIT_STUDENT_BLOCK	BLOCK_QUALITY_POINTS
DAP_NUMBER4	FALLCRCL	REPORTING VIEW	AUDIT_STUDENT_BLOCK	OVERFLOW_CREDITS
DAP_REQ_ID	CLASSNEEDED	REPORTING VIEW	AUDIT_COURSE_NEEDED AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE	BLOCK_ID BLOCK_ID BLOCK_TYPE BLOCK_ID BLOCK_ID
DAP_RESULT_SEQ_NUM	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED	RESULT_SEQUENCE_NUMBER RESULT_SEQUENCE_NUMBER RESULT_SEQUENCE_NUMBER
DAP_RESULT_TYPE	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_COURSE	AUDIT_RESULT_TYPE AUDIT_RESULT_TYPE
DAP_RULE_ID	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED	BLOCK_RULE_ID BLOCK_RULE_ID BLOCK_RULE_ID
DAP_SCHOOL	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE AUDIT_COURSE_NEEDED	STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL
DAP_VALUE1	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED AUDIT_COURSE_NEEDED AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE	RULE_CREDITS_REQUIRED SUBJECT NON_COURSE SUBJECT RULE_CREDITS_REQUIRED RULE_CREDITS_NEEDED RULE_CREDITS_NEEDED
DAP_VALUE2	CLASSNEEDED	REPORTING VIEW	AUDIT_COURSE_NEEDED AUDIT_COURSE_NEEDED AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE AUDIT_STUDENT_COURSE AUDIT_STUDENT_COURSE	RULE_COURSES_NEEDED RULE_COURSE_REQUIRED NON_COURSE_STATUS RULE_NON_COURSES_NEEDED NON_COURSE_OPERATOR COURSE_NUMBER RULE_COURSE_REQUIRED COURSE_NUMBER RULE_COURSES_NEEDED
DAP_VALUE3	CLASSNEEDED	REPORTING VIEW	AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE AUDIT_COURSE_NEEDED AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_COURSE AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE	WITH_ADVICE WITH_ADVICE RULE_OPERATOR_NEEDED RULE_OPERATOR_REQUIRED RULE_OPERATOR_REQUIRED NON_COURSE_INTERNAL_KEY COURSE_INTERNAL_KEY RULE_OPERATOR_NEEDED NON_COURSE_VALUE
DAP_VALUE4	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED	TAKE_TYPE TAKE_TYPE TAKE_TYPE
UNIQUE_ID	CLASSNEEDED	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_COURSE_NEEDED	AUDIT_RESULT_KEY AUDIT_RESULT_KEY AUDIT_RESULT_KEY

Ver: 8.5