RC_PROBTYPE_SS

(SQL View)
 Index Back

Self-Service Problem Types

this view only shows the valid problem types for a self-service user to choose from.

SELECT SETID , PRODUCT_ID , PROBLEM_TYPE , RC_SS_IND , RC_DESCR_SS FROM PS_RC_PROBTYPE_TBL WHERE RC_SS_IND = 'Y'

  • Related Language Record: RC_PT_SS_LNG

  • Parent record: PROD_ITEM

    • # 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.

    Default Value: PROD_ITEM.SETID

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Default Value: PROD_ITEM.PRODUCT_ID

    3 PROBLEM_TYPE Character(8) VARCHAR2(8) NOT NULL Problem Type for Support Cases
    4 RC_SS_IND Character(1) VARCHAR2(1) NOT NULL Defines if this is a self service transaction or not.

    Y/N Table Edit

    Default Value: Y

    5 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages