 |
|||
|
|
|||
|
Page Title:
Appendix C: OASIS Data Base Structure Summary |
|
||
| ||||||||||
|
|
 NAVAIR 17-15-50.1
TM 38-301-1
T.O.33-1-37-1
CGTO 33-1-37-1
OASIS Data Base Structure Summary
Structure for Database: TAPEFILE.DBF
Fld
Fld Name
Type
Width Dec Start
End
1
TRANSCODE
C
1
1
1
Code for Transaction being recorded
I - Initial Record for this Sample
C - Change Record for Sample
D - Sample Deleted Record
F - Feedback Record
U - Undelete Sample Record
2
DT_STAMP
C
14
2
15
Date and time record created Format =
YYYYMMDDHHMMSS
3
TYPEQUIP
C
1
16
16
Type of Equipment (Air, Grd, Qa, etc)
4
TEC
C
4
17
20
Component TEC
5
ACCES
C
1
21
21
Currently Unused
6
COMPSN
C
15
22
36
Component Serial Number
7
DT_SAMPLE
C
8
37
44
Date Sample Taken
8
SAMPNO
C
5
45
49
Sample Number
9
COMPMOD
C
12
50
61
Component Model Number
10
EISN
C
12
62
73
End Item Serial Number at
Time Component Sampled
11
EIMOD
C
11
74
84
End Item Model Number
12
UIC
C
6
85
90
UIC at time Component Sampled
13
MAJCOM
C
3
91
93
Major Command of UIC in Field 12
14
LABCODE
C
3
94
96
Testing Labs Lab Code
15
TRANSIT
C
2
97
98
Days from Sample Date to Received
16
REASSAMP
N
1
99
99
Reason for this sample
17
HRSCOMP
N
6
100
105
Hours since last complete overhaul
18
HRSOIL
N
4
106
109
Hours since last oil change
19
OIL
C
3
110
112
Amount of Oil Added
20
MEAS
C
1
113
113
Measurement unit of Oil Added
21
LABREC
C
1
114
114
Lab Rec for this sample
22
COMPREC
C
1
115
115
Calculated Computer Rec for Sample
23
SPEC_REDG
C
60
116
175
Spectrometer readings and Flags in Character
format (15 elements)
24
MILEIND
C
1
176
176
Mileage Reading (M, K, or H)
25
MILEAGE
N
6
177
182
Mileage or Hours usage
26
REMARKS
C
30
183
212
1st 30 characters or remarks field Fields 27 thru
38 will be blank of 0's in cases where component
does not require physical tests
27
CRACKLE
C
3
213
215
Crackle test results code
28
VISC
C
3
216
218
Viscosity test results code
29
FUELDIL
C
3
219
221
Fuel dilution percent
30
INSOL
C
3
222
224
Solubility test results code
31
PHYSREC1
C
2
225
226
Lab Physical Rec. Code 1
32
PHYSREC2
C
2
227
228
Lab Physical Rec. Code 2
33
PHYSREC3
C
2
229
230
Lab Physical Rec. Code 3
34
TEMP
C
3
231
233
Oil temp. for physical test
35
CONTAM
C
1
234
234
Contamination results code
36
COOL
C
1
235
235
Coolant test results code
37
ALKIN
C
1
236
236
Alkalinity test results code
C-1
|
|
Privacy Statement - Press Release - Copyright Information. - Contact Us |
Click
here for thousands of PDF manuals