 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
ACCESS ADMINISTRATIVE TABLE
The table below outlines the structure of the resulting Administrative Table in ACCESS.
IBRS Administrative Segment 01 |
|||
Access Table ADMINISTRATIVE |
|||
IBRS Data Element |
Access Field Name |
Type |
Size |
Segment Level |
SEG |
Text |
2 |
ORI Number & Incident Number |
UID |
Text |
21 |
Incident Year |
INC_YYYY |
Long Integer |
|
Incident Month |
INC_MM |
Long Integer |
|
Incident Day |
INC_DD |
Long Integer |
|
Report Date Indicator |
RPTDT_INDIC |
Text |
1 |
Incident Hour |
INC_HR |
Long Integer |
|
Cleared Exceptionally |
CLR_EX |
Text |
1 |
Exceptional Clearance Year |
CLR_EX_YYYY |
Long Integer |
|
Exceptional Clearance Month |
CLR_EX_MM |
Long Integer |
|
Exceptional Clearance Day |
CLR_EX_DD |
Long Integer |
|