CartDataSamplesExamples

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
Topic revision: r4 - 2006-02-08, MorganMcLeod
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding NRAO Public Wiki? Send feedback