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

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 Definition Database Data Type Source Name Source Column
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. VARCHAR2(255)

STVTERM

STVTERM_DESC

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. VARCHAR2(255)

STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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 Date the application was added to the system. DATE

SLBRMAP

SLBRMAP_ADD_DATE

MEAL_APPLICATION_FROM_PERIOD Beginning term of the application. VARCHAR2(63)

SLBRMAP

SLBRMAP_FROM_TERM

MEAL_APPLICATION_STATUS Housing application status code associated with the applicant. VARCHAR2(63)

SLBRMAP

SLBRMAP_HAPS_CODE

MEAL_APPLICATION_STATUS_DATE Date when the housing application status code was last changed. DATE

SLBRMAP

SLBRMAP_HAPS_DATE

MEAL_APPLICATION_STATUS_DESC Meal plan status code description. VARCHAR2(255)

STVHAPS

STVHAPS_DESC

MEAL_APPLICATION_TO_PERIOD End term of the application. VARCHAR2(63)

SLBRMAP

SLBRMAP_TO_TERM

MEAL_APPLICATION_TYPE Type of meal application. VARCHAR2(63)

SLBRMAP

SLBRMAP_ARTP_CODE

MEAL_APPLICATION_TYPE_DESC Meal application request type code description. VARCHAR2(255)

STVARTP

STVARTP_DESC

MEAL_PLAN Code for the current meal plan/rate code assigned to the student. VARCHAR2(63)

SLRMASG

SLRMASG_MRCD_CODE

MEAL_PLAN_ASSESSMENT_IND Indicates whether fee assessment is needed for the meal assignment. VARCHAR2(1)

SLRMASG

SLRMASG_ASSESS_NEEDED

MEAL_PLAN_BEGIN_DATE Begin date of the current assigned meal plan/rate code. DATE

SLRMASG

SLRMASG_BEGIN_DATE

MEAL_PLAN_CHARGES_IND Indicates whether the charges have been processed for the current meal plan/rate code. VARCHAR2(1)

SLRMASG

SLRMASG_AR_IND

MEAL_PLAN_DESC Current meal plan/rate code description. VARCHAR2(255)

STVMRCD

STVMRCD_DESC

MEAL_PLAN_END_DATE End date of the current assigned meal plan/rate code. DATE

SLRMASG

SLRMASG_END_DATE

MEAL_PLAN_STATUS Status code for the current meal plan/rate code. VARCHAR2(63)

SLRMASG

SLRMASG_MSCD_CODE

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 Current meal plan status code description. VARCHAR2(255)

STVMSCD

STVMSCD_DESC

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 Total number of months in the current assigned meal plan/rate code. NUMBER

SLRMASG

SLRMASG_TOTAL_MONTHS

MEAL_PLAN_TOTAL_PERIODS Total number of terms in the current assigned meal plan/rate code. NUMBER

SLRMASG

SLRMASG_TOTAL_TERMS

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SLRMASG

SLRMASG_PIDM

PREFERRED_MEAL_PLAN Meal rate code associated with the meal assignment. VARCHAR2(63)

SLBRMAP

SLBRMAP_MRCD_CODE

PREFERRED_MEAL_PLAN_DESC Preferred meal plan code description. VARCHAR2(255)

STVMRCD

STVMRCD_DESC

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 A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA



Ver: 9.1