INJURY_ILL_BRA(SQL Table) |
Index Back |
|---|---|
Injury BrazilInjury Brazil |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table: INCIDENT_DATA |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: EMPLOYMENT |
| 4 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table: NE_INCIDNT_SRCH |
| 5 | CAT_RENDERTYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Rendering Service CAT
1=Urban 2=Rural Default Value: 1 |
| 6 | CAT_WORKED_HR_BRA | Number(5,2) | DECIMAL(4,2) NOT NULL | Worked Hours |
| 7 | CAT_PENSIONER_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Pensioner RGPS
Y/N Table Edit Default Value: N |
| 8 | CAT_TYPE_INSS_BRA | Character(1) | VARCHAR2(1) NOT NULL |
INSS Affiliation Type Brazil
1=Employee 2=Non-Employee 7=Special Security 8=Medical Doctor Default Value: 1 |
| 9 | CID_CODE_BRA | Character(15) | VARCHAR2(15) NOT NULL |
CID Code Brazil
Prompt Table: CID_CODES_BRA |