GPBR_DRIVER_SEQGPBR_NRP_WAX_VW(SQL View) |
Index Back |
|---|---|
Wage Type Xref Elem RelationeSocial Wage Type Xref Elem Relationship. |
| SELECT GPBR_DRIVER_SEQ , GPBR_EVENT_CD , GPBR_WAGE_TYPES_ID , PIN_ELEM_NUM + 50000000 , PIN_NM , GPBR_ES_PS , GPBR_PRV_DT FROM PS_GPBR_DRVWAG_XRF |
| # | 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 | GPBR_WAGE_TYPES_ID | Character(8) | VARCHAR2(8) NOT NULL | Wages Types IDs for eSocial Brazil |
| 4 | PIN_ELEM_NUM | Number(8,0) | INTEGER NOT NULL | Element Number |
| 5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 6 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 7 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |