RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE 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 Academic period or time frame this meal assignment is active. 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)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

ID Person's or organization's current identification number. 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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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(94)

FUNCTION

F_FORMAT_NAME

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)

FUNCTION

GOKODSF.F_GET_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: 3.1