Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period or time frame this telephone assignment is active.	VARCHAR2(6)		SLRPASG	SLRPASG_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
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)		SLRPASG	SLRPASG_PIDM
PHONE_ACCOUNT_NUMBER		Phone account number associated with the current phone assignment.	VARCHAR2(20)		SLRPASG	SLRPASG_PHONE_ACCOUNT_NUMBER
PHONE_APPLICATION_DATE_ADDED		Date the application was added to the system.	DATE		SLBRMAP	SLBRMAP_ADD_DATE
PHONE_APPLICATION_FROM_PERIOD		Beginning term of the application.	VARCHAR2(6)		SLBRMAP	SLBRMAP_FROM_TERM
PHONE_APPLICATION_STATUS		Phone application status code associated with the applicant.	VARCHAR2(2)		SLBRMAP	SLBRMAP_HAPS_CODE
PHONE_APPLICATION_STATUS_DATE		Date when the phone application status code was last changed.	DATE		SLBRMAP	SLBRMAP_HAPS_DATE
PHONE_APPLICATION_STATUS_DESC		Phone application status code description.	VARCHAR2(30)		STVHAPS	STVHAPS_DESC
PHONE_APPLICATION_TO_PERIOD		End term of the application.	VARCHAR2(6)		SLBRMAP	SLBRMAP_TO_TERM
PHONE_APPLICATION_TYPE		Type of phone application.	VARCHAR2(4)		SLBRMAP	SLBRMAP_ARTP_CODE
PHONE_APPLICATION_TYPE_DESC		Phone application request type code description.	VARCHAR2(30)		STVARTP	STVARTP_DESC
PHONE_AREA	Phone Area	Area code of the phone number associated with the phone assignment.	VARCHAR2(6)		SLRPASG	SLRPASG_PHONE_AREA
PHONE_ASSESSMENT_IND		Indicates whether fee assessment is needed for the phone assignment.	VARCHAR2(1)		SLRPASG	SLRPASG_ASSESS_NEEDED
PHONE_BEGIN_DATE		First day of the current phone assignment.	DATE		SLRPASG	SLRPASG_BEGIN_DATE
PHONE_CHARGES_IND		Indicates whether the current phone assignment charges have been processed.	VARCHAR2(1)		SLRPASG	SLRPASG_AR_IND
PHONE_END_DATE		Last day of the current phone assignment.	DATE		SLRPASG	SLRPASG_END_DATE
PHONE_EXTENSION	Phone Extension	Extension of the phone number associated with the phone assignment.	VARCHAR2(10)		SLRPASG	SLRPASG_PHONE_EXT
PHONE_NUMBER	Phone Number	Phone number associated with the current phone assignment.	VARCHAR2(12)		SLRPASG	SLRPASG_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Phone Number Combined	Combination of the area code, phone number, and extension.	VARCHAR2(28)		CALCULATION	SLRPASG_PHONE_AREA||SLRPASG_PHONE_NUMBER||SLRPASG_PHONE_EXT
PHONE_RATE		Phone rate code associated with the current phone assignment.	VARCHAR2(4)		SLRPASG	SLRPASG_PRCD_CODE
PHONE_RATE_DESC		Phone rate code description.	VARCHAR2(30)		STVPRCD	STVPRCD_DESC
PHONE_RATE_STATUS		Phone plan status code of the meal assignment.	VARCHAR2(2)		SLRPASG	SLRPASG_PSCD_CODE
PHONE_RATE_STATUS_DATE		Date the phone plan status code was last updated.	DATE		SLRPASG	SLRPASG_PSCD_DATE
PHONE_RATE_STATUS_DESC		Phone rate status code description.	VARCHAR2(30)		STVPSCD	STVPSCD_DESC
PHONE_TOTAL_DAYS		Total number of days of the current phone assignment.	NUMBER(9, 5)		SLRPASG	SLRPASG_TOTAL_DAYS
PHONE_TOTAL_MONTHS		Total number of months of the current phone assignment.	NUMBER(7, 5)		SLRPASG	SLRPASG_TOTAL_MONTHS
PHONE_TOTAL_PERIODS		Total number of terms of the current phone assignment.	NUMBER(7, 5)		SLRPASG	SLRPASG_TOTAL_TERMS
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: