COMMCTXMEVWLNG

(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 A.ADMIN_FUNCTION , B.INSTITUTION , B.COMM_CONTEXT , B.EFFDT , B.COMM_METHOD , B.COMM_DIRECTION , B.SCC_LETTER_CD , C.LANGUAGE_CD , C.DESCR FROM PS_SCC_STN_LTR_TBL A ,PS_SCC_STNDLTR_LAN C , PS_COMM_CTX_ME_TBL B WHERE A.SCC_LETTER_CD = B.SCC_LETTER_CD AND A.SCC_LETTER_CD=C.SCC_LETTER_CD

  • Related Language Record for COMM_CTX_ME_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: COMM_CTXT_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 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
    6 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
    IN=Incoming Communication
    OUT=Outgoing Communication
    PERS=In Person
    7 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description