OPRIDCO=Company
EM=Employee ID
ES=Establishment
CA=Event Category
EV=Event
ST=Status
AC=Accrual Period
TR=Transaction Date
GPBR_ESOC_MRSRC(SQL Table) |
Index Back |
|---|---|
Monitor Search Criteria Wk RecMonitor 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_ESOC_SRCH_BY | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Monitor Events
CO=Company EM=Employee ID ES=Establishment |
| 3 | GPBR_ESOC_SRCH_EVT | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Monitor Events - Search Event By
CA=Event Category EV=Event |
| 4 | GPBR_ESOC_SRCH_STS | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Events Monitor - Search Status By
ST=Status |
| 5 | GPBR_ESOC_SRCH_DT | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Monitor Events - Search Date By
AC=Accrual Period TR=Transaction Date |
| 6 | GPBR_ACCRYEARFROM | Character(4) | VARCHAR2(4) NOT NULL | Year From - eSocial Monitor |
| 7 | GPBR_ACCRMONTHFROM | Character(2) | VARCHAR2(2) NOT NULL | Month From - eSocial Monitor |
| 8 | GPBR_ACCRYEARTO | Character(4) | VARCHAR2(4) NOT NULL | Year To - eSocial Monitor |
| 9 | GPBR_ACCRMONTHTO | Character(2) | VARCHAR2(2) NOT NULL | Month To - eSocial Monitor |
| 10 | GPBR_TRANS_DT_FROM | Date(10) | DATE | Transaction date from - eSocial Monitor |
| 11 | GPBR_TRANS_DT_TO | Date(10) | DATE | Transaction date to - eSocial Monitor |