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)
|
SFRWDRL
|
SFRWDRL_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_BREAK_DAYS
|
Number of break days defined the academic period.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_ENRL_BREAK_DAYS
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_PERIOD_END_DATE
|
Academic Period End Date.
|
DATE
|
SFRWDRL
|
SFRWDRL_ENRL_END_DATE
|
NO
|
NO
|
ACADEMIC_PERIOD_START_DATE
|
Academic Period Start Date.
|
DATE
|
SFRWDRL
|
SFRWDRL_ENRL_START_DATE
|
NO
|
NO
|
ACADEMIC_PERIOD_TOTAL_DAYS
|
Net number of days attended before the withdrawal or the number of days between the academic period start date and the student's enrollment withdrawal date.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_ENRL_DAYS
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(4)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
ACTIVITY_DATE
|
Date the last change were made to this record.
|
DATE
|
SFRWDRL
|
SFRWDRL_ACTIVITY_DATE
|
NO
|
NO
|
CURRENT_DATE
|
|
DATE
|
|
|
|
NO
|
DOMAIN_VALUE
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
ENROLLMENT_STATUS
|
Student's current enrollment status for this section or schedule offering.
|
VARCHAR2(2)
|
SFRWDRL
|
SFRWDRL_ESTS_CODE
|
NO
|
NO
|
ENROLLMENT_STATUS_DATE
|
Date for the last update to enrollment status.
|
DATE
|
SFRWDRL
|
SFRWDRL_ESTS_DATE
|
NO
|
NO
|
ENROLLMENT_STATUS_DESC
|
Student's enrollment status description.
|
VARCHAR2(30)
|
STVESTS
|
STVESTS_DESC
|
NO
|
NO
|
ENROLLMENT_UPDATE_USER
|
User who made the last updated to this record.
|
VARCHAR2(30)
|
SFRWDRL
|
SFRWDRL_USER
|
NO
|
NO
|
ENROLLMENT_WITHDRAWAL_DATE
|
Date the student's enrollment status was changed to show the student as withdrawn for this academic period.
|
DATE
|
SFRWDRL
|
SFRWDRL_EFF_WDRL_DATE
|
NO
|
NO
|
FINANCIAL_AID_PROCESSED_IND
|
Indicates that the student withdrawal was processed by the Financial Aid Office.
|
VARCHAR2(1)
|
SFRWDRL
|
SFRWDRL_PROCESSED_IND
|
NO
|
NO
|
FINANCIAL_AID_REGULATORY_IND
|
Identified withdrawal processed because of government guidelines. In the US, this withdrawal data is required to be compliant for Title IV regulations.
|
VARCHAR2(1)
|
SFRWDRL
|
SFRWDRL_TIV_IND
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_PIDM
|
NO
|
NO
|
STUDENT_ATTEND_BREAK_DAYS
|
Number of days during the student's enrollment on which classes were on break or not in session during this academic period. Number of days the student was not expected to attend class.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_ATTEND_BREAK_DAYS
|
NO
|
NO
|
STUDENT_ATTEND_DAYS
|
Number of days during the student's enrollment days on which classes were held or in session during this academic period. Number of days the student was expected to attend class.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_ATTEND_DAYS
|
NO
|
NO
|
STUDENT_ATTEND_LEAVE_DAYS
|
Number of approved leave days for the student this academic period.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_LEAVE_DAYS
|
NO
|
NO
|
STUDENT_ATTEND_PERCENT
|
Percent of enrollment period that student attended.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_PERCENT_ATTEND
|
NO
|
NO
|
STUDENT_ORIGINAL_CHARGES
|
Student total original institutional charges for this academic period.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_ORIGINAL_CHARGES
|
NO
|
NO
|
STUDENT_OTHER_CHARGES
|
Other institutional costs not in accounts receivable.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_OTHER_COSTS
|
NO
|
NO
|
WITHDRAWAL_COMMENT
|
Comment associated with this withdrawal record.
|
VARCHAR2(240)
|
SFRWDRL
|
SFRWDRL_COMMENT
|
NO
|
NO
|
WITHDRAWAL_RECORD_NUMBER
|
Sequence number that is used with the PERSON_UID and ACADEMIC_PERIOD to identify a unique withdrawal record.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_SEQ_NO
|
NO
|
NO
|
WITHDRAWAL_RECORD_TYPE
|
Institution defined withdrawal type assigned when the person is identified as withdrawn for the academic period.
|
VARCHAR2(2)
|
SFRWDRL
|
SFRWDRL_WDRL_CODE
|
NO
|
NO
|
WITHDRAWAL_RECORD_TYPE_DESC
|
Description for the type of withdrawal noted for the person.
|
VARCHAR2(30)
|
STVWDRL
|
STVWDRL_DESC
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|