Appendix C: OASIS Data Base Structure Summary (Cont)

NAVAIR 17-15-50.1

TM 38-301-1

T.O.33-1-37-1

CGTO 33-1-37-1

Appendix C (continued)

US Army Oil Analysis Reports

(Monthly) Resample and Type Recommendation Report

This report is a summary of the latest samples with a laboratory recommendation other than normal. A

recommendation is considered abnormal if it is other than an "A" for spectrometric advices or other than "AA" for

physical advices. In case of ground equipment with an advice code of "Z" (previous recommendation still

applies), the number of Z advices is also counted and reported.

The report shows the component serial number, end-item model, end-item serial number, component model,

date sample analyzed, either the physical or spectrometric lab advice depending on the level of significance of

the advice code, and a narrative interpretation of the advice code.

The report items are grouped by UIC. The report may address only specific UIC's, Sort Codes, or all UIC's. See

page D-5 for an example of this report.

(Monthly) Monthly Activity Report

The Monthly Activity Report is grouped by UIC, and up to four copies may be requested. The report shows the

component model, component serial number, end-item serial number, sample number, date sample analyzed,

days in transit, hours since overhaul, hours since oil change, reason for sample and either the physical or

spectrometric lab advice depending on the level of significance of the advice code.

This information is shown for all samples for each piece of equipment. The report also includes totals for number

of samples analyzed for the month, the average days in transit, and the n umber of samples processed with

'UNKNOWN" HSOH (hours since overhaul) and HSOC (hours since oil change). See page D-6 for an example

of this report.

(Monthly) End Item Configuration Report

The End Item Configuration Report shows the end-item model, end-item serial number, UIC, component model,

component serial number, and dates of the last five samples taken. This report is sorted by end-item serial

number, component model, and component serial number. See page D-7 for an example of this report.

(Monthly) Summary by Equipment Type Report

The Summary by Equipment Type Report is a summary of laboratory recommendations given for samples

processed for the previous month. See page D-8 for an example of this report.

(Monthly) Components Enrolled Report

The Components Enrolled Report lists the history records that contain a sample processed in the lab during the

reporting period. The report includes all components enrolled through the last day of the previous month.

The top of the report shows the sort code, UIC, unit name and address, report date, and name of the laboratory.

For ground equipment, the body of the reports shows bumper number, end-item model, end-item serial number,

component model, component serial number, hours since overhaul, hours since oil change, sampling interval

hours/days, date sample taken, reason sampled, and remarks. If the equipment is TDY, the word TDY will

appear in the remarks column.

C-3