HR_OWS_PHONE_VW

(SQL View)
Index Back

Person OWS Phone Numbers

Oracle Workforce Scheduling Person Phone Numbers

SELECT A.EMPLID , A.PHONE_TYPE , A.PHONE , A.EXTENSION , A.PREF_PHONE_FLAG FROM PS_PERSONAL_PHONE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
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
4 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
5 PREF_PHONE_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred
N=No
Y=Yes

Y/N Table Edit

Default Value: N