COMM_SPDKEY_TBL

(SQL Table)
 Index Back

Comm Speed Key Table

COMM_SPDKEY_TBL is used to create a combination of Communication Category, Context, Method, and Direction with one key. Communication Keys created in this table are used to generate communications in background processes either when associated with Checklist Items or when used in the Communication Generation process.

  • Related Language Record: CM_SPDKEYTBL_LN

    • # 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 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

    3 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: COMM_SPDKEY_TBL.DESCR

    6 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category

    Prompt Table: COMM_CATG_VW1

    7 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context

    Prompt Table: COMM_CA_CTX_VW

    8 COMM_DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
    9 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Communication Method
    B=Publication
    D=Document
    E=Email
    F=Fax
    L=Letter
    P=Personal Contact
    T=Telephone Call
    W=Web

    Prompt Table: COMM_CTX_ME_VW2

    10 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
    IN=Incoming Communication
    OUT=Outgoing Communication
    PERS=In Person

    Prompt Table: COMM_ME_DIR_VW

    11 UNSUCCESSFUL Character(1) VARCHAR2(1) NOT NULL Unsuccessful Outcome

    Y/N Table Edit

    Default Value: N

    12 OUTCOME_REASON Character(1) VARCHAR2(1) NOT NULL Outcome Reason
    C=Missing Critical Data
    E=Invalid Email Address
    M=Left Message on Machine
    N=No Answer
    O=No Org Recipients found
    P=Left Message with Person
    R=Returned Mail
    S=Email Send Error
    13 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

    Prompt Table: COMM_CTX_ME_VW

    14 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications

    Y/N Table Edit

    Default Value: N

    15 ACTIVITY_COMPLETED Character(1) VARCHAR2(1) NOT NULL Activity Completed

    Y/N Table Edit

    Default Value: N

    16 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments