RC_SSCASE_SB_VW

(SQL View)
 Index Back

ss case create save

ss case creation save button view used by ss create case to show or hide the save button on a page - USED AND DEFINED ONLY FOR USE ON RC_CASE_SS toolbar light creation SAVE BUTTON

SELECT A.DISP_TMPL_ID , A.PNLGRPNAME , A.PNLNAME , A.PAGE_SECTION_ID , A.VISIBLE_FLG , B.FIELD_REF_ID FROM PS_RDT_FIELD_REF B LEFT OUTER JOIN ps_rdt_tmpl_field A ON A.pnlgrpname = 'RC_CASE_SS' AND A.PNLNAME LIKE 'RC_CASE_SS_RPT%' AND A.FIELD_REF_ID = B.FIELD_REF_ID WHERE B.RECNAME = 'FUNCLIB_SS_CASE' AND B.FIELDNAME = 'SS_SHOW_SAVE_BTN' AND B.GRID_NAME = 'RC_CASE_ATTACH'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
4 PAGE_SECTION_ID Character(15) VARCHAR2(15) NOT NULL Section Identifier defined for the section (various types of group boxes or grouping of fields) in the configurable component.
5 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Visible Flag
N=No
Y=Yes
6 FIELD_REF_ID Number(31,0) DECIMAL(31) NOT NULL Field reference id for the fields which are part of the display template.