Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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(6)
|
SGBSTDN SHRTTRM
|
SGBSTDN_TERM_CODE_EFF SHRTTRM_TERM_CODE
|
NO NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
This field specifies the academic period or term associated with the academic period code.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_STANDING
|
Identifies a student's academic standing at the beginning of the academic period (probation, good standing, etc). This will be either an override academic standing or the calculated value from the closest previous academic period.
|
VARCHAR2(2)
|
FUNCTION
|
SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''ASTD'',''C'')
|
NO
|
NO
|
ACADEMIC_STANDING_DATE
|
Date on which the beginning academic standing is effective for the academic period.
|
DATE
|
FUNCTION
|
SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''ASTD'',''D'')
|
NO
|
NO
|
ACADEMIC_STANDING_DESC
|
Description of the academic standing value.
|
VARCHAR2(30)
|
STVASTD
|
STVASTD_DESC
|
NO
|
NO
|
ACADEMIC_STANDING_END
|
Identifies a student's academic standing at the end of the academic period (probation, good standing, etc).
|
VARCHAR2(2)
|
SHRTTRM
|
SHRTTRM_ASTD_CODE_END_OF_TERM
|
NO
|
NO
|
ACADEMIC_STANDING_END_DT
|
Date on which the end of academic period academic standing is effective.
|
DATE
|
SHRTTRM
|
SHRTTRM_ASTD_DATE_END_OF_TERM
|
NO
|
NO
|
ACADEMIC_STAND_OVERRIDE
|
Identifies the academic standing override for a student for the academic period.
|
VARCHAR2(2)
|
SGBSTDN
|
SGBSTDN_ASTD_CODE
|
NO
|
NO
|
ACADEMIC_STAND_OVERRIDE_DESC
|
Description of the academic standing override value.
|
VARCHAR2(30)
|
STVASTD
|
STVASTD_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
This field identifies the academic year associated with the information on the student information record.
|
VARCHAR2(4)
|
|
|
|
NO
|
ACADEMIC_YEAR_DESC
|
This field specifies the academic year associated with the academic year code.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
ACAD_STANDING_END_DESC
|
Description of the academic standing code.
|
VARCHAR2(30)
|
STVASTD
|
STVASTD_DESC
|
NO
|
NO
|
COMBINED_ACAD_STANDING
|
Identifies a student's combined academic standing at the beginning of the academic period (probation, good standing, etc). This will be either an override combined academic standing or the calculated value from the closest previous academic period.
|
VARCHAR2(2)
|
FUNCTION
|
SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''CAST'',''C'')
|
NO
|
NO
|
COMBINED_ACAD_STANDING_DATE
|
Date combined academic standing code was updated.
|
DATE
|
FUNCTION
|
SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''CAST'',''D'')
|
NO
|
NO
|
COMBINED_ACAD_STANDING_DESC
|
Description of the combined academic standing code for the academic period.
|
VARCHAR2(30)
|
STVCAST
|
STVCAST_DESC
|
NO
|
NO
|
COMBINED_ACAD_STAND_END
|
Identifies a student's combined academic standing at the end of the academic period (probation, good standing, etc).
|
VARCHAR2(2)
|
SHRTTRM
|
SHRTTRM_CAST_CODE
|
NO
|
NO
|
COMBINED_ACAD_STAND_END_DATE
|
Date on which the end of academic period combined academic standing was entered.
|
DATE
|
SHRTTRM
|
SHRTTRM_CAST_DATE
|
NO
|
NO
|
COMBINED_ACAD_STAND_END_DESC
|
Description of the combined academic standing.
|
VARCHAR2(30)
|
STVCAST
|
STVCAST_DESC
|
NO
|
NO
|
COMB_ACAD_STAND_OVERRIDE
|
Identifies the combined academic standing override for a student for the academic period.
|
VARCHAR2(2)
|
SGBSTDN
|
SGBSTDN_CAST_CODE
|
NO
|
NO
|
COMB_ACAD_STAND_OVERRIDE_DESC
|
Description of the combined academic standing override for a student for the academic period.
|
VARCHAR2(30)
|
STVCAST
|
STVCAST_DESC
|
NO
|
NO
|
CURRENT_DATE
|
This is the date when the rows in this view were retrieved.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MIF_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
The internal number used to uniquely identify an individual.
|
NUMBER
|
SGBSTDN SHRTTRM
|
SGBSTDN_PIDM SHRTTRM_PIDM
|
NO NO
|
NO
|
PROGRESS_EVALUATION
|
Identifies a student's progress evaluation at the beginning of the academic period (probation, good standing, etc). This will be either an override progress evaluation or the calculated value from the closest previous academic period.
|
VARCHAR2(2)
|
FUNCTION
|
SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''PREV'',''C'')
|
NO
|
NO
|
PROGRESS_EVALUATION_DATE
|
This is the date progress evaluation code was updated.
|
DATE
|
FUNCTION
|
SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''PREV'',''D'')
|
NO
|
NO
|
PROGRESS_EVALUATION_DESC
|
The description for the progress evaluation code for this academic history academic period.
|
VARCHAR2(30)
|
STVPREV
|
STVPREV_DESC
|
NO
|
NO
|
PROGRESS_EVALUATION_END
|
Identifies a student's progress evaluation at the end of the academic period (probation, good standing, etc).
|
VARCHAR2(2)
|
SHRTTRM
|
SHRTTRM_PREV_CODE
|
NO
|
NO
|
PROGRESS_EVALUATION_END_DATE
|
Date on which the end of academic period progress evaluation was entered.
|
DATE
|
SHRTTRM
|
SHRTTRM_PREV_DATE
|
NO
|
NO
|
PROGRESS_EVALUATION_END_DESC
|
Description of the progress evaluation for this academic period.
|
VARCHAR2(30)
|
STVPREV
|
STVPREV_DESC
|
NO
|
NO
|
PROGRESS_EVAL_OVERRIDE
|
Identifies the progress evaluation override for a student for the academic period.
|
VARCHAR2(2)
|
SGBSTDN
|
SGBSTDN_PREV_CODE
|
NO
|
NO
|
PROGRESS_EVAL_OVERRIDE_DESC
|
Description of the progress evaluation override for a student for the academic period.
|
VARCHAR2(30)
|
STVPREV
|
STVPREV_DESC
|
NO
|
NO
|
STUDENT_LEVEL
|
Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.
|
VARCHAR2(2)
|
SGBSTDN
|
SGBSTDN_LEVL_CODE
|
NO
|
NO
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(30)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
This field identifies the session or part of the academic period associated with the information on the student information record.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
This field identifies the description of the session or part of the academic period associated with the information on the student information record.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|