TRN_BUSPHONE_VW (SQL View)	Index Back
Training Facility Bus. Phone This view displays the business telephone number at a Training Facility.

TRN_BUSPHONE_VW

(SQL View)

Training Facility Bus. Phone

This view displays the business telephone number at a Training Facility.

SELECT A.FACILITY, B.PHONE_TYPE, B.PHONE FROM PS_TRN_FACIL_TBL A, PS_TRN_FACIL_PHONE B WHERE A.FACILITY=B.FACILITY AND B.PHONE_TYPE='BUSN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

2 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work

3 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility
2	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
3	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone