SCC_STG_EMG_PHN

(SQL Table)
Index Back

Emergency Contact Phone Number

Use EMERGENCY_PHONE to record any number of phone numbers for an emergency contact. The field 'phone_type' identifies the type of phone number entered.

  • Parent record: SCC_STG_EMG_CNT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
    2 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    3 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
    4 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    5 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    6 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
    7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time