System Architect Definitions, Encyclopedia:"C:\SYSARCH\PROJECT\MCM\"

System Architect Definitions "C:\SYSARCH\PROJECT\MCM\"

adclin_bad_channel_id (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 3
ORACLE Unique: F
Description:: The channel number that did not pass the ADC linearity test.

Return to Index

adclin_check_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: Part of the compound primary key. This number will automatically be
generated by ORACLE.

Return to Index

adc_linearity_check (Entity)

Normalize: T
Description:: @1 adclin_check_seq+
adclin_bad_channel_id+
@2 mcm_id / FKFROM &quotmcm.mcm_id(mcmid_adc_fk)"/
Definitions Used:: mcm_id (Data Element)
adclin_check_seq (Data Element)
adclin_bad_channel_id (Data Element)

Return to Index

adc_linearity_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the ADC linearity..
Values:
PASS
FAIL

Return to Index

amuadc_bad_channel_id (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 3
ORACLE Unique: F
Description:: The channel number that did not pass the AMU/ functionality test.

Return to Index

amu_adc_check (Entity)

Normalize: T
Description:: @1 amu_adc_check_seq+
amuadc_bad_channel_id+
@2 mcm_id / FKFROM &quotmcm.mcm_id(mcmid_amu_fk)"/
Definitions Used:: mcm_id (Data Element)
amu_adc_check_seq (Data Element)
amuadc_bad_channel_id (Data Element)

Return to Index

amu_adc_check_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: Part of the compound primary key. This number will automatically be generated by ORACLE.

Return to Index

amu_adc_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the AMU and ADC functionality.
Values:
PASS
FAIL

Return to Index

correlator_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of correlator/-correlator functionality.
Values:
PASS
FAIL

Return to Index

discriminator_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the discriminator threshold.
Values:
PASS
FAIL

Return to Index

mcm (Entity)

Description:: @mcm_id
mcm_cable_id
visual_ok
wirebond_ok
wirebond_comment
visual_comment
Normalize: T
Definitions Used:: mcm_id (Data Element)
mcm_cable_id (Data Element)
visual_ok (Data Element)
wirebond_ok (Data Element)
wirebond_comment (Data Element)
visual_comment (Data Element)

Return to Index

mcmid_adc_fk (Relationship)

Identifying: T
From Entity: mcm
To Entity: adc_linearity_check
Parent Update: Cascade
Parent Delete: Cascade
Child Insert: Restrict
Child Update: Restrict

Return to Index

mcmid_amu_fk (Relationship)

Identifying: T
From Entity: mcm
To Entity: amu_adc_check
Parent Update: Cascade
Parent Delete: Cascade
Child Insert: Restrict
Child Update: Restrict

Return to Index

mcmid_func_fk (Relationship)

Identifying: T
From Entity: mcm
To Entity: mcm_functionality
Parent Update: Cascade
Parent Delete: Cascade
Child Insert: Restrict
Child Update: Restrict

Return to Index

mcm_cable_id (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The output cable number attached to the mcm. This will come from
the cable_id field in the mcm_electrical_test table used in the
MCM Cable database.

Return to Index

mcm_functionality (Entity)

Normalize: T
Description:: @1 mcm_func_seq+
spy_channel1_ok+
spy_channel2_ok+
amu_adc_ok+
adc_linearity_ok+
xi_link1_ok+
xi_link2_ok+
correlator_ok+
discriminator_ok+
trigger_ok+
@2 mcm_id / FKFROM &quotmcm.mcm_id(mcmid_func_fk)"/
Definitions Used:: mcm_id (Data Element)
mcm_func_seq (Data Element)
spy_channel1_ok (Data Element)
spy_channel2_ok (Data Element)
amu_adc_ok (Data Element)
adc_linearity_ok (Data Element)
xi_link1_ok (Data Element)
xi_link2_ok (Data Element)
correlator_ok (Data Element)
trigger_ok (Data Element)
discriminator_ok (Data Element)

Return to Index

mcm_func_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: Part of the compound primary key. A unique number will automatically be
generated for this field by ORACLE.

Return to Index

mcm_id (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 20
ORACLE Unique: F
Description:: The serial number of the MCM.

Return to Index

spy_channel1_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the 1st Spy Channel.
Values:
PASS
FAIL

Return to Index

spy_channel2_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the 2nd Spy Channel.
Values:
PASS
FAIL

Return to Index

trigger_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the Trigger functionality.
Values:
PASS
FAIL

Return to Index

visual_comment (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 1800
ORACLE Unique: F
Description:: Comment field for the visual inspection.

Return to Index

visual_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the visual inspection test
Values
PASS
FAIL

Return to Index

wirebond_comment (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 1800
ORACLE Unique: F
Description:: Comment field for the wirebonding checks.

Return to Index

wirebond_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the wirebond checking.
Values
PASS
FAIL

Return to Index

xi_link1_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the 1st Xi Link.
Values:
PASS
FAIL

Return to Index

xi_link2_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry for the test of the 2nd Xi Link.
Values:
PASS
FAIL

Return to Index

Return to diagram index