| Name | Description | Type | Additional information |
|---|---|---|---|
| investigationId | integer |
None. |
|
| typeId | integer |
None. |
|
| typeName | string |
None. |
|
| facilityId | integer |
None. |
|
| facilityName | string |
None. |
|
| facilityAddr1 | string |
None. |
|
| facilityAddr2 | string |
None. |
|
| facilityCity | string |
None. |
|
| facilityState | string |
None. |
|
| facilityZip | integer |
None. |
|
| staffId | integer |
None. |
|
| staffName | string |
None. |
|
| actionId | integer |
None. |
|
| actionName | string |
None. |
|
| dateJCDH | date |
None. |
|
| dateADPH | date |
None. |
|
| dateDue | date |
None. |
|
| dateClosed | date |
None. |
|
| dateTurnedIn | date |
None. |
|
| dateExitInt | date |
None. |
|
| dateFinalReport | date |
None. |
|
| dateEntered | date |
None. |
|
| notes | string |
None. |