RC_SSTMPL_SETID (SQL View)	Index Back
Self Service Search view Self Service Set up Home page serach view for SETID look up. The view retuen SETID for the display template family.

RC_SSTMPL_SETID

(SQL View)

Self Service Search view

Self Service Set up Home page serach view for SETID look up. The view retuen SETID for the display template family.

SELECT DISTINCT (C.SETID) , A.DISP_TMPL_FAM_CD , D.DESCR , A.DISP_TMPL_ID ,A.BUSINESS_UNIT FROM PS_BUS_UNIT_RC_RDT A , PS_RC_SOLUTION B , PS_SET_CNTRL_REC C , ps_setid_tbl D WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RC_SOLUTION' AND B.SETID = C.SETID AND D.SETID=C.SETID

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

2 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

#	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.
2	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DISP_TMPL_ID	Character(30)	VARCHAR2(30) NOT NULL	Template identifier to define the display template.
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit