ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD	Academic period or time frame this telephone assignment is active.			SLRPASG STVTERM	SLRPASG_TERM_CODE STVTERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.			STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.			FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.			STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
ID	Person's or organization's current identification number.			SPRIDEN	SPRIDEN_ID
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.			SLRPASG	SLRPASG_PIDM
PHONE_ACCOUNT_NUMBER	Phone account number associated with the current phone assignment.			SLRPASG	SLRPASG_PHONE_ACCOUNT_NUMBER
PHONE_APPLICATION_DATE_ADDED	Date the application was added to the system.			SLBRMAP	SLBRMAP_ADD_DATE
PHONE_APPLICATION_FROM_PERIOD	Beginning term of the application.			SLBRMAP	SLBRMAP_FROM_TERM
PHONE_APPLICATION_STATUS	Phone application status code associated with the applicant.			SLBRMAP	SLBRMAP_HAPS_CODE
PHONE_APPLICATION_STATUS_DATE	Date when the phone application status code was last changed.			SLBRMAP	SLBRMAP_HAPS_DATE
PHONE_APPLICATION_STATUS_DESC	Phone application status code description.			STVHAPS	STVHAPS_DESC
PHONE_APPLICATION_TO_PERIOD	End term of the application.			SLBRMAP	SLBRMAP_TO_TERM
PHONE_APPLICATION_TYPE	Type of phone application.			SLBRMAP	SLBRMAP_ARTP_CODE
PHONE_APPLICATION_TYPE_DESC	Phone application request type code description.			STVARTP	STVARTP_DESC
PHONE_AREA	Area code of the phone number associated with the phone assignment.			SLRPASG SPRTELE	SLRPASG_PHONE_AREA SPRTELE_PHONE_AREA
PHONE_ASSESSMENT_IND	Indicates whether fee assessment is needed for the phone assignment.			SLRPASG	SLRPASG_ASSESS_NEEDED
PHONE_BEGIN_DATE	First day of the current phone assignment.			SLRPASG	SLRPASG_BEGIN_DATE
PHONE_CHARGES_IND	Indicates whether the current phone assignment charges have been processed.			SLRPASG	SLRPASG_AR_IND
PHONE_END_DATE	Last day of the current phone assignment.			SLRPASG	SLRPASG_END_DATE
PHONE_EXT	Extension of the phone number associated with the phone assignment.			SLRPASG	SLRPASG_PHONE_EXT
PHONE_NUMBER	Phone number associated with the current phone assignment.			SLRPASG	SLRPASG_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Combination of the area code, phone number, and extension.			CALCULATION	SLRPASG_PHONE_AREA||SLRPASG_PHONE_NUMBER||SLRPASG_PHONE_EXT
PHONE_RATE	Phone rate code associated with the current phone assignment.			SLRPASG	SLRPASG_PRCD_CODE
PHONE_RATE_DESC	Phone rate code description.			STVPRCD	STVPRCD_DESC
PHONE_RATE_STATUS	Phone plan status code of the meal assignment.			SLRPASG	SLRPASG_PSCD_CODE
PHONE_RATE_STATUS_DATE	Date the phone plan status code was last updated.			SLRPASG	SLRPASG_PSCD_DATE
PHONE_RATE_STATUS_DESC	Phone rate status code description.			STVPSCD	STVPSCD_DESC
PHONE_TOTAL_DAYS	Total number of days of the current phone assignment.			SLRPASG	SLRPASG_TOTAL_DAYS
PHONE_TOTAL_MONTHS	Total number of months of the current phone assignment.			SLRPASG	SLRPASG_TOTAL_MONTHS
PHONE_TOTAL_PERIODS	Total number of terms of the current phone assignment.			SLRPASG	SLRPASG_TOTAL_TERMS
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.			NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.			NA	NA

Ver: 8.3