HRS_JSRCH_RUN

(SQL Table)
Index Back

Search indexing Run Ctl rec

Applicant Verity index build process run control record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

Prompt Table: OPR_DEF_TBL_FS

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SEARCH_MODE Character(1) VARCHAR2(1) NOT NULL Resume Search Collection
C=Create New
U=Update Existing
4 HRS_OPEN_DT_FROM Date(10) DATE Open Date From
5 RUN_COUNT Number(2,0) SMALLINT NOT NULL Run count
6 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
7 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
9 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id