<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:b="urn:ALIS_UIDES_Training_Messages_200906" xmlns:a="urn:ALIS_UIDES_Training_DataDictionary_200906">
	<xsl:template match="/">
		<Transaction>
			<Insert>
				<Table>
					<xsl:for-each select="b:alisAviatorPostFlightRecord/a:postFlightRecord">
						<deck_dvlp_stage.jsf_flight>
							<Row>
								<Acft_Buerau_Serno>
									<xsl:value-of select="a:bureauNumber"/>
								</Acft_Buerau_Serno>
								<Acft_Serno>
									<xsl:value-of select="a:serialNumber"/>
								</Acft_Serno>
								<Actual_Approach_Nbr>
									<xsl:value-of select="a:actualApproachNumber"/>
								</Actual_Approach_Nbr>
								<Actual_Approach_Type_Ind>
									<xsl:value-of select="a:actualApproachType"/>
								</Actual_Approach_Type_Ind>
								<Actual_Instrument_Hrs>
									<xsl:value-of select="a:actualInstrumentTime"/>
								</Actual_Instrument_Hrs>
								<Aircraft_Type_Desc>
									<xsl:value-of select="a:typeAircraft"/>
								</Aircraft_Type_Desc>
								<Catapult_Launch_Cnt>
									<xsl:value-of select="a:numberCatapultLaunches"/>
								</Catapult_Launch_Cnt>
								<Combat_Hrs>
									<xsl:value-of select="a:combatTime"/>
								</Combat_Hrs>
								<Combat_Sortie_Cnt>
									<xsl:value-of select="a:numberCombatSorties"/>
								</Combat_Sortie_Cnt>
								<Combat_Support_Hrs>
									<xsl:value-of select="a:combatSupportTime"/>
								</Combat_Support_Hrs>
								<Combat_Support_Sortie_Cnt>
									<xsl:value-of select="a:numberCombatSupportSorties"/>
								</Combat_Support_Sortie_Cnt>
								<Comment_Desc>
									<xsl:value-of select="a:comments"/>
								</Comment_Desc>
								<Day_Arrested_Lndg_Cnt>
									<xsl:value-of select="a:numberDayArrestedLandings"/>
								</Day_Arrested_Lndg_Cnt>
								<Day_Field_Carr_Lndg_Prac_Cnt>
									<xsl:value-of select="a:numberDayFieldCarrierLandingPracticeLandings"/>
								</Day_Field_Carr_Lndg_Prac_Cnt>
								<Day_Fullstop_Lndg_Cnt>
									<xsl:value-of select="a:numberDayFullstopLandings"/>
								</Day_Fullstop_Lndg_Cnt>
								<Day_Touch_Go_Lndg_Cnt>
									<xsl:value-of select="a:numberDayTandGLandings"/>
								</Day_Touch_Go_Lndg_Cnt>
								<Detachment_Id>
									<xsl:value-of select="a:detachmentId"/>
								</Detachment_Id>
								<Engine_Run_Hrs>
									<xsl:value-of select="a:engineRunTime"/>
								</Engine_Run_Hrs>
								<Evaluator_Hrs>
									<xsl:value-of select="a:evaluatorTime"/>
								</Evaluator_Hrs>
								<Exception_Code>
									<xsl:value-of select="a:exceptionCode"/>
								</Exception_Code>
								<Flight_Doc_Id>
									<xsl:value-of select="a:postFlightDocumentNumber"/>
								</Flight_Doc_Id>
								<Flight_Duration_Hrs>
									<xsl:value-of select="a:flightDurationPerLeg"/>
								</Flight_Duration_Hrs>
								<Flight_Leg_Cnt>
									<xsl:value-of select="a:numberLegs"/>
								</Flight_Leg_Cnt>
								<Formation_Lndg_Lead_Nbr>
									<xsl:value-of select="a:numberFormationLandingAsLead"/>
								</Formation_Lndg_Lead_Nbr>
								<Formation_Lndg_Wing_Nbr>
									<xsl:value-of select="a:numberFormationLandingAsWing"/>
								</Formation_Lndg_Wing_Nbr>
								<Formation_Takeoff_Lead_Nbr>
									<xsl:value-of select="a:numberFormationTakeoffAsLead"/>
								</Formation_Takeoff_Lead_Nbr>
								<Formation_Takeoff_Wing_Nbr>
									<xsl:value-of select="a:numberFormationTakeoffAsWing"/>
								</Formation_Takeoff_Wing_Nbr>
								<Fullstop_Lndg_Cnt>
									<xsl:value-of select="a:numberFullstopLandings"/>
								</Fullstop_Lndg_Cnt>
								<HOSM_Code>
									<xsl:value-of select="a:hOSMCode"/>
								</HOSM_Code>
								<Instructor_Hrs>
									<xsl:value-of select="a:instructorTime"/>
								</Instructor_Hrs>
								<Lead_Last_Name>
									<xsl:value-of select="a:leadLastName"/>
								</Lead_Last_Name>
								<Mission_Callsign_Name>
									<xsl:value-of select="a:missionCallsign"/>
								</Mission_Callsign_Name>
								<Mission_Commander_Hrs>
									<xsl:value-of select="a:missionCommanderTime"/>
								</Mission_Commander_Hrs>
								<Mission_Hrs>
									<xsl:value-of select="a:missionHours"/>
								</Mission_Hrs>
								<Mission_Nbr>
									<xsl:value-of select="a:missionNumber"/>
								</Mission_Nbr>
								<Night_Arrested_Lndg_Cnt>
									<xsl:value-of select="a:numberNightArrestedLandings"/>
								</Night_Arrested_Lndg_Cnt>
								<Night_Field_Carr_Lndg_Prac_Cnt>
									<xsl:value-of select="a:numberNightFieldCarrierLandingPracticeLandings"/>
								</Night_Field_Carr_Lndg_Prac_Cnt>
								<Night_Fullstop_Lndg_Cnt>
									<xsl:value-of select="a:numberNightfullstopLandings"/>
								</Night_Fullstop_Lndg_Cnt>
								<Night_Hrs>
									<xsl:value-of select="a:nightTime"/>
								</Night_Hrs>
								<Night_Touch_Go_Lndg_Cnt>
									<xsl:value-of select="a:numberNightTandGLandings"/>
								</Night_Touch_Go_Lndg_Cnt>
								<Operations_Code_Ind>
									<xsl:value-of select="a:operationsCode"/>
								</Operations_Code_Ind>
								<Org_Trng_Billed_Loc_Name>
									<xsl:value-of select="a:locationUnitChargedForBilling"/>
								</Org_Trng_Billed_Loc_Name>
								<Org_Trng_Billed_Name>
									<xsl:value-of select="a:unitBilledForTraining"/>
								</Org_Trng_Billed_Name>
								<Owner_Org_Name>
									<xsl:value-of select="a:flyingOrganizationCode"/>
								</Owner_Org_Name>
								<Pilot_In_Command_Hrs>
									<xsl:value-of select="a:pilotInCommandTime"/>
								</Pilot_In_Command_Hrs>
								<Program_Element_Id_Code>
									<xsl:value-of select="a:programElementIdentifierCode"/>
								</Program_Element_Id_Code>
								<Reserve_Status_Name>
									<xsl:value-of select="a:reserveStatus"/>
								</Reserve_Status_Name>
								<Resource_Type_Desc>
									<xsl:value-of select="a:resourceType"/>
								</Resource_Type_Desc>
								<Service_Name>
									<xsl:value-of select="a:service"/>
								</Service_Name>
								<Side_Number_Desc>
									<xsl:value-of select="a:sideNumber"/>
								</Side_Number_Desc>
								<Simulated_Approach_Nbr>
									<xsl:value-of select="a:simulatedApproachNumber"/>
								</Simulated_Approach_Nbr>
								<Simulated_Approach_Type_Ind>
									<xsl:value-of select="a:simulatedApproachType"/>
								</Simulated_Approach_Type_Ind>
								<Simulated_Instrument_Hrs>
									<xsl:value-of select="a:simulatedInstrumentTime"/>
								</Simulated_Instrument_Hrs>
								<Sortie_Cnt>
									<xsl:value-of select="a:numberSorties"/>
								</Sortie_Cnt>
								<Special_Qualification_Code>
									<xsl:value-of select="a:specialQualfCode"/>
								</Special_Qualification_Code>
								<STOVL_Short_Takeoff_Cnt>
									<xsl:value-of select="a:numberStovlShortTakeoffs"/>
								</STOVL_Short_Takeoff_Cnt>
								<STOVL_Vertical_Lndg_Cnt>
									<xsl:value-of select="a:numberStovlVerticalLandings"/>
								</STOVL_Vertical_Lndg_Cnt>
								<Submission_TS>
									<xsl:value-of select="a:dateTimeOfSubmission"/>
								</Submission_TS>
								<Submitter_ALIS_User_Id>
									<xsl:value-of select="a:alisId"/>
								</Submitter_ALIS_User_Id>
								<Submitter_Employee_Id>
									<xsl:value-of select="a:employeeId"/>
								</Submitter_Employee_Id>
								<Submitter_First_Name>
									<xsl:value-of select="a:firstName"/>
								</Submitter_First_Name>
								<Submitter_Last_Name>
									<xsl:value-of select="a:lastName"/>
								</Submitter_Last_Name>
								<Submitter_Middle_Initial_Name>
									<xsl:value-of select="a:middleInitial"/>
								</Submitter_Middle_Initial_Name>
								<Submitter_Rank_Name>
									<xsl:value-of select="a:rank"/>
								</Submitter_Rank_Name>
								<Submitter_User_Name>
									<xsl:value-of select="a:submitterName"/>
								</Submitter_User_Name>
								<Support_Code>
									<xsl:value-of select="a:supportCode"/>
								</Support_Code>
								<Tail_Number_Desc>
									<xsl:value-of select="a:tailNumber"/>
								</Tail_Number_Desc>
								<Total_Flight_Hrs>
									<xsl:value-of select="a:totalTimePerLeg"/>
								</Total_Flight_Hrs>
								<Touch_Go_Lndg_Cnt>
									<xsl:value-of select="a:numberTandGLandings"/>
								</Touch_Go_Lndg_Cnt>
								<Unique_Acft_Id>
									<xsl:value-of select="a:uAI"/>
								</Unique_Acft_Id>
								<Unit_Name>
									<xsl:value-of select="a:unit"/>
								</Unit_Name>
								<Wingman_Last_Name>
									<xsl:value-of select="a:wingmanLastNames"/>
								</Wingman_Last_Name>
							</Row>
						</deck_dvlp_stage.jsf_flight>
						<xsl:for-each select="a:events/a:FlightRecordEvent">
							<deck_dvlp_stage.jsf_flight_event>
								<Row>
									<Activity_Duration_Hrs>
										<xsl:value-of select="a:activityDuration"/>
									</Activity_Duration_Hrs>
									<Flight_Doc_Id>
										<xsl:value-of select="a:postFlightDocumentNumber"/>
									</Flight_Doc_Id>
									<Instructor_ALIS_User_Id>
										<xsl:value-of select="a:instructorAlisId"/>
									</Instructor_ALIS_User_Id>
									<Instructor_First_Initial_Name>
										<xsl:value-of select="a:instructorFirstInitial"/>
									</Instructor_First_Initial_Name>
									<Instructor_Last_Name>
										<xsl:value-of select="a:instructorLastName"/>
									</Instructor_Last_Name>
									<Instructor_Rank_Name>
										<xsl:value-of select="a:instructorRank"/>
									</Instructor_Rank_Name>
									<Instructor_Reserve_Status_Ind>
										<xsl:value-of select="a:instructorReserveStatus"/>
									</Instructor_Reserve_Status_Ind>
									<Instructor_Service_Name>
										<xsl:value-of select="a:instructorService"/>
									</Instructor_Service_Name>
									<Mission_Effective_Code>
										<xsl:value-of select="a:missionEffectiveCode"/>
									</Mission_Effective_Code>
									<Mission_Or_Nonsyllabus_Code>
										<xsl:value-of select="a:missionCodeOrNonsyllabusCode"/>
									</Mission_Or_Nonsyllabus_Code>
									<Reason_For_Noneffective_Desc>
										<xsl:value-of select="a:reasonForNoneffective"/>
									</Reason_For_Noneffective_Desc>
									<Syllabus_Event_Index_Ind>
										<xsl:value-of select="a:syllabusEventIndex"/>
									</Syllabus_Event_Index_Ind>
									<Syllabus_Event_Name>
										<xsl:value-of select="a:syllabusEventName"/>
									</Syllabus_Event_Name>
									<Syllabus_Id>
										<xsl:value-of select="a:syllabusIdentifier"/>
									</Syllabus_Id>
									<Unique_Acft_Id>
										<xsl:value-of select="a:uAI"/>
									</Unique_Acft_Id>
								</Row>
							</deck_dvlp_stage.jsf_flight_event>
						</xsl:for-each>
						<xsl:for-each select="a:legs/a:FlightRecordLeg">
							<deck_dvlp_stage.jsf_flight_leg>
								<Row>
									<Arrival_ICAO_Code>
										<xsl:value-of select="a:landingIcao"/>
									</Arrival_ICAO_Code>
									<Arrival_Location_Name>
										<xsl:value-of select="a:commonNameOfArrivalBase"/>
									</Arrival_Location_Name>
									<Arrival_TS>
										<xsl:value-of select="a:landingDateTimeUtc"/>
									</Arrival_TS>
									<Depart_ICAO_Code>
										<xsl:value-of select="a:takeOffIcao"/>
									</Depart_ICAO_Code>
									<Depart_Location_Name>
										<xsl:value-of select="a:commonNameOfDepartureBase"/>
									</Depart_Location_Name>
									<Depart_TS>
										<xsl:value-of select="a:takeOffDateTimeUtc"/>
									</Depart_TS>
									<Flight_Doc_Id>
										<xsl:value-of select="a:postFlightDocumentNumber"/>
									</Flight_Doc_Id>
									<Flight_Leg_Hrs>
										<xsl:value-of select="a:flightDurationPerLeg"/>
									</Flight_Leg_Hrs>
									<Flight_Leg_Nbr>
										<xsl:value-of select="a:legNumber"/>
									</Flight_Leg_Nbr>
									<Mission_Nbr>
										<xsl:value-of select="a:missionNumber"/>
									</Mission_Nbr>
									<Program_Element_Id_Code>
										<xsl:value-of select="a:programElementIdentifierCode"/>
									</Program_Element_Id_Code>
									<Special_Use_Data_Ind>
										<xsl:value-of select="a:specialUseData"/>
									</Special_Use_Data_Ind>
									<Unique_Acft_Id>
										<xsl:value-of select="a:uAI"/>
									</Unique_Acft_Id>
								</Row>
							</deck_dvlp_stage.jsf_flight_leg>
						</xsl:for-each>
					</xsl:for-each>
				</Table>
			</Insert>
		</Transaction>
	</xsl:template>
</xsl:stylesheet><!-- Stylus Studio meta-information - (c) 2004-2009. Progress Software Corporation. All rights reserved.

<metaInformation>
	<scenarios>
		<scenario default="yes" name="JSF" userelativepaths="yes" externalpreview="no" url="alisAviatorPostFlightRecord.xml" htmlbaseurl="" outputurl="FlightMapping" processortype="saxon8" useresolver="yes" profilemode="0" profiledepth="" profilelength=""
		          urlprofilexml="" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext="" validateoutput="no" validator="internal"
		          customvalidator="">
			<advancedProp name="sInitialMode" value=""/>
			<advancedProp name="bXsltOneIsOkay" value="true"/>
			<advancedProp name="bSchemaAware" value="true"/>
			<advancedProp name="bXml11" value="false"/>
			<advancedProp name="iValidation" value="0"/>
			<advancedProp name="bExtensions" value="true"/>
			<advancedProp name="iWhitespace" value="0"/>
			<advancedProp name="sInitialTemplate" value=""/>
			<advancedProp name="bTinyTree" value="true"/>
			<advancedProp name="bWarnings" value="true"/>
			<advancedProp name="bUseDTD" value="false"/>
			<advancedProp name="iErrorHandling" value="fatal"/>
		</scenario>
	</scenarios>
	<MapperMetaTag>
		<MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="file:///d:/deckplate/dvlp/data/jsf/XSD/FlightTarget.xsd" destSchemaRoot="Transaction" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no">
			<SourceSchema srcSchemaPath="file:///d:/deckplate/dvlp/data/jsf/XSD/ALIS_UIDES_Training_Messages_201002.xsd" srcSchemaRoot="alisAviatorPostFlightRecord" AssociatedInstance="" loaderFunction="document" loaderFunctionUsesURI="no"/>
		</MapperInfo>
		<MapperBlockPosition>
			<template match="/"></template>
		</MapperBlockPosition>
		<TemplateContext></TemplateContext>
		<MapperFilter side="source"></MapperFilter>
	</MapperMetaTag>
</metaInformation>
-->