RC_CASE_FAQ_VW

(SQL View)
 Index Back

FAQ Solution View

FAQ Solution View for Call Center application.

SELECT A.SETID , A.SOLUTION_ID , B.LIBRARY_ID , A.RC_SUMMARY , A.SOLUTION_DESCR , A.ROW_LASTMANT_DTTM FROM PS_RC_SOLUTION A , PS_RC_SOLN_LIBRARI B WHERE A.EXPIRY_IND <> 'Y' AND A.SOLN_STATUS = 'ACTV' AND (A.EXPIRY_DATE > %CurrentDateIn OR A.EXPIRY_DATE IS NULL) AND A.RC_SOLUTION_TYPE NOT IN ('CAND', 'ADHC') AND A.SETID = B.SETID AND A.SOLUTION_ID = B.SOLUTION_ID AND B.INTERNAL_FAQ = 'Y'

  • Related Language Record: RC_CASEFAQVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

    Prompt Table: RC_SOLUTION

    3 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID
    4 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
    5 SOLUTION_DESCR Long Character CLOB Solution Description
    6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.