SCC_OCNTC_PHNVW

(SQL View)
 Index Back

Org Contact Phone View

Organization Contact Phone View Union of record ORG_CNTCT_PHN and PERSONAL_PHONE since EMPLID based Org Contacts no longer require ORG_CNTCT_PHN records.

SELECT A.EXT_ORG_ID , A.ORG_CONTACT , A.EFFDT , A.EMPLID , B.PHONE_TYPE , B.PHONE FROM PS_ORG_CONTACT A , PS_ORG_CNTCT_PHN B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_CONTACT = B.ORG_CONTACT AND A.EFFDT = B.EFFDT AND A.EMPLID = ' ' UNION SELECT A.EXT_ORG_ID , A.ORG_CONTACT , A.EFFDT , A.EMPLID , B.PHONE_TYPE , B.PHONE FROM PS_ORG_CONTACT A , PS_HCR_PERSN_PHN_I B WHERE A.EMPLID = B.EMPLID AND A.EMPLID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
2 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 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
6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone