| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
ERE_ID_ESP |
Character(10) |
VARCHAR2(10) NOT NULL |
ERE ID
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
ERE_NBR_ESP |
Character(9) |
VARCHAR2(9) NOT NULL |
ERE Number
|
| 5 |
ERE_APP_TYPE_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
ERE Applicant type
EE=Employees
ER=Employer
RP=Employee's Representative
|
| 6 |
ERE_BGNDT_ESP |
Date(10) |
DATE NOT NULL |
ERE Begin date
|
| 7 |
ERE_ENDDT_ESP |
Date(10) |
DATE NOT NULL |
ERE End date
|
| 8 |
REDCTN_ID_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Reduction ID
|
| 9 |
ERE_RS_ECO_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Economical ERE reason flag
Y/N Table Edit
Default Value: N
|
| 10 |
ERE_RS_TEC_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Technological ERE reason flag
Y/N Table Edit
Default Value: N
|
| 11 |
ERE_RS_ORG_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Organizational reason flag
Y/N Table Edit
Default Value: N
|
| 12 |
ERE_RS_OTH_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Other reason flag
Y/N Table Edit
Default Value: N
|
| 13 |
ERE_RS_DESCR_ESP |
Character(50) |
VARCHAR2(50) NOT NULL |
ERE reason description
|
| 14 |
ERE_XTRPD_RD_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Extra period reduction percentage
|
| 15 |
ERE_TYP_PERM_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Permanent ERE type
Y/N Table Edit
Default Value: N
|
| 16 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 17 |
ERE_INDM_DAYS_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Days/Year
|
| 18 |
ERE_MAX_PRDS_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Max. Periods
|
| 19 |
ERE_TYP_SUSP_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Suspension ERE type
Y/N Table Edit
Default Value: N
|
| 20 |
ERE_SUSP_DAYS_ESP |
Number(4,0) |
SMALLINT NOT NULL |
ERE duration in days
|
| 21 |
ERE_TYP_WSRD_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Work schedule reduction ERE type
Y/N Table Edit
Default Value: N
|
| 22 |
ERE_WSRD_DAYS_ESP |
Number(4,0) |
SMALLINT NOT NULL |
ERE work schedule reduction duration in days
|
| 23 |
ERE_WKD_RD_PCT_ESP |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Work schedule reduction percentage
|
| 24 |
ERE_SCH_DST_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Work schedule distribution
D=Daily Hours Reduction
W=Work Day Reduction
Default Value: D
|
| 25 |
ERE_DAYS_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Days type
N=Natural
W=Working
Default Value: N
|
| 26 |
ERE_WKD_CORR_ESP |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Work day correction factor.
Default Value: 1
|
| 27 |
BANKRUPTCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Bankruptcy
Y/N Table Edit
Default Value: N
|
| 28 |
COMM_DT |
Date(10) |
DATE |
Communication Date
|
| 29 |
ERE_PIN_BN1_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field houses the Benefits Base GP Core Accumulator Pin Number.
|
| 30 |
ERE_RESLTN_DT_ESP |
Date(10) |
DATE |
ERE Resolution Date
|
| 31 |
ERE_TERRT_AREA_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Territorial Area:
N --> National
A --> Autonomic
P --> Province
A=Autonomic
N=National
P=Provincial
Default Value: P
|
| 32 |
ERE_RSN_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Reason
E -> Economical
O -> Organizational
T -> Technological
P -> Production
F -> Force Majeure
C -> Bankrupt
V -> Force Majeure-COVID19
C=Bankrupt
E=Economical
F=Force Majeure
O=Organizational
P=Production
T=Technological
V=Force Majeure-COVID19
Default Value: O
|
| 33 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|