GPBROES_DSEL_VW

(SQL View)
Index Back

Oracle Internal Use Only

Oracle Internal Use Only - eSocial receipt number generation tool.

SELECT A.GPBR_DRIVER_SEQ , A.GPBR_EVENT_CD , COALESCE(( SELECT B.EMPLID FROM %Table(GPBR_DRVEMP_XRF) B WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ), ' ') , A.COMPANY , A.ESTABID , A.GPBR_STATUS , A.GPBR_RECEIPT_NUM FROM %Table(GPBR_DRIVER_DAT) A

# 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_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
6 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
7 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num