The outline of this page roughly follows the steps described in section 3.10 of
FEND-40.09.03.00-008-A-DSN. Some of the numbers in the table of contents may be cross-referenced with that document.
Contents |
1 First cartridge data delivery |
2 Data delivery with second and subsequent cartridges |
3.10.1 Replacement of a Mixer |
3.10.2 Replacement of a Cold Preamplifier |
3.10.3 Replacement of a Temperature Sensor |
3.10.4 Replacement of a Cold Cartridge Bias Module |
3.10.5 Replacement of a WCA or one or more Warm IF Amplifiers |
3.10.6 Replacement of a Photomixer |
1 First cartridge data delivery
(This is approximately the sample data I sent in a zip file on 20 Jan 2006:
Sample1CSV.zip)
A Cartridge is delivered along with its operating and test data...
Cartridge Operating Parameters
COLDCARTS
keyBand |
keyColdCarts |
fkMixer0 |
fkMixer1 |
fkMixer2 |
fkMixer3 |
fkPreamp0 |
fkPreamp1 |
fkPreamp2 |
fkPreamp3 |
fkTempSensor0 |
fkTempSensor1 |
fkTempSensor2 |
fkTempSensor3 |
fkTempSensor4 |
fkTempSensor5 |
TS |
TS_Removed |
SN |
ESN |
Notes |
6 |
1 |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
5 |
0 |
2005-12-13 14:30:00 |
0 |
COLD SN2 |
ABCD0123EF456789 |
Sample Cold Cartridge 2 |
MIXERS
keyBand |
keyMixers |
TS |
TS_Removed |
SN |
Notes |
6 |
1 |
2005-12-13 14:30:00 |
0 |
SN MIXER 201 |
Sample Mixer 1 |
6 |
2 |
2005-12-13 14:30:00 |
0 |
SN MIXER 202 |
Sample Mixer 2 |
6 |
3 |
2005-12-13 14:30:00 |
0 |
SN MIXER 203 |
Sample Mixer 3 |
6 |
4 |
2005-12-13 14:30:00 |
0 |
SN MIXER 204 |
Sample Mixer 4 |
MIXERPARAMS
keyBand |
keyMixerParams |
fkMixers |
Temperature |
FreqLO |
TS |
VJ |
IJ |
IMAG |
6 |
5 |
1 |
3.72 |
263.000000 |
2005-12-13 14:30:00 |
-9.10 |
-49.7 |
24.0 |
6 |
4 |
1 |
3.72 |
253.000000 |
2005-12-13 14:30:00 |
-9.10 |
-49.8 |
24.0 |
6 |
3 |
1 |
3.72 |
243.000000 |
2005-12-13 14:30:00 |
-9.10 |
-51.0 |
24.0 |
6 |
2 |
1 |
3.72 |
233.000000 |
2005-12-13 14:30:00 |
-9.10 |
-48.6 |
24.0 |
6 |
1 |
1 |
3.72 |
223.000000 |
2005-12-13 14:30:00 |
-9.10 |
-36.8 |
24.0 |
6 |
6 |
2 |
3.72 |
223.000000 |
2005-12-13 14:30:00 |
8.60 |
34.0 |
24.3 |
6 |
7 |
2 |
3.72 |
233.000000 |
2005-12-13 14:30:00 |
8.60 |
48.3 |
24.3 |
6 |
8 |
2 |
3.72 |
243.000000 |
2005-12-13 14:30:00 |
8.60 |
47.4 |
24.3 |
6 |
9 |
2 |
3.72 |
253.000000 |
2005-12-13 14:30:00 |
8.60 |
46.8 |
24.3 |
6 |
10 |
2 |
3.72 |
263.000000 |
2005-12-13 14:30:00 |
8.60 |
46.5 |
24.3 |
6 |
11 |
3 |
3.72 |
223.000000 |
2005-12-13 14:30:00 |
-9.00 |
-40.5 |
24.0 |
6 |
12 |
3 |
3.72 |
233.000000 |
2005-12-13 14:30:00 |
-9.00 |
-50.0 |
24.0 |
6 |
13 |
3 |
3.72 |
243.000000 |
2005-12-13 14:30:00 |
-9.00 |
-50.0 |
24.0 |
6 |
14 |
3 |
3.72 |
253.000000 |
2005-12-13 14:30:00 |
-9.00 |
-49.8 |
24.0 |
6 |
15 |
3 |
3.72 |
263.000000 |
2005-12-13 14:30:00 |
-9.00 |
-50.1 |
24.0 |
6 |
16 |
4 |
3.72 |
223.000000 |
2005-12-13 14:30:00 |
8.60 |
35.2 |
24.3 |
6 |
17 |
4 |
3.72 |
233.000000 |
2005-12-13 14:30:00 |
8.60 |
44.9 |
24.3 |
6 |
18 |
4 |
3.72 |
243.000000 |
2005-12-13 14:30:00 |
8.60 |
47.5 |
24.3 |
6 |
19 |
4 |
3.72 |
254.000000 |
2005-12-13 14:30:00 |
8.60 |
45.3 |
24.3 |
6 |
20 |
4 |
3.72 |
263.000000 |
2005-12-13 14:30:00 |
8.60 |
45.0 |
24.3 |
PREAMPS
keyBand |
keyPreamps |
TS |
TS_Removed |
SN |
ILED |
Notes |
6 |
1 |
2005-12-13 14:30:00 |
0 |
SN PREAMP 00 |
0.0 |
Sample Preamp 1 |
6 |
2 |
2005-12-13 14:30:00 |
0 |
SN PREAMP 01 |
0.0 |
Sample Preamp 2 |
6 |
3 |
2005-12-13 14:30:00 |
0 |
SN PREAMP 10 |
0.0 |
Sample Preamp 3 |
6 |
4 |
2005-12-13 14:30:00 |
0 |
SN PREAMP 11 |
0.0 |
Sample Preamp 4 |
PREAMPPARAMS
keyBand |
keyPreampParams |
fkPreamps |
Temperature |
FreqLO |
TS |
VD1 |
VD2 |
VD3 |
ID1 |
ID2 |
ID3 |
VG1 |
VG2 |
VG3 |
6 |
1 |
1 |
2.73 |
223.000000 |
2005-12-13 14:30:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
6 |
2 |
2 |
2.73 |
223.000000 |
2005-12-13 14:30:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
6 |
3 |
3 |
2.73 |
223.000000 |
2005-12-13 14:30:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
6 |
4 |
4 |
2.73 |
223.000000 |
2005-12-13 14:30:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
TEMPSENSORS
keyBand |
keyTempSensors |
fkColdCarts |
TS |
TS_Removed |
Location |
Model |
SN |
OffsetK |
Notes |
6 |
1 |
1 |
2004-08-27 00:00:00 |
0 |
1 |
1 |
D59639 |
0.00 |
0 |
6 |
2 |
1 |
2004-08-27 00:00:00 |
0 |
2 |
1 |
D59361 |
0.00 |
0 |
6 |
3 |
1 |
2004-08-27 00:00:00 |
0 |
3 |
2 |
D58853 |
-0.03 |
0 |
6 |
4 |
1 |
2004-08-27 00:00:00 |
0 |
4 |
2 |
D58867 |
0.01 |
0 |
6 |
5 |
1 |
2004-08-27 00:00:00 |
0 |
5 |
2 |
D58866 |
-0.10 |
0 |
BIASMODS
keyBand |
keyBiasMods |
fkCartAssys |
TS |
TS_Removed |
SN |
Notes |
6 |
1 |
1 |
2005-12-13 14:30:00 |
0 |
BIAS MOD 32 |
Sample Bias Module |
WCAS
keyBand |
keyWCAs |
fkCartAssys |
TS |
TS_Removed |
SN |
ESN |
SN_PwrAmp |
FloYIG |
FhiYIG |
Notes |
6 |
1 |
1 |
2005-12-13 00:00:00 |
0 |
SN WCA 22 |
889900AABBCCDDEE |
SN PWR AMP 11 |
12.151000 |
14.808000 |
Sample WCA 22 |
LOPARAMS
keyBand |
keyLOParams |
fkWCAs |
FreqLO |
TS |
VDP0 |
VDP1 |
VGP0 |
VGP1 |
AttenP0 |
AttenP1 |
VDAMC |
6 |
1 |
1 |
223.000000 |
2005-12-13 00:00:00 |
0.00 |
0.00 |
-0.05 |
0.05 |
0.00 |
0.00 |
4.00 |
WARMIFPLATES
keyBand |
keyWIFPlates |
fkCartAssys |
TS |
TS_Removed |
SN_WIF0 |
SN_WIF1 |
SN_WIF2 |
SN_WIF3 |
Notes |
6 |
1 |
1 |
2005-12-13 00:00:00 |
0 |
W01 |
W02 |
W06 |
W07 |
Sample Warm IF Plate |
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
1 |
1 |
1 |
1 |
1 |
2005-12-13 00:00:00 |
0 |
SN_PM_000 |
Sample Cartridge Assembly |
Cartridge Test Data
Only showing noise temperature for brevity and convenience...
Note that the combination (keyBand, fkCartAssys) references a single record in CARTASSEMBLIES.
NOISE_TEMPERATURE
keyBand |
keyDataSet |
fkCartAssys |
TS |
FreqLO |
CenterIF |
BWIF |
Pol |
SB |
TReceiver |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
4.000000 |
1.000000 |
0 |
1 |
274.6 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
4.000000 |
1.000000 |
0 |
2 |
661.3 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
4.000000 |
1.000000 |
1 |
1 |
132.2 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
4.000000 |
1.000000 |
1 |
2 |
323.0 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
5.000000 |
1.000000 |
0 |
1 |
661.3 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
5.000000 |
1.000000 |
0 |
2 |
661.3 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
5.000000 |
1.000000 |
1 |
1 |
323.0 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
5.000000 |
1.000000 |
1 |
2 |
323.0 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
6.000000 |
1.000000 |
0 |
1 |
170.5 |
6 |
1 |
1 |
2005-12-13 16:33:00 |
223.000000 |
6.000000 |
1.000000 |
0 |
2 |
170.5 |
... |
2 Data delivery with second and subsequent cartridges
A second cartridge is delivered with its operating and test data...
Note that these data files do not contain any of the previously delivered records. All of the keyXxx fields are unique, both internally and with respect to the ones in the first batch.
COLDCARTS
keyBand |
keyColdCarts |
fkMixer0 |
fkMixer1 |
fkMixer2 |
fkMixer3 |
fkPreamp0 |
fkPreamp1 |
fkPreamp2 |
fkPreamp3 |
fkTempSensor0 |
fkTempSensor1 |
fkTempSensor2 |
fkTempSensor3 |
fkTempSensor4 |
fkTempSensor5 |
TS |
TS_Removed |
SN |
ESN |
Notes |
6 |
2 |
5 |
6 |
7 |
8 |
5 |
6 |
7 |
8 |
6 |
7 |
8 |
9 |
10 |
0 |
2006-02-01 00:00:00 |
0 |
COLD SN3 |
7FFF7FFF7FFFF7FF |
Sample Cold Cartridge 3 |
MIXERS
keyBand |
keyMixers |
TS |
TS_Removed |
SN |
Notes |
6 |
5 |
2006-02-01 00:00:00 |
0 |
SN MIXER 301 |
Sample Mixer 5 |
6 |
6 |
2006-02-01 00:00:00 |
0 |
SN MIXER 302 |
Sample Mixer 6 |
6 |
7 |
2006-02-01 00:00:00 |
0 |
SN MIXER 303 |
Sample Mixer 7 |
6 |
8 |
2006-02-01 00:00:00 |
0 |
SN MIXER 304 |
Sample Mixer 8 |
MIXERPARAMS
keyBand |
keyMixerParams |
fkMixers |
Temperature |
FreqLO |
TS |
VJ |
IJ |
IMAG |
6 |
21 |
8 |
3.72 |
263.000000 |
2006-02-01 00:00:00 |
8.50 |
44.1 |
24.2 |
6 |
22 |
8 |
3.72 |
254.000000 |
2006-02-01 00:00:00 |
8.50 |
45.8 |
24.3 |
6 |
23 |
8 |
3.72 |
243.000000 |
2006-02-01 00:00:00 |
8.40 |
49.4 |
24.3 |
6 |
24 |
8 |
3.72 |
233.000000 |
2006-02-01 00:00:00 |
8.90 |
41.5 |
24.3 |
6 |
25 |
8 |
3.72 |
223.000000 |
2006-02-01 00:00:00 |
9.00 |
37.5 |
24.2 |
6 |
26 |
7 |
3.72 |
263.000000 |
2006-02-01 00:00:00 |
-8.70 |
-54.1 |
23.9 |
6 |
27 |
7 |
3.72 |
253.000000 |
2006-02-01 00:00:00 |
-9.20 |
-52.8 |
23.9 |
6 |
28 |
7 |
3.72 |
243.000000 |
2006-02-01 00:00:00 |
-9.40 |
-52.9 |
24.1 |
6 |
29 |
7 |
3.72 |
233.000000 |
2006-02-01 00:00:00 |
-8.50 |
-54.7 |
23.9 |
6 |
30 |
7 |
3.72 |
223.000000 |
2006-02-01 00:00:00 |
-9.20 |
-42.1 |
24.1 |
6 |
31 |
6 |
3.72 |
263.000000 |
2006-02-01 00:00:00 |
9.10 |
50.1 |
24.3 |
6 |
32 |
6 |
3.72 |
253.000000 |
2006-02-01 00:00:00 |
8.50 |
46.9 |
24.3 |
6 |
33 |
6 |
3.72 |
243.000000 |
2006-02-01 00:00:00 |
8.30 |
42.7 |
24.4 |
6 |
34 |
6 |
3.72 |
233.000000 |
2006-02-01 00:00:00 |
8.90 |
48.2 |
24.2 |
6 |
35 |
6 |
3.72 |
223.000000 |
2006-02-01 00:00:00 |
8.50 |
33.6 |
24.2 |
6 |
36 |
5 |
3.72 |
223.000000 |
2006-02-01 00:00:00 |
-9.40 |
-37.4 |
24.1 |
6 |
37 |
5 |
3.72 |
233.000000 |
2006-02-01 00:00:00 |
-9.30 |
-51.9 |
23.9 |
6 |
38 |
5 |
3.72 |
243.000000 |
2006-02-01 00:00:00 |
-8.80 |
-50.9 |
24.0 |
6 |
39 |
5 |
3.72 |
253.000000 |
2006-02-01 00:00:00 |
-9.30 |
-52.8 |
23.9 |
6 |
40 |
5 |
3.72 |
263.000000 |
2006-02-01 00:00:00 |
-9.10 |
-49.6 |
23.9 |
PREAMPS
keyBand |
keyPreamps |
TS |
TS_Removed |
SN |
ILED |
Notes |
6 |
5 |
2006-02-01 00:00:00 |
0 |
SN PREAMP 20 |
0.0 |
Sample Preamp 5 |
6 |
6 |
2006-02-01 00:00:00 |
0 |
SN PREAMP 21 |
0.0 |
Sample Preamp 6 |
6 |
7 |
2006-02-01 00:00:00 |
0 |
SN PREAMP 22 |
0.0 |
Sample Preamp 7 |
6 |
8 |
2006-02-01 00:00:00 |
0 |
SN PREAMP 23 |
0.0 |
Sample Preamp 8 |
PREAMPPARAMS
keyBand |
keyPreampParams |
fkPreamps |
Temperature |
FreqLO |
TS |
VD1 |
VD2 |
VD3 |
ID1 |
ID2 |
ID3 |
VG1 |
VG2 |
VG3 |
6 |
5 |
5 |
2.73 |
223.000000 |
2006-02-01 00:00:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
6 |
6 |
6 |
2.73 |
223.000000 |
2006-02-01 00:00:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
6 |
7 |
7 |
2.73 |
223.000000 |
2006-02-01 00:00:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
6 |
8 |
8 |
2.73 |
223.000000 |
2006-02-01 00:00:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
TEMPSENSORS
keyBand |
keyTempSensors |
fkColdCarts |
TS |
TS_Removed |
Location |
Model |
SN |
OffsetK |
Notes |
6 |
6 |
2 |
2005-12-11 00:00:00 |
0 |
1 |
1 |
D56738 |
0.00 |
0 |
6 |
7 |
2 |
2005-12-11 00:00:00 |
0 |
2 |
1 |
D52043 |
0.00 |
0 |
6 |
8 |
2 |
2005-12-11 00:00:00 |
0 |
3 |
2 |
D52302 |
-0.02 |
0 |
6 |
9 |
2 |
2005-12-11 00:00:00 |
0 |
4 |
2 |
D58765 |
-0.05 |
0 |
6 |
10 |
2 |
2005-12-11 00:00:00 |
0 |
5 |
2 |
D59712 |
0.00 |
0 |
BIASMODS
keyBand |
keyBiasMods |
fkCartAssys |
TS |
TS_Removed |
SN |
Notes |
6 |
2 |
2 |
2006-02-01 00:00:00 |
0 |
BIAS MOD 35 |
Another Sample Bias Module |
WCAS
keyBand |
keyWCAs |
fkCartAssys |
TS |
TS_Removed |
SN |
ESN |
SN_PwrAmp |
FloYIG |
FhiYIG |
Notes |
6 |
2 |
2 |
2006-02-01 00:00:00 |
0 |
SN WCA 24 |
7F8F9F8F9F7F7F9F |
SN PWR AMP 14 |
12.151300 |
14.806300 |
Sample WCA 24 |
LOPARAMS
keyBand |
keyLOParams |
fkWCAs |
FreqLO |
TS |
VDP0 |
VDP1 |
VGP0 |
VGP1 |
AttenP0 |
AttenP1 |
VDAMC |
6 |
2 |
2 |
223.000000 |
2006-02-01 00:00:00 |
0.00 |
0.00 |
-0.10 |
0.03 |
0.00 |
0.00 |
0.00 |
WARMIFPLATES
keyBand |
keyWIFPlates |
fkCartAssys |
TS |
TS_Removed |
SN_WIF0 |
SN_WIF1 |
SN_WIF2 |
SN_WIF3 |
Notes |
6 |
2 |
2 |
2006-02-01 00:00:00 |
0 |
W09 |
W11 |
W13 |
W15 |
Sample Warm IF Plate 2 |
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
2 |
2 |
2 |
2 |
2 |
2006-02-01 00:00:00 |
0 |
SN_PM_001 |
Sample Cartridge Assembly 2 |
NOISE_TEMPERATURE
keyBand |
keyDataSet |
fkCartAssys |
TS |
FreqLO |
CenterIF |
BWIF |
Pol |
SB |
TReceiver |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.000000 |
0.100000 |
0 |
2 |
51.9 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.000000 |
0.100000 |
0 |
1 |
48.1 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.100000 |
0.100000 |
0 |
2 |
50.9 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.100000 |
0.100000 |
0 |
1 |
49.8 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.200000 |
0.100000 |
0 |
2 |
49.6 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.200000 |
0.100000 |
0 |
1 |
51.5 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.300000 |
0.100000 |
0 |
2 |
49.7 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.300000 |
0.100000 |
0 |
1 |
52.2 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.400000 |
0.100000 |
0 |
2 |
51.3 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.400000 |
0.100000 |
0 |
1 |
49.7 |
6 |
1 |
2 |
2006-01-09 10:00:36 |
223.000000 |
4.500000 |
0.100000 |
0 |
2 |
50.9 |
... |
3.10.1 Replacement of a Mixer
When a cartridge has been returned and then sent back to the integration center after repair...
"Update the TS_Removed field in MIXERS with the date and time the old mixer was removed."
"Create a new record in MIXERS having a unique value of keyMixers and have the date and time that the old mixer was removed as the value of TS"
MIXERS
keyBand |
keyMixers |
TS |
TS_Removed |
SN |
Notes |
6 |
1 |
2005-12-13 14:30:00 |
2006-03-15 00:00:00 |
SN MIXER 201 |
Sample Mixer 1 removed for repair |
6 |
9 |
2006-03-15 00:00:00 |
0 |
SN MIXER 404 |
Sample Mixer 9 was installed to replace Mixer 1 |
"Create a new collection of records in MIXERPARAMS having new unique values of keyMixerParams and having the new value of keyMixers as fkMixers."
MIXERPARAMS
keyBand |
keyMixerParams |
fkMixers |
Temperature |
FreqLO |
TS |
VJ |
IJ |
IMAG |
6 |
41 |
9 |
3.72 |
263.000000 |
2006-02-01 00:00:00 |
8.40 |
44.3 |
24.2 |
6 |
42 |
9 |
3.72 |
254.000000 |
2006-02-01 00:00:00 |
8.70 |
40.9 |
24.2 |
6 |
43 |
9 |
3.72 |
243.000000 |
2006-02-01 00:00:00 |
8.00 |
45.9 |
24.3 |
6 |
44 |
9 |
3.72 |
233.000000 |
2006-02-01 00:00:00 |
9.20 |
44.9 |
24.4 |
6 |
45 |
9 |
3.72 |
223.000000 |
2006-02-01 00:00:00 |
8.60 |
38.1 |
24.2 |
"Update the TS_Removed field in COLDCARTS with the date and time the cold cartridge was actually removed from available stock."
"Create a new record in COLDCARTS having a new unique value of keyColdCarts and having all the same values as the old record except: The new value of keyMixers is stored in fkMixerN; the date and them the old mixer was removed as TS."
COLDCARTS
keyBand |
keyColdCarts |
fkMixer0 |
fkMixer1 |
fkMixer2 |
fkMixer3 |
fkPreamp0 |
fkPreamp1 |
fkPreamp2 |
fkPreamp3 |
fkTempSensor0 |
fkTempSensor1 |
fkTempSensor2 |
fkTempSensor3 |
fkTempSensor4 |
fkTempSensor5 |
TS |
TS_Removed |
SN |
ESN |
Notes |
6 |
1 |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
5 |
0 |
2005-12-13 14:30:00 |
2006-03-15 00:00:00 |
COLD SN2 |
ABCD0123EF456789 |
Sample Cold Cartridge 2 |
6 |
3 |
9 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
5 |
0 |
2006-03-15 00:00:00 |
0 |
COLD SN2 |
ABCD0123EF456789 |
Sample Cold Cartridge 2 replaced mixer |
"Update the TS_Removed field in CARTASSEMBLIES with the date and time the cold cartridge (and therefore, old mixer) was removed."
"Create a new record in CARTASSEMBLIES having a new unique value of keyCartAssys and having all the same values as the old record except: The new value of keyColdCarts is stored in fkColdCarts; the date and time the old mixer was removed as TS."
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
1 |
1 |
1 |
1 |
1 |
2005-12-13 00:00:00 |
2006-03-15 00:00:00 |
SN_PM_000 |
Sample Cartridge Assembly |
6 |
3 |
3 |
1 |
1 |
1 |
2006-03-15 00:00:00 |
0 |
SN_PM_000 |
Sample Cartridge Assembly replaced mixer |
New test data references the new CARTASSEMBLIES record:
NOISE_TEMPERATURE
keyBand |
keyDataSet |
fkCartAssys |
TS |
FreqLO |
CenterIF |
BWIF |
Pol |
SB |
TReceiver |
6 |
1 |
3 |
2006-03-15 00:00:00 |
223.000000 |
4.000000 |
0.100000 |
0 |
2 |
51.9 |
6 |
1 |
3 |
2006-03-15 00:00:00 |
223.000000 |
4.000000 |
0.100000 |
0 |
1 |
48.1 |
6 |
1 |
3 |
2006-03-15 00:00:00 |
223.000000 |
4.100000 |
0.100000 |
0 |
2 |
50.9 |
... |
3.10.2 Replacement of a Cold Preamplifier
"Update the TS_Removed field in PREAMPS with the date and time when the preamp was removed."
"Create a new record in PREAMPS having a unique value of keyPreamps and having the date and time the old preamp was removed as the value of TS_Removed."
PREAMPS
keyBand |
keyPreamps |
TS |
TS_Removed |
SN |
ILED |
Notes |
6 |
2 |
2005-12-13 14:30:00 |
2006-04-14 00:00:00 |
SN PREAMP 01 |
0.0 |
Sample Preamp 2 |
6 |
11 |
2006-04-14 00:00:00 |
0 |
SN PREAMP 67 |
0.0 |
Sample Preamp 2 installed for repair |
"Create a new collection of records in PREAMPPARAMS having new, unique values of keyPreampParams and having the new value of keyPreamps stored in fkPreamps."
PREAMPPARAMS
keyBand |
keyPreampParams |
fkPreamps |
Temperature |
FreqLO |
TS |
VD1 |
VD2 |
VD3 |
ID1 |
ID2 |
ID3 |
VG1 |
VG2 |
VG3 |
6 |
9 |
11 |
2.73 |
223.000000 |
2006-04-14 00:00:00 |
0.70 |
0.70 |
0.70 |
4.00 |
4.00 |
3.00 |
0.00 |
0.00 |
0.00 |
"Update the TS_Removed field in COLDCARTS with the date and time the old preamp was removed."
"Create a new record in COLDCARTS having a new unique value of keyColdCarts and having all the same values as the old record except: The new value of keyPreamps as fkPreampN; the date and time the old preamp was removed as TS."
COLDCARTS
keyBand |
keyColdCarts |
fkMixer0 |
fkMixer1 |
fkMixer2 |
fkMixer3 |
fkPreamp0 |
fkPreamp1 |
fkPreamp2 |
fkPreamp3 |
fkTempSensor0 |
fkTempSensor1 |
fkTempSensor2 |
fkTempSensor3 |
fkTempSensor4 |
fkTempSensor5 |
TS |
TS_Removed |
SN |
ESN |
Notes |
6 |
3 |
9 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
5 |
0 |
2006-03-15 00:00:00 |
2006-04-14 00:00:00 |
COLD SN2 |
ABCD0123EF456789 |
Sample Cold Cartridge 2 replaced mixer |
6 |
4 |
9 |
2 |
3 |
4 |
11 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
5 |
0 |
2006-04-14 00:00:00 |
0 |
COLD SN2 |
ABCD0123EF456789 |
Sample Cold Cartridge 2 replaced preamp |
"Update the TS_Removed field in CARTASSEMBLIES with the date and time the old preamp was removed."
"Create a new record in CARTASSEMBLIES having a new unique value of keyCartAssys and having all the same values as the old record except: The new value of keyColdCarts as fkColdCarts; the date and time the old preamp was removed as TS."
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
3 |
3 |
1 |
1 |
1 |
2006-03-15 00:00:00 |
2006-04-14 00:00:00 |
SN_PM_000 |
Sample Cartridge Assembly repaired mixer |
6 |
4 |
4 |
1 |
1 |
1 |
2006-04-14 00:00:00 |
0 |
SN_PM_000 |
Sample Cartridge Assembly replaced preamp |
New test data references the new CARTASSEMBLIES record:
NOISE_TEMPERATURE
keyBand |
keyDataSet |
fkCartAssys |
TS |
FreqLO |
CenterIF |
BWIF |
Pol |
SB |
TReceiver |
6 |
1 |
4 |
2006-04-14 00:00:00 |
223.000000 |
4.000000 |
0.100000 |
0 |
2 |
51.9 |
6 |
1 |
4 |
2006-04-14 00:00:00 |
223.000000 |
4.000000 |
0.100000 |
0 |
1 |
48.1 |
6 |
1 |
4 |
2006-04-14 00:00:00 |
223.000000 |
4.100000 |
0.100000 |
0 |
2 |
50.9 |
... |
3.10.3 Replacement of a Temperature Sensor
"Update TS_Removed in TEMPSENSORS with the date and time the sensor was removed."
"Create a new record in TEMPSENSORS having a unique value of keyTempSensors and having the date and time the old sensor was removed as TS. The fkColdCarts field should be the same as was in the old TEMPSENSORS record referencing the cold cartridge in which the sensor is now installed."
TEMPSENSORS
keyBand |
keyTempSensors |
fkColdCarts |
TS |
TS_Removed |
Location |
Model |
SN |
OffsetK |
Notes |
6 |
1 |
1 |
2004-08-27 00:00:00 |
2006-05-25 00:00:00 |
1 |
1 |
D59639 |
0.00 |
Removed bad temp sensor |
6 |
11 |
1 |
2006-05-25 00:00:00 |
0 |
1 |
1 |
D54321 |
0.04 |
Replacement temp sensor |
"Update the record in COLDCARTS so that the appropriate fkTempSensorN field now references the new sensor."
COLDCARTS
keyBand |
keyColdCarts |
fkMixer0 |
fkMixer1 |
fkMixer2 |
fkMixer3 |
fkPreamp0 |
fkPreamp1 |
fkPreamp2 |
fkPreamp3 |
fkTempSensor0 |
fkTempSensor1 |
fkTempSensor2 |
fkTempSensor3 |
fkTempSensor4 |
fkTempSensor5 |
TS |
TS_Removed |
SN |
ESN |
Notes |
6 |
4 |
9 |
2 |
3 |
4 |
11 |
2 |
3 |
4 |
11 |
2 |
3 |
4 |
5 |
0 |
2006-04-14 00:00:00 |
0 |
COLD SN2 |
ABCD0123EF456789 |
Sample Cold Cartridge 2 replaced temp sensor |
3.10.4 Replacement of a Cold Cartridge Bias Module
"Update the record in BIASMODS so that TS_Removed contains the date and time the module was removed."
"Create a new record in BIASMODS having a unique value of keyBiasMods and having the date and time the old module was removed as the value of TS. The fkCartAssys field should be the same value as that in the old BIASMODS record referencing the cartridge assembly in which the module is now installed."
BIASMODS
keyBand |
keyBiasMods |
fkCartAssys |
TS |
TS_Removed |
SN |
Notes |
6 |
1 |
1 |
2005-12-13 14:30:00 |
2006-06-16 00:00:00 |
BIAS MOD 32 |
Sample Bias Module removed |
6 |
3 |
1 |
2006-06-16 00:00:00 |
0 |
BIAS MOD 39 |
replacement Bias Module |
"Update the record in CARTASSEMBLIES to contain the new value of keyBiasMods as fkBiasMods."
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
4 |
4 |
1 |
3 |
1 |
2006-04-14 00:00:00 |
0 |
SN_PM_000 |
Sample Cartridge Assembly replaced bias module |
3.10.5 Replacement of a WCA or one or more Warm IF Amplifiers
"Update the record in WCAs or WarmIFPlates so that the TS_Removed contains the date and time the WCA or IF plate was removed."
"Create a new record in WCAs or WarmIFPlates having a unique value of its respective key and having the date and time the module was removed as the value of TS. The fkCartAssys field should be the same as was in the old record referencing the cartridge assembly in which the module is now installed."
WCAS
keyBand |
keyWCAs |
fkCartAssys |
TS |
TS_Removed |
SN |
ESN |
SN_PwrAmp |
FloYIG |
FhiYIG |
Notes |
6 |
1 |
1 |
2005-12-13 00:00:00 |
2006-07-22 00:00:00 |
SN WCA 22 |
889900AABBCCDDEE |
SN PWR AMP 11 |
12.151000 |
14.808000 |
Sample WCA 22 |
6 |
3 |
1 |
2006-07-22 00:00:00 |
0 |
SN WCA 52 |
8F8FF8F8F8F88F8F |
SN PWR AMP 17 |
12.150000 |
14.800000 |
replacement WCA 52 |
If no new testing is required:
"Update the record in CartAssemblies to reference the new keyWCA or keyWarmIFPlates."
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
4 |
4 |
3 |
1 |
1 |
2006-04-14 00:00:00 |
0 |
SN_PM_000 |
Sample Cartridge Assembly replaced WCA |
Done.
If new tests must be performed:
"Update the record in CartAssemblies so that TS_Removed contains the date and time the WCA or Plate was removed."
"Create a new record in CartAssemblies with a unique value of keyCartAssys and having the new value of keyWCAs or keyWarmIFPlates and the same values as the previous record for fkColdCarts and (if applicable) fkBiasMods. Set TS equal to the date and time the old module was removed."
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
4 |
4 |
1 |
1 |
1 |
2006-04-14 00:00:00 |
2006-07-22 00:00:00 |
SN_PM_000 |
Sample Cartridge Assembly removed WCA |
6 |
5 |
4 |
3 |
1 |
1 |
2006-07-22 00:00:00 |
0 |
SN_PM_003 |
Sample Cartridge Assembly replaced WCA |
"Update the foreign keys fkCartAssys in WarmIFPlates and/or WCAs to the new value of keyCartAssys."
keyBand |
keyWCAs |
fkCartAssys |
TS |
TS_Removed |
SN |
ESN |
SN_PwrAmp |
FloYIG |
FhiYIG |
Notes |
6 |
3 |
5 |
2006-07-22 00:00:00 |
0 |
SN WCA 52 |
8F8FF8F8F8F88F8F |
SN PWR AMP 17 |
12.150000 |
14.800000 |
replacement WCA 52 |
"Create a new collection of records for LOPARAMS corresponding to the LO-dependent parameters of the new WCA."
LOPARAMS
keyBand |
keyLOParams |
fkWCAs |
FreqLO |
TS |
VDP0 |
VDP1 |
VGP0 |
VGP1 |
AttenP0 |
AttenP1 |
VDAMC |
6 |
1 |
3 |
223.000000 |
2006-07-22 00:00:00 |
0.00 |
0.00 |
-0.03 |
0.04 |
0.00 |
0.00 |
0.00 |
"Produce test data referencing the new keyCartAssys as fkCartAssys."
NOISE_TEMPERATURE
keyBand |
keyDataSet |
fkCartAssys |
TS |
FreqLO |
CenterIF |
BWIF |
Pol |
SB |
TReceiver |
6 |
1 |
5 |
2006-07-22 00:00:00 |
223.000000 |
4.000000 |
0.100000 |
0 |
2 |
51.9 |
6 |
1 |
5 |
2006-07-22 00:00:00 |
223.000000 |
4.000000 |
0.100000 |
0 |
1 |
48.1 |
6 |
1 |
5 |
2006-07-22 00:00:00 |
223.000000 |
4.100000 |
0.100000 |
0 |
2 |
50.9 |
... |
3.10.6 Replacement of a Photomixer
"...only the SN_Photomixer field in the CartAssemblies table needs to be updated when a photomixer is installed or changed."
CARTASSEMBLIES
keyBand |
keyCartAssys |
fkColdCarts |
fkWCAs |
fkBiasMods |
fkWarmIFPlates |
TS |
TS_Removed |
SN_Photomixer |
Notes |
6 |
5 |
4 |
3 |
1 |
1 |
2006-04-14 00:00:00 |
0 |
SN_PM_005 |
Sample Cartridge Assembly replaced Photomixer |
--
MorganMcLeod - 08 Feb 2006