XML_DLT_INJ_VW (SQL View)	Index Back
View Delt@ Incident Data View Delta Incident Data

XML_DLT_INJ_VW

(SQL View)

View Delt@ Incident Data

View Delta Incident Data

SELECT A.EMPLID ,C.INCIDENT_DT ,A.ABS_BEGIN_DT ,A.EMPL_RCD ,A.INCIDENT_NBR ,A.ABS_END_DT ,A.DLT_INC_TYPE_ESP ,A.DLT_RELAPSE_ESP ,'1' ,A.DLT_CNO_ESP ,A.DLT_SEN_MONTH_ESP ,A.DLT_SEN_DAYS_ESP ,'01' ,A.DLT_NBR_OF_EMPL ,A.DLT_HIR ,A.DLT_ETT ,A.DLT_PLACE_CODE_ESP ,C.COUNTRY ,C.STATE ,C.CITY ,C.ADDRESS1 ,C.NUM1 ,C.DESCRLONG ,A.DLT_EMPL_COMP ,A.DLT_OTHR_COMP ,A.FISCAL_ID_CD4_ESP ,A.FISCAL_ID_CD2_ESP ,A.FISCAL_ID_CD3_ESP ,A.DLT_CAUSE_ESP ,A.DLT_ADDRESS1_ESP ,A.DLT_STATE_ESP ,A.DLT_CITY_ESP ,A.DLT_POSTAL_ESP ,A.DLT_PHONE_ESP ,A.DLT_STAFF_ESP ,A.DLT_SSN_EMPLER_ESP ,A.INDSTRY_CD_ESP ,A.DLT_PLACE_TYPE_ESP ,A.DLT_WORK_TYPE_ESP ,A.DLT_TASK_ESP ,A.DLT_USUAL_TOOL_ESP ,A.DLT_INCHOUR_ESP ,A.DLT_WORKHOUR_ESP ,A.DLT_INCWORK_ESP ,A.DLT_RISK_EVAL_ESP ,A.DLT_DEVIATION_ESP ,A.DLT_CAUSE_ESP ,A.DLT_UNUS_TOOL_ESP ,A.DLT_SOURCE_ESP ,A.DLT_EMPL_FLG_ESP ,A.DLT_WITNS_FLG_ESP ,A.DLT_WITNS_DATA_ESP ,A.DLT_INJURY_ESP ,A.DLT_INJRY_GRD_ESP ,A.DLT_BODY_PART_ESP ,A.DLT_CONTACT_ESP ,A.DLT_ASIST_TYPE_ESP ,A.CONTRIB_BASE_ESP ,A.CONTRIB_DAYS_ESP ,A.REG_BASE_ESP ,A.CONTRIB_OVER_ESP ,A.SUM_B1_B2_ESP ,A.AVERAGE_ESP ,A.AVERAGE_A_ESP ,A.AVERAGE_B_ESP ,A.AVERAGE_TOTAL_ESP ,A.AVERAGE_BNFIT_ESP ,A.RESPONSIBLE_ROLE ,A.STATE2 ,A.PRESENTED_DT ,A.INSUR_COMP_CD_ESP ,A.DAY_OF_WK ,A.COMPANY ,A.SSN_EMPLOYER ,A.DLT_RAF_REASON_ESP ,A.DLT_RAF_GRD_ESP ,A.DIAGNOSIS_CD ,A.DLT_COMP_TYPE_ESP ,A.DLT_OTH_ADDR_ESP ,A.DLT_VIAKM_ESP ,A.DLT_HOSPITALZD_ESP ,A.DLT_CNTR_BASE_ESP ,A.DLT_CNTR_OVER_ESP ,A.DLT_INCIDENT_NBR ,A.DLT_REPORT_STATUS ,A.DLT_RAF_STATUS FROM PS_INJURY_ILL_ESP A , PS_INJURY_ILL B , PS_INCIDENT_DATA C WHERE A.INCIDENT_NBR = C.INCIDENT_NBR AND A.EMPLID = B.EMPLID AND A.INCIDENT_NBR = B.INCIDENT_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 INCIDENT_DT Date(10) DATE Incident Date

3 ABS_BEGIN_DT Date(10) DATE Absence Begin Date

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

6 ABS_END_DT Date(10) DATE Absence End Date

7 DLT_INC_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Incident Type
P=Industrial Acc. Sick Note
R=Industrial Acc. No Sick Note

8 DLT_RELAPSE_ESP Character(1) VARCHAR2(1) NOT NULL Relapse
1=Accident
2=Relapse

9 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

10 DLT_CNO_ESP Character(4) VARCHAR2(4) NOT NULL Occupational Code
Prompt Table: DLT_CNO_ESP_VW

11 DLT_SEN_MONTH_ESP Character(3) VARCHAR2(3) NOT NULL Seniority Months

12 DLT_SEN_DAYS_ESP Character(2) VARCHAR2(2) NOT NULL Seniority Days

13 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP

14 DLT_NBR_OF_EMPL Number(6,0) INTEGER NOT NULL Number of Employees in the company.

15 DLT_HIR Character(1) VARCHAR2(1) NOT NULL Hiring Flag

16 DLT_ETT Character(1) VARCHAR2(1) NOT NULL Temporary Work Company

17 DLT_PLACE_CODE_ESP Character(1) VARCHAR2(1) NOT NULL Place Code
1=Usual Work Center
2=Taken Journey
3=In Itinere
4=Other Work Center

18 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

19 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

20 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other

21 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other

22 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other

23 DESCRLONG Long Character CLOB Long Description

24 DLT_EMPL_COMP Character(1) VARCHAR2(1) NOT NULL Center belongs to EE Company

25 DLT_OTHR_COMP Character(1) VARCHAR2(1) NOT NULL External Company
Y/N Table Edit

26 FISCAL_ID_CD4_ESP Character(10) VARCHAR2(10) NOT NULL Fiscal ID Hiring

27 FISCAL_ID_CD2_ESP Character(10) VARCHAR2(10) NOT NULL Fiscal ID ETT

28 FISCAL_ID_CD3_ESP Character(10) VARCHAR2(10) NOT NULL Fiscal ID Other

29 DLT_DESCR_ESP Character(200) VARCHAR2(200) NOT NULL TO BE DELETE

30 DLT_ADDRESS1_ESP Character(60) VARCHAR2(60) NOT NULL Address Company

31 DLT_STATE_ESP Character(2) VARCHAR2(2) NOT NULL State Company

32 DLT_CITY_ESP Character(5) VARCHAR2(5) NOT NULL City Company

33 DLT_POSTAL_ESP Character(5) VARCHAR2(5) NOT NULL Postal Company

34 DLT_PHONE_ESP Character(14) VARCHAR2(14) NOT NULL Phone Company

35 DLT_STAFF_ESP Character(5) VARCHAR2(5) NOT NULL Staff

36 DLT_SSN_EMPLER_ESP Character(11) VARCHAR2(11) NOT NULL SSN Employer

37 INDSTRY_CD_ESP Character(5) VARCHAR2(5) NOT NULL Industry Activity Code
Prompt Table: INDSTRY_ACT_ESP

38 DLT_PLACE_TYPE_ESP Character(3) VARCHAR2(3) NOT NULL Industrial Accident Place Type
Prompt Table: DLT_PLC_ESP_VW

39 DLT_WORK_TYPE_ESP Character(2) VARCHAR2(2) NOT NULL Work Type
Prompt Table: DLT_WRK_ESP_VW

40 DLT_TASK_ESP Character(2) VARCHAR2(2) NOT NULL Task
Prompt Table: DLT_TSK_ESP_VW

41 DLT_USUAL_TOOL_ESP Character(11) VARCHAR2(11) NOT NULL Usual Working Tool
Prompt Table: DLT_TOOL_ESP_VW

42 DLT_INCHOUR_ESP Character(2) VARCHAR2(2) NOT NULL Incident Time Delta

43 DLT_WORKHOUR_ESP Character(2) VARCHAR2(2) NOT NULL Weeking Hour
0=In Itinere
1=Hour 1
10=Hour 10
11=Hour 11
12=Hour 12
2=Hour 2
3=Hour 3
4=Hour 4
5=Hour 5
6=Hour 6
7=Hour 7
8=Hour 8
9=Hour 9
99=In Itinere

44 DLT_INCWORK_ESP Character(1) VARCHAR2(1) NOT NULL Usual Work

45 DLT_RISK_EVAL_ESP Character(1) VARCHAR2(1) NOT NULL Risk Evaluation

46 DLT_DEVIATION_ESP Character(2) VARCHAR2(2) NOT NULL Deviation
Prompt Table: DLT_DEV_ESP_VW

47 DLT_CAUSE_ESP Character(200) VARCHAR2(200) NOT NULL Cause

48 DLT_UNUS_TOOL_ESP Character(11) VARCHAR2(11) NOT NULL Unusual Working Tool
Prompt Table: DLT_TOOL_ESP_VW

49 DLT_SOURCE_ESP Character(11) VARCHAR2(11) NOT NULL Source of Injury
Prompt Table: DLT_TOOL_ESP_VW

50 DLT_EMPL_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Multiple Employees

51 DLT_WITNS_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Witness

52 DLT_WITNS_DATA_ESP Character(50) VARCHAR2(50) NOT NULL Witness Data

53 DLT_INJURY_ESP Character(3) VARCHAR2(3) NOT NULL Injury
Prompt Table: DLT_INJ_ESP_VW

54 DLT_INJRY_GRD_ESP Character(1) VARCHAR2(1) NOT NULL Injury Grade
1=Low Damage
2=High Damage
3=Very High Damage
4=Death

55 DLT_BODYPART_ESP Character(8) VARCHAR2(8) NOT NULL Body Part
Prompt Table: DLT_DIA_ESP_VW

56 DLT_CONTACT_ESP Character(2) VARCHAR2(2) NOT NULL Contact Mode
Prompt Table: DLT_CNT_ESP_VW

57 DLT_ASIST_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Assistance Type
1=Hospital
2=Ambulatory

58 CONTRIB_BASE_ESP Number(19,6) DECIMAL(18,6) NOT NULL Common Contingency Base

59 CONTRIB_DAYS_ESP Number(4,0) SMALLINT NOT NULL Contribution Days

60 REG_BASE_ESP Number(9,2) DECIMAL(8,2) NOT NULL Regulatory Base

61 CONTRIB_OVER_ESP Number(19,6) DECIMAL(18,6) NOT NULL Contribution Overtime

62 SUM_B1_B2_ESP Number(15,2) DECIMAL(14,2) NOT NULL Sum Base1 and Base 2

63 AVERAGE_ESP Number(9,2) DECIMAL(8,2) NOT NULL Average

64 AVERAGE_A_ESP Number(9,2) DECIMAL(8,2) NOT NULL Average A

65 AVERAGE_B_ESP Number(9,2) DECIMAL(8,2) NOT NULL Average B

66 AVERAGE_TOTAL_ESP Signed Number(10,2) DECIMAL(8,2) NOT NULL Average Total

67 AVERAGE_BNFIT_ESP Number(9,2) DECIMAL(8,2) NOT NULL Benefit

68 RESPONSIBLE_ROLE Character(30) VARCHAR2(30) NOT NULL Responsible Role

69 STATE2 Character(6) VARCHAR2(6) NOT NULL State

70 PRESENTED_DT Date(10) DATE Evidence Presented

71 INSUR_COMP_CD_ESP Character(5) VARCHAR2(5) NOT NULL Insurance Company Code

72 DAY_OF_WK Character(1) VARCHAR2(1) NOT NULL Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday

73 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

74 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
Prompt Table: ALL_CCC_ESP_VW

75 DLT_RAF_REASON_ESP Character(2) VARCHAR2(2) NOT NULL Reason Discharge
00=Recovery
01=Death
02=Recovery
02=Recovery
03=Medical Inspection
03=Medical Inspection
04=Proposed Disability
05=Dead Line Expired
05=Dead Line Expired
06=Improvement
06=Improvement
07=Absence
08=Begin Maternity Leave
10=INSS Control 12 Months
10=INSS Control 12 Months
17=Recovery
18=Training Courses Absenteeism

76 DLT_RAF_GRD_ESP Character(2) VARCHAR2(2) NOT NULL RAF Injuy Grade
1=Moderate
2=High Damage
3=Very High Damage
4=Death

77 DIAGNOSIS_CD Character(6) VARCHAR2(6) NOT NULL Diagnosis Code
Prompt Table: DLT_DIA_ESP_VW

78 DLT_COMP_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Company Type
E=Temporary Work Company
H=Hiring
O=Other

79 DLT_OTH_ADDR_ESP Character(40) VARCHAR2(40) NOT NULL Place Code

80 DLT_VIAKM_ESP Character(40) VARCHAR2(40) NOT NULL Place Code

81 DLT_HOSPITALZD_ESP Character(1) VARCHAR2(1) NOT NULL Place Code
Y/N Table Edit
Default Value: N

82 DLT_CNTR_BASE_ESP Number(9,2) DECIMAL(8,2) NOT NULL Common Contingency Base

83 DLT_CNTR_OVER_ESP Number(9,2) DECIMAL(8,2) NOT NULL Contribution Overtime

84 DLT_INCIDENT_NBR Character(12) VARCHAR2(12) NOT NULL Delta File Number

85 DLT_REPORT_STATUS Character(1) VARCHAR2(1) NOT NULL Delta Reporting Status
0=Not Communicated
1=XML Generated

86 DLT_RAF_STATUS Character(1) VARCHAR2(1) NOT NULL Delta RAF Status.
0=Not Reported
1=XML Generated

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	INCIDENT_DT	Date(10)	DATE	Incident Date
3	ABS_BEGIN_DT	Date(10)	DATE	Absence Begin Date
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
6	ABS_END_DT	Date(10)	DATE	Absence End Date
7	DLT_INC_TYPE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Incident Type P=Industrial Acc. Sick Note R=Industrial Acc. No Sick Note
8	DLT_RELAPSE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Relapse 1=Accident 2=Relapse
9	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
10	DLT_CNO_ESP	Character(4)	VARCHAR2(4) NOT NULL	Occupational Code Prompt Table: DLT_CNO_ESP_VW
11	DLT_SEN_MONTH_ESP	Character(3)	VARCHAR2(3) NOT NULL	Seniority Months
12	DLT_SEN_DAYS_ESP	Character(2)	VARCHAR2(2) NOT NULL	Seniority Days
13	SCHEME_ID_ESP	Character(4)	VARCHAR2(4) NOT NULL	Scheme ID - ESP
14	DLT_NBR_OF_EMPL	Number(6,0)	INTEGER NOT NULL	Number of Employees in the company.
15	DLT_HIR	Character(1)	VARCHAR2(1) NOT NULL	Hiring Flag
16	DLT_ETT	Character(1)	VARCHAR2(1) NOT NULL	Temporary Work Company
17	DLT_PLACE_CODE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Place Code 1=Usual Work Center 2=Taken Journey 3=In Itinere 4=Other Work Center
18	COUNTRY_OTHER	Character(3)	VARCHAR2(3) NOT NULL	Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
19	STATE_OTHER	Character(6)	VARCHAR2(6) NOT NULL	State Other
20	CITY_OTHER	Character(30)	VARCHAR2(30) NOT NULL	City Other
21	ADDRESS1_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 1 Other
22	NUM1_OTHER	Character(6)	VARCHAR2(6) NOT NULL	Number 1 Other
23	DESCRLONG	Long Character	CLOB	Long Description
24	DLT_EMPL_COMP	Character(1)	VARCHAR2(1) NOT NULL	Center belongs to EE Company
25	DLT_OTHR_COMP	Character(1)	VARCHAR2(1) NOT NULL	External Company Y/N Table Edit
26	FISCAL_ID_CD4_ESP	Character(10)	VARCHAR2(10) NOT NULL	Fiscal ID Hiring
27	FISCAL_ID_CD2_ESP	Character(10)	VARCHAR2(10) NOT NULL	Fiscal ID ETT
28	FISCAL_ID_CD3_ESP	Character(10)	VARCHAR2(10) NOT NULL	Fiscal ID Other
29	DLT_DESCR_ESP	Character(200)	VARCHAR2(200) NOT NULL	TO BE DELETE
30	DLT_ADDRESS1_ESP	Character(60)	VARCHAR2(60) NOT NULL	Address Company
31	DLT_STATE_ESP	Character(2)	VARCHAR2(2) NOT NULL	State Company
32	DLT_CITY_ESP	Character(5)	VARCHAR2(5) NOT NULL	City Company
33	DLT_POSTAL_ESP	Character(5)	VARCHAR2(5) NOT NULL	Postal Company
34	DLT_PHONE_ESP	Character(14)	VARCHAR2(14) NOT NULL	Phone Company
35	DLT_STAFF_ESP	Character(5)	VARCHAR2(5) NOT NULL	Staff
36	DLT_SSN_EMPLER_ESP	Character(11)	VARCHAR2(11) NOT NULL	SSN Employer
37	INDSTRY_CD_ESP	Character(5)	VARCHAR2(5) NOT NULL	Industry Activity Code Prompt Table: INDSTRY_ACT_ESP
38	DLT_PLACE_TYPE_ESP	Character(3)	VARCHAR2(3) NOT NULL	Industrial Accident Place Type Prompt Table: DLT_PLC_ESP_VW
39	DLT_WORK_TYPE_ESP	Character(2)	VARCHAR2(2) NOT NULL	Work Type Prompt Table: DLT_WRK_ESP_VW
40	DLT_TASK_ESP	Character(2)	VARCHAR2(2) NOT NULL	Task Prompt Table: DLT_TSK_ESP_VW
41	DLT_USUAL_TOOL_ESP	Character(11)	VARCHAR2(11) NOT NULL	Usual Working Tool Prompt Table: DLT_TOOL_ESP_VW
42	DLT_INCHOUR_ESP	Character(2)	VARCHAR2(2) NOT NULL	Incident Time Delta
43	DLT_WORKHOUR_ESP	Character(2)	VARCHAR2(2) NOT NULL	Weeking Hour 0=In Itinere 1=Hour 1 10=Hour 10 11=Hour 11 12=Hour 12 2=Hour 2 3=Hour 3 4=Hour 4 5=Hour 5 6=Hour 6 7=Hour 7 8=Hour 8 9=Hour 9 99=In Itinere
44	DLT_INCWORK_ESP	Character(1)	VARCHAR2(1) NOT NULL	Usual Work
45	DLT_RISK_EVAL_ESP	Character(1)	VARCHAR2(1) NOT NULL	Risk Evaluation
46	DLT_DEVIATION_ESP	Character(2)	VARCHAR2(2) NOT NULL	Deviation Prompt Table: DLT_DEV_ESP_VW
47	DLT_CAUSE_ESP	Character(200)	VARCHAR2(200) NOT NULL	Cause
48	DLT_UNUS_TOOL_ESP	Character(11)	VARCHAR2(11) NOT NULL	Unusual Working Tool Prompt Table: DLT_TOOL_ESP_VW
49	DLT_SOURCE_ESP	Character(11)	VARCHAR2(11) NOT NULL	Source of Injury Prompt Table: DLT_TOOL_ESP_VW
50	DLT_EMPL_FLG_ESP	Character(1)	VARCHAR2(1) NOT NULL	Multiple Employees
51	DLT_WITNS_FLG_ESP	Character(1)	VARCHAR2(1) NOT NULL	Witness
52	DLT_WITNS_DATA_ESP	Character(50)	VARCHAR2(50) NOT NULL	Witness Data
53	DLT_INJURY_ESP	Character(3)	VARCHAR2(3) NOT NULL	Injury Prompt Table: DLT_INJ_ESP_VW
54	DLT_INJRY_GRD_ESP	Character(1)	VARCHAR2(1) NOT NULL	Injury Grade 1=Low Damage 2=High Damage 3=Very High Damage 4=Death
55	DLT_BODYPART_ESP	Character(8)	VARCHAR2(8) NOT NULL	Body Part Prompt Table: DLT_DIA_ESP_VW
56	DLT_CONTACT_ESP	Character(2)	VARCHAR2(2) NOT NULL	Contact Mode Prompt Table: DLT_CNT_ESP_VW
57	DLT_ASIST_TYPE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Assistance Type 1=Hospital 2=Ambulatory
58	CONTRIB_BASE_ESP	Number(19,6)	DECIMAL(18,6) NOT NULL	Common Contingency Base
59	CONTRIB_DAYS_ESP	Number(4,0)	SMALLINT NOT NULL	Contribution Days
60	REG_BASE_ESP	Number(9,2)	DECIMAL(8,2) NOT NULL	Regulatory Base
61	CONTRIB_OVER_ESP	Number(19,6)	DECIMAL(18,6) NOT NULL	Contribution Overtime
62	SUM_B1_B2_ESP	Number(15,2)	DECIMAL(14,2) NOT NULL	Sum Base1 and Base 2
63	AVERAGE_ESP	Number(9,2)	DECIMAL(8,2) NOT NULL	Average
64	AVERAGE_A_ESP	Number(9,2)	DECIMAL(8,2) NOT NULL	Average A
65	AVERAGE_B_ESP	Number(9,2)	DECIMAL(8,2) NOT NULL	Average B
66	AVERAGE_TOTAL_ESP	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Average Total
67	AVERAGE_BNFIT_ESP	Number(9,2)	DECIMAL(8,2) NOT NULL	Benefit
68	RESPONSIBLE_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Responsible Role
69	STATE2	Character(6)	VARCHAR2(6) NOT NULL	State
70	PRESENTED_DT	Date(10)	DATE	Evidence Presented
71	INSUR_COMP_CD_ESP	Character(5)	VARCHAR2(5) NOT NULL	Insurance Company Code
72	DAY_OF_WK	Character(1)	VARCHAR2(1) NOT NULL	Day of the Week 1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday
73	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
74	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number Prompt Table: ALL_CCC_ESP_VW
75	DLT_RAF_REASON_ESP	Character(2)	VARCHAR2(2) NOT NULL	Reason Discharge 00=Recovery 01=Death 02=Recovery 02=Recovery 03=Medical Inspection 03=Medical Inspection 04=Proposed Disability 05=Dead Line Expired 05=Dead Line Expired 06=Improvement 06=Improvement 07=Absence 08=Begin Maternity Leave 10=INSS Control 12 Months 10=INSS Control 12 Months 17=Recovery 18=Training Courses Absenteeism
76	DLT_RAF_GRD_ESP	Character(2)	VARCHAR2(2) NOT NULL	RAF Injuy Grade 1=Moderate 2=High Damage 3=Very High Damage 4=Death
77	DIAGNOSIS_CD	Character(6)	VARCHAR2(6) NOT NULL	Diagnosis Code Prompt Table: DLT_DIA_ESP_VW
78	DLT_COMP_TYPE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Company Type E=Temporary Work Company H=Hiring O=Other
79	DLT_OTH_ADDR_ESP	Character(40)	VARCHAR2(40) NOT NULL	Place Code
80	DLT_VIAKM_ESP	Character(40)	VARCHAR2(40) NOT NULL	Place Code
81	DLT_HOSPITALZD_ESP	Character(1)	VARCHAR2(1) NOT NULL	Place Code Y/N Table Edit Default Value: N
82	DLT_CNTR_BASE_ESP	Number(9,2)	DECIMAL(8,2) NOT NULL	Common Contingency Base
83	DLT_CNTR_OVER_ESP	Number(9,2)	DECIMAL(8,2) NOT NULL	Contribution Overtime
84	DLT_INCIDENT_NBR	Character(12)	VARCHAR2(12) NOT NULL	Delta File Number
85	DLT_REPORT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Delta Reporting Status 0=Not Communicated 1=XML Generated
86	DLT_RAF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Delta RAF Status. 0=Not Reported 1=XML Generated