RC_SS_FCATG_VW (SQL View)	Index Back
SS Search Facet - Category Category facets available for SS search

RC_SS_FCATG_VW

(SQL View)

SS Search Facet - Category

Category facets available for SS search

SELECT DISP_TMPL_FAM_CD , RC_TYPE_OF_FACETS , SEQNO , RC_CONTENT_TYPE_CD , SETID_CATEGORY , RC_CATEGORY , SETID_SOLN_LIB , LIBRARY_ID , SETID_PROD_grp , PRODUCT_GROUP , %subrec(RB_AUDIT_SBR, PS_RC_SS_FACET) FROM PS_RC_SS_FACET WHERE RC_TYPE_OF_FACETS = 'G'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RC_TYPE_OF_FACETS Character(1) VARCHAR2(1) NOT NULL Facet types
C=Content Type
G=Category
P=Product Group
T=Topic
Default Value: G

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 1

4 RC_CONTENT_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Content Type
F=Frequently Asked Questions
I=Known Issues
S=Solutions

5 SETID_CATEGORY Character(5) VARCHAR2(5) NOT NULL Field used to hold the Setid of a Category field for use in reports.
Prompt Table: SP_SETID_NONVW

6 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
Prompt Table: RC_SS_CATG_VW
Set Control Field: SETID_CATEGORY

7 SETID_SOLN_LIB Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

8 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID
Prompt Table: RC_SS_TOPIC_VW
Set Control Field: SETID_SOLN_LIB

9 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group setid field
Prompt Table: SP_SETID_NONVW

10 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
Prompt Table: RC_PRDGRP_VW1
Set Control Field: SETID_PROD_GRP

11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
2	RC_TYPE_OF_FACETS	Character(1)	VARCHAR2(1) NOT NULL	Facet types C=Content Type G=Category P=Product Group T=Topic Default Value: G
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 1
4	RC_CONTENT_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Content Type F=Frequently Asked Questions I=Known Issues S=Solutions
5	SETID_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Field used to hold the Setid of a Category field for use in reports. Prompt Table: SP_SETID_NONVW
6	RC_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	CallCenter Category. Used in HD. Prompt Table: RC_SS_CATG_VW Set Control Field: SETID_CATEGORY
7	SETID_SOLN_LIB	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
8	LIBRARY_ID	Character(5)	VARCHAR2(5) NOT NULL	Solution Library ID or Troubleshooting Guide ID Prompt Table: RC_SS_TOPIC_VW Set Control Field: SETID_SOLN_LIB
9	SETID_PROD_GRP	Character(5)	VARCHAR2(5) NOT NULL	Product Group setid field Prompt Table: SP_SETID_NONVW
10	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group Prompt Table: RC_PRDGRP_VW1 Set Control Field: SETID_PROD_GRP
11	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
12	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
13	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
14	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
15	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
16	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time