CartridgeDataDelivery

Documents Status

FEND-40.09.03.00-032-A-DSN "Cartridge Data Formats for Delivery to the Front End Integration Centers" replaces the two previous documents (linked below).

• The various Cartridge Acceptance Test Plan documents specify the actual test data to be delivered, whereas this document dictates only the format and procedures for delivering the data.

I still am working towards a FEIC Database User Software design document which will show how some of the burden of maintaining the key relationships amongst cartridge sub-assemblies and test data can be taken over by the database itself.

Delivered Data

CONFIGURATION AND OPERATING PARAMETERS

cartridge	status	notes
Band 3 #1	OK	See comments on ALMA EDM for specific data format issues.
Band 3 #2	OK
Band 3 #3	Missing LOParams	See additional comments on ALMA EDM.
Band 3 #6	OK
Band 3 #7	OK
Band 3 #8	OK
Band 6 #1	OK	Some errors in XML needed inspection & correction.
Band 6 #8	OK
Band 7 #1	OK	Need warm IF plates data.
Band 7 #2	OK
Band 7 #4	OK
Band 7 #7	OK
Band 9 #1	OK	Delivered as an MS Access database. Should be plain text or XML.
Band 9 #2	OK	Delivered as an MS Access database. Should be plain text or XML.
Band 9 #3	OK	Delivered as an MS Access database. Should be plain text or XML.
Band 9 #4	OK	Delivered as an MS Access database. Should be plain text or XML.
Band 9 #6	OK	Delivered as an MS Access database. Should be plain text or XML.
Band 9 #8	OK	Delivered as an MS Access database. Should be plain text or XML.

TEST DATA

Cartridge	NOISE	IMAGE	S.B.	INBAND	TOTAL	POWER	GAIN	AMPL.	PHASE
	TEMP.	SUPPR.	RATIO	POWER	POWER	VAR.	COMP.	STAB.	DRIFT
Band 3 #1	OK	OK	N/A	OK	OK	OK	OK	OK	OK
Band 3 #2	OK	OK	N/A	OK	OK	OK		OK
Band 3 #3	OK	OK	N/A	OK	OK	OK	OK	OK	OK
Band 3 #6	OK	OK	N/A	OK	OK	OK	OK	OK	OK
Band 3 #7	OK	OK	N/A	OK	OK	OK	OK	OK	OK
Band 3 #8	OK	OK	N/A	OK	OK	OK	OK	OK	OK
Band 6 #1	OK	OK	N/A	OK	OK	OK	OK	OK	OK
Band 6 #8			N/A
Band 7 #1			N/A
Band 7 #2			N/A
Band 7 #4			N/A
Band 7 #7			N/A
Band 9 #1	OK	N/A	OK	OK	OK	OK	OK	OK	SEE NOTE
Band 9 #2	OK	N/A	OK	OK	OK	OK	OK	OK	SEE NOTE
Band 9 #3			N/A
Band 9 #4			N/A
Band 9 #6			N/A
Band 9 #8			N/A

Cartridge	BEAM	IF	POL.	XPOL	XPOL	I-V
	PATTERN	SPECTRUM	ACCURACY	PATTERN	TOTAL	CURVE
Band 3 #1		OK
Band 3 #2		OK
Band 3 #3	SEE NOTE	OK		SEE NOTE
Band 3 #6		OK
Band 3 #7		OK
Band 3 #8		OK
Band 6 #1	INCOMPLETE	OK	OK
Band 6 #8
Band 7 #1
Band 7 #2
Band 7 #4
Band 7 #7
Band 9 #1	SEE NOTE	OK	OK	INCOMPLETE	OK
Band 9 #2	OK	OK	OK	INCOMPLETE	OK
Band 9 #3
Band 9 #4
Band 9 #6
Band 9 #8

NOTES

• Phase Drift:
  • For Band 9 #1, phase drift data was provided as phase vs. time.
  • For Band 9 #2, phase drift looks closer to what's expected. See the new document linked above for clarifications.
• Beam Pattern:
  • For Band 3 #3, the beam pattern data gives copol. The Cross-Polarized file gives only XPol power. Does this point to a redundancy in the data format or does it make sense to have both types of data files?
  • For Band 6 #1, the beam pattern data seems to be incomplete. Only roughly 1/4 of the pattern is visible.
  • For Band 9 #1, pattern data was given as normalized between zero and one.
• Cross-Polarized Beam Pattern:
  • The new document linked above clarifies how XPOL pattern and XPOL total should be provided.

Links to Obsolete Documents

• FEND-40.02.00.00-016-A-STD gives the data requirements for cartridge operating data. updated 2006-10-16

• FEND-40.09.03.00-008-A-DSN gives the format for data to be delivered by cartridge manufacturers to the FEIC. updated 2006-10-18

Older links:

• CartDataSamplesExamples gives sample cartridge data and the transactions which occur when new or updated data is delivered.

• FEND-40.09.03.00-007-A-DSN gives the design of the database to be used in the FEIC. updated 2006-05-12

• Following up on the 2005-05-17 teleconference, MorganMcLeod has been working on database designs for the cartridge operating parameters and the cartridge test data. The data in these databases are to be delivered simultaneous with each cartridge to the FEIC.

• The deprecated document Cartridge Test Data Requirements is mentioned in the minutes above.

• AccessToMySQL gives information and instructions on setting up MySQL and on moving data from MS Access into MySQL.

• Migrating to MySQL has some helpful hints.

• CartridgeOperatingParamsDatabase gives the data format and instructions for the operating params database.