ERE_ID_ESPEMPLIDPrompt Table: PERS_SRCH_GBL
EMPL_RCDPrompt Table: EMPLOYMENT
0=Not Communicated
1=XML Generated
2=XML Sent/Confirmated
Default Value: 0
0=No Communicated
1=XML Generated
Default Value: 0
ERE_EE_PRCS_ESP(SQL Table) |
Index Back |
|---|---|
Permanent ERE employeesEmployee population for a permanent ERE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERE_ID_ESP |
Character(10) | VARCHAR2(10) NOT NULL | ERE ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EMPLOYMENT |
| 4 | ERE_BGNDT_ESP | Date(10) | DATE | ERE Begin date |
| 5 | ERE_PRCS_FLG_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Report as XML flag
0=Not Communicated 1=XML Generated 2=XML Sent/Confirmated Default Value: 0 |
| 6 | ERE_XPRCD_FLG_ESP | Character(1) | VARCHAR2(1) NOT NULL |
ERE XML Procedure Status
0 : No reported
1: XML Generated
0=No Communicated 1=XML Generated Default Value: 0 |