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 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



Ver: 9.2