GPES_NRP_ER2_VW

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