| Source |
Source Tab Ord |
SourceTable |
Source Field Ord |
FieldName |
PII/HIPAA Sensitive |
CHPPM Approval |
CHPPM SP2Delta |
FieldType |
Nullability |
Primary Key |
Title |
Desc |
Notes |
FDM Comments |
ADS Comment |
Code Table Reference |
| ASMIS-R |
1 |
AtbAircraftInjuryData |
1 |
AircraftID |
Yes |
Yes |
11/3/2009 |
|
|
FK |
|
Foreign Key (FK) reference to main aircraft table. |
From schema Aviation |
|
|
|
| ASMIS-R |
1 |
AtbAircraftInjuryData |
2 |
Disabling |
|
Yes |
11/3/2009 |
|
|
|
|
The number of occupants of this aircraft that received disabling injuries. Ex. 1, 2, .... |
From schema Aviation |
|
|
|
| ASMIS-R |
1 |
AtbAircraftInjuryData |
3 |
Fatal |
|
Yes |
11/3/2009 |
|
|
|
|
The number of occupants of this aircraft that received fatal injuries. Ex. 1, 2, ... |
From schema Aviation |
|
|
|
| ASMIS-R |
1 |
AtbAircraftInjuryData |
4 |
Missing |
|
Yes |
11/3/2009 |
|
|
|
|
The number of occupants of this aircraft that are missing and presumed dead. Ex. 3, 2, .... |
From schema Aviation |
|
|
|
| ASMIS-R |
1 |
AtbAircraftInjuryData |
5 |
Nondisabling |
|
Yes |
11/3/2009 |
|
|
|
|
The number of occupants of this aircraft that received non-disabling injuries. Ex. 2, 5, .... |
From schema Aviation |
|
|
|
| ASMIS-R |
1 |
AtbAircraftInjuryData |
6 |
NotInjured |
|
Yes |
11/3/2009 |
|
|
|
|
The number of occupants of this aircraft that did not receive injuries. Ex. 3, 5, .... |
From schema Aviation |
|
|
|
| ASMIS-R |
1 |
AtbAircraftInjuryData |
7 |
PersonType |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code describing type of personnel such as Occupants Military, Occupants Other, Non-Occupants Mil, Non-Occupants. E and F on block 19 can be autocalculated. Ex. NM, NO, ... |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
1 |
Allowed |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates if the equipment allowed an injury to occur to an individual. Ex. Y, N |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
2 |
Available |
|
Yes |
11/3/2009 |
|
|
|
|
A code indicating whether the protective equipment was available to be used by the individual. Ex. Y, N, U, .... |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
3 |
Functioned |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates if the equipment functioned as designed. Ex. Y, N |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
4 |
Prevented |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates if the equipment prevented an injury to an individual. Ex. Y, N |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
5 |
Produced |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates if the equipment produced an injury to an individual. Ex. Y, N |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
6 |
Reduced |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates if the equipment reduced an injury to an individual. Ex. Y, N |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
7 |
Required |
|
Yes |
11/3/2009 |
|
|
|
|
A code indicating whether the protective equipment was required to be used by the individual. Ex. Y, N, U, ...._x000D_ |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
8 |
SpecificItemType |
|
Yes |
11/3/2009 |
|
|
FK |
|
The specific type of the ppe item selected. |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
9 |
Used |
|
Yes |
11/3/2009 |
|
|
|
|
A code indicating whether the protective equipment was used by the individual. Ex. Y, N, U, ...._x000D_ |
From schema Aviation |
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
|
PPEID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
|
PersonnelID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
|
PPEItem |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
2 |
AtbAvnProtectiveEquipment |
|
PPEItemOther |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
3 |
AtbDiseaseDefectHistory |
1 |
Diagnosis |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code indicating the pre-existing diseases/defects. Ex. G, H, J |
From schema Aviation |
|
|
|
| ASMIS-R |
3 |
AtbDiseaseDefectHistory |
2 |
DiscoveryMethod |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code indicating how the disease/defect was identified. |
From schema Aviation |
|
|
|
| ASMIS-R |
3 |
AtbDiseaseDefectHistory |
3 |
DiscoveryMethodOther |
|
Yes |
11/3/2009 |
|
|
|
|
Description of the method of discovery, if other chosen. Not sure if needed, but trying to plan ahead. We can remove later if not used. |
From schema Aviation |
|
|
|
| ASMIS-R |
3 |
AtbDiseaseDefectHistory |
4 |
WaiverAuthorized |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code indicating if a Waiver is authorized for the disease/defect. |
From schema Aviation |
|
|
|
| ASMIS-R |
3 |
AtbDiseaseDefectHistory |
|
DiagnosisID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
3 |
AtbDiseaseDefectHistory |
|
PersonnelID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
3 |
AtbDiseaseDefectHistory |
|
DiagnosisOther |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
4 |
AtbEnvironmentalGeneralData |
1 |
GeneralConditions |
|
Yes |
11/3/2009 |
|
|
FK |
|
(AVIATION) General IMC, VMC or Unknown |
From schema Aviation |
|
|
|
| ASMIS-R |
4 |
AtbEnvironmentalGeneralData |
2 |
Temperature |
|
Yes |
11/3/2009 |
|
|
|
|
The temperature at the time of the accident. |
From schema Aviation |
|
|
|
| ASMIS-R |
15 |
AtbCollisions |
1 |
Collision |
|
Yes |
11/3/2009 |
|
|
FK |
|
Coded value indicating the type of collision in which this property/materiel was involved. Started recording FY 1992. Ex. 01, 02, ... |
From schema Ground |
|
|
|
| ASMIS-R |
15 |
AtbCollisions |
2 |
CollisionID |
|
Yes |
11/3/2009 |
|
|
PK |
|
Unique identifier for record distinctness. Auto generated id. Supports functionality for LINQ. Unique key will be established to ensure uniqueness of old key. |
From schema Ground |
|
|
|
| ASMIS-R |
15 |
AtbCollisions |
3 |
CollisionOther |
|
Yes |
11/3/2009 |
|
|
|
|
Description of the type of collision if other selected in drop down. Ex. Backed into pole, .... |
From schema Ground |
|
|
|
| ASMIS-R |
15 |
AtbCollisions |
4 |
CollisionSequenceNumber |
|
Yes |
11/3/2009 |
|
|
|
|
Sequence number of the collision type. Ex. 1, 2, 3, ... |
From schema Ground |
|
|
|
| ASMIS-R |
15 |
AtbCollisions |
|
MaterielID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
16 |
AtbExplosiveNarrative |
1 |
Narrative |
|
Yes |
11/3/2009 |
|
|
|
|
Narrative or textual description entered for the particular explosive materiel. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
1 |
CausedInjury |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the equipment/materiel caused an injury. Ex. Y, N |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
2 |
IncidentID |
|
Yes |
11/3/2009 |
|
|
FK |
|
Foreign Key (FK) reference to the Incident table. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
3 |
MaterielFailure |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the equipment/materiel failed. Ex. Y, N |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
4 |
Modifier1 |
|
Yes |
11/3/2009 |
|
|
|
|
First modifier to define the type of equipment. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
5 |
Modifier2 |
|
Yes |
11/3/2009 |
|
|
|
|
Second modifier to define the type of equipment. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
6 |
Modifier3 |
|
Yes |
11/3/2009 |
|
|
|
|
Third modifier to define the type of equipment. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
7 |
Modifier4 |
|
Yes |
11/3/2009 |
|
|
|
|
Fourth modifier to define the type of equipment. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
8 |
Modifier5 |
|
Yes |
11/3/2009 |
|
|
|
|
Fifth modifier to define the type of equipment. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
9 |
Nomenclature |
|
Yes |
11/3/2009 |
|
|
|
|
Description of the type of property/materiel involved in the incident. For explosives, the type of explosive present and/or contributing. Materiel Ex. Sedan, Truck, Generator, .... Explosives Ex. HG Smoke Violet, Flare Surface Trip M49A1, .... |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
10 |
Ownership |
Yes |
Yes |
11/3/2009 |
|
|
FK |
|
Owner of the property/materiel. Ex. A, B, .... |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
11 |
PVEH |
Yes |
Yes |
11/3/2009 |
|
|
FK |
|
Primary vehicle code for the equipment/materiel. Ex. 20, 47, .... |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
12 |
Quantity |
|
Yes |
11/3/2009 |
|
|
|
|
Number of pieces of this type equipment/materiel that were involved in the incident. Ex. 1, 2, 3, .... |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
13 |
RolloverProtectionSystemInstalled |
|
Yes |
11/3/2009 |
|
|
|
|
Was rollover protection system installed. Started recording in FY 1992. Ex. Y, N, .. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
14 |
SerialNumber |
Yes |
Yes |
11/3/2009 |
|
|
|
|
Serial or VIN number of the material item or vehicle. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
15 |
SubAssembly |
|
Yes |
11/3/2009 |
|
|
|
|
Sub assembly code. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
16 |
TotalLoss |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the damage to the equipment/materiel resulted in a total loss. Ex. Y, N, ... |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
17 |
TowingVehicle |
|
Yes |
11/3/2009 |
|
|
FK |
|
What piece of equipment/materiel was doing the towing. If null the equipment/materiel was not being towed. Started recording in FY 1992. |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
18 |
TypeReactionCategory |
|
Yes |
11/3/2009 |
|
|
FK |
|
Type of reaction which occurred. (S)ingle or (M)ultiple. Ex. S, M |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
19 |
VehicleBeingTowed |
|
Yes |
11/3/2009 |
|
|
|
|
Was the current vehicle being towed when the incident occurred? |
From schema Ground |
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
|
Groups |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
|
MaterielID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
17 |
AtbMateriel |
|
MaterielSequenceNumber |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
18 |
AtbParachute |
1 |
DateGraduated |
|
Yes |
11/3/2009 |
|
|
|
|
Date the individual graduated from Basic Airborne Training. Ex. 1/2/2008, ..... |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
2 |
EquipmentWeightTotal |
|
Yes |
11/3/2009 |
|
|
|
|
Total weight, in pounds, of all equipment used/carried by the individual in the jump. Ex. 25, 45, .... |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
3 |
JumpAltitude |
|
Yes |
11/3/2009 |
|
|
|
|
Altitude, in feet, at which the jump occurred. Ex. 17000, 18000, .... |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
4 |
JumpType |
|
Yes |
11/3/2009 |
|
|
FK |
|
Coded value for the type of parachute jump being performed by the individual when the incident occurred. Ex. A, B, C, .... |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
5 |
LastJumpDate |
|
Yes |
11/3/2009 |
|
|
|
|
Date of the individuals last jump. Ex. 1/3/2007, .... |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
6 |
LastJumpType |
|
Yes |
11/3/2009 |
|
|
FK |
|
Type of jump individual did the last time jumped. Ex. A, B, .... |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
7 |
PersonnelID |
DI |
Yes |
11/3/2009 |
|
|
FK |
|
Foreign Key (FK) to the main personnel table. |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
8 |
StickPosition |
|
Yes |
11/3/2009 |
|
|
|
|
Stick position the individual was in during the jump. Ex. 1, 2, 3, .... |
From schema Ground |
|
|
|
| ASMIS-R |
18 |
AtbParachute |
9 |
TimePreJumpBrief |
|
Yes |
11/3/2009 |
|
|
|
|
The time, in 24hour format, that the individual received their pre-jump briefing. Ex. 1314, .... |
From schema Ground |
|
|
|
| ASMIS-R |
19 |
AtbPersonnelActivities |
1 |
ActivityCode |
|
Yes |
11/3/2009 |
|
|
|
|
Activity or task at the time of the accident. If the person was engaged in more than one activity, at the time of the incident, then the most relevant to the cause of the accident. Ex. A, B, C, ... |
From schema Ground |
|
|
|
| ASMIS-R |
19 |
AtbPersonnelActivities |
2 |
ActivityCode2 |
|
Yes |
11/3/2009 |
|
|
|
|
Modifier to the activity code to further identify the activity being performed. Ex. A, B, C,..... |
From schema Ground |
|
|
|
| ASMIS-R |
19 |
AtbPersonnelActivities |
3 |
ActivityCode3 |
|
Yes |
11/3/2009 |
|
|
|
|
Modifier to the activity code to further identify the activity being performed. Ex. A, B, C, ..... |
From schema Ground |
|
|
|
| ASMIS-R |
19 |
AtbPersonnelActivities |
4 |
ActivityDescription |
|
Yes |
11/3/2009 |
|
|
|
|
Descriptive explanation of the activity the individual was performing at the time of the incident. Ex. some descriptive text a lot better than this..... |
From schema Ground |
|
|
|
| ASMIS-R |
20 |
AtbPersonnelActivityStandards |
1 |
Standard |
|
Yes |
11/3/2009 |
|
|
|
|
Type of guidance (standard/reference) covering the activity/task that the individual was performing. Started recording FY 1992. Ex. A, B, C.... |
From schema Ground |
|
|
|
| ASMIS-R |
20 |
AtbPersonnelActivityStandards |
2 |
StandardDescription |
|
Yes |
11/3/2009 |
|
|
|
|
The name/number of the guidance. Ex. DA PAM 385-40, AR 385-10, .... |
From schema Ground |
|
|
|
| ASMIS-R |
20 |
AtbPersonnelActivityStandards |
3 |
StandardsID |
|
Yes |
11/3/2009 |
|
|
PK |
|
Unique identifier for record distinctness. Auto generated id. Supports functionality for LINQ. Unique key will be established to ensure uniqueness of old key. |
From schema Ground |
|
|
|
| ASMIS-R |
20 |
AtbPersonnelActivityStandards |
|
PersonnelID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
21 |
AtbBodyParts |
1 |
BodyPart |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code indicating the body part of the individual that received the injury. Ex. B02, B03, B05, B06, .... |
From schema Incident |
|
|
|
| ASMIS-R |
21 |
AtbBodyParts |
2 |
BodyPartAspectPrimary |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code indicating the aspect of the body part that received the injury. Ex. 01, 02, 03, 09 |
From schema Incident |
|
|
|
| ASMIS-R |
21 |
AtbBodyParts |
3 |
BodyPartAspectSecondary |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code indicating the aspect of the body part that received the injury. Ex. 01, 02, 03, 09 |
From schema Incident |
|
|
|
| ASMIS-R |
21 |
AtbBodyParts |
4 |
BodyPartID |
|
Yes |
11/3/2009 |
|
|
PK |
|
Unique identifier for record distinctness. Auto generated id. Supports functionality for LINQ. Unique key will be established to ensure uniqueness of old key. |
From schema Incident |
|
|
|
| ASMIS-R |
21 |
AtbBodyParts |
5 |
BodyPartOther |
|
Yes |
11/3/2009 |
|
|
|
|
Description of the body part injured, if an appropriate body part not found in listing and "Other" is chosen. Ex. My obscure body part, .... |
From schema Incident |
|
|
|
| ASMIS-R |
21 |
AtbBodyParts |
6 |
BodyPartSeverity |
|
Yes |
11/3/2009 |
|
|
|
|
A numeric identifier indicating the severity level of the injury to the individual. Indicated in sequence. Ex. 1, 2, 3, ... |
From schema Incident |
|
|
|
| ASMIS-R |
21 |
AtbBodyParts |
7 |
PersonnelID |
DI |
Yes |
11/3/2009 |
|
|
FK |
|
Foreign Key (FK) reference to Personnel table. |
From schema Incident |
|
|
|
| ASMIS-R |
22 |
AtbCaseSequenceAssigned |
1 |
AircraftSerialNumber |
Yes |
Yes |
11/3/2009 |
|
|
|
|
If an aviation case, the aircraft serial number from the primary aircraft from the incident. Ex. 0004583, 0004584, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
22 |
AtbCaseSequenceAssigned |
2 |
CaseSequenceID |
|
Yes |
11/3/2009 |
|
|
PK |
|
Foreign Key reference to the Case Sequence table. |
From schema Incident |
|
|
|
| ASMIS-R |
23 |
AtbChainOfCommand |
1 |
CommandNumber |
|
Yes |
11/3/2009 |
|
|
|
|
Computer generated sequence number. Ex. 1,2,3,.... |
From schema Incident |
|
|
|
| ASMIS-R |
23 |
AtbChainOfCommand |
2 |
IncidentID |
|
Yes |
11/3/2009 |
|
|
FK |
|
Foreign Key (FK) reference to the main incident table. |
From schema Incident |
|
|
|
| ASMIS-R |
23 |
AtbChainOfCommand |
|
CommandID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
1 |
ArmyAccountable |
|
Yes |
11/3/2009 |
|
|
|
|
Coded value indicating whether the case is considered an Army accountable accident. Will default to a Y. Ex. Y, N |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
2 |
CaseNumber |
|
Yes |
11/3/2009 |
|
|
|
|
Case number for the incident. Computer (system/database) generated by a function within the database with a return value of char(11). Format YYYYMMDDSEQ. Four digit year, two digit month, two digit day, (all of the incident date) and a three digit sequence number kept by system. Ex. 20071105001, 20071105002, .... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
3 |
DateOccurred |
|
Yes |
11/3/2009 |
|
|
|
|
The date the incident occurred. Ex. January 1, 2005, .... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
4 |
ExplosivesInvolved |
|
Yes |
11/3/2009 |
|
|
|
|
Were explosives, ammunition or pyrotechnics involved. This does not include small arms ammunition, present only as cargo, that did not play a role in the accident. Started recording FY 1992. Ex. Y, N,.... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
5 |
ExplosivesPresent |
|
Yes |
11/3/2009 |
|
|
|
|
Were explosives, ammunition or pyrotechnics present. This does not include small arms ammunition, present only as cargo, that did not play a role in the accident. Ex. Y, N, .... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
6 |
ExplosivesSecured |
|
Yes |
11/3/2009 |
|
|
|
|
Have the explosives, ammunition or pyrotechnics which were involved in the event been secured. Started recording FY 2006 as part of the IN tool. Ex. Y, N,.... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
8 |
LocationDescription |
|
Yes |
11/3/2009 |
|
|
|
|
Exact location of the event. Should include the building number or direction and distance from closest landmark, grid coordinate, street or highway name/number and city. Ex. 123 Mockingbird Lane, Building 45 Turn left Go 2 blocks, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
9 |
METL |
|
Yes |
11/3/2009 |
|
|
|
|
Mission Essential Task List event. AGAR Only. Ex. Y, N, .... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
10 |
Mission |
|
Yes |
11/3/2009 |
|
|
|
|
Description of mission that was being performed at the time the incident occurred. AGAR Only. Ex. Operating gun turret on vehicle, .... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
11 |
OccurredOnAirfield |
|
Yes |
11/3/2009 |
|
|
|
|
Coded value indicating whether the incident occurred on an airfield. Ex. Y, N, ... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
12 |
OccurredOnPost |
|
Yes |
11/3/2009 |
|
|
|
|
Coded value indicating whether the incident occurred on or off post. Ex. Y, N,... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
13 |
PrimaryVehicleMaterielNumber |
Yes |
Yes |
11/3/2009 |
|
|
|
|
Contains the materiel id number of the materiel item determined to be the primary vehicle. This will be based on application logic that performs a check based on the materiel items PVEH code and Accident Type. THIS IS AUTOCALCULATED BASED ON MATERIEL INPUT. Ex. 1, 2, .... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
14 |
PVEHCode |
|
Yes |
11/3/2009 |
|
|
FK |
|
Contains the PVEH code of the associated Materiel item (referenced in PrimaryVehicleMaterielNumber) that was identified as being the primary vehicle based on the check of PVEH and Accident Type. THIS IS AUTOCALCULATED BASED ON MATERIEL INPUT. Ex. 01, 02, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
15 |
ReceivedDate |
|
Yes |
11/3/2009 |
|
|
|
|
Date the incident report was received at the center (physically). Ex. November 11, 2007 10:45 am,.... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
16 |
RotationalAccident |
|
Yes |
11/3/2009 |
|
|
FK |
|
Type of rotational training exercise being performed when the incident occurred. Ex. A, B, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
17 |
Source |
|
Yes |
11/3/2009 |
|
|
FK |
|
Coded value indicating the source (or origin reporting type) for the incident. This value will be used in conjunction with Case Type to identify the source in the referenced lookup table. Ex. A, B, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
18 |
Stage |
|
Yes |
11/3/2009 |
|
|
FK |
|
Current stage of the report within the application. Ex. U, P, N, H, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
24 |
AtbIncidents |
|
PrimaryVehicleMaterielNumber |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
25 |
AtbInitialNotificationData |
1 |
AdvisorSent |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the Center sent an advisor to the site to advise on the investigation. Ex. Y, N |
From schema Incident |
|
|
|
| ASMIS-R |
25 |
AtbInitialNotificationData |
2 |
IncidentID |
|
Yes |
11/3/2009 |
|
|
PK |
|
Foreign Key (FK) reference to the main incident table. |
From schema Incident |
|
|
|
| ASMIS-R |
25 |
AtbInitialNotificationData |
3 |
SiteDisturbed |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates if the incident site has been disturbed. Ex. Y, N,.... |
From schema Incident |
|
|
|
| ASMIS-R |
25 |
AtbInitialNotificationData |
4 |
SitePhotos |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the incident site has been photographed. Ex. Y, N,... |
From schema Incident |
|
|
|
| ASMIS-R |
25 |
AtbInitialNotificationData |
5 |
SiteSecured |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the incident site has been secured. Ex. Y, N, ... |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
1 |
AbbreviatedInjuryScale |
|
Yes |
11/3/2009 |
|
|
|
|
(AVIATION) The abbreviated injury scale (AIS). To be completed by a physician or physicians assistant. |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
2 |
CauseAction |
|
Yes |
11/3/2009 |
|
|
FK |
|
(AVIATION) The subject code description which best describes, from an engineering viewpoint, what aspects of the aircraft contributed to the injury cause factors (why injury occurred). Ex. ABSORBED, ALLOWED, BROKE, BUCKLED |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
3 |
CauseofInjury |
|
Yes |
11/3/2009 |
|
|
FK |
|
(GROUND) Cause of the injury/illness. 1 per injury type. This field corresponds to the Cause of Injury field on Ground in ASMIS. (AVIATION) The action code that best describes the injury mechanism. Ex. 1, 2, 3,.... |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
4 |
CauseQualifier |
|
Yes |
11/3/2009 |
|
|
FK |
|
(AVIATION) The qualifier code which best describes, from an engineering viewpoint, what aspects of the aircraft contributed to the injury cause factors (why injury occurred). Ex. 03, 04, 05 |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
5 |
CauseSubject |
|
Yes |
11/3/2009 |
|
|
FK |
|
(AVIATION) The subject code which best describes, from an engineering viewpoint, what aspects of the aircraft contributed to the injury cause factors (why injury occurred). Ex. 07, 08, 09, 10 |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
7 |
InjuryType |
|
Yes |
11/3/2009 |
|
|
FK |
|
Coded value for the type of injury incurred on body part. Up to 3 per body part. Ex. A02, B03, .... |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
8 |
InjuryTypeOther |
|
Yes |
11/3/2009 |
|
|
|
|
Description of the injury type that occurred, if an appropriate type is not found in listing and "Other" is chosen. Ex. Banged with a hammer, .... |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
9 |
MechanismQualifier |
|
Yes |
11/3/2009 |
|
|
FK |
|
(AVIATION) The qualifier code that best describes the injury mechanism. Ex. 02, 03, 04, 05 |
From schema Incident |
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
|
BodyPartID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
26 |
AtbInjuries |
|
InjuryOrder |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
27 |
AtbNarratives |
1 |
Narrative |
|
Yes |
11/3/2009 |
|
|
|
|
Narrative or textual description entered for each associated type from the form. Ex. A very long text describing what happened, a mistake, etc. |
From schema Incident |
|
|
|
| ASMIS-R |
27 |
AtbNarratives |
2 |
NarrativeID |
|
Yes |
11/3/2009 |
|
|
PK |
|
Unique identifier for record distinctness. Auto generated id. Supports functionality for LINQ. Unique key will be established to ensure uniqueness of old key. |
From schema Incident |
|
|
|
| ASMIS-R |
27 |
AtbNarratives |
3 |
NarrativeType |
|
Yes |
11/3/2009 |
|
|
FK |
|
The type of narrative or textual description being entered from the form. Ex. 1, 2, 3,.... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
1 |
Alcohol |
|
Yes |
11/3/2009 |
|
|
|
|
Did the use of alcohol cause or contribute to the accident. Started recording FY 1992. Ex. Y, N, U, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
2 |
Amnesia |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the individual ever suffered from amnesia as a result of the incident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
3 |
AmnesiaHours |
|
Yes |
11/3/2009 |
|
|
|
|
(AVIATION) The number of hours the individual had amnesia due to injury from the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
4 |
AtControls |
|
Yes |
11/3/2009 |
|
|
|
|
A code indicating whether the individual was on the controls when the accident occurred. Ex. N, U, Y, Z |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
5 |
AutopsyPerformed |
|
Yes |
11/3/2009 |
|
|
|
|
(AVIATION) A code indicating whether or not an autopsy was performed on the individual. Ex. Y, N |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
6 |
CauseOfDeath |
|
Yes |
11/3/2009 |
|
|
|
|
(AVIATION) A code indicating the cause of death of the individual due to the accident. Ex. 00, 02, 14 |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
7 |
ContributedAccident |
|
Yes |
11/3/2009 |
|
|
FK |
|
(AVIATION) A code indicating if errors of the individual caused/contributed to the accident. Ex. D, S, N, U |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
10 |
DaysHospitalized |
|
Yes |
11/3/2009 |
|
|
|
|
Actual or estimated number of days hospitalized receiving treatment. This does not include days for observation. Ex. 2, 3, 4, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
11 |
Drugs |
|
Yes |
11/3/2009 |
|
|
|
|
Did the use of drugs cause or contribute to the accident. Ex. Y, N, U, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
12 |
FieldExerciseNamedOperation |
|
Yes |
11/3/2009 |
|
|
FK |
|
The name of the exercise or operation (major and local field training exercise), if it has a name (e.g., Team Spirit, REFORGER, OEF/OIF). Select (None), if the activity was not part of a field exercise or anamed operation. Ex. NO, 01, 02, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
13 |
FieldExerciseNamedOperationOther |
|
Yes |
11/3/2009 |
|
|
|
|
Description of field exercise or operation, when (Other) is selected in field operation. Ex. New Eagle, New Hope, ... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
14 |
FirstName |
Yes |
Yes |
11/3/2009 |
|
|
|
|
First name of the individual involved in the incident. Ex. John, Mary, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
15 |
FlightActivityCategory |
|
Yes |
11/3/2009 |
|
|
FK |
|
The Flight Activity Code (FAC) level that the individual is rated. Ex. 1,2,3 |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
16 |
HoursAwakePrior |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours the individual was awake prior to the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
17 |
HoursFlown48 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours the individual flew in the last 48 hours before the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
18 |
HoursFlown72 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours the individual flew in the last 72 hours before the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
19 |
HoursFlownLast24 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours the individual flew in the last 24 hours before the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
20 |
HoursLastSleepPeriod |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours DURATION of the last sleep period of the individual prior to the accident |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
21 |
HoursSleep48 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours of sleep the individual had in the last 48 hours before the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
22 |
HoursSleep72 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours of sleep the individual had in the last 72 hours before the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
23 |
HoursSlept24 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours of sleep the individual had in the last 24 hours before the incident. Ex. 4, 5, 6,.... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
24 |
HoursWorked48 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours the individual worked in the last 48 hours before the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
25 |
HoursWorked72 |
|
Yes |
11/3/2009 |
|
|
|
|
The number of hours the individual worked in the last 72 hours before the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
26 |
HoursWorkedLast24 |
|
Yes |
11/3/2009 |
|
|
|
|
Number of continuous hours this individual was on duty before the accident in the last 24 hours. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
28 |
InjuryCost |
|
Yes |
11/3/2009 |
|
|
|
|
The injury cost to the individual. Ex. 3000, 10000, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
29 |
InjuryResult |
|
Yes |
11/3/2009 |
|
|
FK |
|
A coded value for indicating the result of the injury to the individual. Ex. Z00, Z04, Z08,.... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
30 |
LicensedToOperate |
|
Yes |
11/3/2009 |
|
|
|
|
Was the individual properly licensed to operate the vehicle or equipment that he was operating at the time of the accident. Started recording FY 1992. Ex. Y, N, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
31 |
MadeMistake |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the person made a mistake or not. Ex. Y, N |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
32 |
MedicalExamAutopsyDate |
|
Yes |
11/3/2009 |
|
|
|
|
The date of the post incident medical examination or admission to a medical facility for treatment of injuries resulting from the incident. For non-survivors, the day of autopsy. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
34 |
PostCrashEvalDate |
|
Yes |
11/3/2009 |
|
|
|
|
The date of the post accident flight evaluation. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
35 |
PostCrashResults |
|
Yes |
11/3/2009 |
|
|
FK |
|
A code indicating the result of the post accident flight evaluation. Ex. U,S |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
36 |
SSN |
DI |
Yes |
11/3/2009 |
|
|
|
|
Social Security Number or National Identification Number of the Individual. Foreign National personnel will have a National ID Number. If personnel classification is anything other than a code starting with an "F", the app should ensure the SSN is no longer than 9 characters/digits. Ex. 123456789, FN-1234, ...... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
37 |
TacticalTraining |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the activity being performed at the time of the incident was part of tactical training. Ex. Y, N, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
38 |
TimeSinceLastTraining |
|
Yes |
11/3/2009 |
|
|
FK |
|
Number of months since the last time the individual received training for the associated activity they were performing at the time of the incident. Started recording FY 1992. Ex. A, B, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
39 |
TotalHoursIncidentMTDS |
|
Yes |
11/3/2009 |
|
|
|
|
Total hours flown by the individual in the incident MTDS |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
40 |
TypeTraining |
|
Yes |
11/3/2009 |
|
|
FK |
|
If the individual was participating in any type of training, check the type of training in which he was participating. If unit training is selected, also indicate the type of unit training (platoon, crew, or individual). Ex. A, C, D, 2, ... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
41 |
TypeTrainingFacility |
|
Yes |
11/3/2009 |
|
|
FK |
|
If the individual was participating in any type of training, the type of training facility being used at the time of the incident Started recording FY 1992. Ex. A, B, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
42 |
TypeTrainingFacilityOther |
|
Yes |
11/3/2009 |
|
|
|
|
Description of type training facility when other is selected. Ex. Other Facility Type, ... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
43 |
TypeTrainingOther |
|
Yes |
11/3/2009 |
|
|
|
|
Description of type of training when other is selected. Ex. Some other training, .... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
45 |
UnconsciousHours |
|
Yes |
11/3/2009 |
|
|
|
|
(AVIATION) The number of hours the individual was unconscious due to injury from the accident. |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
46 |
WorkDaysLost |
|
Yes |
11/3/2009 |
|
|
|
|
Actual or estimated number of lost days from work. Ex. 2, 3, 4, ... |
From schema Incident |
|
|
|
| ASMIS-R |
28 |
AtbPersonnel |
47 |
WorkDaysRestricted |
|
Yes |
11/3/2009 |
|
|
|
|
Actual or estimated number of workdays this individual will be unable to perform all regular duties after going back to work (on light duty/profile). Ex. 2, 3, 4, ... |
From schema Incident |
|
|
|
| ASMIS-R |
29 |
AtbPersonnelDeployment |
1 |
DateReturnedFromDeployment |
|
Yes |
11/3/2009 |
|
|
|
|
The date the individual returned from their most recent deployment (if deployed within last year). Ex. 1/1/2008, ..... |
From schema Incident |
|
|
|
| ASMIS-R |
29 |
AtbPersonnelDeployment |
2 |
DeployedInPastYear |
|
Yes |
11/3/2009 |
|
|
|
|
Indicates whether the individual was deployed in the 365 day period prior to the incident occurring. Ex. Y, N, ... |
From schema Incident |
|
|
|
| ASMIS-R |
29 |
AtbPersonnelDeployment |
3 |
DeploymentLengthDays |
|
Yes |
11/3/2009 |
|
|
|
|
The number of days the individual was deployed on their last deployment. Ex. 160, 180, .... |
From schema Incident |
|
|
|
| ASMIS-R |
29 |
AtbPersonnelDeployment |
4 |
DeploymentLocation |
Yes |
Yes |
11/3/2009 |
|
|
FK |
|
Code indicating the FTX or Conflict the individual was deployed to. Ex. 01, 02, ... |
From schema Incident |
|
|
|
| ASMIS-R |
29 |
AtbPersonnelDeployment |
5 |
DeploymentLocationOther |
|
Yes |
11/3/2009 |
|
|
|
|
Further description of where the individual was deployed. Will be filled out no matter what is input into Deployment Location. |
From schema Incident |
|
|
|
| ASMIS-R |
29 |
AtbPersonnelDeployment |
|
PersonnelID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
29 |
AtbPersonnelDeployment |
|
DeploymentLocationOther |
|
Yes |
|
|
|
|
|
|
|
|
|
|
| ASMIS-R |
30 |
AtbWhatMistakes |
1 |
ATMTask |
|
Yes |
11/3/2009 |
|
|
|
|
(AVIATION) The Aviator Training Manual (ATM) task number being performed at the time the mistake/error was made. |
From schema Incident |
|
|
|
| ASMIS-R |
30 |
AtbWhatMistakes |
2 |
CausedContributed |
|
Yes |
11/3/2009 |
|
|
FK |
|
Indicates whether the mistake caused or contributed to the accident. PC - caused/contributed to the accident; PCS - had an impact on the severity of injury or damage; PBNC - did not cause or contribute to the accident, but if left uncorrected, could lead to future accident. Ex. 1, 2, ... |
From schema Incident |
|
|
|
| ASMIS-R |
30 |
AtbWhatMistakes |
5 |
WhatMistake |
|
Yes |
11/3/2009 |
|
|
FK |
|
Coded value indicating the mistake the individual made. Ex. 11B, 12, .... |
From schema Incident |
|
|
|
| ASMIS-R |
30 |
AtbWhatMistakes |
|
WhatMistakeID |
|
Yes |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| highlighted yellow - added for linkage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|