Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Academic period or time frame this meal assignment is active.
|
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
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
ID
|
ID
|
Person's or organization's current identification number.
|
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
|