Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
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(63)
|
SFRWDRL
|
SFRWDRL_TERM_CODE
|
ACADEMIC_PERIOD_BREAK_DAYS
|
Academic Period Break Days
|
Number of break days defined the academic period.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_ENRL_BREAK_DAYS
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_PERIOD_END_DATE
|
Academic Period End Date
|
Academic Period End Date.
|
DATE
|
SFRWDRL
|
SFRWDRL_ENRL_END_DATE
|
ACADEMIC_PERIOD_START_DATE
|
Academic Period Start Date
|
Academic Period Start Date.
|
DATE
|
SFRWDRL
|
SFRWDRL_ENRL_START_DATE
|
ACADEMIC_PERIOD_TOTAL_DAYS
|
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
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
ACTIVITY_DATE
|
Activity Date
|
Date the last change were made to this record.
|
DATE
|
SFRWDRL
|
SFRWDRL_ACTIVITY_DATE
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
ENROLLMENT_STATUS
|
Enrollment Status
|
Student's current enrollment status for this section or schedule offering.
|
VARCHAR2(63)
|
SFRWDRL
|
SFRWDRL_ESTS_CODE
|
ENROLLMENT_STATUS_DATE
|
Enrollment Status Date
|
Date for the last update to enrollment status.
|
DATE
|
SFRWDRL
|
SFRWDRL_ESTS_DATE
|
ENROLLMENT_STATUS_DESC
|
Enrollment Status Description
|
Student's enrollment status description.
|
VARCHAR2(255)
|
STVESTS
|
STVESTS_DESC
|
ENROLLMENT_UPDATE_USER
|
Enrollment Update User
|
User who made the last updated to this record.
|
VARCHAR2(63)
|
SFRWDRL
|
SFRWDRL_USER
|
ENROLLMENT_WITHDRAWAL_DATE
|
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
|
FINANCIAL_AID_PROCESSED_IND
|
Financial Financial Aid Processed Indicator
|
Indicates that the student withdrawal was processed by the Financial Aid Office.
|
VARCHAR2(1)
|
SFRWDRL
|
SFRWDRL_PROCESSED_IND
|
FINANCIAL_AID_REGULATORY_IND
|
Financial Financial Aid Regulatory Indicator
|
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
|
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
|
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 person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
STUDENT_ATTEND_BREAK_DAYS
|
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
|
STUDENT_ATTEND_DAYS
|
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
|
STUDENT_ATTEND_LEAVE_DAYS
|
Student Attend Leave Days
|
Number of approved leave days for the student this academic period.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_LEAVE_DAYS
|
STUDENT_ATTEND_PERCENT
|
Student Attend Percent
|
Percent of enrollment period that student attended.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_PERCENT_ATTEND
|
STUDENT_ORIGINAL_CHARGES
|
Student Original Charges
|
Student total original institutional charges for this academic period.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_ORIGINAL_CHARGES
|
STUDENT_OTHER_CHARGES
|
Student Other Charges
|
Other institutional costs not in accounts receivable.
|
NUMBER
|
SFRWDRL
|
SFRWDRL_OTHER_COSTS
|
WITHDRAWAL_COMMENT
|
Withdrawal Comment
|
Comment associated with this withdrawal record.
|
VARCHAR2(4000)
|
SFRWDRL
|
SFRWDRL_COMMENT
|
WITHDRAWAL_RECORD_NUMBER
|
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
|
WITHDRAWAL_RECORD_TYPE
|
Withdrawal Record Type
|
Institution defined withdrawal type assigned when the person is identified as withdrawn for the academic period.
|
VARCHAR2(63)
|
SFRWDRL
|
SFRWDRL_WDRL_CODE
|
WITHDRAWAL_RECORD_TYPE_DESC
|
Withdrawal Record Type Description
|
Description for the type of withdrawal noted for the person.
|
VARCHAR2(255)
|
STVWDRL
|
STVWDRL_DESC
|