GVT_PHONE_TEMP

(SQL Table)
Index Back

Temp table for GVT_PERS_PHONE.

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

    Prompt Table: GVT_PERSONAL_VW

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    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

    Default Value: HOME

    6 PREF_PHONE_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred

    Y/N Table Edit

    Default Value: N

    7 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    9 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension