| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
DEPARTMENT
|
Department responsible for this minor in the student's academic program or study.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
DEPARTMENT_LD
|
Long description name for this department.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
DEPARTMENT_SD
|
Short description name for this department.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
MINOR
|
Minor subject area emphasis of the person's academic program or study.
|
VARCHAR2(63)
|
ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY
|
FIRST_MINOR FOURTH_MINOR SECOND_MINOR THIRD_MINOR
|
NO NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE
|
|
MINOR_KEY
|
Key for the minor dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
MINOR_LD
|
Long description name of the student's minor subject area.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY
|
FIRST_MINOR_DESC FOURTH_MINOR_DESC SECOND_MINOR_DESC THIRD_MINOR_DESC
|
NO NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE
|
|
MINOR_SD
|
Short description name of the student's minor subject area.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY
|
FIRST_MINOR_DESC FOURTH_MINOR_DESC SECOND_MINOR_DESC THIRD_MINOR_DESC
|
NO NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE ACADEMIC PROGRAM COURSE
|
|
PROGRAM_CLASSIFICATION
|
Program classification associated with the minor subject area of study for this academic program. This may be the Classification of Institutional Programs (CIP) codes used for reporting to the federal government.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
PROGRAM_CLASSIFICATION_LD
|
Long description for the program classification.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
PROGRAM_CLASSIFICATION_SD
|
Short description for the program classification.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE
|