Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner Operational Data Store
Composite View Target: AS_PHONE_ASSIGNMENT

Description Source composite view contains all telephone assignment information.

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: