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

SGHE Banner Operational Data Store
Composite View Target: AS_TELEPHONE

Description Source composite view contains all telephone data for the person or entity. Includes both active and inactive telephone details.

Target Column Business Definition Database Data Type Source Name Source Column
COUNTRY_CODE Country code associated with the persons address. VARCHAR2(4)

SPRTELE

SPRTELE_CTRY_CODE_PHONE

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

SPRTELE

SPRTELE_PIDM

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

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

PHONE_ADDRESS_SEQ_NO Address type sequence number associated with address type. NUMBER

SPRTELE

SPRTELE_ADDR_SEQNO

PHONE_ADDRESS_TYPE Optional address type code associated with telephone number. VARCHAR2(2)

SPRTELE

SPRTELE_ATYP_CODE

PHONE_ADDRESS_TYPE_DESC Optional address type code description associated with telephone number. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

PHONE_AREA Phone area. VARCHAR2(6)

SPRTELE

SPRTELE_PHONE_AREA

PHONE_COMMENT Free form comments related to this phone number. VARCHAR2(60)

SPRTELE

SPRTELE_COMMENT

PHONE_DESC Telephone number type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

PHONE_EXT Phone extension. VARCHAR2(10)

SPRTELE

SPRTELE_PHONE_EXT

PHONE_INTL_ACCESS Free form number to store the international number associated with the person's address. VARCHAR2(16)

SPRTELE

SPRTELE_INTL_ACCESS

PHONE_NUMBER Phone number. VARCHAR2(12)

SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_NUMBER_COMBINED Combined values of the international access, area code, phone number and phone extensions. VARCHAR2(44)

CALCULATION

SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT

PHONE_PRIMARY_IND Primary indicator to denote primary telephone numbers based on telephone types. VARCHAR2(1)

SPRTELE

SPRTELE_PRIMARY_IND

PHONE_SEQ_NUMBER Sequence number associated with this specific phone type for this person. NUMBER

SPRTELE

SPRTELE_SEQNO

PHONE_STATUS_IND Status that indicates active or inactive for the telephone. VARCHAR2(1)

SPRTELE

SPRTELE_STATUS_IND

PHONE_TYPE Type of telephone information such as home phone, emergency contact. VARCHAR2(4)

SPRTELE

SPRTELE_TELE_CODE

PHONE_UNLIST_IND Specifies if the phone number is to be unlisted. VARCHAR2(1)

SPRTELE

SPRTELE_UNLIST_IND

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: