| # |
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:
ERE_E_SRCH_ESP
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
Prompt Table:
ERE_EM_SRCH_ESP
|
| 4 |
ERE_BGNDT_ESP |
Date(10) |
DATE |
ERE Begin date
Default Value: ERE_DATA_ESP.ERE_BGNDT_ESP
|
| 5 |
ERE_ENDDT_ESP |
Date(10) |
DATE |
ERE End date
Default Value: ERE_DATA_ESP.ERE_ENDDT_ESP
|
| 6 |
LACKING_IND_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Benefit eligibility
N=Regular Benefit
S=Special Subsidy
Y=No Benefit
Default Value: N
|
| 7 |
ERE_SCH_DST_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Work schedule distribution
D=Daily Hours Reduction
W=Work Day Reduction
Default Value: ERE_DATA_ESP.ERE_SCH_DST_ESP
|
| 8 |
PARTIAL_HRS |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Partial Hours
|
| 9 |
UNEMPLOYMNT_OFFICE |
Character(30) |
VARCHAR2(30) NOT NULL |
Employment Office
|
| 10 |
UNEMPLYMT_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment type
F=Full
P=Partial
Default Value: F
|
| 11 |
UMEMPL_RQST_DT_ESP |
Date(10) |
DATE |
Unemployment request date
|
| 12 |
ERE_PRTIAL_RSN_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Partial ERE reason
1=Full Time Schedule Reduction
2=Part Time Schedule Reduction
3=Part Time Contract
4=Change Full Time to Part Time
5=P Time Termination by Dismissl
6=Change Part Time to another PT
7=Part Time Termination
8=Change Part Time to another PT
|
| 13 |
ERE_EE_STATUS_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Employee status during ERE procedure
01=Permanent
02=Temporary
03=FD without Activity Interruptn
04=FD with Activity Interruptn
05=Migrants for Less than 6 Month
06=Part-Time
07=Members of Cooperative
08=Contract Administration
09=Public Employee
10=High Charge of A.G.
11=Union Representative
12=City Council Member
Default Value: 01
|
| 14 |
REFERENCE_DT_ESP |
Date(10) |
DATE |
Reference date
|
| 15 |
UNEMPL_BNF_BGN_ESP |
Date(10) |
DATE |
Unemployment benefit begin date
|
| 16 |
UNEMPL_BNF_END_ESP |
Date(10) |
DATE |
Unemployment benefit end date
|
| 17 |
DAILY_CNTB_BS_ESP |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Daily regulatory base (BRD: Base Reguladora Diaria)
|
| 18 |
CONTRIB_DAYS_ESP |
Number(4,0) |
SMALLINT NOT NULL |
Contribution Days
|
| 19 |
CONTRIB_BASE_ESP |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Common Contingency Base
|
| 20 |
CONTRIB_CPBASE_ESP |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Professional Contingency Base
|
| 21 |
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
|
| 22 |
ACCOUNT_ID |
Number(3,0) |
SMALLINT NOT NULL |
Account ID
Prompt Table:
ERE_BANK_ESP_VW
|
| 23 |
ERE_WKD_RD_PCT_ESP |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Work schedule reduction percentage
|
| 24 |
ERE_BENEFT_RSN_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Benefit ERE reason
70=Contributed Benefit
74=Replenish Benefit Entitlement
Default Value: 70
|
| 25 |
CNO_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Code
Prompt Table:
XML_CNO_ESP_VW
|
| 26 |
ERE_SPENT_DAYS_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
ERE Spent Benefit Days
|
| 27 |
FTE_AVG_ESP |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FTE Average
Default Value: 1
|
| 28 |
ERE_EVENT_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Event Type
A : New
B : Delete
M: Update
A=New
B=Delete
M=Update
Default Value: A
|
| 29 |
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
|
| 30 |
LST_ASGN_START_DT |
Date(10) |
DATE |
Lastest start date of the specific EMPL_RCD assignment. This is different from the Person's organizational instance Last Hire Date.
Prompt Table:
GPES_BG_DT_DVW
|
| 31 |
ERE_JD_UPD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
"ERE Data update" Job Data update flag.
Y/N Table Edit
Default Value: Y
|
| 32 |
ERE_CN_UPD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
"ERE Data Update" Contract data update flag
Y/N Table Edit
Default Value: Y
|
| 33 |
ERE_AB_UPD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
"ERE Data Update" Absence event update flag.
Y/N Table Edit
Default Value: Y
|
| 34 |
ERE_BR_UPD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
BRD update flag
Y/N Table Edit
Default Value: Y
|
| 35 |
ERE_REDTN_FREQ_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Reduction Frequency
A : Annual
M : Monthly
S : Weekly
D : Daily
A=Annualy
D=Daily
M=Monthly
S=Weekly
Default Value: A
|
| 36 |
PROCESS_DTTM |
DateTime(26) |
TIMESTAMP |
Process Date/Time
|