Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PHONE_ASSIGNMENT

Description Contains details when a telephone assignment is made by assigning a phone rate to a person.
Key & Frequency One row per person per academic period per phone rate.
Recommended Search Columns PERSON_UID, ACADEMIC_YEAR, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
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. VARCHAR2(255)

STVTERM

STVTERM_DESC

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. VARCHAR2(255)

STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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 Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SLRPASG

SLRPASG_PIDM

PHONE_ACCOUNT_NUMBER Phone account number associated with the current phone assignment. VARCHAR2(63)

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(63)

SLBRMAP

SLBRMAP_FROM_TERM

PHONE_APPLICATION_STATUS Phone application status code associated with the applicant. VARCHAR2(63)

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(255)

STVHAPS

STVHAPS_DESC

PHONE_APPLICATION_TO_PERIOD End term of the application. VARCHAR2(63)

SLBRMAP

SLBRMAP_TO_TERM

PHONE_APPLICATION_TYPE Type of phone application. VARCHAR2(63)

SLBRMAP

SLBRMAP_ARTP_CODE

PHONE_APPLICATION_TYPE_DESC Phone application request type code description. VARCHAR2(255)

STVARTP

STVARTP_DESC

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 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_EXT Extension of the phone number associated with the phone assignment. VARCHAR2(63)

SLRPASG

SLRPASG_PHONE_EXT

PHONE_NUMBER Phone number associated with the current phone assignment. VARCHAR2(63)

SLRPASG

SLRPASG_PHONE_NUMBER

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 code associated with the current phone assignment. VARCHAR2(63)

SLRPASG

SLRPASG_PRCD_CODE

PHONE_RATE_DESC Phone rate code description. VARCHAR2(255)

STVPRCD

STVPRCD_DESC

PHONE_RATE_STATUS Phone plan status code of the meal assignment. VARCHAR2(63)

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(255)

STVPSCD

STVPSCD_DESC

PHONE_TOTAL_DAYS Total number of days of the current phone assignment. NUMBER

SLRPASG

SLRPASG_TOTAL_DAYS

PHONE_TOTAL_MONTHS Total number of months of the current phone assignment. NUMBER

SLRPASG

SLRPASG_TOTAL_MONTHS

PHONE_TOTAL_PERIODS Total number of terms of the current phone assignment. NUMBER

SLRPASG

SLRPASG_TOTAL_TERMS

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 A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA



Ver: 8.5