RC_QUICK_CD_VW2

(SQL View)
 Index Back

Quick Code Prompt View

Used on search page of Quick Code definition page.

SELECT A.BUSINESS_UNIT , A.QUICK_CD , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DISP_TMPL_ID , A.RC_CATEGORY , A.RC_TYPE , A.RC_DETAIL , A.PROVIDER_GRP_ID , A.SOLUTION_ID , A.RC_QC_USAGECOUNT , A.RC_QC_LASTUSED , A.RC_SUMMARY , A.KEYWORDS , A.RC_DESCRLONG FROM PS_RC_QUICK_CD_TBL A

  • Related Language Record: RC_QUICKCD_LVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

    Prompt Table: SP_BU_RC_NONVW

    2 QUICK_CD Character(3) VARCHAR2(3) NOT NULL Quick Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.

    Prompt Table: RDT_TMPL_DEFN

    7 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

    Prompt Table: RC_CATEGORY_TBL
    Set Control Field: BUSINESS_UNIT

    8 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.

    Prompt Table: RC_TYP_TBL
    Set Control Field: BUSINESS_UNIT

    9 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.

    Prompt Table: RC_DET_TBL
    Set Control Field: BUSINESS_UNIT

    10 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

    Prompt Table: RF_PROVGRP_VW2

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

    Prompt Table: RC_SOLUTION_VW2

    12 RC_QC_USAGECOUNT Number(10,0) DECIMAL(10) NOT NULL Usage Count for Quick Code usage by Case (HRHD)
    13 RC_QC_LASTUSED Date(10) DATE Qucik Code Last Used Date
    14 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
    15 KEYWORDS Character(100) VARCHAR2(100) NOT NULL Query Keywords
    16 RC_DESCRLONG Long Character CLOB Long description used in CallCenter for Problem, Solution...