PTSF_STAT_ARCH

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).
2 PTSF_SRCH_ENG_INS Character(30) VARCHAR2(30) NOT NULL Search Instance Name
3 PTSF_FEED_AE_STAT Character(2) VARCHAR2(2) NOT NULL AE Status
10=Initializing
20=Deleting old data
30=Pre processing
40=Generating index data
50=Post processing
60=SES crawling data
90=Schedule success

Default Value: 10

4 PTSF_QRY_FROM_DTTM DateTime(26) TIMESTAMP Datetime prompt value
5 PTSF_NEXTEXEC_DTTM DateTime(26) TIMESTAMP Next exceute datetime
6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 PTSF_FEED_RQS_DTTM DateTime(26) TIMESTAMP Feed requested datetime
8 PTSF_FEEDGEN_STAT Character(1) VARCHAR2(1) NOT NULL Feed generation status
D=Done
E=Errored
G=Generating
N=Not Started
S=Started

Default Value: S

9 PTSF_GENEATED_SEG Number(5,0) INTEGER NOT NULL Generated segment count
10 PTSF_CRAWLED_SEG Number(5,0) INTEGER NOT NULL Segments returned to crawler
11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
12 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
14 PTSF_RECRAWL_MODE Character(1) VARCHAR2(1) NOT NULL Indexing type
N=Incremental Index
P=Data Partition
Y=Full index
15 PTSF_LANGUAGE Character(3) VARCHAR2(3) NOT NULL All Languages
ALL=All Languages
BAS=Base Language
16 PTSF_RESUME_SCHED Character(1) VARCHAR2(1) NOT NULL Resume schedule
C=Restart SES crawl
R=Resume at failure
S=Rebuild index

Default Value: R

17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.