DATETIME Fields
DATETIME type fields are 8 byte fields that include month, day, year, hours, minutes, and seconds information in a single field. Valid dates are {^0001-01-01} is January 1st, 1 A.D to {^9999-12-31}, December 31st, 9999 A.D., plus 00:00:00 AM to 11:59:59 PM.
DATETIME fields are separate from the Date and Time fields that are populated in FH based on the Date and Time record values. FH records entered before FH 6 will not have DATETIME values.
To populate DATETIME fields for the pre-FH 6 records, run FHRecalc.EXE located in the FH installation CD Tools folder. DATETIME fields may be useful in custom reports.
| Table Name | Field Name | Description | Sequence | Type | Length |
|---|---|---|---|---|---|
| ACC_HIST | DTTM | Date/Time | 5 | T | 8 |
| ACC_IPRT | DATE_TIME | Date/Time | 3 | T | 8 |
| ACT_MAIN | DTTM | Date/Time | 5 | T | 8 |
| ACT_MAIN | END_DTTM | End Date/Time | 8 | T | 8 |
| ATT_SIGN | SIGN_DTTM | Signed Date/Time | 5 | T | 8 |
| AUD_HIST | DATE_TIME | Date/Time | 4 | T | 8 |
| AUD_LOCK | LOCK_DTTM | Locked Date/Time | 5 | T | 8 |
| AUD_LOG | LOGIN | Login Date/Time | 4 | T | 8 |
| AUD_LOG | LOGOUT | Logout Date/Time | 5 | T | 8 |
| AUD_MAIN | DATE_TIME | Date Time | 3 | T | 8 |
| DIS_MAIN | ALM_DTTM | Alarm Date/Time | 6 | T | 8 |
| DIS_MAIN | DISP_DTTM | Dispatch Notified Date/Time | 40 | T | 8 |
| EMS_AUTH | DTTM | Date/Time | 10 | T | 8 |
| EMS_CARD | WIT_DTTM | Arrest Wit Date/Time | 34 | T | 8 |
| EMS_CARD | CPRINIT_DTTM | CPR Init Date/Time | 38 | T | 8 |
| EMS_CARD | CPRDISC_DTTM | CPR Discontinue Date/Time | 42 | T | 8 |
| EMS_CARD | DEFIB_DTTM | Defibrillation Date/Time | 46 | T | 8 |
| EMS_CARD | MED_DTTM | Med Admin Date/Time | 50 | T | 8 |
| EMS_CARD | SPON_DTTM | Spon Pulse Date/Time | 54 | T | 8 |
| EMS_MAIN | ALM_DTTM | Alarm Date/Time | 6 | T | 8 |
| EMS_MAIN | DISP_DTTM | Disp Notif Date/Time | 37 | T | 8 |
| EMS_MAIN | ARV_DTTM | Arrival Date/Time | 41 | T | 8 |
| EMS_MAIN | CLR_DTTM | Cleared Date/Time | 45 | T | 8 |
| EMS_MEDS | DTTM | Date/Time | 7 | T | 8 |
| EMS_PROC | DTTM | Date/Time | 7 | T | 8 |
| EMS_PTNT | NOTIF_DTTM | Unit Notified Date/Time | 34 | T | 8 |
| EMS_PTNT | ROLL_DTTM | Unit Enroute Date/Time | 38 | T | 8 |
| EMS_PTNT | CANCEL_DTTM | Cancel Date/Time | 43 | T | 8 |
| EMS_PTNT | ARV_DTTM | Arrival Date/Time | 47 | T | 8 |
| EMS_PTNT | PT_DTTM | Arrive Ptnt Date/Time | 51 | T | 8 |
| EMS_PTNT | LV_DTTM | Enroute to Dest Date/Time | 55 | T | 8 |
| EMS_PTNT | DEST_DTTM | Arrive Dest Date/Time | 59 | T | 8 |
| EMS_PTNT | CLR_DTTM | Cleared Date/Time | 63 | T | 8 |
| EMS_PTNT | IN_DTTM | In Service Date/Time | 67 | T | 8 |
| EMS_PTNT | ALS_DTTM | ALS Arrival Date/Time | 71 | T | 8 |
| EMS_PTNT | ONSET_DTTM | Onset Date/Time | 89 | T | 8 |
| EMS_VITA | DTTM | Date/Time | 7 | T | 8 |
| EXP_LOG | DATE_TIME | Export Date/Time | 2 | T | 8 |
| EXX_LOG | DATE_TIME | Export Date/Time | 3 | T | 8 |
| HYD_ACTV | DTTM | Date/Time | 6 | T | 8 |
| HYD_ACTV | END_DTTM | End Date/Time | 9 | T | 8 |
| HYD_HIST | DTTM | Date/Time | 5 | T | 8 |
| IMP_LOG | DATE_TIME | Date/Time | 2 | T | 8 |
| INC_17XX | SUP_NOTIF_DTTM | Supp Notif Date/Time | 7 | T | 8 |
| INC_17XX | SUP_ROLL_DTTM | Supp Roll Date/Time | 11 | T | 8 |
| INC_17XX | SUP_ARV_E_DTTM | Supp Eng Arv Date/Time | 15 | T | 8 |
| INC_17XX | SUP_ARV_F_DTTM | Supp Full Alm Arv Date/Time | 19 | T | 8 |
| INC_17XX | MED_NOTIF_DTTM | Med Notif Date/Time | 25 | T | 8 |
| INC_17XX | MED_ROLL_DTTM | Med Roll Date/Time | 29 | T | 8 |
| INC_17XX | MED_ARV_B_DTTM | Med BLS Arv Date/Time | 33 | T | 8 |
| INC_17XX | MED_ARV_A_DTTM | Med ALS Arv Date/Time | 37 | T | 8 |
| INC_17XX | ARV_RESRC_DTTM | Resc Arv Date/Time | 42 | T | 8 |
| INC_17XX | CAP_ATTACK_DTTM | Capability of Attack Date/Time | 46 | T | 8 |
| INC_ACHN | OUT_DTTM | Out Date/Time | 10 | T | 8 |
| INC_ACHN | IN_DTTM | In Date/Time | 13 | T | 8 |
| INC_AEVI | DTTM | Date/Time | 7 | T | 8 |
| INC_APIC | TAKEN_DTTM | Taken Date/Time | 9 | T | 8 |
| INC_AUTH | DTTM | Date/Time | 9 | T | 8 |
| INC_CCAS | INJ_DTTM | Injury Date/Time | 18 | T | 8 |
| INC_FCAS | INJ_DTTM | Injury Date/Time | 19 | T | 8 |
| INC_MAID | NOTIF_DTTM | Notified Date/Time | 14 | T | 8 |
| INC_MAID | CANCEL_DTTM | Cancel Date/Time | 19 | T | 8 |
| INC_MAID | ARV_DTTM | Arrival Date/Time | 23 | T | 8 |
| INC_MAID | CLR_DTTM | Cleared Date/Time | 27 | T | 8 |
| INC_MAIN | ALM_DTTM | Alarm Date/Time | 5 | T | 8 |
| INC_MAIN | DISP_DTTM | Dispatch Notified Date/Time | 39 | T | 8 |
| INC_MAIN | ARV_DTTM | Arrival Date/Time | 43 | T | 8 |
| INC_MAIN | CTRL_DTTM | Controlled Date/Time | 47 | T | 8 |
| INC_MAIN | CLR_DTTM | Cleared Date/Time | 51 | T | 8 |
| INC_UNIT | NOTIF_DTTM | Unit Notified Date/Time | 15 | T | 8 |
| INC_UNIT | ROLL_DTTM | Unit Enroute Date/Time | 19 | T | 8 |
| INC_UNIT | CANCEL_DTTM | Cancel Date/Time | 24 | T | 8 |
| INC_UNIT | ARV_DTTM | Arrival Date/Time | 28 | T | 8 |
| INC_UNIT | PT_DTTM | Arrived Ptnt Date/Time | 32 | T | 8 |
| INC_UNIT | LV_DTTM | Enroute to Dest Date/Time | 36 | T | 8 |
| INC_UNIT | DEST_DTTM | Arrived Dest Date/Time | 40 | T | 8 |
| INC_UNIT | CLR_DTTM | Cleared Date/Time | 44 | T | 8 |
| INC_UNIT | IN_DTTM | In Service Date/Time | 48 | T | 8 |
| INS_MAIN | START_DTTM | Start Date/Time | 12 | T | 8 |
| INS_MAIN | END_DTTM | End Date/Time | 13 | T | 8 |
| INV_MNT | DTTM | Date/Time | 11 | T | 8 |
| INV_MNT | END_DTTM | End Date/Time | 14 | T | 8 |
| INV_USE | DTTM | Date/Time | 12 | T | 8 |
| JNL_EVNT | DTTM | Date/Time | 4 | T | 8 |
| JNL_EVNT | END_DTTM | End Date/Time | 7 | T | 8 |
| OCC_HIST | DTTM | Date/Time | 5 | T | 8 |
| PDA_LOG | DATE_TIME | DateTime of Log Entry | 3 | T | 8 |
| REM_NOTE | DTTM | Date/Time | 4 | T | 8 |
| SCH_EXCH | START_DTIME | Start DateTime | 8 | T | 8 |
| SCH_EXCH | END_DTIME | End DateTime | 9 | T | 8 |
| SCH_EXCH | REQUESTED | Requested Date | 11 | T | 8 |
| SCH_EXCH | APPROVED | Approved Date | 12 | T | 8 |
| SCH_MAIN | START_DTTM | Start Date/Time | 6 | T | 8 |
| STF_AVL | FROM_DTTM | From Date/Time | 7 | T | 8 |
| STF_AVL | TO_DTTM | To Date/Time | 8 | T | 8 |
| STF_HIST | ACT_DTTM | Date/Time | 5 | T | 8 |
| STA_EXPO | DATE_TIME | Date Time | 3 | T | 8 |
| STA_IMPO | IMP_START | Start Date/Time | 5 | T | 8 |
| STA_IMPO | IMP_COMPLETE | Completed Date/Time | 6 | T | 8 |
| TSK_LOG | DATE_TIME | Date/Time | 3 | T | 8 |
| TSK_MAIN | LAST_DTTM | Last Date/Time | 13 | T | 8 |
| TRN_MAIN | DTTM | Date/Time | 10 | T | 8 |
| TRN_MAIN | END_DTTM | End Date/Time | 13 | T | 8 |
| VEN_HIST | DTTM | Date/Time | 5 | T | 8 |
| SYS_UPDT | LAST_UPDT | Last Updated Date/Time | 2 | T | 8 |
| SYS_WKUP | LAST_UPDT | Last Updated | 5 | T | 8 |
| GRA_MAIN | MOD_DTTM | Last Modified Date/Time | 14 | T | 8 |
| MAP_MAIN | MOD_DTTM | Last Modified Date/Time | 12 | T | 8 |
| REP_FILE | LAST_UPDT | Last Updated | 2 | T | 8 |
| REP_MAIN | MOD_DTTM | Last Modified Date/Time | 19 | T | 8 |
| QRY_MAIN | MOD_DTTM | Last Modified Date/Time | 20 | T | 8 |