J-0200000-06 SERVICE PROVIDER INFORMATION Updated 21APR2022.xlsx

Work Order Flat File template

N = field may be empty; Y = field must be entered depending on usage of field

NOT REQUIRED IF: if work order represents Preventive Maintenance work.

REQUIRED IF: work order was received from the Government in an approved OR completed status. If work order was received after hours and constituted emergency work, enter date/time of the call. Identifies the work order's type. Some example types are: preventive maintenance, corrective maintenance, emergency maintenance. Must be valid entry as listed on "WorkType Combinations" tab.

Required: If work is received from the Government, must retain the work type provided. If the work is after hours Emergency then Work Type must be Emergency. If the work is Preventive Maintenance then the work type must be Recurring. Contractor's internal tracking number for work order.

REQUIRED: Required on all work being passed to NAVFAC Washington. Describes the work order. To enter or view additional information, click the Long Description button.

REQUIRED: passed to contractor via normal work reception channels, if passed to contractor as after hours emergency, or if work is Preventive Maintenance or other work not otherwise generated by the Government. Identifies the work order's location.

Required: If work is received from the Government via normal work reception channels, must utilize the location provided. If after hours Emergency if Preventive Maintenance, must identify the location in accordance with NAVFAC location values as shown on "Location" tab. Identifies the person reporting the work order.

REQUIRED: must use name provided via normal work reception channels. If the work is Preventive Maintenance or after hours emergency, enter "___________" UNIFORMAT Master System Designator

Required If: No Asset is submitted on the work order. Return the provided value or classify according to the work that is being perfomed Status of the work order, for example, in progress, waiting on material, waiting for approval, or completed.

Required: must enter for all work orders. Normally expect this to be "COMP". In the case of Preventive Maintenance work orders where the equipment was found to not exist, the value of "COMP-OS" shall be used. However, in all such cases the contractor shall also submit a corresponding Asset Flat File to indicate the equipment not found. Assets found to be not present shall be marked as "DEA" under Status on the Asset file. Date the work order status was last changed.

Required: Enter date the work was completed. Identifies the importance of the work order, from 0-999, where 0 is the lowest priority and 999 is the highest. If the Priority is null, in the inbound file, then this field is defaulted.

Required: If priority is provided by the Government, return value provided. Otherwise, leave blank Date and time the actual work began.

REQUIRED: work order is in a completed status. Must relfect the date and time of actual start. Date and time the actual work was completed.

REQUIRED: work order is in a completed status. Must reflect the date and time of actual completion. Supervisor of the work.

NOT Required. Actual Labor Hours

Required: Required for all work orders. Actual Labor Cost

NOT Required. Actual Material Cost

Required: Required for all work orders. Estimated remaining number of hours needed to complete the work.

NOT Required. Identifies the asset. The Asset field is for the Maximo asset identifier, the value Maximo uses to track the asset. Asset number is used to get meter data.

Required IF: Required for all Preventive Maintenance work orders. If provided by Government must be returned by Contractor. If not provided, may be returned by Contractor but must match Navy Maximo asset number. Date the work order is targeted to be completed.

REQUIRED: If passed to Contractor via normal work reception channels must return date/time provided. Otherwise, enter planned Target Finish based on schedule. Date the work order is targeted to begin.

REQUIRED: If passed to Contractor via normal work reception channels must return date/time provided. Otherwise, leave blank. Date the work order reported.

REQUIRED: If passed to Contractor via normal work reception channels must return date/time provided. Otherwise, enter date/time of reception of Emergency call or the date/time Contractor created a Preventive Maintenance work order. Lead person responsible for the work.

NOT Required. Date and time the work is scheduled to begin.

NOT Required. Date and time the work is scheduled to completed.

NOT Required. Date the work order was last modified.

REQUIRED: Enter the date/time the record was modified by Contractor. Normally will be date of submission of the flat file. Name of person who made the change to the record.

REQUIRED: If provided by NAVFAC, return value provided. Otherwise, enter "______________" From the next Next Due Date of the PM

NOT Required. Specifies whether the work order is a task. If the check box is selected, the work order is a task. If the check box is cleared, the work order is not a task.

Required: Default to "N" unless the work order is a task to another work order, then enter "Y". Normally only applies in the case of Preventive Maintenance work. Parent of the work order shown in the Work Order field.

REQUIRED IF: If work order data provided to Contractor includes a Parent Work Order number, must return the value to the Government. Identifies the work order. If work order already exists in Navy Maximo, must enter Navy Maximo Work Order Number here.

REQUIRED IF: If work order is passed to Contractor via normal work reception channels, must return value provided. Otherwise, for Preventive Maintenance and after hours Emergency work leave blank. REQUIRED IF: information provided to Contractor must be returned. Otherwise may leave blank. Contract Line Item Number

NOT Required. Identifies Navy's internal customer.

Required IF: If value is provide to Contractor via normal work reception channels must return value provided. Otherwise leave blank. Defaulted field based on the value of worktype. Must be valid entry as listed on "WorkType Combinations" tab.

Required: If work is received from Government via normal work reception channels, must return value provided. For Preventive Maintenance work use "PM", for after hours Emergency work use "KTR". Identifies the work center performing the work.

Required: If work is received from Government via normal work reception channels, must return value provided. For Preventive Maintenance and after hours Emergency work use value provide separately.

WorkType Combinations

EMERGENCY UTILITIES Utilities related Situations which require immediate action to prevent loss or damage to government property; restore essential services that have been disrupted; eliminate hazard to personnel; restore essential mission operational capability.

ROUTINE UTILITIES Any UEM deficiency that does not qualify as Emergency or Urgent, but is needed to maintain the agreed upon facility condition

URGENT FACILITIES Any deficiency that not immediately endanger personnel or property but extended delays of repairs could result in damage to Government property or soon affect the security, health or well-being of personnel or the continued operation of a service system

Location