GPBR_ES_ERR_EVT

(SQL Table)
Index Back

eSocial - Event Errors Table

Event processing errors.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
2 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
3 GPBR_STATUS Character(4) VARCHAR2(4) NOT NULL Status
CANC=Cancelled
COMP=Completed
DUPL=Duplicated
ERRM=Error Mapping
GERR=WS Return Error
GSUC=WS Return Success
HOLD=On Hold
MAPP=Mapping
NEW=New
RDY=Ready
SMOV=Without Movement
SUCC=Success
XCRT=XML Create
XERR=XML Error
XRDY=XML Ready
XSEN=XML Sent
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 GPBR_ES_ERR_SRC Character(2) VARCHAR2(2) NOT NULL eSocial Error Catalog - Error Source
GB=Government - Batch
GE=Government - Event
IL=Initial Loading
MP=Mapping
ON=Online
PR=Process
TP=Third-Party
XG=XML Generation
6 GPBR_ES_ERR_OWNER Character(1) VARCHAR2(1) NOT NULL eSocial Error Catalog - Error Owner
C=Customer Maintained
N=PS Delivered / Not Maintained
P=PS Delivered / Maintained
7 GPBR_ES_ERR_CODE Character(10) VARCHAR2(10) NOT NULL eSocial Error Catalog - Error Code
8 GPBR_ES_ERR_SEVER Character(1) VARCHAR2(1) NOT NULL eSocial Error Catalog - Error Severity
1=Error
2=Warning
3=Message
9 DESCRLONG Long Character CLOB Long Description
10 GPBR_ES_LOC_NAME Character(254) VARCHAR2(254) NOT NULL eSocial Error Catalog - Location Name
11 GPBR_TIMESTAMP DateTime(26) TIMESTAMP Process Time Stamp for Mass Termination