GPBR_DRIVER_SEQTRANSACTION_NBRGPBR_NRP_ABX_VW(SQL View) |
Index Back |
|---|---|
Absence Xref Element RelationeSocial Absence Xref Element Relationship View |
| SELECT GPBR_DRIVER_SEQ , TRANSACTION_NBR , GPBR_EVENT_CD , EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM + 50000000 , END_DT , ABSENCE_REASON , DURATION_ABS , GPBR_ABS_RPT_CD1 , GPBR_ABS_RPT_CD2 , CID_CODE_BRA FROM PS_GPBR_DRVABS_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 | TRANSACTION_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 3 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | BGN_DT | Date(10) | DATE | Begin Date |
| 7 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 8 | END_DT | Date(10) | DATE | end date |
| 9 | ABSENCE_REASON | Character(3) | VARCHAR2(3) NOT NULL | absence reason |
| 10 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
| 11 | GPBR_ABS_RPT_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Below 15 days Absence Code |
| 12 | GPBR_ABS_RPT_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Above 15 Days Absence Code |
| 13 | CID_CODE_BRA | Character(15) | VARCHAR2(15) NOT NULL | CID Code Brazil |