| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTSF_SRCCAT_NAME |
Character(65) |
VARCHAR2(65) NOT NULL |
Search Category Name (see PSPTSF_SRCCAT).
|
| 2 |
PTSF_FACET_NAME |
Character(65) |
VARCHAR2(65) NOT NULL |
Facet Name
|
| 3 |
PTSF_FCT_SEQ_NO |
Number(3,0) |
SMALLINT NOT NULL |
Sequence No
|
| 4 |
PTSF_FCT_PNODE_ID |
Number(3,0) |
SMALLINT NOT NULL |
Parent Node ID
|
| 5 |
PTSF_FCT_NLEVEL |
Number(2,0) |
SMALLINT NOT NULL |
Node Level
|
| 6 |
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.
|
| 7 |
PTSF_MSG_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 8 |
PTSF_FCT_BEG_OPR |
Character(2) |
VARCHAR2(2) NOT NULL |
Begin Operator
GE=Greater Than Equals
GT=Greater Than
NA=Not Applicable
|
| 9 |
PTSF_BEGIN_FCT_VAL |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Begin Facet Value
|
| 10 |
PTSF_FCT_END_OPR |
Character(2) |
VARCHAR2(2) NOT NULL |
End Operator
LE=Less Than Equals
LT=Less Than
NA=Not Applicable
|
| 11 |
PTSF_END_FCT_VAL |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
End Facet Value
|
| 12 |
PTSF_FCTEXP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Range Type
F=Fixed Range
R=Relative Range
|
| 13 |
PTSF_FCT_BDATE_VAL |
Date(10) |
DATE |
Begin Date Value
|
| 14 |
PTSF_FCT_EDATE_VAL |
Date(10) |
DATE |
End Date Value
|
| 15 |
PTSF_FCT_DBEG_NO |
Number(5,0) |
INTEGER NOT NULL |
Begin Range Number
|
| 16 |
PTSF_FCT_DEND_NO |
Number(5,0) |
INTEGER NOT NULL |
End Range Number
|
| 17 |
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
|
| 18 |
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
|
| 19 |
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
|