SPE4AX17D9413_Add_2_Attachment_3.xlsx
XLSX spreadsheet 15 KB Posted
- Solicitation number
- SPE4AX17D9413
- Issued by
-
Defense Logistics Agency Aviation
About this file
Quality Matrix Dictionary
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SPE4AX17D9413_ADD_2_Attachment_2.xlsx | XLSX spreadsheet | |
| SPE4AX17D9413_ADD_2_Attachment_1.pdf | ||
| PID_Attachment_4.pdf | ||
| Attachment_1_Schedule_B_ADD_24_Sypnopsis_Solictation.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
QM Dictionary BAE-STANDARD REPORT || Quality Matrix || Data Dictionary/Sources
| Result Field Name | Column | Description | Criteria / Derivation | extraction | Source Table | |
| (most: EDW.SQL/) | Field |
(in source table)
| NIIN | A | National Item Identification Number | n/a | n/a | CV_CS_MATERIAL | M_BIC_B_NIIN | |
| FSC | B | Federal Supply Class | leading four positions | SUBSTR(mm.m_matl_group,1,4) | CV_CS_MATERIAL | M_MATL_GROUP | |
| Site | C | Primary Field Level Activity | decode of Profit Center | ||||
| first and second position | 10 = Richmond (DSCR) |
11 = Non-DLA Industrial Support Activities 30 = Columbus (DSCC) 50 = Philadelphia (DSCP)
| 70 = DLA Headquarters | CV_CS_MATERIAL | M_PROFIT_CENTER | |||||
| Profit Center | D | Profit Center | trailing seven characters | n/a | CV_CS_MATERIAL | M_PROFIT_CENTER | |
| Division | E | Division | -BAE internal Cross Reference | join on Profit Center | PC_IST_XREF | ||
| (Common Data Sets) | VIRTUAL_DIV | ||||||
| Branch | F | Branch | -BAE internal Cross Reference | join on Profit Center | PC_IST_XREF | ||
| (Common Data Sets) | VIRTUAL_OFC | ||||||
| IST Label | G | IST Label | -BAE internal Cross Reference | join on Profit Center | PC_IST_XREF | ||
| (Common Data Sets) | IST_TEXT | ||||||
| Nomenclature | H | Description of item (Noun) | n/a | n/a | CV_CS_MATERIAL | M_MATERIAL_DESC | |
| ALRE | I | Aircraft Launch and Recovery Equipment | decoded from Special Procedures Code (SPC) | where SPC = "01" | CV_CS_MATERIAL | M_BIC_BSPCCODE | |
| IRPOD | J | Individual Repair Parts Ordering Data | decoded from Special Procedures Code (SPC) | where SPC = "02" | CV_CS_MATERIAL | M_BIC_BSPCCODE | |
| ICBM | K | InterContinental Ballistic Missle | decoded from Special Procedures Code (SPC) | where SPC = "04" | CV_CS_MATERIAL | M_BIC_BSPCCODE | |
| CSI | L | Critical Safety Item | decoded from Special Procedures Code (SPC) | 03 = CSI-Navy |
05 = CSI-Army 06 = CSI-Air Force
| 07 = Chem-Bio | CV_CS_MATERIAL | M_BIC_BSPCCODE | |||||
| FMS | M | Foreign Military Sales indicator | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BBFMSIND | |
| Config Mgmt | N | Relevant for Configuration Management | n/a | n/a | CV_CS_MATERIAL | M_BIC_BRELCONFM | |
| PIC | O | Place of Inspection code | n/a | n/a | CV_CS_MATERIAL | M_BIC_BPLACEINS | |
| U/I | P | Unit of Issue (DoD Sales Unit) | n/a | n/a | CV_CS_ITEM_DETAIL | M_SALES_UNIT | |
| BUoM | Q | Base Unit of Measure (EBS mgmt unit) | n/a | n/a | CV_CS_MATERIAL | M_BASE_UOM | |
| U/I Conv Fctr | R | Unit of Issue Conversion Factor | n/a | n/a | CV_CS_MATERIAL | _BIC_BBUOM | |
| Shelf Life Type | S | Extendible or Defined Period item | n/a | n/a | CV_CS_MATERIAL | M_BIC_BCONTRREQ | |
| Shelf Life Months | T | Shelf Life Period in Months | n/a | n/a | CV_CS_MATERIAL | M_BIC_BUNITCUBE | |
| HMIC | U | Hazardous Material Indicator Code | n/a | n/a | CV_CS_MATERIAL | M_BIC_BHZDMATCD | |
| CIC | V | Critical Item | n/a | n/a | CV_CS_MATERIAL | M_BIC_BCRIT_IND | |
| PMIC | W | Precious Metal Indicator Code | n/a | n/a | CV_CS_MATERIAL | M_BIC_BPRCMTLCD | |
| Tech Manual | X | Technical Manual Required | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BTECHCD | |
| FSI | Y | Flight Safety Item | n/a | n/a | CV_CS_MATERIAL | M_BIC_BFLIGHTSF | |
| LSE | Z | Life Support Equipment | n/a | n/a | CV_CS_MATERIAL | M_BIC_BLIFESUPT | |
| FAT | AA | First Article Test required | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BFRSTTIND | |
| Govt Tool | AB | Government Furnished Tooling | n/a | n/a | BSM_CTD_DIMENSION | ||
| (DORRA-DW) | GOV_FURN_TLNG_IND | ||||||
| Govt Matl | AC | Government Furnished Material | n/a | n/a | CV_TQ_BTQHO64 | _BIC_GFM_IND | |
| Govt Prop | AD | Government Furnished Property | n/a | n/a | BSM_CTD_DIMENSION | ||
| (DORRA-DW) | GOV_FURN_PROP_IND | ||||||
| Govt Prop/Tool/STE | AE | Government Furnished Propery/Tooling | |||||
| /Special Testing Equipment | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BGOVIND | |||
| QPL | AF | Qualified Products List | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BRGHTCD | |
| COQC | AG | Certificate of Quality Conformance | n/a | n/a | CV_CS_MATERIAL | _BIC_BQLTYRQCP | |
| Hghr Lvl Qual | AH | Higher Level Quality requirement | decoded from Quality Control Code (QCC) | where first position in ('E','F','K','L','Q','R') | CV_CS_MATERIAL | M_BIC_BQLTYCTRL | |
| Prod Verif Tstg | AI | Product Verification Testing | decoded from Quality Control Code (QCC) | where second position in ('B','E','F','G') | CV_CS_MATERIAL | M_BIC_BQLTYCTRL | |
| Proc Ctrl | AJ | Statistical Process Controls | decoded from Quality Control Code (QCC) | where third position = 'G' | CV_CS_MATERIAL | M_BIC_BQLTYCTRL | |
| Govt Fit Verif | AK | Government Fit & Verification Testing | decoded from Quality Control Code (QCC) | where first position in ('J','K','L') | CV_CS_MATERIAL | M_BIC_BQLTYCTRL | |
| Measure & Testg | AL | Measurement and Testing Equipment | decoded from Quality Control Code (QCC) | where second position in ('C','E','H','G') | CV_CS_MATERIAL | M_BIC_BQLTYCTRL | |
| COTS Ind | AM | Commercial Off-The-Shelf Indicator | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BCOTSIND | |
| Rights Guard | AN | Boeing Rights Guard applies | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BBRGIND | |
| QCC | AO | Quality Control Code | n/a | n/a | CV_CS_MATERIAL | M_BIC_BQLTYCTRL | |
| DWG | AP | Drawing associated | decoded from Document Type | where Document Type = "DWG" | DRAD | ||
| (DocMgmtSys) | DOKAR (Document Type) | ||||||
| MYL | AQ | Mylar associated | decoded from Document Type | where Document Type = "MYL" | DRAD | ||
| (DocMgmtSys) | DOKAR (Document Type) | ||||||
| QAP | AR | Quality Assurance Provision associated | decoded from Document Type | where Document Type = "QAP" | DRAD | ||
| (DocMgmtSys) | DOKAR (Document Type) | ||||||
| Export Control | AS | Export Controlled item | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BEXPCIND | |
| Contains Classif | AT | Contains Classified Material | n/a | n/a | CV_TQ_BTQHO64 | _BIC_BCLMLTIND | |
| ENAC | AU | ENvironmental Attributes Code | n/a | n/a | CV_CS_MATERIAL | M_BIC_BENVATRCD | |
| SMS | AV | ||||||
| Supply Chain | AW | Supply Chain | -BAE internal Cross Reference | join on Profit Center | PC_IST_XREF | ||
| (Common Data Sets) | S_C_TEXT | ||||||
| Nuclear | AX | "Nuclear" WeapSys Indicator | decoded from WSDC | where WSDC in ("FMF","FNF","FOF","04F", | |||
| "ABF","AYF","01F","36F") | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |||||
| B-2 | AY | B-2 - "Nuclear" WeapSys | decoded from WSDC | where WSDC in ("FMF","FNF","FOF") | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Aircraft FMF | AZ | B-2 - Aircraft FMF - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "FMF" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Support FNF | BA | B-2 - Support FNF - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "FNF" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Engine FOF | BB | B-2 - Engine FOF - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "FOF" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| B-52 | BC | B-52 - "Nuclear" WeapSys | decoded from WSDC | where WSDC in ("04F","ABF","AYF") | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Aircraft 04F | BD | B-52 - Aircraft 04F - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "04F" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Support ABF | BE | B-52 - Support ABF - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "ABF" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Engine AYF | BF | B-52 - Engine AYF - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "AYF" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| ICBM 01F | BG | ICBM 01F - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "01F" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| ICBM 36F | BH | ALCM 36F - "Nuclear" WeapSys | decoded from WSDC | where WSDC = "36F" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| NRP 21N | BI | NRP 21N - Navy Nuclear Reactor Program | decoded from WSDC | where WSDC = "21N" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Ohio 23N | BJ | Ohio 23N - Ohio Class Submarine | decoded from WSDC | where WSDC = "23N" | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| Count | BK | Count of WSDCs | Count of all distinct WSDCs | n/a | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC | |
| WSDCs | BL | Weapon System Designator Code(s) | Aggregate of all distinct WSDCs | n/a | CV_CS_ZDMT_WSF_MM_WSSP | _BIC_BFC_WSDC |
SPE4AX-17-D-9413 Quality Matric-Dictionary Attachment 3
File details come from the government source that posted it.