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)
|
SLRMASG
|
SLRMASG_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(4)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
MEAL_APPLICATION_DATE_ADDED
|
Meal Application Date Added
|
Date the application was added to the system.
|
DATE
|
SLBRMAP
|
SLBRMAP_ADD_DATE
|
MEAL_APPLICATION_FROM_PERIOD
|
Meal Application From Period
|
Beginning term of the application.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_FROM_TERM
|
MEAL_APPLICATION_STATUS
|
Meal Application Status
|
Housing application status code associated with the applicant.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_HAPS_CODE
|
MEAL_APPLICATION_STATUS_DATE
|
Meal Application Status Date
|
Date when the housing application status code was last changed.
|
DATE
|
SLBRMAP
|
SLBRMAP_HAPS_DATE
|
MEAL_APPLICATION_STATUS_DESC
|
Meal Application Status Description
|
Meal plan status code description.
|
VARCHAR2(255)
|
STVHAPS
|
STVHAPS_DESC
|
MEAL_APPLICATION_TO_PERIOD
|
Meal Application To Period
|
End term of the application.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_TO_TERM
|
MEAL_APPLICATION_TYPE
|
Meal Application Type
|
Type of meal application.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_ARTP_CODE
|
MEAL_APPLICATION_TYPE_DESC
|
Meal Application Type Description
|
Meal application request type code description.
|
VARCHAR2(255)
|
STVARTP
|
STVARTP_DESC
|
MEAL_PLAN
|
Meal Plan
|
Code for the current meal plan/rate code assigned to the student.
|
VARCHAR2(63)
|
SLRMASG
|
SLRMASG_MRCD_CODE
|
MEAL_PLAN_ASSESSMENT_IND
|
Meal Plan Assessment Indicator
|
Indicates whether fee assessment is needed for the meal assignment.
|
VARCHAR2(1)
|
SLRMASG
|
SLRMASG_ASSESS_NEEDED
|
MEAL_PLAN_BEGIN_DATE
|
Meal Plan Begin Date
|
Begin date of the current assigned meal plan/rate code.
|
DATE
|
SLRMASG
|
SLRMASG_BEGIN_DATE
|
MEAL_PLAN_CHARGES_IND
|
Meal Plan Charges Indicator
|
Indicates whether the charges have been processed for the current meal plan/rate code.
|
VARCHAR2(1)
|
SLRMASG
|
SLRMASG_AR_IND
|
MEAL_PLAN_DESC
|
Meal Plan Description
|
Current meal plan/rate code description.
|
VARCHAR2(255)
|
STVMRCD
|
STVMRCD_DESC
|
MEAL_PLAN_END_DATE
|
Meal Plan End Date
|
End date of the current assigned meal plan/rate code.
|
DATE
|
SLRMASG
|
SLRMASG_END_DATE
|
MEAL_PLAN_STATUS
|
Meal Plan Status
|
Status code for the current meal plan/rate code.
|
VARCHAR2(63)
|
SLRMASG
|
SLRMASG_MSCD_CODE
|
MEAL_PLAN_STATUS_DATE
|
Meal Plan Status Date
|
Date the status code was updated for the current meal plan/rate code.
|
DATE
|
SLRMASG
|
SLRMASG_MSCD_DATE
|
MEAL_PLAN_STATUS_DESC
|
Meal Plan Status Description
|
Current meal plan status code description.
|
VARCHAR2(255)
|
STVMSCD
|
STVMSCD_DESC
|
MEAL_PLAN_TOTAL_DAYS
|
Meal Plan Total Days
|
Total number of days in the current assigned meal plan/rate code.
|
NUMBER
|
SLRMASG
|
SLRMASG_TOTAL_DAYS
|
MEAL_PLAN_TOTAL_MONTHS
|
Meal Plan Total Months
|
Total number of months in the current assigned meal plan/rate code.
|
NUMBER
|
SLRMASG
|
SLRMASG_TOTAL_MONTHS
|
MEAL_PLAN_TOTAL_PERIODS
|
Meal Plan Total Periods
|
Total number of terms in the current assigned meal plan/rate code.
|
NUMBER
|
SLRMASG
|
SLRMASG_TOTAL_TERMS
|
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
|
SLRMASG
|
SLRMASG_PIDM
|
PREFERRED_MEAL_PLAN
|
Preferred Meal Plan
|
Meal rate code associated with the meal assignment.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_MRCD_CODE
|
PREFERRED_MEAL_PLAN_DESC
|
Preferred Meal Plan Description
|
Preferred meal plan code description.
|
VARCHAR2(255)
|
STVMRCD
|
STVMRCD_DESC
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|