PTSF_FCT_RNG_VW

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