INCIDENT_BRA(SQL Table) |
Index Back |
---|---|
Incident Report BrazilCAT Report Incident Report Brazil |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Incident Number | |
2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
3 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
4 | Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID | |
5 | Number(6,0) | INTEGER NOT NULL | CAT Number | |
6 | CAT_DATE_BRA | Date(10) | DATE NOT NULL |
Date CAT Brazil
Default Value: INCIDENT_DATA.INCIDENT_DT |
7 | CAT_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
CAT Type
1=Initial 2=Reopened 3=Death Communication |
8 | CAT_DIAGNOS_BRA | Character(200) | VARCHAR2(200) NOT NULL | Observations CAT Report Brazil |
9 | CAT_SAL_TYPE_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Salary Type CAT Brazil
1=Global Payroll 2=Job Monthly Pay Rate 3=Job Rate Code 4=Other Default Value: 2 |
10 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: COMP_RATECD_TBL |
11 | CAT_MONTH_SAL_BRA | Number(13,2) | DECIMAL(12,2) NOT NULL | Monthly Salary |
12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
13 | CAT_DEATH_BRA | Character(1) | VARCHAR2(1) NOT NULL |
CAT Death
Y/N Table Edit Default Value: N |
14 | CAT_DEATH_DATE_BRA | Date(10) | DATE | Death Communication Date |
15 | CAT_PARTIAL_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Certificate of Death
Y/N Table Edit Default Value: N |
16 | CAT_DEATH_CERT_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Certificate of Death
Y/N Table Edit Default Value: N |
17 | CAT_REG_ID_BRA | Number(13,0) | DECIMAL(13) NOT NULL | CAT Register ID Brazil |
18 | CAT_REG_DT_BRA | Date(10) | DATE |
CAT Register Date
Default Value: %date |
19 | CAT_EMITED_BY_BRA | Character(1) | VARCHAR2(1) NOT NULL |
CAT Emitted by
1=Employer 2=Union 3=Doctor 4=Seg o Dependen 5=Authority Public |
20 | DATE_FROM | Date(10) | DATE NOT NULL |
Date From
Default Value: %date |
21 | CAT_LOC_DESCR_BRA | Character(200) | VARCHAR2(200) NOT NULL | Location description CAT Brazil |