| 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(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_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 CONSTANT CONSTANT DAP_REQ_BLOCK
|
'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' TITLE
|
|
BLOCK_GPA
|
Block GPA - Grade Point Average or Average
|
Block grade point average.
|
NUMBER
|
CONSTANT DAP_RESULT_DTL
|
0 DAP_NUMBER2
|
|
BLOCK_ID
|
Block ID
|
Block identification grouping a set of requirements.
|
VARCHAR2(63)
|
DAP_RESULT_DTL
|
DAP_REQ_ID
|
|
BLOCK_QUALITY_POINTS
|
Block Quality Points
|
Block quality points used in GPA calculation.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_NUMBER3
|
|
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
|
|
BLOCK_TYPE
|
Block Type
|
Block categorization such as Degree, Major, Minor, Concentration, etc.
|
VARCHAR2(63)
|
DAP_REQ_BLOCK DAP_RESULT_DTL
|
BLOCK_TYPE DAP_REQ_ID
|
|
BLOCK_TYPE_DESC
|
Block Type Description
|
Block type description.
|
VARCHAR2(255)
|
CONSTANT CONSTANT CONSTANT UCX_SCR004
|
'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' UCX_VALUE
|
|
BLOCK_VALUE
|
Block Value
|
Value of the degree or major like BA for Bachelor of Arts degree or ANTH for a major in anthropology.
|
VARCHAR2(63)
|
DAP_REQ_BLOCK
|
BLOCK_VALUE
|
|
BLOCK_VALUE_DESC
|
Block Value Description
|
Block value description.
|
VARCHAR2(255)
|
CONSTANT CONSTANT CONSTANT DAP_REQ_BLOCK
|
'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' TITLE
|
|
CATALOG_YEAR_END
|
Catalog Year End
|
Last catalog year where the degree requirements were defined for the institution.
|
VARCHAR2(63)
|
DAP_REQ_BLOCK
|
PERIOD_STOP
|
|
CATALOG_YEAR_END_DESC
|
Catalog Year End Description
|
Catalog year end description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
|
CATALOG_YEAR_START
|
Catalog Year Start
|
Earliest catalog year where the degree requirements were defined for the institution.
|
VARCHAR2(63)
|
DAP_REQ_BLOCK
|
PERIOD_START
|
|
CATALOG_YEAR_START_DESC
|
Catalog Year Start Description
|
Catalog year start description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
|
COURSES_APPLIED
|
Courses Applied
|
Number of courses counted.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_NUMBER2
|
|
COURSES_APPLIED_RANGE
|
Courses Applied Range
|
Range that the number of block courses counted falls within based upon pre-defined cleansing rules.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
|
COURSES_APPLIED_RANGE_DESC
|
Courses Applied Range Description
|
Courses applied range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
COURSES_APPLIED_RANGE_ORDER
|
Courses Applied Range Order
|
Courses applied range order concatenated with courses applied range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
COURSES_NEEDED
|
Courses Needed
|
Number of courses needed.
|
NUMBER
|
CONSTANT DAP_RESULT_DTL
|
0 DAP_NUMBER2
|
|
COURSES_NEEDED_RANGE
|
Courses Needed Range
|
Range that the number of block courses needed falls within based upon pre-defined cleansing rules.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
|
COURSES_NEEDED_RANGE_DESC
|
Courses Needed Range Description
|
Courses needed range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
COURSES_NEEDED_RANGE_ORDER
|
Courses Needed Range Order
|
Courses needed range order concatenated with courses needed range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
COURSES_REQUIRED
|
Courses Required
|
Minimum number of courses that must be taken.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_NUMBER2
|
|
CREDITS_APPLIED
|
Credits Applied
|
Number of credits counted.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_NUMBER1
|
|
CREDITS_APPLIED_RANGE
|
Credits Applied Range
|
Range that the number of block credits counted falls within based upon pre-defined cleansing rules.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
|
CREDITS_APPLIED_RANGE_DESC
|
Credits Applied Range Description
|
Credits applied range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
CREDITS_APPLIED_RANGE_ORDER
|
Credits Applied Range Order
|
Credits applied range order concatenated with credits applied range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
CREDITS_NEEDED
|
Credits Needed
|
Number of credits needed.
|
NUMBER
|
CONSTANT DAP_RESULT_DTL
|
0 DAP_NUMBER1
|
|
CREDITS_NEEDED_RANGE
|
Credits Needed Range
|
Range that the number of block credits needed falls within based upon pre-defined cleansing rules.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
|
CREDITS_NEEDED_RANGE_DESC
|
Credits Needed Range Description
|
Credits needed range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
CREDITS_NEEDED_RANGE_ORDER
|
Credits Needed Range Order
|
Credits needed range order concatenated with credits needed range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
CREDITS_PCT_CMPLETE_RANGE_DESC
|
Credits Percent Cmplete Range Description
|
Credits percent complete range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
CREDITS_PCT_CMPLTE_RANGE_ORDER
|
Credits Percent Cmplete Range Order
|
Credits percent complete range order concatenated with credits percent range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
CREDITS_PCT_COMPLETE_RANGE
|
Credits Percent Completion Range
|
Range that the block percent credits complete falls within based upon pre-defined ODS EXTRACT PARAMETERS.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
|
CREDITS_PERCENT_COMPLETE
|
Credits Percent Completion
|
Block credits percent complete.
|
NUMBER
|
CONSTANT
|
0
|
|
CREDITS_REQUIRED
|
Credits Required
|
Minimum number of credits that must be taken.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_NUMBER2
|
|
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
|
|
GPA_RANGE
|
GPA - Grade Point Average or Average Range
|
Range that the block GPA falls within based upon pre-defined ODS EXTRACT PARAMETERS.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
|
GPA_RANGE_DESC
|
GPA - Grade Point Average or Average Range Description
|
GPA range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
GPA_RANGE_ORDER
|
GPA - Grade Point Average or Average Range Order
|
GPA range order concatenated with GPA range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
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
|
|
MINIMUM_GPA
|
Minimum GPA - Grade Point Average or Average
|
Minimum GPA required for the block.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_NUMBER2
|
|
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
|
|
OVERFLOW_CREDITS
|
Overflow Credits
|
Fall-through overflow credits. Used in calculation block percentage of credit completed for block sequence 1.
|
NUMBER
|
DAP_RESULT_DTL
|
DAP_NUMBER4
|
|
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(255)
|
NA
|
NA
|
|
REQUIRE_PCT_CMPLETE_RANGE_DESC
|
Requirements Percent Cmplete Range Description
|
Requirements percent complete range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
REQUIRE_PCT_CMPLTE_RANGE_ORDER
|
Requirements Percent Complete Range Order
|
Requirements percent complete range order concatenated with requirements percent range description.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
|
REQUIRE_PCT_COMPLETE_RANGE
|
Requirements Percent Completion Range
|
Range that the block percent requirements complete falls within based upon pre-defined ODS EXTRACT PARAMETERS.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
|
REQUIRE_PERCENT_COMPLETE
|
Requirements Percent Completion
|
Block requirements percent complete.
|
NUMBER
|
CONSTANT DAP_RESULT_DTL
|
0 DAP_NUMBER1
|
|
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 from Degree Works.
|
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
|
Student 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
|