Aviation.Crew

persistent class Aviation.Crew extends %Library.Persistent

SQL Table Name: Aviation.Crew

This class represents the details on crew involved in events registered by the National Transportation Safety BoardOpens in a new tab.

Note on the data: The dataset provided in this sample demo is only a lightweight subset of the full NTSB dataset, which is available from http://www.ntsb.govOpens in a new tab. This data is supplied here for demonstration purposes only and neither intended nor warranted to be accurate.
Courtesy: National Transportation Safety Board

Property Inventory

• Age
• Aircraft
• AircraftKey
• Category
• CrewNumber
• EventId
• Injury
• MedicalCertification
• MedicalCertificationDate
• MedicalCertificationValid
• Seat
• SeatbeltUsed
• Sex
• ShoulderHarnessUsed
• ToxicologyTestPerformed

Properties

property Age as %Integer;

Property methods: AgeDisplayToLogical(), AgeGet(), AgeGetStored(), AgeIsValid(), AgeLogicalToDisplay(), AgeNormalize(), AgeSet()

relationship Aircraft as Aviation.Aircraft [ Required , Inverse = Crew , Cardinality = parent ];

Property methods: AircraftGet(), AircraftGetObject(), AircraftGetObjectId(), AircraftGetStored(), AircraftGetSwizzled(), AircraftIsValid(), AircraftNewObject(), AircraftOnDelete(), AircraftRClose(), AircraftRExec(), AircraftRFetch(), AircraftRelate(), AircraftSQLCompute(), AircraftSet(), AircraftSetObject(), AircraftSetObjectId(), AircraftUnRelate(), AircraftUnSwizzle()

property AircraftKey as %Library.Integer [ Required ];

Property methods: AircraftKeyDisplayToLogical(), AircraftKeyGet(), AircraftKeyGetStored(), AircraftKeyIsValid(), AircraftKeyLogicalToDisplay(), AircraftKeyNormalize(), AircraftKeySet()

property Category as %String (MAXLEN = 20);

Property methods: CategoryDisplayToLogical(), CategoryGet(), CategoryGetStored(), CategoryIsValid(), CategoryLogicalToDisplay(), CategoryLogicalToOdbc(), CategoryNormalize(), CategorySet()

property CrewNumber as %Library.Integer [ Required ];

Property methods: CrewNumberDisplayToLogical(), CrewNumberGet(), CrewNumberGetStored(), CrewNumberIsValid(), CrewNumberLogicalToDisplay(), CrewNumberNormalize(), CrewNumberSet()

property EventId as %String [ Required ];

Property methods: EventIdDisplayToLogical(), EventIdGet(), EventIdGetStored(), EventIdIsValid(), EventIdLogicalToDisplay(), EventIdLogicalToOdbc(), EventIdNormalize(), EventIdSet()

property Injury as %String (MAXLEN = 10);

Property methods: InjuryDisplayToLogical(), InjuryGet(), InjuryGetStored(), InjuryIsValid(), InjuryLogicalToDisplay(), InjuryLogicalToOdbc(), InjuryNormalize(), InjurySet()

property MedicalCertification as %String (MAXLEN = 20);

Property methods: MedicalCertificationDisplayToLogical(), MedicalCertificationGet(), MedicalCertificationGetStored(), MedicalCertificationIsValid(), MedicalCertificationLogicalToDisplay(), MedicalCertificationLogicalToOdbc(), MedicalCertificationNormalize(), MedicalCertificationSet()

property MedicalCertificationDate as %Library.TimeStamp;

Property methods: MedicalCertificationDateDisplayToLogical(), MedicalCertificationDateGet(), MedicalCertificationDateGetStored(), MedicalCertificationDateIsValid(), MedicalCertificationDateLogicalToDisplay(), MedicalCertificationDateNormalize(), MedicalCertificationDateOdbcToLogical(), MedicalCertificationDateSet()

property MedicalCertificationValid as %String (MAXLEN = 50);

Property methods: MedicalCertificationValidDisplayToLogical(), MedicalCertificationValidGet(), MedicalCertificationValidGetStored(), MedicalCertificationValidIsValid(), MedicalCertificationValidLogicalToDisplay(), MedicalCertificationValidLogicalToOdbc(), MedicalCertificationValidNormalize(), MedicalCertificationValidSet()

property Seat as %String (MAXLEN = 10);

Property methods: SeatDisplayToLogical(), SeatGet(), SeatGetStored(), SeatIsValid(), SeatLogicalToDisplay(), SeatLogicalToOdbc(), SeatNormalize(), SeatSet()

property SeatbeltUsed as %String (MAXLEN = 1);

Property methods: SeatbeltUsedDisplayToLogical(), SeatbeltUsedGet(), SeatbeltUsedGetStored(), SeatbeltUsedIsValid(), SeatbeltUsedLogicalToDisplay(), SeatbeltUsedLogicalToOdbc(), SeatbeltUsedNormalize(), SeatbeltUsedSet()

property Sex as %String (MAXLEN = 1);

Property methods: SexDisplayToLogical(), SexGet(), SexGetStored(), SexIsValid(), SexLogicalToDisplay(), SexLogicalToOdbc(), SexNormalize(), SexSet()

property ShoulderHarnessUsed as %String (MAXLEN = 1);

Property methods: ShoulderHarnessUsedDisplayToLogical(), ShoulderHarnessUsedGet(), ShoulderHarnessUsedGetStored(), ShoulderHarnessUsedIsValid(), ShoulderHarnessUsedLogicalToDisplay(), ShoulderHarnessUsedLogicalToOdbc(), ShoulderHarnessUsedNormalize(), ShoulderHarnessUsedSet()

property ToxicologyTestPerformed as %String (MAXLEN = 1);

Property methods: ToxicologyTestPerformedDisplayToLogical(), ToxicologyTestPerformedGet(), ToxicologyTestPerformedGetStored(), ToxicologyTestPerformedIsValid(), ToxicologyTestPerformedLogicalToDisplay(), ToxicologyTestPerformedLogicalToOdbc(), ToxicologyTestPerformedNormalize(), ToxicologyTestPerformedSet()

Indexes

index (IDKEY on ) [IdKey, Type = key];

Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

index (PKINDEX on EventId,AircraftKey,CrewNumber) [PrimaryKey, Unique];

Index methods: PKINDEXCheck(), PKINDEXCheckUnique(), PKINDEXDelete(), PKINDEXExists(), PKINDEXOpen(), PKINDEXSQLCheckUnique(), PKINDEXSQLExists(), PKINDEXSQLFindPKeyByConstraint(), PKINDEXSQLFindRowIDByConstraint()