ISIR_PHONENO_VW

(SQL View)
 Index Back

Phone Numbers

Use PERSONAL_PHONE to record Phone Numbers for people. A person may have as many different Phone Numbers as there are types.

SELECT A.EMPLID , C.PHONE_TYPE , A.PHONE FROM PS_PERSONAL_PHONE A , PS_PHONE_ORDER_TBL C , PS_FA_PRCSDEMO_TBL D WHERE A.PHONE_TYPE = C.PHONE_TYPE AND C.ADDR_USAGE = D.ISIR_PHONE_USAGE AND D.FA_PROCESS_NAME = 'I' AND C.ADDR_USAGE_ORDER = ( SELECT MIN(C1.ADDR_USAGE_ORDER) FROM PS_PHONE_ORDER_TBL C1 WHERE C1.ADDR_USAGE = D.ISIR_PHONE_USAGE AND C1.PHONE_TYPE IN ( SELECT A1.PHONE_TYPE FROM PS_PERSONAL_PHONE A1 WHERE A1.EMPLID = A.EMPLID ))

  • Parent record: PERSONAL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    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