| This tab, 1.Cover Letter, describes the information in tab 2. | ||
| Tab | Description | |
| 2.TRAC2ES-USAPHC Atr | Report on the attributes available for selection. Explaination of the report column heads appears below, titled Column Definitions. | |
| Column Definitions | ||
| Column | Name | Description |
| A | Source | Name of Data Source |
| B | SourceTabOrd | Ordinal Position of Table in Data Dictionary received from Source System-used internally |
| C | SourceTable | Name of the Table from which the data element is extracted from Source System |
| D | SourceFieldOrd | Ordinal Position of the data element in a Table in the Source System Data Dictionary-used internally |
| E | FieldName | Name of the data element (please use the literal format as in the column) |
| F | PII/HIPAA Sensitive | Please note YES, NO or DI (De-Identification)for the element PII or HIPAA sensitivity. If the element is PII or HIPAA sensitive and it will be de-identified, enter DI. A blank enter will be considered the same as a NO. |
| G | Army STARRS (or USAPHC(Prov)) Approval | User has accepted this as a valid element for their use-drop down list-Yes or No |
| H | Army STARRS (or USAPHC(Prov)) SP2Delta | Date the data element requested in Spiral-2. This will help in revising your existing extract routines |
| I | FieldType | This is the data type. |
| J | Nullability | This is the Nullability condition |
| K | Primary Key | Indicator if data element is a primary key (PK) or foreign key (FK) in this table |
| L | Title | Data Element Name |
| M | Desc | Dictionary meaning of the data element and enumerated values if applicable |
| N | Notes | Notes concerning the element |
| O | FDM Comments | Please add any comments that will help us understand the output extract. |
| P | ADS Comment | Please add any comments on authoritativeness |
| Q | Code Table Reference | Reference to code table. |
| Source | Source Tab Ord | SourceTable | Source Field Ord | FieldName | PII/HIPAA Sensitive | USAPHC (Prov) Approval | USAPHC (Prov) SP2Delta | FieldType | Nullability | Primary Key | Title | Desc | Notes | FDM Comments | ADS Comment | Code Table Reference |
| TRAC2ES | 1 | Patient Movement Request Identification | 1 | SEQ_PMR_ID | Yes | 7/23/2010 | N(10) | PMR Unique Identifier | Unique identifier in TRAC2ES for each PMR | System Generated | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 2 | SEQ_PATIENT_ID | Yes | 7/23/2010 | N(10) | Person Unique Identifier | Unique identifier in TRAC2ES for each Patient | System Generated | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 5 | PMR_STATE | Yes | 7/23/2010 | Char(2) | Current PMR State | Valid states are: Submitted – PMR is submitted for validation Validating – PMR is in the process of clinical or administrative validation Errored - PMR was returned by the validator to originator with errors Resubmitted – PMR errors were corrected and PMR was re-submitted for validation Validated - PMR is validated and ready to be scheduled for movement Planned - PMR was planned for movement on a mission Ready - PMR planned movement was approved and is ready to execute Executing - PMR movement executing Completed – PMR movement set to completed Canceled - PMR was permanently canceled Suspended - PMR was temporarily suspended from further processing |
System Generated from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 6 | CITE_NUMBER | Yes | 7/23/2010 | Char(10) | PMR Cite Number | Cite number is generated when a PMR is submitted. | Unique Identifier for a submitted PMR. Format: YYDDDPXXXX YY = Julian Date Year DDD = Julian Date Day P = PMRC Code of the PMR Originating MTF XXXX = 4 digit sequence generated number left padded with zeros and reset each day. |
ADCF will drop this field from the NIMH extract. | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 7 | PATIENT_LAST_NAME | Yes | Yes | 7/23/2010 | Char(50) | PMR Person Last Name | Last name of patient being moved | Input | ADCF will drop this field from the NIMH extract. | ||||
| TRAC2ES | 1 | Patient Movement Request Identification | 8 | PATIENT_FIRST_NAME | Yes | Yes | 7/23/2010 | Char(50) | PMR Person First Name | First name of patient being moved | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 9 | PATIENT_MI | Yes | Yes | 7/23/2010 | Char(1) | PMR Person Middle Initial | Middle initial of patient being moved | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 10 | PATIENT_PERSON_ID | DI | Yes | 7/23/2010 | Char(15) | PMR Person ID | Identifier for person being moved. Valid types given below. | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 11 | PATIENT_PERSON_ID_TYPE_NM | Yes | 7/23/2010 | Char(10) | PMR Person ID Type | Valid Person ID types are: SSN – Social Security Number NATO – NATO ID number Other – Unspecified other identifier | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 12 | PATIENT_SERVICE_GRADE_CD | DI | Yes | 7/23/2010 | Char(3) | PMR Person Service Grade Code | Service grade of patient | Values from Ref Table | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 13 | PATIENT_SERVICE_GRADE_NM | DI | Yes | 7/23/2010 | Char(60) | PMR Person Service Grade Name | Service grade name of patient | Values from Ref Table | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 14 | PATIENT_STATUS_CD | Yes | 7/23/2010 | Char(3) | PMR Person Personnel Status Code | Personnel status of patient | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 15 | PATIENT_STATUS_NM | Yes | 7/23/2010 | Char(80) | PMR Person Personnel Status Name | Personnel status name of patient | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 16 | SERVICE | Yes | 7/23/2010 | Char(15) | PMR Person Service | Identifies branch of service for all Active Duty personnel | Calculated - If PS code is A11 Service = Army, If PS code is C11 = coast guard, if ps code is F11 service = Air Force, if ps code M11 service = Marine Corps, if ps code is N11 service = Navy, If code is anything else or is Null then = Not AD Service | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 17 | PATIENT_AGE | Yes | 7/23/2010 | N(3) | PMR Person Age | Age of patient at time of movement | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 18 | PATIENT_AGE_UNIT | Yes | 7/23/2010 | Char(10) | PMR Person Age Type | Valid values are: Year Month Day |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 19 | PATIENT_BIRTH_DATE | Yes | 7/23/2010 | Date | PMR Person Date of Birth | Date of Birth of patient | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 20 | PATIENT_GENDER_NM | Yes | 7/23/2010 | Char(15) | PMR Person Gender | Gender of patient. Valid values are: Male Female Unknown |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 21 | PATIENT_NATIONALITY_COUNTRY_NM | Yes | 7/23/2010 | Char(50) | PMR Person Nationality | Nationality of patient | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 29 | PATIENT_UNIT_NAME | Yes | Yes | 7/23/2010 | Char(50) | PMR Person Unit Name | Patient’s Unit Name | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 30 | PATIENT_UNIT_DUTY_STATION | Yes | Yes | 7/23/2010 | Char(50) | PMR Person Unit Duty Station | Duty station name | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 34 | MVA_IND | Yes | 7/23/2010 | Char(1) | PMR Person Moving Vehicle Accident | Yes/No indicator | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 36 | WORK_RELATED_IND | Yes | 7/23/2010 | Char(1) | PMR Person Work Related | Yes/No Selection | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 37 | ORIG_FAC_MTF_THEATER_NM | Yes | 7/23/2010 | Char(30) | Originating MTF Theater | Theater of Origin MTF | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 38 | ORIG_FAC_MTF_CD | Yes | 7/23/2010 | Char(5) | Originating MTF Code | Unique MTF ID for Origin MTF | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 39 | ORIG_FAC_MTF_NM | Yes | 7/23/2010 | Char(30) | Originating MTF Name | Name of Origin MTF | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 43 | DEST_FAC_MTF_THEATER_NM | Yes | 7/23/2010 | Char(30) | Destination MTF Theater | Theater of Destination MTF | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 44 | DEST_FAC_MTF_CD | Yes | 7/23/2010 | Char(5) | Destination MTF Code | Unique MTF ID for Destination MTF | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 45 | DEST_FAC_MTF_NM | Yes | 7/23/2010 | Char(30) | Destination MTF Name | Name of Destination MTF | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 49 | READY_DATE_TIME | Yes | 7/23/2010 | Date | Ready Date | Date and time PMR is ready to move PMR is ready to move | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 51 | MOVEMENT_PRECEDENCE_NM | Yes | 7/23/2010 | Char(10) | Precedence Name | Precedence of Patient Movement. Valid values are: Urgent Priority Routine |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 52 | REASON_REGULATED_CD | Yes | 7/23/2010 | Char(2) | Reason Regulated Code | Code to specify why patient was moved. Valid values are: AF-After the Fact AR-Administrative Requirements/Others AT-Medical or Non-Medical Attendant BA-Board Action CC-Closest With Capability CR-Other Clinical Reasons CT-Continuity of Treatment DS-Nearest MTF to Duty Station HU-Humanitarian OP-Outpatient PR-Nearest MTF to Place of Residence SA-Service Agreement TC-Teaching Case XD-Recovered Patient Returning to Duty Station XP-Recovered Patient Returning to Place of Residence |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 55 | CASUALTY_EVENT_NM | Yes | 7/23/2010 | Char(20) | Casualty Event Name | Name of event in which patient was injured. Casualty events can updated by TRAC2ES Users | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 56 | INJURY_TYPE_NM | Yes | 7/23/2010 | Char(25) | Injury Type Name | Injury types can be updated by TRAC2ES users | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 58 | MOVEMENT_CLASSIFICATION_NM | Yes | 7/23/2010 | Char(250) | Patient Movement Classification Name | 1A-Severe psychiatric litter patient requiring the use of restraining apparatus, sedation, and close supervision. 1B-Psychiatric litter patient of intermediate severity. 1C-Psychiatric walking patient of moderate severity. 2A-Immobile litter patient, non-psychiatric, who are not able to move about on own volition. 2B-Mobile litter patient, non-psychiatric, who are able to move about on own volition. 3A-Ambulatory patient, non-psychiatric and non-substance abuse, going for treatment or evaluation. 3B-Recovered patient, returning to home station. 3C-Ambulatory, drug, or alcohol (substance) abuse going for treatment. 4A-Infant under three years of age, occupying an aircraft seat, going for treatment. 4B-Recovered infant, under three years of age, occupying an aircraft seat. 4C-Infant requiring incubator. 4D-Infant under 3 years of age occupying a litter. 4E-Outpatient under 3 years of age. 5A-Outpatient ambulatory patient, non-psychiatric and non-substance abuse, going for treatment. 5B-Outpatient ambulatory, drug or alcohol (substance) abuse, going for treatment. 5C-Psychiatric outpatient going for treatment or evaluation. 5D-Outpatient on litter for comfort going for treatment. 5E-Returning outpatient on litter for comfort. 5F-Returning outpatient. 6A-Medical Attendant 6B-Non-Medical Attendant 9V-ITV Patient - Non-AE Movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 59 | SPECIAL_PMR_IND | Yes | 7/23/2010 | Char(1) | Special Indicator | Yes/No Selection Indicates that Patient Movement Requirement Center (PMRC) wishes to pay special attention to PMR during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 60 | SPECIAL_PMR_IND_REMARKS | Yes | 7/23/2010 | Char(2000) | Special Indicator Remarks | Remarks to explain special indicatory | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 61 | AMBULATORY_ESTIMATE | Yes | 7/23/2010 | N(3) | Ambulatory Space Estimation | Number of seats patient will occupy during move | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 62 | LITTER_ESTIMATE | Yes | 7/23/2010 | N(3) | Litter Space Estimation | Number of litters patient will occupy during move | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 63 | CCATT_IND | Yes | 7/23/2010 | Char(1) | CCATT | CCATT team will accompany patient | Yes/No Selection | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 64 | COMMERCIAL_TRNSP_IND | Yes | 7/23/2010 | Char(1) | Moving via Commercial Transportation | Patient will move on commercial flight | Yes/No Selection | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 67 | PROPOSED_DEPARTURE | Yes | 7/23/2010 | Date | Planned Departure Date of Departure - 1st Mission | Planned Departure Date and time of first leg of patient's itinerary | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 68 | ACTUAL_DEPARTURE | Yes | 7/23/2010 | Date | Actual Departure Date of Departure - 1st Mission | Actual Departure date and time of first leg of patient's itinerary | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 73 | LAST_MISSION | Yes | 7/23/2010 | Char(35) | Mission ID# for Arrival - Last Mission | ID of mission used to transport patient to final stop | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 74 | PROPOSED_ARRIVAL_TIME | Yes | 7/23/2010 | Date | Planned Arrival date of Arrival - Last Mission | Planned Arrival Date and time of last leg of patient's itinerary | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 75 | ACTUAL_ARRIVAL_TIME | Yes | 7/23/2010 | Date | Actual Arrival date of Arrival - Last Mission | Actual Arrival Date and time of last leg of patient’s itinerary | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 80 | NUMBER_OF_RON | Yes | 7/23/2010 | N(3) | Planned # RON Stops | Number of Remain Over Night (RON) stops planned for patient during move | Calculated - count the # RON ID that = Y | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 81 | NUMBER_OF_MISSIONS | Yes | 7/23/2010 | N(3) | # Missions (PMR Movements) | Number of missions used to transport patient | Calculated - count the number of unique missions that a PMR has an itinerary for | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 96 | NUMBER_OF_ATTENDANTS | Yes | 7/23/2010 | N(3) | # Total Attendants | Number of medical and non-medical attendants moving with patient | Calculated - total count of attendants | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 97 | NUMBER_OF_MED_ATTENDANTS | Yes | 7/23/2010 | N(3) | # Medical Attendants | Number of medical attendants moving with patient | Calculated - count of # attendant with attendant type = MT, PT, RT, DR, or RN | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 98 | NUMBER_OF_NON_MED_ATTENDANTS | Yes | 7/23/2010 | N(3) | # Non-Medical Attendants | Number of non-medical attendants moving with patient | Calculated - count of # attendant with attendant type = 00, 01, FM, FD, or GU | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 100 | ADMITTED_MTF_NM | Yes | 7/23/2010 | Char(30) | Admitted Destination MTF Name | MTF name associated with the PMR's Admitted ITV event. This comes from the MTF table and is only provided if MTF name has not been updated since ITV event was entered. | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 101 | ADMISSION_DATE | Yes | 7/23/2010 | Date | Destination MTF Admission Date | Event date associated with the PMR's Admitted ITV event. This comes from ITV event table is supplied if event exists | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 105 | LAST_KNOWN_ITV_EVENT | Yes | 7/23/2010 | Char(30) | Last Known ITV Event Name | ITV event name associated with PMR's latest ITV event | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 106 | LAST_KNOWN_LOCATION | Yes | 7/23/2010 | Char(100) | Last Known Location | Event location associated with PMR's latest ITV event | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 107 | LAST_KNOWN_LOCATION_DATE | Yes | 7/23/2010 | Date | Last known location date | Event date associated with PMR's latest ITV event | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 108 | PRIMARY_DIAGNOSIS_CD | Yes | 7/23/2010 | Char(10) | Primary Diagnosis Code | Primary diagnosis ICD9 code | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 109 | PRIMARY_DIAGNOSIS_NM | Yes | 7/23/2010 | Char(50) | Primary Diagnosis Name | Primary diagnosis ICD9 name | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 110 | PRIMARY_MEDICAL_SPECIALTY_CD | Yes | 7/23/2010 | Char(6) | Primary Med. Specialty Code | Primary medical specialty (Armed Services Medical Regulating Office (ASMRO) code) | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 111 | PRIMARY_MEDICAL_SPECIALTY_NM | Yes | 7/23/2010 | Char(60) | Primary Med. Specialty Name | Primary Medical specialty name | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 112 | SECONDARY_DIAGNOSIS_CD | Yes | 7/23/2010 | Char(10) | Secondary Diagnosis Code | Secondary diagnosis ICD9 code | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 113 | SECONDARY_DIAGNOSIS_NM | Yes | 7/23/2010 | Char(50) | Secondary Diagnosis Name | Secondary diagnosis ICD9 name | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 114 | SECONDARY_MEDICAL_SPECIALTY_CD | Yes | 7/23/2010 | Char(6) | Secondary Med. Specialty Code | Secondary medical specialty (ASMRO code) | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 115 | SECONDARY_MEDICAL_SPECIALTY_NM | Yes | 7/23/2010 | Char(60) | Secondary Med. Specialty Name | Secondary medical specialty name | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 116 | OTHER_DIAGNOSIS_CD | Yes | 7/23/2010 | Char(10) | Other Diagnosis Code | Other diagnosis ICD9 code | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 117 | OTHER_DIAGNOSIS_NM | Yes | 7/23/2010 | Char(50) | Other Diagnosis Name | Other diagnosis ICD9 name | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 118 | OTHER_MEDICAL_SPECIALTY_CD | Yes | 7/23/2010 | Char(6) | Other Med. Specialty Code | Other medical specialty (ASMRO code) | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 119 | OTHER_MEDICAL_SPECIALTY_NM | Yes | 7/23/2010 | Char(60) | Other Med. Specialty Name | Other medical specialty name | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 120 | DIAGNOSIS_REMARKS | Yes | Yes | 7/23/2010 | Char(2000) | Diagnosis Remarks | Free Text to explain diagnosis | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 124 | VITAL_SIGNS_READING_DATE | Yes | 7/23/2010 | Date | Vital Signs Recorded Date | Date Vital signs were recorded. Vital signs fields include: +H137Blood pressure diastolic, Blood pressure systolic, Pulse Rate, Respiratory Rate, Temperature and Weight |
Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 125 | BLOOD_PRESSURE_DIASTOLIC | Yes | 7/23/2010 | N(3) | Blood Pressure diastolic | Diastolic blood pressure reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 126 | BLOOD_PRESSURE_SYSTOLIC | Yes | 7/23/2010 | N(3) | Blood Pressure Systolic | Systolic blood pressure reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 127 | PULSE | Yes | 7/23/2010 | N(3) | Pulse Rate | Pulse rate reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 128 | RESPIRATORY_RATE | Yes | 7/23/2010 | N(10) | Respiratory Rate Breath/min | Respiratory rate reading (breaths / minute) | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 129 | TEMPERATURE | Yes | 7/23/2010 | N(5) | Temperature | Temperature Reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 130 | TEMPERATURE_UNIT | Yes | 7/23/2010 | Char(10) | Temperature type | Possible values are: C - Celsius F – Fahrenheit |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 131 | WEIGHT | Yes | 7/23/2010 | N(5) | Weight | Weight reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 132 | WEIGHT_UNIT | Yes | 7/23/2010 | Char(10) | Weight type | Possible values are: kgs - kilograms lbs – pounds |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 133 | LAB_DATE | Yes | 7/23/2010 | Date | Lab Reading Date | Date Lab data was read. Lab fields include: HGB, HCT, WBC, Glucose, HCO3, PCO2, pH, PO2, and BE |
Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 134 | HGB | Yes | 7/23/2010 | N(6) | HGB | Hemoglobin | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 135 | HCT | Yes | 7/23/2010 | N(3) | HCT | Hematocrit | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 136 | WBC | Yes | 7/23/2010 | N(10) | WBC | White blood cell count | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 137 | GLUCOSE | Yes | 7/23/2010 | N(3) | Glucose | Glucose level in blood | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 138 | ABG_HCO3 | Yes | 7/23/2010 | N(3) | HCO3 | HCO3 arterial blood gas reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 139 | ABG_PCO2 | Yes | 7/23/2010 | N(3) | PCO2 | PCO2 arterial blood gas reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 140 | ABG_PH | Yes | 7/23/2010 | N(3) | pH | pH arterial blood gas reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 141 | ABG_PO2 | Yes | 7/23/2010 | N(4) | PO2 | PO2 arterial blood gas reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 142 | ABG_BE | Yes | 7/23/2010 | N(3) | BE | BE arterial blood gas reading | Input | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 143 | ALLERGIES_IND | Yes | 7/23/2010 | Char(1) | Allergies | Yes/No indicator | Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 144 | ALLERGIES | Yes | Yes | 7/23/2010 | Char(2000) | Allergies Description | Full allergy description | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 166 | BACK_BOARD_IND | Yes | 7/23/2010 | Char(1) | Back Board (PMI) | Yes/No indicator Yes if backboard is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 167 | BATTERY_SUPPORT_UNIT_IND | Yes | 7/23/2010 | Char(1) | Battery Support unit (PMI) | Yes/No indicator Yes if battery support unit is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 168 | BLANKET_IND | Yes | 7/23/2010 | Char(1) | Blanket, Thermal, cotton (PMI) | Yes/No indicator Yes if cotton thermal blanket is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 169 | CARDIAC_MONITOR_REQ_IND | Yes | 7/23/2010 | Char(1) | Cardiac Monitor (PMI) | Yes/No indicator Yes if cardiac monitor is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 170 | INCUBATOR_REQUIRED_IND | Yes | 7/23/2010 | Char(1) | Incubator (PMI) | Yes/No indicator Yes if Incubator is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 171 | LITTER_FOLDING_IND | Yes | 7/23/2010 | Char(1) | Litter, Folding (PMI) | Yes/No indicator Yes if folding litter is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 172 | MATTRESS_LITTER_IND | Yes | 7/23/2010 | Char(1) | Mattress, Litter (PMI) | Yes/No indicator Yes if litter mattress is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 173 | OXYGEN_ANALYZER_IND | Yes | 7/23/2010 | Char(1) | Oxygen Analyzer, 9 volt (PMI) | Yes/No indicator Yes if 9 volt oxygen analyzer is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 174 | PULSE_OXIMETER_IND | Yes | 7/23/2010 | Char(1) | Pulse Oximeter (PMI) | Yes/No indicator Yes if pulse oximeter is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 175 | INFUSION_PUMP_IND | Yes | 7/23/2010 | Char(1) | Pump, Intravenous Infusion (PMI) | Yes/No indicator Yes I intravenous infusion pump is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 176 | RESTRAINT_SET_IND | Yes | 7/23/2010 | Char(1) | Restraint Set (Wrist & Ankle) (PMI) | Yes/No indicator Yes if wrist and ankle restraint set is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 177 | STRAPS_WEBBING_IND | Yes | 7/23/2010 | Char(1) | Straps, webbing (Litter Straps) (PMI) | Yes/No indicator Yes if litter straps are required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 178 | STRYKER_FRAME_IND | Yes | 7/23/2010 | Char(1) | Stryker Frame (PMI) | Yes/No indicator Yes if Stryker frame is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 179 | SUCTION_APPARATUS_IND | Yes | 7/23/2010 | Char(1) | Suction Apparatus, Continuous/Intermittent (PMI) | Yes/No indicator Yes if Suction apparatus is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 180 | TRACTION_REQ_IND | Yes | 7/23/2010 | Char(1) | Traction Appliance, Cervical Injury (PMI) | Yes/No indicator Yes if cervical injury traction appliance is required during patient movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 182 | VENTILATOR_IND | Yes | 7/23/2010 | Char(1) | Ventilator, Pole (PMI) | Yes/No indicator Yes if portable ventilator is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 183 | VITAL_SIGNS_MONITOR_IND | Yes | 7/23/2010 | Char(1) | Vital Signs Monitor (PMI) | Yes/No indicator Yes if vital signs monitor is required during movement |
Values from Ref Table | ||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 189 | HISTORY | Yes | Yes | 7/23/2010 | Char(2000) | History | Complete patient medical history | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 190 | PMR_REMARKS | Yes | Yes | 7/23/2010 | Char(2000) | Remarks | Complete patient remarks | Input | |||||
| TRAC2ES | 1 | Patient Movement Request Identification | 191 | PMR Has Itinerary | Yes | 7/23/2010 | ||||||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 192 | PMR Movement Remarks | Yes | 7/23/2010 | ADCF will drop this field from the NIMH extract. | |||||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 193 | Disposition date | Yes | 7/23/2010 | ||||||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 194 | Disposition Event | Yes | 7/23/2010 | ||||||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 195 | Disposition Comments | Yes | 7/23/2010 | ADCF will drop this field from the NIMH extract. | |||||||||
| TRAC2ES | 1 | Patient Movement Request Identification | 196 | Database | Yes | 7/23/2010 |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |