Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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: