INCIDENT_BRA

(SQL Table)
Index Back

Incident Report Brazil

CAT Report Incident Report Brazil

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID
5 CAT_ID_BRA 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