PSPTSF_FACET_DT

index back

Facet Ranges

Facet Ranges

PeopleSoft Field NameField TypeColumn TypeDescription
PTSF_SRCCAT_NAMECharacter(65)VARCHAR2(65) NOT NULLSearch Category Name (see PSPTSF_SRCCAT).
PTSF_FACET_NAMECharacter(65)VARCHAR2(65) NOT NULLFacet Name
PTSF_FCT_SEQ_NONumber(3,0)SMALLINT NOT NULLSequence No
PTSF_FCT_PNODE_IDNumber(3,0)SMALLINT NOT NULLParent Node ID
PTSF_FCT_NLEVELNumber(2,0)SMALLINT NOT NULLNode Level
PTSF_MSG_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
PTSF_MSG_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
PTSF_FCT_BEG_OPRCharacter(2)VARCHAR2(2) NOT NULLBegin Operator
GE=Greater Than Equals
GT=Greater Than
NA=Not Applicable
PTSF_BEGIN_FCT_VALSigned Number(19,2)DECIMAL(17,2) NOT NULLBegin Facet Value
PTSF_FCT_END_OPRCharacter(2)VARCHAR2(2) NOT NULLEnd Operator
LE=Less Than Equals
LT=Less Than
NA=Not Applicable
PTSF_END_FCT_VALSigned Number(19,2)DECIMAL(17,2) NOT NULLEnd Facet Value
PTSF_FCTEXP_TYPECharacter(4)VARCHAR2(4) NOT NULLRange Type
F=Fixed Range
R=Relative Range
PTSF_FCT_BDATE_VALDate(10)DATEBegin Date Value
PTSF_FCT_EDATE_VALDate(10)DATEEnd Date Value
PTSF_FCT_DBEG_NONumber(5,0)INTEGER NOT NULLBegin Range Number
PTSF_FCT_DEND_NONumber(5,0)INTEGER NOT NULLEnd Range Number
PTSF_FCT_DB_RANGECharacter(4)VARCHAR2(4) NOT NULLBegin 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_RANGECharacter(4)VARCHAR2(4) NOT NULLEnd 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_DATECharacter(4)VARCHAR2(4) NOT NULLNode
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 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19