TS130_CNTRL_COM

(SQL Table)
Index Back

TS130 Control - Communications

Define PERS records fro TS130.

  • Parent record: TS130_CONTROL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    4 COMM_TYPE Character(2) VARCHAR2(2) NOT NULL TS130 Communication Number Qualifier
    AP=Alternate Telephone
    AS=Answering Service
    BN=Beeper Number
    CP=Cellular Phone
    EM=Electronic Mail
    EX=Telephone Extension
    FX=Fax
    HF=Home Fax Number
    HP=Home Phone Number
    NP=Night Telephone
    OF=Other Residential Fax
    OT=Other Residential Phone
    PA=Appointment Phone
    PC=Personal cellular
    PP=Personal Phone
    TE=Telephone
    TL=Telex
    TM=Telemail
    TN=Teletex Number
    VM=Voice Mail
    WC=Work Cellular
    WF=Work Fax Number
    WP=Work Phone Number
    5 EDI_COMM Character(80) VARCHAR2(80) NOT NULL Communication Number