PTSF_STAT_ARCH

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTSF_SBO_NAMECharacter(65)VARCHAR2(65) NOT NULLSearch Definition (see PSPTSF_SD).
PTSF_FEED_AE_STATCharacter(2)VARCHAR2(2) NOT NULLAE 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: 10

PTSF_QRY_FROM_DTTMDateTime(26)TIMESTAMPDatetime prompt value
PTSF_NEXTEXEC_DTTMDateTime(26)TIMESTAMPNext exceute datetime
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
PTSF_FEED_RQS_DTTMDateTime(26)TIMESTAMPFeed requested datetime
PTSF_FEEDGEN_STATCharacter(1)VARCHAR2(1) NOT NULLFeed generation status
D=Done
E=Errored
G=Generating
N=Not Started
S=Started

Default: S

PTSF_GENEATED_SEGNumber(5,0)INTEGER NOT NULLGenerated segment count
PTSF_CRAWLED_SEGNumber(5,0)INTEGER NOT NULLSegments returned to crawler
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
PTSF_RECRAWL_MODECharacter(1)VARCHAR2(1) NOT NULLIndexing type
N=Incremental Index
Y=Full index
PTSF_LANGUAGECharacter(3)VARCHAR2(3) NOT NULLAll Languages
ALL=All Languages
BAS=Base Language
PTSF_RESUME_SCHEDCharacter(1)VARCHAR2(1) NOT NULLResume schedule
C=Restart SES crawl
R=Resume at failure
S=Rebuild index

Default: R

LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19