This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

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 Board.

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.gov. This data is supplied here for demonstration purposes only and neither intended nor warranted to be accurate.
Courtesy: National Transportation Safety Board

Property Inventory

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: AircraftCheck(), AircraftDelete(), AircraftGet(), AircraftGetObject(), AircraftGetObjectId(), AircraftGetStored(), AircraftGetSwizzled(), AircraftIsValid(), AircraftKeyDisplayToLogical(), AircraftKeyGet(), AircraftKeyGetStored(), AircraftKeyIsValid(), AircraftKeyLogicalToDisplay(), AircraftKeyNormalize(), AircraftKeySet(), 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: MedicalCertificationDateDisplayToLogical(), MedicalCertificationDateGet(), MedicalCertificationDateGetStored(), MedicalCertificationDateIsValid(), MedicalCertificationDateLogicalToDisplay(), MedicalCertificationDateNormalize(), MedicalCertificationDateOdbcToLogical(), MedicalCertificationDateSet(), MedicalCertificationDisplayToLogical(), MedicalCertificationGet(), MedicalCertificationGetStored(), MedicalCertificationIsValid(), MedicalCertificationLogicalToDisplay(), MedicalCertificationLogicalToOdbc(), MedicalCertificationNormalize(), MedicalCertificationSet(), MedicalCertificationValidDisplayToLogical(), MedicalCertificationValidGet(), MedicalCertificationValidGetStored(), MedicalCertificationValidIsValid(), MedicalCertificationValidLogicalToDisplay(), MedicalCertificationValidLogicalToOdbc(), MedicalCertificationValidNormalize(), MedicalCertificationValidSet()
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(), SeatbeltUsedDisplayToLogical(), SeatbeltUsedGet(), SeatbeltUsedGetStored(), SeatbeltUsedIsValid(), SeatbeltUsedLogicalToDisplay(), SeatbeltUsedLogicalToOdbc(), SeatbeltUsedNormalize(), SeatbeltUsedSet()
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()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (Aviation.Crew)

{%%PARENT}("Crew")(ID)
=
%%CLASSNAME
EventId
AircraftKey
CrewNumber
Age
Category
Injury
Sex
ToxicologyTestPerformed
MedicalCertificationDate
MedicalCertification
MedicalCertificationValid
Seat
SeatbeltUsed
ShoulderHarnessUsed
Feedback