Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: MEAL_ASSIGNMENT

Description Contains details for all meal plan assignments made for the person.
Key & Frequency One row per person per academic period per meal plan assigned.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD

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



Ver: 9.0