GPBR_ES_PH_SRCH(SQL Table) |
Index Back |
|---|---|
Monitor Search Criteria RecordMonitor search criteria record that stores the last filtering options used by each oprid. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | GPBR_ES_SRCH_DT | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Monitor Events
01=Accrual Period 02=Hire Date 03=Transaction Date |
| 3 | GPBR_ES_SRCH_BY | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Monitor Events
01=Company 05=Employees |
| 4 | GPBR_ES_STATUS_PH | Character(4) | VARCHAR2(4) NOT NULL |
Status Pre-Hiring
AEXC=Await Exclusion CANC=Canceled COMP=Complete ERRO=Error HIRE=Hired HPRO=Hiring in Progress PEHR=Pending Hiring RDY=Ready RECT=Rectified WHIR=Withdraw Hiring WPHR=Withdraw Pre-Hiring XSEN=Wait for Return |
| 5 | GPBR_ES_SRCH_STS | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Pre-Hiring Monitor page (Status)
01=Error 02=Withdraw Pre-Hiring 03=Withdraw Hiring 04=Hired 05=Pending Hiring 06=Wait for Return |
| 6 | GPBR_ES_DT_FROM | Date(10) | DATE | Termination Date Through |
| 7 | GPBR_ES_DT_TO | Date(10) | DATE | Termination Date Through |
| 8 | GPBR_ES_ACTION_PH | Character(3) | VARCHAR2(3) NOT NULL |
eSocial Action Pre-Hiring
CAN=Cancel EXC=Exclude REC=Rectify REP=Reprocess |