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)	STVACYR	STVACYR_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)	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: 8.1