Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(6)	SLRPASG	SLRPASG_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SLRPASG	SLRPASG_PIDM	NO	NO
PHONE_ACCOUNT_NUMBER	Phone account number associated with the current phone assignment.	VARCHAR2(20)	SLRPASG	SLRPASG_PHONE_ACCOUNT_NUMBER	NO	NO
PHONE_APPLICATION_DATE_ADDED	Date the application was added to the system.	DATE	SLBRMAP	SLBRMAP_ADD_DATE	NO	NO
PHONE_APPLICATION_FROM_PERIOD	Beginning term of the application.	VARCHAR2(6)	SLBRMAP	SLBRMAP_FROM_TERM	NO	NO
PHONE_APPLICATION_STATUS	Phone application status code associated with the applicant.	VARCHAR2(2)	SLBRMAP	SLBRMAP_HAPS_CODE	NO	NO
PHONE_APPLICATION_STATUS_DATE	Date when the phone application status code was last changed.	DATE	SLBRMAP	SLBRMAP_HAPS_DATE	NO	NO
PHONE_APPLICATION_STATUS_DESC	Phone application status code description.	VARCHAR2(30)	STVHAPS	STVHAPS_DESC	NO	NO
PHONE_APPLICATION_TO_PERIOD	End term of the application.	VARCHAR2(6)	SLBRMAP	SLBRMAP_TO_TERM	NO	NO
PHONE_APPLICATION_TYPE	Type of phone application.	VARCHAR2(4)	SLBRMAP	SLBRMAP_ARTP_CODE	NO	NO
PHONE_APPLICATION_TYPE_DESC	Phone application request type code description.	VARCHAR2(30)	STVARTP	STVARTP_DESC	NO	NO
PHONE_AREA	Area code of the phone number associated with the phone assignment.	VARCHAR2(6)	SLRPASG	SLRPASG_PHONE_AREA	NO	NO
PHONE_ASSESSMENT_IND	Indicates whether fee assessment is needed for the phone assignment.	VARCHAR2(1)	SLRPASG	SLRPASG_ASSESS_NEEDED	NO	NO
PHONE_BEGIN_DATE	First day of the current phone assignment.	DATE	SLRPASG	SLRPASG_BEGIN_DATE	NO	NO
PHONE_CHARGES_IND	Indicates whether the current phone assignment charges have been processed.	VARCHAR2(1)	SLRPASG	SLRPASG_AR_IND	NO	NO
PHONE_END_DATE	Last day of the current phone assignment.	DATE	SLRPASG	SLRPASG_END_DATE	NO	NO
PHONE_EXTENSION	Extension of the phone number associated with the phone assignment.	VARCHAR2(10)	SLRPASG	SLRPASG_PHONE_EXT	NO	NO
PHONE_NUMBER	Phone number associated with the current phone assignment.	VARCHAR2(12)	SLRPASG	SLRPASG_PHONE_NUMBER	NO	NO
PHONE_NUMBER_COMBINED	Combination of the area code, phone number, and extension.	VARCHAR2(28)	CALCULATION	SLRPASG_PHONE_AREA||SLRPASG_PHONE_NUMBER||SLRPASG_PHONE_EXT	NO	NO
PHONE_RATE	Phone rate code associated with the current phone assignment.	VARCHAR2(4)	SLRPASG	SLRPASG_PRCD_CODE	NO	NO
PHONE_RATE_DESC	Phone rate code description.	VARCHAR2(30)	STVPRCD	STVPRCD_DESC	NO	NO
PHONE_RATE_STATUS	Phone plan status code of the meal assignment.	VARCHAR2(2)	SLRPASG	SLRPASG_PSCD_CODE	NO	NO
PHONE_RATE_STATUS_DATE	Date the phone plan status code was last updated.	DATE	SLRPASG	SLRPASG_PSCD_DATE	NO	NO
PHONE_RATE_STATUS_DESC	Phone rate status code description.	VARCHAR2(30)	STVPSCD	STVPSCD_DESC	NO	NO
PHONE_TOTAL_DAYS	Total number of days of the current phone assignment.	NUMBER	SLRPASG	SLRPASG_TOTAL_DAYS	NO	NO
PHONE_TOTAL_MONTHS	Total number of months of the current phone assignment.	NUMBER	SLRPASG	SLRPASG_TOTAL_MONTHS	NO	NO
PHONE_TOTAL_PERIODS	Total number of terms of the current phone assignment.	NUMBER	SLRPASG	SLRPASG_TOTAL_TERMS	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(0)	NA	NA	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: