Skip to main content
Skip table of contents

PSSIS_Person_Phone_Type (ver12.0.1)

This view may be used for querying the student contact schema. It returns only the highest priority phone Numberby type among a person's associated phone numbers.

Column NameInitial VersionData TypeDescription

PersonDCID

12.0.1

Number(16,0)

[From Person] The person's internal DCID in the Person table. Indexed.

PersonID

12.0.1

Number(16,0)

[From Person] The person's internal ID in the Person table. Indexed.

PersonPhoneNumberAssocID

12.0.1

Number(16,0)

[From PersonPhoneNumberAssoc] The primary key for a person phone Numberassociation. Indexed.

PhoneTypeCodeSetID

12.0.1

Number(16,0)

[From CodeSet] The internal ID for the phone type code in the CodeSet table. Indexed.

PhoneType

12.0.1

Varchar2(40)

[From CodeSet] The phone type code.

PhoneTypeDesc

12.0.1

Varchar2(2000)

[From CodeSet] The phone type code description.

PhoneTypeDisp

12.0.1

Varchar2(100)

[From CodeSet] The phone type code display value.

PhoneNumberPriorityOrder

12.0.1

Number(10,0)

[From PersonPhoneNumberAssoc] The original priority (sort) order of the person's phone number.

FilteredPriorityOrder

12.0.1

Number(10,0)

The filtered priority (sort) order of the person's phone Numberfor the given constraints of the view. Guaranteed to start with 1 and be consecutive.

IsPreferred

12.0.1

Number(1,0)

[From PersonPhoneNumberAssoc] Indicates whether this is a preferred phone number.

PhoneNumberAsEntered

12.0.1

Varchar2(50)

[From PhoneNumber] The phone Numberas entered.

PhoneNumber

12.0.1

Varchar2(50)

[From PhoneNumber] The phone number.

PhoneNumberExt

12.0.1

Varchar2(10)

[From PhoneNumber] The phone Numberextension (if specified).

IsSMS

12.0.1

Number(1,0)

[From PhoneNumber] Indicates whether this phone is capable of receiving SMS messages.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.