GPBROES_DSEL_VW(SQL View) |
Index Back |
---|---|
Oracle Internal Use OnlyOracle 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 |