COMMUNICATION

(SQL Table)
 Index Back

Communication Data

COMMUNICATION is used to record all incoming/outgoing/in person contact that an institution has with an individual.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number

    Default Value: 99999

    3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    4 COMM_DTTM DateTime(26) TIMESTAMP NOT NULL Communication DateTime

    Default Value: %datetime

    5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    6 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: %EDITTABLE15

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

    Prompt Table: COMM_CATG_VW

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

    Prompt Table: COMM_CA_CTX_VW

    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 INCLUDE_ENCL Character(1) VARCHAR2(1) NOT NULL Include Enclosures

    Y/N Table Edit

    Default Value: N

    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Default Value: OPR_DEF_TBL_CS.DEPTID

    Prompt Table: SCC_DEPT_TBL_VW
    Set Control Field: INSTITUTION

    12 COMM_ID Character(11) VARCHAR2(11) NOT NULL Person responsible for the communication

    Prompt Table: PEOPLE_SRCH

    13 COMM_DT Date(10) DATE Communication Date

    Default Value: %date

    14 COMM_BEGIN_TM Time(15) TIMESTAMP Communication Begin Time
    15 COMM_END_TM Time(15) TIMESTAMP Communication End Time
    16 COMPLETED_COMM Character(1) VARCHAR2(1) NOT NULL Communication Completed

    Y/N Table Edit

    Default Value: N

    17 COMPLETED_ID Character(11) VARCHAR2(11) NOT NULL Completed ID

    Prompt Table: PEOPLE_SRCH

    18 COMPLETED_DT Date(10) DATE Date Activity Completed
    19 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

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

    Y/N Table Edit

    Default Value: N

    21 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
    22 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

    Prompt Table: COMM_CTX_ME_VW

    23 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    24 LETTER_PRINTED_TM Time(15) TIMESTAMP Time Letter Printed
    25 CHECKLIST_SEQ_3C Number(5,0) INTEGER NOT NULL Checklist Seq Number
    26 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence
    27 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications

    Y/N Table Edit

    Default Value: N

    28 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr

    Prompt Table: ORG_CONTACT3_VW

    29 ORG_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr

    Prompt Table: ORG_DEPT_VW

    30 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr

    Prompt Table: ORG_LOCATIONVW2

    31 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    32 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    33 VAR_DATA_SEQ Number(4,0) SMALLINT NOT NULL Variable Data Sequence Number
    34 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments
    35 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID
    36 JOINT_COMM Character(1) VARCHAR2(1) NOT NULL Create Joint Communications

    Y/N Table Edit

    Default Value: N

    37 SCC_COMM_LANG Character(3) VARCHAR2(3) NOT NULL Language Used
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    38 SCC_COMM_MTHD Character(1) VARCHAR2(1) NOT NULL Method Used
    B=Publication
    D=Document
    E=E-Mail
    F=Fax
    L=Letter
    P=Personal Contact
    T=Telephone Call
    W=Web
    39 SCC_COMM_PROC Character(1) VARCHAR2(1) NOT NULL Process Used
    C=Communication Generation
    E=Envelope and Label Generation
    L=Letter Generation
    M=Manual Completion