Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
ACAD_HISTORY_EXISTS_IND
|
Indicates this student has courses in academic history for this academic period.
|
NUMBER
|
ENROLLMENT
|
ACADEMIC_HISTORY_EXISTS_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ACAD_HISTORY_EXISTS_IND_LD
|
Long description for the academic history indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ACAD_HISTORY_EXISTS_IND_SD
|
Short description for the academic history indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ACAD_OUTCOME_ENROLLED_IND
|
Indicates that there is an academic outcome tied to the student record for this enrollment academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ACAD_OUTCOME_ENROLLED_IND_LD
|
Long description for the academic outcome enrolled indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ACAD_OUTCOME_ENROLLED_IND_SD
|
Short description for the academic outcome enrolled indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
COOP_ED_PARTICIPANT_IND
|
Indicates the student is in in a program that has a cooperative education experience in this academic period.
|
NUMBER
|
ACADEMIC_STUDY
|
COOPERATIVE_EDUCATION_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
COOP_ED_PARTICIPANT_IND_LD
|
Long description for participant in cooperative education indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
COOP_ED_PARTICIPANT_IND_SD
|
Short description for participant in cooperative education indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLLED_IND
|
Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLLED_IND_LD
|
Long description for the enrolled indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLLED_IND_SD
|
Short description for the enrolled indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLL_BY_CENSUS_DATE1_IND
|
Identifies this student was enrolled in at least one course as of the first census date. This means the initial section add date is prior to the census date and any new course registration status does take the student out of the include in section count prior to the census date.
|
NUMBER
|
ENROLLMENT
|
ENROLL_CENSUS_DATE1_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLL_BY_CENSUS_DATE1_IND_LD
|
Long description for enrolled by census date 1 indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLL_BY_CENSUS_DATE1_IND_SD
|
Short description for enrolled by census date 1 indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLL_BY_CENSUS_DATE2_IND
|
Identifies this student was enrolled in at least one course as of the second census date. This means the initial section add date is prior to the census date and any new course registration status does take the student out of the include in section count prior to the census date.
|
NUMBER
|
ENROLLMENT
|
ENROLL_CENSUS_DATE2_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLL_BY_CENSUS_DATE2_IND_LD
|
Long description for enrolled by census date 2 indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
ENROLL_BY_CENSUS_DATE2_IND_SD
|
Short description for enrolled by census date 2 indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
GRADUATE_CREDIT_ELIG_IND
|
Indicates the student has permission to take graduate credit courses in this academic period.
|
NUMBER
|
STUDENT
|
GRADUATE_CREDIT_ELIG_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
GRADUATE_CREDIT_ELIG_IND_LD
|
Long description for graduate credit eligible indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
GRADUATE_CREDIT_ELIG_IND_SD
|
Short description for graduate credit eligible indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
MATRICULATED_IND
|
Indicates the student is matriculated in a degree seeking program at the institution.
|
NUMBER
|
ACADEMIC_STUDY
|
MATRICULATED_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
MATRICULATED_IND_LD
|
Long description for the matriculation indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
MATRICULATED_IND_SD
|
Short description for the matriculation indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NEW_STUDENT_IND
|
Indicates this is the academic period admit when the student is new to the institution.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NEW_STUDENT_IND_LD
|
Long description for the new student indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NEW_STUDENT_IND_SD
|
Short description for the new student indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
PERMIT_REGISTRATION_IND
|
Indicates the student status for this academic period permits the student to register.
|
NUMBER
|
ACADEMIC_STUDY
|
PERMIT_REGISTRATION
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
PERMIT_REGISTRATION_IND_LD
|
Long description for the permit registration indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
PERMIT_REGISTRATION_IND_SD
|
Short description for the permit registration indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
REGISTERED_IND
|
Indicates that the student is considered registered because the have at least one course section with a registration course status assigned for this academic period where the status has a yes in the include in section enrollment indicator is yes.
|
NUMBER
|
ACADEMIC_STUDY
|
REGISTERED_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
REGISTERED_IND_LD
|
Long description for the registered indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
REGISTERED_IND_SD
|
Short description for the registered indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
STUDENT_STATUS_KEY
|
Key for the student status dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT PROGRESS
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT PROGRESS
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT PROGRESS
|
WITHDRAWN_IND
|
Indicates the student has an enrollment status that identifies the student as withdrawn from the institution in this academic period.
|
NUMBER
|
ENROLLMENT
|
WITHDRAWN_IND
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
WITHDRAWN_IND_LD
|
Long description for the withdrawn indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
WITHDRAWN_IND_SD
|
Short description for the withdrawn indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|