|
|
|
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_DESCRIPTION |
| IBRS Data Element |
Access Field Name |
Type |
Size |
| ORI Number & Incident
Number |
UID |
Text |
21 |
| Type Property Loss/Etc. |
TYPE_LOSS |
Text |
1 |
| Property Sequence Number
(not an IBRS element) |
PROP_SEQ_NO |
Long Integer |
|
| Property Description |
DESCR |
Text |
1 |
| Property Value |
VALU |
Long Integer |
|
| Property Recovery Year |
RECOV_YYYY |
Long Integer |
|
| Property Recovery Month |
RECOV_MM |
Long Integer |
|
| Property Recovery Day |
RECOV_DD |
Long Integer |
|
|