<< Previous Appendix AS, ED, IP X12-837 Input / IP Output / OP Output Next Appendix >>

APPENDIX V-SPARCS Inpatient Master File Description

NOTE:  Bolded and UPPER CASE are IDENTIFYING DATA ELEMENTS see SPARCS Data Access

FILE NAME:  SPARCS Inpatient Master File Description
FILE SORT SEQUENCE:  Record Key RECORD LENGTH:  3000
SOURCE OF DATA:  SPARCS Data Submissions
POSITION FIELD
DATA ELEMENT NAME FROM TO SIZE TYPE
RECORD LENGTH 1 3000 3000 REC
RECORD KEY (First 100 characters of both MAIN RECORD and SERVICE LINE DATA) 1 100 100 KEY
Facility Identifier 1 6 6 A/N
PATIENT CONTROL NUMBER 7 26 20 A/N
MEDICAL RECORD NUMBER 27 43 17 A/N
ADMISSION DATE 44 51 8 NUM
DISCHARGE DATE 52 59 8 NUM
Filler 60 61 2 A/N
Record Sequence Number 62 64 3 NUM
Record Sequence Count 65 67 3 NUM
Log Number 68 73 6 NUM
Transaction Code 74 74 1 A/N
Claim Type 75 75 1 A/N
Emergency Department Indicator 76 76 1 A/N
Date Processed 77 84 8 A/N
SPARCS Region 85 86 2 A/N
Claim ID 87 98 12 A/N
Key Area Filler 99 100 2 A/N
MAIN RECORD 101 300 2900
RECORD KEY (see definitions above) 1 100 100 KEY
Patient Sex 101 101 1 A/N
PATIENT BIRTH DATE 102 109 8 NUM
Patient Race 110 111 2 A/N
Patient Ethnicity 112 112 1 A/N
PATIENT RESIDENCE ADDRESS - ADDRESS LINE 1 113 130 18 A/N
PATIENT RESIDENCE ADDRESS - ADDRESS LINE 2 131 148 18 A/N
Patient City 149 163 15 A/N
Patient State 164 165 2 A/N
Patient Postal Service Zip Code and EXTENSION CODE 166 174 9 A/N
Patient County Code 175 176 2 NUM
Patient Age 177 179 3 NUM
Patient Age in Days 180 182 3 NUM
Patient Age Group 183 183 1 A/N
UNIQUE PERSONAL IDENTIFIER 184 193 10 A/N
STATEMENT COVERS PERIOD FROM DATE 194 201 8 NUM
STATEMENT COVERS PERIOD THRU DATE 202 209 8 NUM
Admission Hour 210 211 2 NUM
Discharge Hour 212 213 2 NUM
Patient Discharge Status 214 215 2 A/N
Type of Bill 216 218 3 A/N
Accident Related Code 219 220 2 A/N
ACCIDENT RELATED DATE 221 228 8 NUM
Method of Anesthesia Used 229 230 2 NUM
ATTENDING PHYSICIAN 1 STATE LICENSE NUMBER 231 238 8 A/N
OPERATING PHYSICIAN 2 STATE LICENSE NUMBER 239 246 8 A/N
OTHER PHYSICIAN 3 STATE LICENSE NUMBER 247 254 8 A/N
Age Warning Flag 255 255 1 A/N
Procedure Date Warning Flag 256 256 1 A/N
AMI Warning Flag 257 257 1 NUM
AMI Heart Rate 258 260 3 NUM
AMI BP Systolic 261 263 3 NUM
AMI BP Diastolic 264 266 3 NUM
Residence Indicator 267 267 1 A/N
Facility NPI 268 277 10 NUM
Same Day Discharge Indicator 278 278 1 A/N
Admit Weekday 279 281 3 A/N
Discharge Weekday 282 284 3 A/N
Newborn Flag 285 285 1 A/N
AIDS/HIV Flag 286 286 1 A/N
Abortion Flag 287 287 1 A/N
Diagnosis Data (8 Occurs 25X) 288 487 200 A/N
Diagnosis Code 7 A/N
Present on Admission Indicator 1 A/N
Admitting Diagnosis Code 488 494 7 A/N
External Cause-of-Injury Code 495 501 7 A/N
Place-of-Injury Code 502 508 7 A/N
Coding Method 509 509 1 A/N
CCS Diagnosis Category 510 512 3 A/N
CCS Procedure Category 513 515 3 A/N
Expected Principal Reimbursement 516 517 2 A/N
Source of Payment Typology 1 518 522 5 NUM
Source of Payment Typology 2 523 527 5 NUM
Source of Payment Typology 3 528 532 5 NUM
Source of Payment Information (43 Occurs 6X) 533 790 258 A/N
Source of Payment Code 1 A/N
POLICY NUMBER 19 A/N
Payor Identification Number 8 A/N
Claim Filing Indicator 2 A/N
Provider Identification Number 13 A/N
Total Charges 791 802 12 NUM
Total Non-Covered Charges 803 814 12 NUM
Filler 815 822 8 NUM
SPARCS Collector Code 823 825 3 NUM
Source File Type 826 826 1 NUM
Facility Name 827 896 70 A/N
Health Service Area Code 897 897 1 NUM
Hospital County Code 898 899 2 NUM
Operating Certificate Number 900 906 7 NUM
Filler 907 919 13 A/N
Race/Ethnicity Codes (9 Occurs 10X) 920 1009 90 A/N
Race/Ethnicity Code 9 A/N
Patient ID 1010 1021 12 A/N
Common Area Filler 1022 1300 279 A/N
Expected Reimbursement Other 1 1301 1302 2 A/N
Expected Reimbursement Other 2 1303 1304 2 A/N
Blood Furnished Amount 1305 1313 9 NUM
Type of Admission 1314 1314 1 A/N
Source of Admission / Point of Origin 1315 1315 1 A/N
Emergency Department Admission Indicator 1316 1316 1 A/N
Alternate Level of Care Days 1317 1320 4 NUM
MOTHER'S MEDICAL RECORD NUMBER FOR NEWBORN CHILD 1321 1337 17 A/N
NEONATE BIRTH WEIGHT 1338 1341 4 NUM
Total Leave of Absence Days 1342 1345 4 NUM
Special Program (DIS) 1346 1346 1 A/N
Special Program (FP) 1347 1347 1 A/N
Special Program (PHC) 1348 1348 1 A/N
Special Program (SFP) 1349 1349 1 A/N
Workers' Compensation/No Fault Indicator 1350 1351 2 A/N
Workers' Compensation/No Fault Amount 1352 1360 9 NUM
Surplus, Catastrophic, or Recurring Monthly Income Code 1361 1361 1 A/N
Surplus, Catastrophic, or Recurring Monthly Income Amount 1362 1370 9 NUM
Exempt Unit Indicator 1371 1373 3 A/N
Length of Stay 1374 1377 4 NUM
Service Category Group 1378 1378 1 A/N
Covered Days 1379 1382 4 NUM
Non-Covered Days 1383 1386 4 NUM
Procedure Data Information (24 Occurs 15X) 1387 1746 360 A/N
Procedure Code 7 A/N
Procedure Date 8 A/N
Pre-Admit Indicator 1 A/N
Pre-Operative Days 4 A/N
Post-Operative Days 4 A/N
Diagnosis Related Group (DRG) Data Information (8 Occurs 9X) 1747 1818 72 A/N
Total Accommodations Charges 1819 1828 10 NUM
Total Accommodations Non-Covered Charges 1829 1838 10 NUM
Total Inpatient Ancillary Charges 1839 1848 10 NUM
Total Inpatient Ancillary Non-Covered Charges 1849 1858 10 NUM
Inpatient Area Filler 1859 1900 42 A/N
Old SPARCS Accommodation Codes (4 Occurs 50X) 1901 2100 200 A/N
Accommodation Code 4 A/N
Filler 2101 2102 2 A/N
PFI Check Digit 2103 2103 1 A/N
Type of Alternate Care Required 2104 2104 1 A/N
DATE ALTERNATE CARE REQUIRED 2105 2112 8 NUM
Unscheduled/Scheduled Admission 2113 2113 1 A/N
Alternate Level of Care Days (4 Occurs 6X) 2114 2137 24 NUM
Leave of Absence Days (4 Occurs 6X) 2138 2161 24 NUM
Covered Days (4 Occurs 6X) 2162 2185 24 NUM
Non-Covered Days (4 Occurs 6X) 2186 2209 24 NUM
After Anesthesia Indicator (1 Occurs 14X) 2210 2223 14 A/N
Placement of Bed Indicator 2224 2226 3 A/N
Total Acute Certified Days 2227 2230 4 NUM
DRG Number Billed 2231 2234 4 A/N
Do Not Resuscitate Indicator 2235 2235 1 A/N
Filler 2236 2255 20 A/N
PRE-HOSPITAL CARE REPORT NUMBER 2256 2263 8 A/N
Filler 2264 2400 137 A/N
Non-Acute Care Group (18 Occurs 30X) 2401 2940 540 A/N
Non-Acute Care Type 2 A/N
NON-ACUTE CARE FROM DATE 8 A/N
NON-ACUTE CARE THROUGH DATE 8 A/N
NAC Filler 2941 3000 60 A/N
SERVICE LINE DATA RECORDS
RECORD KEY (see definitions above) 1 100 100 KEY
Overflow Type = "IPREV" 101 105 5 A/N
Overflow Filler Area 106 120 15 A/N
Service Lines (64 occurs 45) 121 3000 2880 SERVICE LINE

SERVICE LINE - Overflow Type = "IPREV" (64)
Revenue Code 1 4 4 A/N
Revenue Type 5 5 1 A/N
Filler 6 10 5 A/N
Filler 11 12 2 A/N
Filler 13 14 2 A/N
Service Charge 15 24 10 NUM
Unit Type 25 25 2 A/N
Unit Quantity 27 34 8 NUM
Non-Covered Charge 35 44 10 NUM
Filler 45 52 8 A/N
Service Line Filler 53 64 12 A/N