GPBROES_DADH_VW

(SQL View)
 Index Back

Oracle Internal Use Only

Oracle Internal Use Only - eSocial receipt number generation tool.

SELECT A.GPBR_DRIVER_SEQ , COALESCE(( SELECT B.EMPLID FROM %Table(GPBR_DRVEMP_XRF) B WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ), ' ') , 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num