Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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(63)	SLRPASG STVTERM	SLRPASG_TERM_CODE STVTERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	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	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SLRPASG	SLRPASG_PIDM
PHONE_ACCOUNT_NUMBER	Phone Account Number	Phone account number associated with the current phone assignment.	VARCHAR2(63)	SLRPASG	SLRPASG_PHONE_ACCOUNT_NUMBER
PHONE_APPLICATION_DATE_ADDED	Phone Application Date Added	Date the application was added to the system.	DATE	SLBRMAP	SLBRMAP_ADD_DATE
PHONE_APPLICATION_FROM_PERIOD	Phone Application From Period	Beginning term of the application.	VARCHAR2(63)	SLBRMAP	SLBRMAP_FROM_TERM
PHONE_APPLICATION_STATUS	Phone Application Status	Phone application status code associated with the applicant.	VARCHAR2(63)	SLBRMAP	SLBRMAP_HAPS_CODE
PHONE_APPLICATION_STATUS_DATE	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 Description	Phone application status code description.	VARCHAR2(255)	STVHAPS	STVHAPS_DESC
PHONE_APPLICATION_TO_PERIOD	Phone Application To Period	End term of the application.	VARCHAR2(63)	SLBRMAP	SLBRMAP_TO_TERM
PHONE_APPLICATION_TYPE	Phone Application Type	Type of phone application.	VARCHAR2(63)	SLBRMAP	SLBRMAP_ARTP_CODE
PHONE_APPLICATION_TYPE_DESC	Phone Application Type Description	Phone application request type code description.	VARCHAR2(255)	STVARTP	STVARTP_DESC
PHONE_AREA	Phone Area	Area code of the phone number associated with the phone assignment.	VARCHAR2(63)	SLRPASG SPRTELE	SLRPASG_PHONE_AREA SPRTELE_PHONE_AREA
PHONE_ASSESSMENT_IND	Phone Assessment Indicator	Indicates whether fee assessment is needed for the phone assignment.	VARCHAR2(1)	SLRPASG	SLRPASG_ASSESS_NEEDED
PHONE_BEGIN_DATE	Phone Begin Date	First day of the current phone assignment.	DATE	SLRPASG	SLRPASG_BEGIN_DATE
PHONE_CHARGES_IND	Phone Charges Indicator	Indicates whether the current phone assignment charges have been processed.	VARCHAR2(1)	SLRPASG	SLRPASG_AR_IND
PHONE_END_DATE	Phone End Date	Last day of the current phone assignment.	DATE	SLRPASG	SLRPASG_END_DATE
PHONE_EXT	Phone Extension	Extension of the phone number associated with the phone assignment.	VARCHAR2(63)	SLRPASG	SLRPASG_PHONE_EXT
PHONE_NUMBER	Phone Number	Phone number associated with the current phone assignment.	VARCHAR2(63)	SLRPASG	SLRPASG_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Phone Number Combined	Combination of the area code, phone number, and extension.	VARCHAR2(63)	CALCULATION	SLRPASG_PHONE_AREA||SLRPASG_PHONE_NUMBER||SLRPASG_PHONE_EXT
PHONE_RATE	Phone Rate	Phone rate code associated with the current phone assignment.	VARCHAR2(63)	SLRPASG	SLRPASG_PRCD_CODE
PHONE_RATE_DESC	Phone Rate Description	Phone rate code description.	VARCHAR2(255)	STVPRCD	STVPRCD_DESC
PHONE_RATE_STATUS	Phone Rate Status	Phone plan status code of the meal assignment.	VARCHAR2(63)	SLRPASG	SLRPASG_PSCD_CODE
PHONE_RATE_STATUS_DATE	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 Description	Phone rate status code description.	VARCHAR2(255)	STVPSCD	STVPSCD_DESC
PHONE_TOTAL_DAYS	Phone Total Days	Total number of days of the current phone assignment.	NUMBER	SLRPASG	SLRPASG_TOTAL_DAYS
PHONE_TOTAL_MONTHS	Phone Total Months	Total number of months of the current phone assignment.	NUMBER	SLRPASG	SLRPASG_TOTAL_MONTHS
PHONE_TOTAL_PERIODS	Phone Total Periods	Total number of terms of the current phone assignment.	NUMBER	SLRPASG	SLRPASG_TOTAL_TERMS
PROCESS_GROUP	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	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA

Ver: 9.2