COMM_TMP2_MC

(SQL Table)
 Index Back

Communication Data MC

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

  • Parent record: PERSONAL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
    2 MC_STATUS Character(3) VARCHAR2(3) NOT NULL Mass Change Status
    APR=Approved Transaction
    CAN=Cancel Transaction
    ERR=Errored Transaction
    PND=Pending Transaction
    SCS=Successful Transaction
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    5 COMM_DTTM DateTime(26) TIMESTAMP NOT NULL Communication DateTime

    Default Value: %date

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: ADM_FUNCTN_TBL

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

    Prompt Table: COMM_CATG_VW

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

    Prompt Table: COMM_CA_CTX_VW

    10 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_TBL

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

    Default Value: OPR_DEF_TBL_CS.DEPTID

    Prompt Table: DEPT_TBL

    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

    Default Value: %date

    15 COMM_END_TM Time(15) TIMESTAMP Communication End Time

    Default Value: %date

    16 COMPLETED_COMM Character(1) VARCHAR2(1) NOT NULL Communication Completed
    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
    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: STANDRD_LTR_VW

    23 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    24 LETTER_PRINTED_TM Time(15) TIMESTAMP Time Letter Printed
    25 CHECKLIST_DTTM DateTime(26) TIMESTAMP Checklist Date Time
    26 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence

    Prompt Table: PERSON_CHK_ITEM

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

    Y/N Table Edit

    Default Value: N

    28 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    29 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    30 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    31 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    32 STRM Character(4) VARCHAR2(4) NOT NULL Term
    33 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    34 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
    35 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    36 GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Group ID
    37 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
    38 CHECKLIST_DTTM_VAR DateTime(26) TIMESTAMP Checklist Date Time
    39 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    40 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
    41 RESTRICTED_AID_ID Character(10) VARCHAR2(10) NOT NULL Restricted Aid ID
    42 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    43 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    44 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    45 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
    46 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr
    47 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    48 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
    49 EFFDT_VAR Date(10) DATE Effective Date
    50 EFFSEQ_VAR Number(1,0) SMALLINT NOT NULL Effective Date Sequence #
    51 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    52 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    53 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID
    54 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    55 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    56 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    57 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    58 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    59 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    60 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    61 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
    62 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
    63 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
    64 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
    65 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code
    66 AUD_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
    A=Administrative
    R=Reporting
    S=Segmentation
    67 MEMBERSHIP_NBR Character(12) VARCHAR2(12) NOT NULL Membership Number
    68 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code
    69 AV_STD_BEN Character(6) VARCHAR2(6) NOT NULL Standard Benefit
    70 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
    71 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments