RC_SS_FLTPC_VW

(SQL View)
 Index Back

SS Fluid Pref - Topic

Topics facets available for SS Fluid Preferences

SELECT DISP_TMPL_FAM_CD , RC_TYPE_OF_FACETS , SEQNO , SEQNUM , 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_FL) FROM PS_RC_SS_FACET_FL WHERE RC_TYPE_OF_FACETS = 'T'

# 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: T

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 1

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 0

5 RC_CONTENT_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Content Type
F=Frequently Asked Questions
I=Known Issues
S=Solutions
6 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

7 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

Prompt Table: RC_CATEGORY_VW
Set Control Field: SETID_CATEGORY

8 SETID_SOLN_LIB Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

9 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

10 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group setid field

Prompt Table: SP_SETID_NONVW

11 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

Prompt Table: RC_PRDGRP_VW1
Set Control Field: SETID_PROD_GRP

12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
16 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.
17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time