ERE_RC_UDTA_ESP(SQL Table) |
Index Back |
|---|---|
Process ERE data run controlProcess ERE data run control |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | ERE_ID_ESP | Character(10) | VARCHAR2(10) NOT NULL |
ERE ID
Prompt Table: ERE_DATA_ESP |
| 4 | ERE_TYP_PERM_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Permanent ERE type
Y/N Table Edit Default Value: N |
| 5 | ERE_TYP_SUSP_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Suspension ERE type
Y/N Table Edit Default Value: N |
| 6 | ERE_TYP_WSRD_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Work schedule reduction ERE type
Y/N Table Edit Default Value: N |
| 7 | ERE_JD_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
"ERE Data update" Job Data update flag.
Y/N Table Edit Default Value: N |
| 8 | ERE_CN_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
"ERE Data Update" Contract data update flag
Y/N Table Edit Default Value: N |
| 9 | ERE_AB_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
"ERE Data Update" Absence event update flag.
Y/N Table Edit Default Value: N |
| 10 | ERE_TE_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
"ERE Data Update" Manage termination update flag.
Y/N Table Edit Default Value: N |
| 11 | ERE_BR_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
BRD update flag
Y/N Table Edit Default Value: N |