Analytics Data Dictionary
Data Dictionary Version | 5.1 |
|---|---|
Version Date | Jul 23, 2018 |
COLUMN NAME | DISPLAY NAME | Page |
|---|
COLUMN NAME | DISPLAY NAME | Page |
|---|---|---|
ACTIVITY_AUDIT | Activity Audit | Page 9 - Misc Forms |
ALS_ASSESSMENT_ID | 0 | 0 |
ALS_ASSESSMENT_NAME | Name | Page 2 - CC/HPI |
ALS_RULEOUT | ALS Ruleout | Page 2 - CC/HPI |
BASE_ID | 0 | 0 |
BASE_NAME | Basesite | Page 1 - Dispatch Information |
BELONGINGS | Belongings | Page 2 - CC/HPI |
CATEGORY_ID | 0 | 0 |
CATEGORY_NAME | Medical Category | Page 1 - Dispatch Information |
CC | Chief Complaint | Page 2 - CC/HPI |
CCDURATION | Chief Complaint Duration | Page 2 - CC/HPI |
CCDURUNITS_ID | 0 | 0 |
CCDURUNITS_NAME | Chief Complaint Duration Units | Page 2 - CC/HPI |
CMDFAC_ID | 0 | 0 |
CMDFAC_NAME | Command Facility | Page 1 - Dispatch Information |
CMN_CONSENT_ID | 0 | 0 |
CMN_CONSENT_NAME | PCS / Medical Necessity Signed | Patient Page |
CMS_SVCLEVEL_ID | 0 | 0 |
CMS_SVCLEVEL_NAME | CMS Service Level | Chart Summary |
CREATED_BY | Created By | Misc |
CREATED_BY_ID | 0 | 0 |
CREATED_WHEN | Created When | Misc |
CREW_ALS | Crew ALS | Page 1 - Dispatch Information |
CREW_OTHER | Crew - Other | Page 1 - Dispatch Information |
CUSTOM_TIME1_LABEL | Date Custom 1 Label | Page 1 - Dispatch Information |
CUSTOM_TIME2_LABEL | Date Custom 2 Label | Page 1 - Dispatch Information |
CUSTOM_TIME3_LABEL | Date Custom 3 Label | Page 1 - Dispatch Information |
CUSTOM_TIME4_LABEL | Date Custom 4 Label | Page 1 - Dispatch Information |
DESTGPS | Destination Location GPS | Page 1 - Dispatch Information |
DESTUSNG | Receiving USNG | Page 1 - Dispatch Information |
DEST_BASIS_COMMENT | Destination Basis Comment | Page 1 - Dispatch Information |
DEST_BASIS_ID | 0 | 0 |
DEST_BASIS_NAME | Destination Basis | Page 1 - Dispatch Information |
DEST_MRN | Destination Account Number | Patient Page |
DISPCOMP_ID | 0 | 0 |
DISPCOMP_NAME | Dispatched As | Page 1 - Dispatch Information |
DISPID | Dispatch ID | Page 1 - Dispatch Information |
DT_ARRIVE | Date Arrived | Page 1 - Dispatch Information |
DT_ARVREC | Date Arrive Rec | Page 1 - Dispatch Information |
DT_ATPT | Date Assessment (At Pt) | Page 5 - Secondary Survey |
DT_ATPT | Date Assessment (At Pt) | Page 5 - Secondary Survey |
DT_AVAILABLE | Date Available | Page 1 - Dispatch Information |
DT_CANCEL | Date Cancelled | Page 1 - Dispatch Information |
DT_CUSTOM_TIME1 | Date Custom 1 | Page 1 - Dispatch Information |
DT_CUSTOM_TIME2 | Date Custom 2 | Page 1 - Dispatch Information |
DT_CUSTOM_TIME3 | Date Custom 3 | Page 1 - Dispatch Information |
DT_CUSTOM_TIME4 | Date Custom 4 | Page 1 - Dispatch Information |
DT_DESCENT | Date of Descent | Page 1 - Dispatch Information |
DT_DISP | Date Dispatched | Page 1 - Dispatch Information |
DT_ENROUTE | Date Enroute | Page 1 - Dispatch Information |
DT_FRESP | Date First Resp. | Page 1 - Dispatch Information |
DT_INJURY | Date of Onset | Page 1 - Dispatch Information |
DT_INQTRS | Date In Qtrs | Page 1 - Dispatch Information |
DT_LVPT | Date Leave Pt | Page 1 - Dispatch Information |
DT_LVREF | Date Leave Ref | Page 1 - Dispatch Information |
DT_NOTIFY | Date Notified | Page 1 - Dispatch Information |
DT_REC | Date Received | Page 1 - Dispatch Information |
DT_STANDBY | Date Standby | Page 1 - Dispatch Information |
DT_TRANS_SCENE | Date Transported Unit At Scene | Page 1 - Dispatch Information |
DT_TXCARE | Date Tx Care | Page 1 - Dispatch Information |
EMD_CARD | EMD Card Number | Page 1 - Dispatch Information |
EMD_ID | 0 | 0 |
EMD_NAME | EMD Name | Page 1 - Dispatch Information |
EMERG_INFO_FORM | Emerg. Info. Form | Patient Page |
FIRENUM | Fire Incident Number | Page 2 - CC/HPI |
GRID_LOOKUP | Use Grid Lookup | Page 1 - Dispatch Information |
HIPAA_CONSENT_ID | 0 | 0 |
HIPAA_CONSENT_NAME | Consent Form Signed | Patient Page |
HPI | HPI | Page 2 - CC/HPI |
IFR_ID | 0 | 0 |
IFR_NAME | Flight Plan | Page 1 - Dispatch Information |
IH_ID | 0 | 0 |
IH_NAME | Type of Service (IH/Scene) | Page 1 - Dispatch Information |
INIT_PT_ACUITY_ID | 0 | 0 |
INIT_PT_ACUITY_NAME | Initial Patient Acuity | Page 2 - CC/HPI |
LAWNUM | Law Enforcement Number | Page 2 - CC/HPI |
LOCALID | Local ID | Page 1 - Dispatch Information |
LOCATION | Location | Page 1 - Dispatch Information |
LOCATION | Location | Page 1 - Dispatch Information |
LOCKLEVEL | QA Level (Numeric) | Misc |
LOCKLEVEL_LEVEL | Locklevel Type | 0 |
LOCKLEVEL_LEVEL | Locklevel Type | 0 |
LPM_ATREC | Odometer - At Receiving | Page 1 - Dispatch Information |
LPM_ATREF | Odometer - At Referring | Page 1 - Dispatch Information |
LPM_END | Odometer - End | Page 1 - Dispatch Information |
LPM_LPM | Use Patient Mileage | Page 1 - Dispatch Information |
LPM_ODOM | Use Odometer | Page 1 - Dispatch Information |
LPM_OOC | Mileage - Out Of County | Page 1 - Dispatch Information |
LPM_OOC_DISP | Use Out Of County Mileage | Page 1 - Dispatch Information |
LPM_PT | Mileage - Loaded | Page 1 - Dispatch Information |
LPM_START | Odometer - Start | Page 1 - Dispatch Information |
LPM_TOT | Mileage - Total | Page 1 - Dispatch Information |
MASS_CAS_ID | 0 | 0 |
MASS_CAS_NAME | Mass Casualty | Page 1 - Dispatch Information |
MAXALT | Max Altitude | Page 1 - Dispatch Information |
NUM_PTS_SCENE | Num of Patients on Scene | Page 2 - CC/HPI |
OUTCOME_ID | 0 | 0 |