Division of Federal Employees' Compensation (DFEC)
New Case Management Data Extract File Layout
Field # |
Name |
Field Type |
Description |
Value/Format |
1 |
EXTRACT-RECORD-TYPE |
CHAR(1) |
Record type identifier |
C = Change; D = Delete |
2 |
CASE-NUMBER |
CHAR(9) |
Unique identifier assigned by OWCP |
|
3 |
CASE-TYPE |
CHAR(1) |
Indicates the relationship between this case and associated cases for the same employee |
I = Independent; M = Master; |
4 |
CASE-PTR |
CHAR(9) |
Uses the Case Type field to map cases to the master case |
If Case Type = M, Case Pointer = total number of subsidiary cases associated with this master case |
5 |
LAST-NAME |
CHAR(20) |
Employee’s Last Name |
|
6 |
FIRST-NAME |
CHAR(20) |
Employee’s First Name |
|
7 |
MIDDLE-NAME |
CHAR(20) |
Employee’s Middle Name |
|
8 |
SEX |
CHAR(1) |
Employee’s Gender |
F = Female; M = Male |
9 |
SSN |
CHAR(9) |
Employee’s Social Security Number |
|
10 |
DOB |
DATE (8) |
Employee’s Date of Birth |
YYYYMMDD |
11 |
DOD |
DATE (8) |
Employee’s Date of Death |
YYYYMMDD |
12 |
ADDR-1 |
CHAR(70) |
Employee’s Address Field 1 |
Employee’s address |
13 |
ADDR-2 |
CHAR(70) |
Employee’s Address Field 2 |
Address continued |
14 |
ADDR-3 |
CHAR(70) |
Employee’s Address Field 3 |
Address continued |
15 |
CITY |
CHAR(20) |
Employee’s City |
Address city |
16 |
STATE |
CHAR(2) |
Employee’s State |
State abbreviation code |
17 |
ZIP |
CHAR(9) |
Employee’s Zip Code |
Postal Zip Code |
18 |
PHONE-NUMBER |
CHAR(10) |
Employee’s Phone Number |
Area Code + Phone Number |
19 |
EMP-DOI |
DATE (8) |
Employee’s Date of Injury |
YYYYMMDD |
20 |
INJ-ZIP |
CHAR(9) |
Zip Code of location where injury occurred |
Postal Zip Code |
21 |
EXTENT-OF-INJ |
CHAR(1) |
Indicates seriousness of injury |
0 = fatal; 1 = no time lost |
22 |
FATAL-IND |
CHAR(1) |
For fatal cases indicates claimed relationship of employee’s death to employment |
0 = Not Related to Injury |
23 |
ANAT-LOCN-CODE |
CHAR(2) |
Indicates the anatomical location of the reported injury/condition |
See Appendix |
24 |
NATURE-CODE |
CHAR(2) |
Nature of Injury Code |
See Appendix |
25 |
CAUSE-CODE |
CHAR(2) |
Cause of Injury Code |
See Appendix |
26 |
FORMS-RECVD |
CHAR(1) |
Indicates claim form type of used |
1 = CA-1; 2 = CA-2; 5 = CA-5 |
27 |
LOST-TIME-FLAG |
CHAR(1) |
Lost Time (Per CA-1 Filing Instructions) |
Y= Yes; N =No |
New Case Management Data Extract File Layout
Field # |
Name |
Field Type |
Description |
Value/Format |
28 |
NLT-NO-EXPENSE-FLAG |
CHAR(1) |
No Lost Time, No Medical Expense Incurred (Per CA-1 Filing Instructions) |
Y= Yes; N =No |
29 |
NLT-YES-EXPENSE-FLAG |
CHAR(1) |
No Lost Time, Medical Expense Incurred (Per CA-1 Filing Instructions) |
Y= Yes; N =No |
30 |
FIRST-AID-INJURY-FLAG |
CHAR(1) |
First Aid Injury (Per CA-1 Filing Instructions) |
Y= Yes; N =No |
31 |
INJURED-IN-POD-FLAG |
CHAR(1) |
Injured during performance of duty indicator (Per CA-1 Report) |
Y= Yes; N =No |
32 |
COP-FLAG |
CHAR(1) |
Claimant utilized Continuation of Pay benefits (Per CA-1 Report) |
Y= Yes; N =No |
33 |
CNTRVTD-IND |
CHAR(1) |
COP claim controverted by agency (Per CA-1 Report) |
Y= Yes; N =No |
34 |
PAY-STOPPED-DT |
DATE (8) |
Date employee’s pay stopped |
YYYYMMDD |
35 |
DEPENDENT-FLAG |
CHAR(1) |
Employee has Dependent(s) |
Y= Yes; N =No |
36 |
PAY-GRADE |
CHAR(4) |
Grade at time of injury |
e.g., GS09, WG10 |
37 |
PAY-STEP |
CHAR(4) |
Step at time of injury |
|
38 |
OCC-CODE |
CHAR(5) |
Indicates employee’s occupation code at time of injury |
See Appendix |
39 |
INJURY-TYPE-CODE |
CHAR(3) |
Indicates type of injury reported |
See Appendix |
40 |
INJURY-SOURCE-CODE |
CHAR(4) |
Indicates source of reported injury |
See Appendix |
41 |
DEPT-AGENCY-CODE |
CHAR(6) |
Agency Code and Agency Building Code |
4 digits plus 2 alpha-numeric |
42 |
AGENCY-RECEIVED-DT |
DATE (8) |
Date CA-1/CA-2 claim was received by employing agency |
YYYYMMDD |
43 |
DOL-RECEIVED-DATE |
DATE (8) |
Date claim was received by OWCP |
YYYYMMDD |
44 |
DATE-CASE-CREATED |
DATE (8) |
Date the case was created by OWCP |
YYYYMMDD |
45 |
SFC-FLAG |
CHAR(1) |
Administrative acceptance and Short Form Closure of eligible traumatic injury case at time of creation |
Y = Currently a Short Form Closure case; |
46 |
SFC-REOPEN-CODE |
CHAR(1) |
Short Form Closure reopen code |
See Appendix |
47 |
SFC-REOPEN-DATE |
DATE (8) |
Short Form Closure reopen date |
YYYYMMDD |
48 |
REP-ACCPT-COND |
CHAR(45) |
Reported condition or accepted diagnosis |
Narrative, or up to 6 ICD-9 codes |
49 |
THIRD-PARTY-IND |
CHAR(2) |
Indicator of Third Party Status |
See Appendix |
50 |
THIRD-PARTY-DATE |
DATE (8) |
Third Party Status Date |
YYYYMMDD |
CURR-ADJUD-STATUS |
CHAR(2) |
Current Adjudication Status |
See Appendix |
|
52 |
CURR-ADJUD-STATUS-DATE |
DATE (8) |
Current Adjudication Status Date |
YYYYMMDD |
New Case Management Data Extract File Layout
Field # |
Name |
Field Type |
Description |
Value/Format |
53 |
CURR-CASE-STATUS |
CHAR(2) |
Current Case Status |
See Appendix |
54 |
CURR-CASE-STATUS-DATE |
DATE (8) |
Current Case Status Date |
YYYYMMDD |
55 |
PREV-CASE-STATUS |
CHAR(2) |
Previous Case Status |
See Appendix |
56 |
PREV-CASE-STATUS-DATE |
DATE (8) |
Previous Case Status Date |
YYYYMMDD |
57 |
PREV-ADJUD-STATUS |
CHAR(2) |
Previous Adjudication Status |
See Appendix |
58 |
PREV-ADJUD-DATE |
DATE (8) |
Previous Adjudication Status date |
YYYYMMDD |
59 |
INIT-ADJUD-STATUS |
CHAR(2) |
Initial Adjudication Status |
See Appendix |
60 |
INIT-ADJUD-DATE |
DATE (8) |
Initial Adjudication Status Date |
YYYYMMDD |
61 |
DATE-CLOSED |
DATE (8) |
Date the case was last closed (after previous not closed status) |
YYYYMMDD |
62 |
DATE-REOPENED |
DATE (8) |
Date the case was last reopened (after previous closed status) |
YYYYMMDD |
63 |
COMP-CLAIM-DATE |
DATE (8) |
First CA-7 Claim Received Date |
YYYYMMDD |
64 |
WAGE-LOSS-DATE |
DATE (8) |
Indicates the date wage loss began |
YYYYMMDD |
65 |
QCM-FLAG |
CHAR(1) |
Indicates case is under Quality Case Management (QCM) tracking |
Y = Yes; N = No |
66 |
RECURRENCE-NUMBER |
CHAR(2) |
Recurrence claim received number (last) |
00 – 99 |
67 |
RTW-CODE |
CHAR(2) |
Indicates Return To Work information |
See Appendix |
68 |
RTW-DATE |
DATE (8) |
Return To Work Date |
YYYYMMDD |
69 |
PRM-FLAG |
CHAR(1) |
Indicates case is under Periodic Roll Management (PRM) tracking |
Y = Yes; N = No |
70 |
REHAB-IND |
CHAR(1) |
Indicates Vocational Rehabilitation Status |
See Appendix |
71 |
REHAB-DATE |
DATE (8) |
Vocational Rehabilitation Status Date |
YYYYMMDD |
72 |
RCE-ID |
CHAR(3) |
Responsible Claims Examiner Code |
YYYYMMDD |
73 |
DIST-OFFICE-NUMBER |
CHAR(2) |
District Office Number |
See Appendix |
74 |
DATE-LAST-CHANGE |
DATE (8) |
Date of last record update |
YYYYMMDD |
Including 74 field delimiters, the maximum possible record length is 706 (col 26 changed to CHAR(1)).
APPENDIX
Anatomical Location Codes
A1 = Single Upper Arm |
F1 = Single First Finger |
R1 = Single Clavicle/Collar Bone |
APPENDIX
Nature of Injury Codes
99 = OTHER (DISEASE)
C9 = CARDIOVASCULAR DISEASE, OTHER
CA = ANGINA
CB = BLOOD DISORDER
CH = HYPERTENSION
CM = MYOCARDIAL INFARCTION
CP = VARICOSE VEINS, PHLEBITIS, THROMBOPHLEBITIS
CS = CEREBROVASCULAR ACCIDENT
D1 = PARALYSIS, ONE LIMB
DA = HEADACHES
DB = SEIZURES, CONVULSIONS
DC = COMA
DE = OCCUPATIONAL EXPOSURE TO CHEMICALS/TOXINS/BIOLOGICAL SUBSTANCE, ETC.
DF = GENERAL SYMPTOMS: SYNCOPE, DIZZINESS, VERTIGO, FATIGUE, NUMBNESS OF BODY PART
DH = HEARING LOSS
DI = LOSS OF VISION
DM = MENTAL, EMOTIONAL, NERVOUS CONDITIONS
DN = NERVE CONDITION (INCLUDING PARALYSIS) AFTER EXPOSURE TO TOXINS
DR = EFFECTS OF EXPOSURE TO RADIATION
DT = TUMORS, CANCER AND RELATED CONDITIONS
G9 = GASTROINTESTINAL CONDITION, NOT SPECIFIED
GD = DIARRHEA, WITH/WITHOUT VOMITING
GH = HERNIA, HIATAL
GO = HERNIA, OTHER
GP = ABDOMINAL PAIN
GU = ULCER, GASTRIC, DUODENAL, PEPTIC
M9 = MUSCULOSKELETAL CONDITION, OTHER
MA = ARTHRITIS/OSTEOARTHRITIS
MB = BACK SPRAIN/STRAIN, BACK PAIN, SUBLUXATION
MC = CARPAL TUNNEL SYNDROME/CUBITAL TUNNEL SYNDROME
MD = INTERVERTEBRAL DISC DISORDERS
MI = CONDITIONS OF TENDONS, ETC.
MK = CHONDROMALACIA
MP = PAIN/SWELLING/STIFFNESS/REDNESS IN JOINT
MS = PAIN/SWELLING/STIFFNESS/REDNESS NOT IN JOINT
OF = FOOD POISONING
OG = TOOTH AND GUM PROBLEMS
OL = HERNIA, INGUINAL
OP = PREGNANCY (PEACE CORPS ONLY)
R9 = RESPIRATORY CONDITION, OTHER
RA = ASBESTOSIS
RB = BRONCHITIS
RC = ASTHMA
RE = EMPHYSEMA
RP = PNEUMOCONIOSIS
RR = REACTION TO SMOKE, FUMES, CHEMICALS
RS = SILICOSIS
S9 = SKIN CONDITION, OTHER
SB = CONTACT DERMATITIS
SC = CHEMICAL
SL = CALLUS, CORN
T0 = NO INJURY STATED
T1 = NERVOUS SYSTEM INJURIES
T2 = ACOUSTIC TRAUMA
T3 = CARDIOVASCULAR CONDITIONS
T4 = MENTAL, EMOTIONAL, NERVOUS CONDITIONS
T5 = HEADACHES
T6 = DEATH SUDDEN/VIOLENT
T7 = GENERAL SYMPTOMS
T8 = TRAUMATIC INJURY - UNCLASS. (EXCEPT DISEASE, ILLNESS)
TA = AMPUTATION
TB = BACK SPRAIN/STRAIN, BACK PAIN, SUBLUXATION, IVD DISORDERS
TC = CONTUSION
TD = DISLOCATION
TE = INJURY DUE TO ENVIRONMENTAL CAUSES
TF = FRACTURE
TG = EFFECTS OF ELECTRICAL CURRENT
TH = INGUINAL HERNIA
TI = SKIN CONDITIONS: ALLERGY, ECZEMA, DERMATITIS
TJ = CRUSH INJURY
TK = CONCUSSION
TL = LACERATION
TM = EXPOSURE TO ALL CHEMICAL OR BIOLOGICAL CAUSES
TN = SUPERFICIAL WOUNDS
TO = PAIN, SWELLING, REDNESS, STIFFNESS, NOT IN JOINT
TP = PUNCTURE WOUND
TQ = GASTROINTESTINAL CONDITIONS
TR = RESPIRATORY CONDITIONS
TS = SPRAIN/STRAIN OF LIGAMENT, MUSCLE, TENDON, NOT BACK
TT = INJURIES TO TEETH
TU = BURNS
TV = FOREIGN BODY IN ANY BODY PART
TW = TB INCLUDING EXPOSURE AND POSITIVE SKIN TEST
TX = INFECTIOUS DISEASES: BACTERIA, VIRUSES, PARASITES
TY = INSECT BITE
TZ = PAIN/SWELLING/STIFFNESS/REDNESS IN JOINT
V1 = FEVER, WITH OR WITHOUT CHILLS, FATIGUE, ETC.
V9 = INFECTIOUS OR PARASITIC DISEASE, OTHER
VA = ACQUIRED IMMUNE DEFICIENCY SYNDROME (AIDS)
VB = BRUCELLOSIS
VC = COCCIDIODOMYCOSIS
VD = ANTHRAX
VF = RABIES (INCLUDES EXPOSURE)
VH = HEPATITIS
VL = LYME DISEASE
VM = MALARIA
VP = PARASITIC DISEASES
VR = ROCKY MOUNTAIN SPOTTED FEVER
VS = STAPHYLOCOCCUS
VT = TB INCLUDING EXPOSURE AND POSITIVE SKIN TEST
APPENDIX
Cause of Injury Codes
00 = Legacy Case Use |
47 = Handling Tool Boxes |
APPENDIX
Occupation Codes
01 = Aeronautics Engineer |
51 =Meat Cutter |
APPENDIX
Injury Type Codes
100 = Struck |
320 = Caught in |
600 = Exertion |
APPENDIX
Source of Injury Codes
0100 = Building or Working Area |
0610 = Dust (Silica, Coal, Grain, Cotton) |
APPENDIX
Lost Time/No Lost Time Reopen Codes
1 = Reopened SFC: medical bills exceed $1500
2 = Reopened SFC: compensation claim received
3 = Reopened SFC: case controverted
4 = Reopened SFC: other reason
C = Reopened SFC: "referred" cop/rtw case with no rtw
U = Reopened SFC: Surgery required
V = Reopened SFC: Date of first treatment is less than DOI
X = Reopened SFC: Recurrence claim received
Y = Reopened SFC: RTW date is missing
Z = Reopened SFC: RTW = Less than regular duty full time restrictions within 14 days of TCM call
APPENDIX
Third Party Indicator Codes
00 = no third party potential
01 = identified as third party not referred to sol
02 = referred to solicitor
03 = usps case, responsibility of usps
04 = closed - minor not economical to pursue
05 = closed - other
06 = settled - no refund due
07 = settled - refund not received
08 = settled - refund received no credit remaining
09 = settled - refund received credit against future compensation
10 = closed - the applicable statute of limitation has expired
11 = closed - the negligent 3rd party can not be identified
12 = closed - the negligent 3rd party has left the jurisdiction and recovery can not be pursued
13 = closed - the negligent 3rd party has no assets from which recovery can be made
14 = closed - the 3rd party identified is clearly not liable
APPENDIX
Adjudication Status Codes
00 = No Status |
D1 = Denied - Time Limitations Expired |
APPENDIX
Case Status Codes
C1 = Closed - No Time Lost |
ON = Overpayment - Compensation Terminated |
APPENDIX
Return to Work Codes
FF = Full duty, full time |
NL = No lost tine |
APPENDIX
Rehabilitation Indicator Codes
1 = Closed on referral |
I = Plan Approved |
APPENDIX
District Office Number
01 = Boston
02 = New York
03 = Philadelphia
06 = Jacksonville
09 = Cleveland
10 = Chicago
11 = Kansas City
12 = Denver
13 = San Francisco
14 = Seattle
16 = Dallas
25 = Washington
50 = National Office