| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
GPBR_DRIVER_SEQ |
Number(30,0) |
DECIMAL(30) NOT NULL |
Driver Sequence
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 5 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 6 |
INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 8 |
GPBR_EVENT_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
eSocial - Event Code
|
| 9 |
GPBR_ES_PS |
Date(10) |
DATE |
eSocial on PeopleSoft Date
|
| 10 |
INCIDENT_DT |
Date(10) |
DATE |
Incident Date
|
| 11 |
GPBR_RECT |
Number(30,0) |
DECIMAL(30) NOT NULL |
eSocial Ind Calculation
|
| 12 |
GPBR_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Process Time Stamp for Mass Termination
|
| 13 |
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
|
| 14 |
CAT_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
CAT Type
1=Initial
2=Reopened
3=Death Communication
|
| 15 |
GPBR_CAT_INI |
Number(1,0) |
SMALLINT NOT NULL |
Initial CAT
|
| 16 |
GPBR_RECEIPT_NUM |
Character(40) |
VARCHAR2(40) NOT NULL |
Receipt Num
|
| 17 |
GPBR_CAT_REG_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
CAT Origin
|
| 18 |
GPBR_COM_INS_TYPEE |
Character(2) |
VARCHAR2(2) NOT NULL |
Company Inscription Type
|
| 19 |
GPBR_ESTAB_ID_EST |
Character(20) |
VARCHAR2(20) NOT NULL |
Establishment ID
|
| 20 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 21 |
GPBR_HRACCID_CAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Accident Time in string format 4 characters HHMI
|
| 22 |
GPBR_CAT_WORKED_HR |
Character(4) |
VARCHAR2(4) NOT NULL |
CAT Worked Hours Before
|
| 23 |
CAT_INC_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
CAT Incident Type
1=Typical
2=Illness
3=Route
|
| 24 |
GPBR_LEAVE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Ind
|
| 25 |
CAT_LOCTYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
CAT Location Type
1=Employer Establishment
2=Employee Service Taker
3=Public Thoroughfare
4=Rural Area
5=Other
6=Establishment Outside Brazil
|
| 26 |
CAT_SPEC_LOC_BRA |
Long Character |
CLOB |
CAT Specific Location
|
| 27 |
GPBR_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
State Code
|
| 28 |
INJURY_NAT_CD_BRA |
Number(9,0) |
DECIMAL(9) NOT NULL |
Nature of Injury Legal Code
|
| 29 |
CAT_POLICE_REG_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Police Register for Brazil (CAT)
|
| 30 |
CAT_DEATH_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
CAT Death
|
| 31 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 32 |
GPBR_COMMENTS |
Long Character |
CLOB |
Comments.
|
| 33 |
TREATMENT_DT |
Date(10) |
DATE |
Treatment Date
|
| 34 |
GPBR_TREATMENT_TM |
Character(4) |
VARCHAR2(4) NOT NULL |
Treatment Time
|
| 35 |
GPBR_HOSP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Hospital Ind
|
| 36 |
GPBR_HOSP_DUR |
Number(4,0) |
SMALLINT NOT NULL |
Hospital Duration
|
| 37 |
GPBR_DESC_INJURY |
Number(9,0) |
DECIMAL(9) NOT NULL |
Injury Description
|
| 38 |
GPBR_DIAGNOS |
Character(100) |
VARCHAR2(100) NOT NULL |
Diagnostic
|
| 39 |
GPBR_CID_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
CID Code
|
| 40 |
GPBR_PERS_NAME |
Character(70) |
VARCHAR2(70) NOT NULL |
Used to keep a person name.
|
| 41 |
GPBR_MED_TYPE |
Number(1,0) |
SMALLINT NOT NULL |
Medical Type
|
| 42 |
MED_CRM_BRA |
Character(15) |
VARCHAR2(15) NOT NULL |
Medical Certication Register.
|
| 43 |
GPBR_STATE_OC |
Character(2) |
VARCHAR2(2) NOT NULL |
OC State
|
| 44 |
GPBR_CAT_OBS |
Character(254) |
VARCHAR2(254) NOT NULL |
Observations CAT
|
| 45 |
ESTAB_ID_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Establishment ID Brazil
|
| 46 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 47 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 48 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 49 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 50 |
CBO_CD_BRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Occupation Code for Brazil
|
| 51 |
CAT_RENDERTYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Rendering Service CAT
1=Urban
2=Rural
|
| 52 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 53 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 54 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 55 |
ESTAB_ID2_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Establishment ID Brazil
|
| 56 |
DESCR100A |
Character(100) |
VARCHAR2(100) NOT NULL |
Description
|
| 57 |
GPBR_CAT_LATE |
Number(1,0) |
SMALLINT NOT NULL |
Lateralit
|
| 58 |
GPBR_INJURY_CD |
Number(9,0) |
DECIMAL(9) NOT NULL |
Injury Code
|
| 59 |
GPBR_INJURY_CD2 |
Number(9,0) |
DECIMAL(9) NOT NULL |
Injury Code
|
| 60 |
DESCR100B |
Character(100) |
VARCHAR2(100) NOT NULL |
Description
|
| 61 |
DESCR100_2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Description
|
| 62 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 63 |
CAT_WORK_DATE_BRA |
Date(10) |
DATE |
Last Work Date
|
| 64 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 65 |
CAT_LOC_DESCR_BRA |
Character(200) |
VARCHAR2(200) NOT NULL |
Location description CAT Brazil
|
| 66 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|