RC_SS_FACET

(SQL Table)
Index Back

SS Search Facets

Facets available for SS search

# 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
3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
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.
6 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
7 SETID_SOLN_LIB Character(5) VARCHAR2(5) NOT NULL SetID
8 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID
9 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group setid field
10 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
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