RC_CHS_MKT_VW

(SQL View)
Index Back

Case History Market Prompt

Case History Market Prompt SVC002 - 6/28/2012 - ADDED RC_CASE_SS

SELECT MARKET , PNLGRPNAME FROM PSPNLGRPDEFN WHERE PNLGRPNAME IN ('RC_CASE_HD', 'RC_CASE_HD_SS', 'RC_CASE_HD_SS_RPT', 'RC_CASE_SW', 'RC_CASE_SW_SS', 'RC_CASE_SW_SS_RPT', 'RC_CASE_SS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: RC_CHS_EVENTSET.MARKET

2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name