RDM_CR_CONT_LVW

(SQL View)
 Index Back

Call Report for a Contact RL

Related Language record -- list of Call Reports for a given Contact. This view is made for mobile use.

SELECT A.PERSON_ID , A.CALL_REPORT_ID ,B.LANGUAGE_CD ,A.DESCR30 FROM PS_RDM_CR_CONT_VW A , PS_RD_CALL_REPORTL B WHERE A.CALL_REPORT_ID = B.CALL_REPORT_ID

  • Related Language Record for RDM_CR_CONT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description