|
|
|
ACCESS PROPERTY DRUG TABLE
The table below outlines the structure of the Property Drug Table, resulting from
normalizing the Property Table in ACCESS.
| IBRS Property Segment 03 |
| Access Table
PROPERTY_DRUG |
| IBRS Data Element |
Access Field Name |
Type |
Size |
| ORI Number & Incident
Number |
UID |
Text |
21 |
| Type Property Loss/Etc. |
TYPE_LOSS |
Text |
1 |
| Drug Sequence Number (not an
IBRS element) |
DRUG_SEQ_NO |
Long Integer |
|
| Suspected Drug Type |
DRUG |
Text |
1 |
| Estimated Drug Quantity |
DRUG_QUANT |
Double |
8 |
| Type Drug Measurement |
MEAS |
Text |
2 |
|