PTSF_FCT_RNG_VW

 index back

Facet Ranges

Facet Ranges
SELECT PTSF_SRCCAT_NAME ,PTSF_FACET_NAME ,' ' ,PTSF_FCT_SEQ_NO ,PTSF_FCT_PNODE_ID ,PTSF_FCT_NLEVEL ,PTSF_MSG_SET_NBR ,PTSF_MSG_NBR , PTSF_FCT_BEG_OPR ,PTSF_BEGIN_FCT_VAL ,PTSF_FCT_END_OPR ,PTSF_END_FCT_VAL , PTSF_FCTEXP_TYPE ,PTSF_FCT_BDATE_VAL ,PTSF_FCT_EDATE_VAL ,PTSF_FCT_DBEG_NO ,PTSF_FCT_DEND_NO ,PTSF_FCT_DB_RANGE ,PTSF_FCT_DE_RANGE ,PTSF_FCT_SYS_DATE FROM PSPTSF_FACET_DT

PeopleSoft Field Name Field Type Column Type Description
PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).
PTSF_FACET_NAME Character(65) VARCHAR2(65) NOT NULL Facet Name
PTSF_FACET_NODE Character(65) VARCHAR2(65) NOT NULL Node Name
PTSF_FCT_SEQ_NO Number(3,0) SMALLINT NOT NULL Sequence No
PTSF_FCT_PNODE_ID Number(3,0) SMALLINT NOT NULL Parent Node ID
PTSF_FCT_NLEVEL Number(2,0) SMALLINT NOT NULL Node Level
PTSF_MSG_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
PTSF_MSG_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
PTSF_FCT_BEG_OPR Character(2) VARCHAR2(2) NOT NULL Begin Operator
GE=Greater Than Equals
GT=Greater Than
NA=Not Applicable
PTSF_BEGIN_FCT_VAL Signed Number(19,2) DECIMAL(17,2) NOT NULL Begin Facet Value
PTSF_FCT_END_OPR Character(2) VARCHAR2(2) NOT NULL End Operator
LE=Less Than Equals
LT=Less Than
NA=Not Applicable
PTSF_END_FCT_VAL Signed Number(19,2) DECIMAL(17,2) NOT NULL End Facet Value
PTSF_FCTEXP_TYPE Character(4) VARCHAR2(4) NOT NULL Range Type
F=Fixed Range
R=Relative Range
PTSF_FCT_BDATE_VAL Date(10) DATE Begin Date Value
PTSF_FCT_EDATE_VAL Date(10) DATE End Date Value
PTSF_FCT_DBEG_NO Number(5,0) INTEGER NOT NULL Begin Range Number
PTSF_FCT_DEND_NO Number(5,0) INTEGER NOT NULL End Range Number
PTSF_FCT_DB_RANGE Character(4) VARCHAR2(4) NOT NULL Begin Date Range
DBF=Days before
DFN=Days from now
MBF=Months before
MFN=Months from now
YBF=Years before
YFN=Years from now
PTSF_FCT_DE_RANGE Character(4) VARCHAR2(4) NOT NULL End Date Range
DBF=Days before
DFN=Days from now
MBF=Months before
MFN=Months from now
YBF=Years before
YFN=Years from now
PTSF_FCT_SYS_DATE Character(4) VARCHAR2(4) NOT NULL Node
BY=Before This Year
FD=Future Date
P100=Past 100 Days
P15D=Past 15 Days
P30D=Past 30 Days
P50D=Past 50 Days
P7D=Past 7 Days
TD=Today
TM=This Month
TW=This Week
TY=This Year
YD=Yesterday
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20