Appendix TMC Repair Order Data Element Mapping To AIAG/Star XML Schema
| Element/Attribute | (Maps to) Properties/Annotation |
|---|---|
| REPAIR ORDER (GENERAL) INFORMATION | |
| Repair Order Number | RepairOrder/star:RepairOrderHeader/star:DocumentIdentificationGroup/star:DocumentIdentification/DocumentID |
| Date | RepairOrder/star:RepairOrderHeader/DocumentDateTime |
| Repair Priority | RepairOrder/star:RepairOrderHeader/RepairOrderPriorityCode |
| Repair Site | RepairOrder/star:RepairOrderHeader/LocationID |
| Continuation Repair Order | RepairOrder/star:JobReferback/JobReferbackNumberString |
| Date/Time Promised | RepairOrder/starRepairOrderHeader/PromisedRepairCompletionDate |
| Written By | RepairOrder/star:RepairOrderHeader/star:ServiceAdvisorParty/PartyID |
| Reason for Repair | RepairOrder/star:RepairOrderHeader/star:CASE/CaseTypeCode |
| Instructions | RepairOrder/star:RepairOrderHeader/OrderNotes |
| COMPANY INFORMATION | |
| Company Code | RepairOrder/starRepairOrderHeader/star:RepairOrderVehicleLineItem/star:FleetAccount/FleetAccountString |
| Facility Code | RepairOrder/starRepairOrderHeader/star:RepairOrderVehicleLineItem/star:FleetAccount/FleetAccountCode |
| Facility Identification | RepairOrder/starRepairOrderHeader/star:RepairOrderVehicleLineItem/star:FleetAccount/RegistrationFleetID |
| EQUIPMENT/VEHICLE INFORMATION | |
| Fleet identification | RepairOrder/star:RepairOrderHeader/star:RepairOrderVehicleLineItem/star:FleetAccount/FleetVehicleID |
| Equipment/Vehicle Identification | RepairOrder/starRepairOrderHeader/star:RepairOrderVehicleLineItem/star:FleetAccount/FleetVehicleID |
| Company Name | RepairOrder/star:RepairOrderHeader/star:OwnerParty/star:SpecifiedOrganization/CompanyName |
| Meter Reading | RepairOrder/star:RepairOrderHeader/InDistanceMeasure |
| Activity Code | RepairOrder/star:RepairOrderHeader/star:RepairOrderVehicleLineItem/ActivityCode |
| COMPONENT (PART) INFORMATION | |
| System | RepairOrder/star:Job/star:ServiceParts/star:ItemIdentificationGroup/star:ItemIdentification/ItemID Comment: System, Assembly, Component and Part Number all map to ItemID. Usage is identified by SchemeID 31,32, 33 which correspond to VMRS Code Key 31, 32, 33 respectively. Part number is just a string. |
| Assembly | RepairOrder/star:Job/star:ServiceParts/star:ItemIdentificationGroup/star:ItemIdentification/ItemID Comment: System, Assembly, Component and Part Number all map to ItemID. Usage is identified by SchemeID 31,32, 33 which correspond to VMRS Code Key 31, 32, 33 respectively. Part number is just a string. |
| Component | RepairOrder/star:Job/star:ServiceParts/star:ItemIdentificationGroup/starItemIdentification/ItemID Comment: System, Assembly, Component and Part Number all map to ItemID. Usage is identified by SchemeID 31,32, 33 which correspond to VMRS Code Key 31, 32, 33 respectively. Part number is just a string. |
| Part Number | RepairOrder/star:Job/star:ServiceParts/star:ItemIdentificationGroup/star:ItemIdentification/ItemID Comment: System, Assembly, Component and Part Number all map to ItemID. Usage is identified by SchemeID 31,32, 33 which correspond to VMRS Code Key 31, 32, 33 respectively. Part number is just a string. |
| Part Description | RepairOrder/star:Job/star:ServiceParts/ItemIdDescription |
| Manufacturer Code | RepairOrder/star:Job/star:ServiceParts/PartSourceCode |
| Quantity | RepairOrder/star:Job/star:ServiceParts/ItemQuantity |
| Unit Price | RepairOrder/star:Job/star:ServiceParts/star:Pricing/starPrice/ChargeAmount |
| Condition Code | RepairOrder/star:Job/star:ServiceParts/ItemServiceCode |
| Part Cost | Comment: Cost maps to charge amount and PriceCode which indicates what is the type of price (e.g., unit vs. total). RepairOrder/star:Job/star:ServiceParts/star:Pricing/star:Price/ChargeAmount |
| Total Part Price | RepairOrder/star:RepairOrderHeader/star:Sublet7star:ServiceParts/star:Pricing/starPrice/ChargeAmount |
| Tax | RepairOrder/star:RepairOrderHeader/star:Tax/TaxAmount |
| Cost | RepairOrder/star:RepairOrderHeader/star:Price/ChargeAmount |
| LABOR INFORMATION | |
| Completion Date | RepairOrder/star:Job/star:ServiceLabor/CompletionDateTime |
| Employee Number | RepairOrder/star:Job/star:ServiceLabor/star:ServiceTechnicianParty/star:SpecifiedPerson/ID |
| System | RepairOrder/star:Job/star:ServiceLabor/star:ServiceParts/star:ItemIdentificationGroup/starItemIdentification/ItemlD Comment: System, Assembly, Component and Part Number all map to ItemID. Usage is identified by SchemeID 31,32, 33 which correspond to VMRS Code Key 31, 32, 33 respectively. |
| Assembly | RepairOrder/star:Job/star:ServiceLabor/star:ServiceParts/star:ItemIdentificationGroup/starItemIdentification/ItemID Comment: System, Assembly, Component and Part Number all map to ItemID. Usage is identified by SchemeID 31,32, 33 which correspond to VMRS Code Key 31, 32, 33 respectively. |
| Work Accomplished | RepairOrder/star:Job/star:ServiceLabor/LaborActionCode |
| Standard Time | RepairOrder/star:Job/star:ServiceLabor/LaborAllowanceHoursNumeric |
| Actual Time | RepairOrder/star:Job/star:ServiceLabor/LaborActualHoursNumeric |
| Labor Cost | RepairOrder/star:Job/star:ServiceLabor/star:Pricing/star:Price/ChargeAmount |
| Total Labor Cost | RepairOrder/star:RepairOrderHeader/star:Sublet/star:ServiceLabor/star:Pricing/star:Price/ChargeAmount |
| Technician Comments | RepairOrder/star:Job/star:ServiceLabor/star:LaborNarrative/Narrative |
| METER RESET INFORMATION | |
| Old Meter Reading | RepairOrder/star:RepairOrderHeader/star:RepairOrderVehicleLineItem/OldOdometerDistanceMeasure |
| Reset/Replacement Reading | RepairOrder/star:RepairOrderHeader/star:RepairOrderVehicleLineItem/NewOdometerDistanceMeasure |
| Estimated Utilization (Number Reading) | RepairOrder/star:RepairOrderHeader/star:RepairOrderVehicleLineItem/EstimatedUsageDistanceMeasure |
| INSPECTION INFORMATION | |
| Inspected By | RepairOrder/star:Job/star:ServiceTechnicianParty/star:SpecifiedPerson/GivenName |
| Date Inspected | RepairOrder/star:Job/star:ServiceTechnicianParty/star:PartyActionEvent/EventOccurrenceDateTime |
| VENDOR NOTIFICATION | |
| Vendor Name | RepairOrder/star:RepairOrderHeader/star:Sublet/ProviderName |
| Invoice Number | RepairOrder/star:R!epairOrderHeader/star:Sublet/SubletInvoiceNumberString |