Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_MEAL_ASSIGNMENT

Description Source composite view contains all meal plan information.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame this meal assignment is active. VARCHAR2(6)

SLRMASG

SLRMASG_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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(6)

SLBRMAP

SLBRMAP_FROM_TERM

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

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 Housing application status code description. VARCHAR2(30)

STVHAPS

STVHAPS_DESC

MEAL_APPLICATION_TO_PERIOD End term of the application. VARCHAR2(6)

SLBRMAP

SLBRMAP_TO_TERM

MEAL_APPLICATION_TYPE Type of meal application. VARCHAR2(4)

SLBRMAP

SLBRMAP_ARTP_CODE

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

STVARTP

STVARTP_DESC

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

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(30)

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(2)

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(30)

STVMSCD

STVMSCD_DESC

MEAL_PLAN_TOTAL_DAYS Total number of days in the current assigned meal plan/rate code. NUMBER(9, 5)

SLRMASG

SLRMASG_TOTAL_DAYS

MEAL_PLAN_TOTAL_MONTHS Total number of months in the current assigned meal plan/rate code. NUMBER(7, 5)

SLRMASG

SLRMASG_TOTAL_MONTHS

MEAL_PLAN_TOTAL_PERIODS Total number of terms in the current assigned meal plan/rate code. NUMBER(7, 5)

SLRMASG

SLRMASG_TOTAL_TERMS

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

NA

NA

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

NA

NA

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

SLRMASG

SLRMASG_PIDM

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

SLBRMAP

SLBRMAP_MRCD_CODE

PREFERRED_MEAL_PLAN_DESC Description for the preferred meal plan code. VARCHAR2(30)

STVMRCD

STVMRCD_DESC

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(0)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(0)

NA

NA

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 8.0