COMM_ME_DIR_VW

(SQL View)
 Index Back

Communication Context Meth Vw

COMM_CTX_ME_VW is used to select the appropriate letter codes for a communication context, method and direction within the communication record.

SELECT DISTINCT A.INSTITUTION , A.COMM_CONTEXT , A.EFFDT , A.COMM_METHOD , A.COMM_DIRECTION , B.XLATLONGNAME FROM PS_COMM_CTX_ME_TBL A , PSXLATITEM B WHERE B.FIELDNAME = 'COMM_DIRECTION' AND B.FIELDVALUE = A.COMM_DIRECTION AND %EffdtCheck(PSXLATITEM,B,%CurrentDateIn) AND B.EFF_STATUS= 'A'

  • Related Language Record: CM_ME_DIR_VW_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 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context

    Prompt Table: COMM_CTXT_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 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
    5 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
    IN=Incoming Communication
    OUT=Outgoing Communication
    PERS=In Person
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description