PTSF_DP_SDL_AET

(SQL Table)
Index Back

Run Control Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PTSF_IDX_DP Character(1) VARCHAR2(1) NOT NULL Index By Partition
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).

Prompt Table: PTSF_DEP_SBO_VW

6 PTSF_SRCH_ENG_INS Character(30) VARCHAR2(30) NOT NULL Search Instance Name
7 PTSF_RESUME_SCHED Character(1) VARCHAR2(1) NOT NULL Resume schedule
C=Restart SES crawl
R=Resume at failure
S=Rebuild index
8 PTSF_RECRAWL_MODE Character(1) VARCHAR2(1) NOT NULL Indexing type
N=Incremental Index
P=Data Partition
Y=Full index

Default Value: N

9 PTSF_LANGUAGE Character(3) VARCHAR2(3) NOT NULL All Languages
ALL=All Languages
BAS=Base Language
10 PTSF_DP_SDATE Date(10) DATE Start Date
11 PTSF_DP_EDATE Date(10) DATE End Date
12 PTSF_DP_STIME Time(15) TIMESTAMP HH:MM
13 PTSF_DP_ETIME Time(15) TIMESTAMP HH:MM
14 PTSF_DP_SDTTM DateTime(26) TIMESTAMP Start Time
15 PTSF_DP_EDTTM DateTime(26) TIMESTAMP End Time
16 PTSF_DP_PARTCNT Number(4,0) SMALLINT NOT NULL Number of Partitions
17 PTSF_DP_STGNAME Character(15) VARCHAR2(15) NOT NULL Used in Index By Data Partition
18 PTSF_DP_TTBLNAME Character(15) VARCHAR2(15) NOT NULL Used in Index By Data Partition
19 PTSF_DP_APPLID Character(12) VARCHAR2(12) NOT NULL Used in Index By Data Partition
20 PTSF_DP_SECTION Character(8) VARCHAR2(8) NOT NULL Used in Index By Data Partition
21 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
22 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).