A01 - PWS Attachment 0003 CHS5 PWS Appendix B Data Item Tables.xlsx

XLSX spreadsheet 57 KB Posted

Attached to
Common Hardware Systems-5 (CHS-5) Request for Information (RFI) Federal contract opportunity
Solicitation number
W15P7T-18-D-0008-RFI
Issued by
Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

View the file

Other files for this federal contract opportunity

Other files attached to Common Hardware Systems-5 (CHS-5) Request for Information (RFI), newest first.
File Type Posted
A01 - PWS Attachment 0004 CHS-5 PWS Appendix C Safety Specification.docx DOCX document
A01 - PWS Attachment 0002 CHS5 PWS Appendix A Survivability Reliability Verif.docx DOCX document
A01 - PWS Attachment 0001 CHS-5 PWS (dated 19 Jun 2018).docx DOCX document

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

SUMMARY

APPENDIX B – Data Item Tables

Orders / Shipping Header
Orders / Shipping Details
Technology Insertions Summary
Task Orders Summary
Price
Warranty Options
EOL
Product Specifications
Configuration Tracker
Configuration Relationship
Warranty
Repairs
Product Categorization

Orders-Shipping Header Orders / Shipping Header Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS Contract no
DO_Mod_NoTextYesDelivery order or mod no
SLINTextYesSLIN
Contract_Delivery_DateDateDelivery Order Due Date
Contract_Delivery_Date_Change_NotesTextLog changes to contract delivery date
Part_NoTextPart no
Item_NoTextItem no
Item_nameTextItem short name
Item_DescriptionTextItem long description
SLIN_QtyNumberSLIN qty
Unit_MeasureTextUnit measure: Each or Lot, etc
Qty_Unit_MeasureNumberQty per unit measure (Each = 1; Lot = Lot Qty)
DO_Mod_StatusTextDelivery order or mod statusOpen or Closed when all items qtys have been shipped
DO_Mod_Award_DateDateDelivery order or mod award date
Customer_Order_NoTextCHS customer order no
Customer_Program_NameTextCustomer program name
NotesTextNotes
DODAACTextDODAAC
Ship_ToTextShipping Address
Marked_ForTextWho it is being shipped to and instructions

Orders-Shipping Details Orders / Shipping Details Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract no
DO_Mod_NoTextYesPart no
SLINTextYesSLIN
DD250_NoTextYesDD250 no
Scheduled_Delivery_DateDateScheduled delivery date
DD250_Date_ShippedDateDD250 date shipped
Qty_By_DateNumberQuantity by date
Qty_RequiredNumberQuantity required
Qty_ShippedNumberQuantity shipped
Qty_OutstandingNumberQuantity outstanding
Unit_PriceCurrency2Unit Price
CarrierText
Tracking_NoText

Tech Insertions Summary Technology Insertions Summary Table – Data Fields BACK TO SUMMARY

Name Type Decimal Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract no
ECP_FFPP_NoTextYesECP_FFPP_no
TI_NoTextCorresponding PdL CHS Technology Insertion Tracking Number
DescriptionTextEffort description
Submittal_DateDateDate proposal submitted
Submittal_LetterTextProposal submittal letter contron no
CommentsTextComments
Pricing_Submittal_DateDateProposal pricing submittal date
Pricing_Submittal_LetterTextProposal pricing submittal letter
Contract_MOD_NoTextContract Mod no
Contract_MOD_DateDateContract Mod award date

Task Orders Summary Task Order Summary Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoYesCHS contract no
Task_Order_NoTextYesTask order no
Task_DescriptionTextTask description
Task_Order_StatusTextTask Order Status -- Open or Closed
Delivery_Order_NoTextDelivery order no
Customer_Program_NameTextCustomer program name
Award_DateDateAward date
PoP_Start_DateDateStart Date Period of Performance
PoP_End_DateDateEnd Date Period of Performance
Report_CommentsTextReport comments
Authorized_ValueCurrency2Delivery order award amount
Expended_ValueCurrency2Expended amount
Remaining_BudgetCurrency2Remaining funding balance

Price Price Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract number
Part_NoTextYesPart number
Warranty_Price_Ref_NoNumber0YesPrice table warranty unit cost reference no (populated for warranty pricing)
Price_YearNumberYesContract price year
Range_Scheme_Quantity_NoNumber0YesSequential quantity numbers to identify ranges, example, 1-10, 11-29, 30-60, etc
Item_NoNumbervariableAlternate unique item identifier
Item_NameTextItem short name
Item_DescriptonTextItem long description
Item_StatusTextIndicate status, if applicable.Definitized, NTE (Not to excceed, etc.)
SLINTextSLIN
Unit_CostCurrency2Unit cost
Unit_MeasureTextUnit measure: 1, Lot, etcAlso provided on product specification table
Unit_Measure_QtyNumberUnit measure quantityAlso provided on product specification table
ARONumber0Number of days to deliver after receipt of delivery order
EOL_StatusTextIndicate EOL (End of Life) statusAlso provided on product specification table
EOL_DateDateDate item is EOLAlso provided on product specification table
EOL_NotesTextEOL notesAlso provided on product specification table

Warranty Options Warranty Options Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract no
Part_NoTextYesPart no
Warranty_Price_Ref_NoNumber0YesPrice table warranty unit cost reference no (populated for warranty pricing)
Warranty_TypeTextWarranty Type: OEM-Only, OEM-PT (OEM Pass Thru), CHS Standard, CHS ExtendedConsistent across tables
Warranty_YearsTextWarranty YearsConsistent across tables

EOL

EOL Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract no
Part_NoTextYesPart no
SLINTextSLIN
Item_NoNumberAlternate unique item identifier
Item_DescriptonTextItem long description
EOL_DateDateEnd of Life date
Special_EOL_NotesTextSpecial EOL notes
To_CHS_Notification_Letter_NoTextTo CHS notification letter no
To_CHS_Notification_DateDateTo CHS notification date
Replacement_ECP_FFP_NoTextReplacement_ECP or FFP no
Replacement_Item_NoTextReplacement Item no, may be SLIN no
Replacement_Part_NoTextReplacement part no
Replacement_DescriptionTextReplacement description

Product Specifications Product Specifications Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Notes

Contract_NoAlpha-NumericYes
Item NameText
Part_NoAlpha-NumericYes
SLINAlpha-Numeric
Item Number (CLIN)Alpha-Numeric
NSNNumeric
Item DescriptionText
Item Version (V1,V1+,V2,V3)Alpha-Numeric
Item TypeText (from Tier 1 Categorization List)
Item CategoryText (from Tier 2 Categorization List)
Item Type RoleText (from Tier 3 List)
ECP FFPP NumberAlpha-Numeric
Cage CodeNumeric
OEM NameText
OEM Part NumberAlpha-Numeric
OEM Model NumberAlpha-Numeric
OEM AddressAlpha-Numeric
Composite / EtchYes or No
Composite / Etch LocationText
Operating System OEMText
OS VersionAlpha-Numeric
OS Patch VersionAlpha-Numeric
PowerPick List (Power Adapter, Battery, Power Supply)
Power Adapter InputNumeric (xxx) VAC or VDC
Power Adapter OutputNumeric (xxx) VAC or VDC
Power Requirements WattageNumeric (xxx) watts
Power Requirements AmperageNumeric (xxx) amp or mA)
Power Requirements Voltage110, 220, both
CI HeightNumeric (xxx.xx) ft, in, m, cm, or mm
CI WidthNumeric (xxx.xx) ft, in, m, cm, or mm
CI LengthNumeric (xxx.xx) ft, in, m, cm, or mm
CI WeightNumeric (xxx.xx) lb, oz, kg, g, or mg
CI Weight with packaging materialNumeric (xxx.xx) lb, oz, kg, g, or mg
CI Cable(s)Power cord, Video cable, Power distribution cable, Ethernet
CI Installation KitYes or No
CI Installation Kit IsolatedYes or No
I/O Ports QuantityNumeric (xxx)
HDMINumeric (xxx)
USB (1.0)Numeric (xxx)
USB (2.0)Numeric (xxx)
USB (3.0)Numeric (xxx)
USB (Misc)Numeric (xxx)
SerialNumeric (xxx)
VGANumeric (xxx)
ThunderboltNumeric (xxx)
PCMCIANumeric (xxx)
RJ-45Numeric (xxx)
Data Connectors QuantityNumeric (xxx)
Data Connectors (1GB)Numeric (xxx)
Data Connectors (10GB)Numeric (xxx)
Data Connectors (100GB)Numeric (xxx)
Data Connectors (1000GB)Numeric (xxx)
Data Connectors (1/10/100/1000GB)Numeric (xxx)
Data Connectors (40 GIG-E)Numeric (xxx)
Data Connectors (Misc)Numeric (xxx)
Data Connectors (Fiber ST)Numeric (xxx)
Data Connectors (Fiber SC)Numeric (xxx)
Data Connectors (Fiber FC)Numeric (xxx)
Data Connectors (Fiber MT-RJ)Numeric (xxx)
Data Connectors (Fiber LC)Numeric (xxx)
Data Connectors (Fiber Misc)Numeric (xxx)
I/O MiscNumeric (xxx)
Drive Bays QuantityNumeric (xxx)
Drive OEMText
Drive TypeDVD, CD, Blu-Ray, or SD Card Reader
Drive IntegrationInternal or External)
Drive Bay Expansion Storage QuantityNumeric (xxx)
Drive Bay OEMText
Drive Bay Expansion TypeRAID 5, RAID 0+1, or RAID 10
Drive Bay Expansion SizeNumeric (xxx) PB, TB, GB, or MB
Drive Bay Expansion SlotsNumeric (xxx)
Processor OEMText
Processor ModelAlpha-Numeric
Processor TypeAlpha-Numeric
Processor SpeedNumeric (xxx.xx) GHz
Processor QuantityNumeric (xxx)
CacheNumeric (xxx) GB or MB
Cores (number of cores)Numeric (xxx)
Bus SpeedNumeric (xxx) MHz
Socket (number of sockets)Numeric (xx)
Hyper-threadingYes or No
Motherboard OEMText
Chipset16, 32, 64, 128, or 256 bit
BIOSAlpha-Numeric
FirmwareAlpha-Numeric
Controller (TPM 1.2 and 2.0)TPM + Numeric (xxx.xxx)
DriverAlpha-Numeric
RAM Memory OEMText
RAM Memory TypeDDR1, DDR2, or DDR3
RAM Memory Subtype ECCYes or No
RAM Memory Slots1, 2, 3, 4, etc
RAM Memory Slot TypeDIMM, SIMM, or DRAM
RAM Memory Size (per Slot)Numeric (xxx) MB or GB
RAM Memory Total SizeNumeric (xxx) MB or GB
Hard Drive OEMText
HD Controller / InterfaceATA, IDE, SATA, PATA, or SCSI
HD TypeHDD or SSD
HD Dimension (Height)Numeric (xxx.xx) in, cm, or mm
HD Dimension (Width)Numeric (xxx.xx) in, cm, or mm
HD Dimension (Length)Numeric (xxx.xx) in, cm, or mm
HD SizeNumeric (xxx.xx) PB, TB, GB, or MB
HD Rotating SpeedNumeric (xxxxx) RPM, NA
HD Permanent or RemovablePerm or Removable
Hot Swappable Drive OEMText
Hot Swappable Drive TypeHDD or SSD
Hot Swappable Drive SlotNumeric (xx)
Monitor Display OEMText
Monitor Display ModelAlpha-Numeric
Monitor Display TypeLCD, LED, OLED, Plasma, or CRT
Monitor Display Resolution1680x1050, 1280x1024, 1152x864, 1024x768, or 800x600
Monitor Display Size13, 14, etc + in
Graphical Processor Unit (GPU) OEMText
GPU ModelAlpha-Numeric
GPU TypeIntegrated, PCI, AGP, or PCIx
GPU MemoryNumeric (xxx) PB, TB, GB, or MB
GPU SpeedNumeric (xxxxx) MHz
Storage / Transit Case OEMText
Storage / Transit Case TypeStorage Case or Transit Case
Storage / Transit Case SizeSmall, Medium, or Large
Storage / Transit Case Dimensions (Height)Numeric (xxx.xx) ft, in, m, cm, or mm
Storage / Transit Case Dimensions (Width)Numeric (xxx.xx) ft, in, m, cm, or mm
Storage / Transit Case Dimensions (Length)Numeric (xxx.xx) ft, in, m, cm, or mm
Storage / Transit Case WeightNumeric (xxx.xx) lb, oz, kg, g, or mg
Device Peripherals (I/O) QuantityNumeric (xxx)
MouseNumeric (xxx)
KeyboardNumeric (xxx)
Number PadNumeric (xxx)
HeadsetNumeric (xxx)
MicrophoneNumeric (xxx)
Drawing PenNumeric (xxx)
SpeakersNumeric (xxx)
WebcamNumeric (xxx)
Misc (Peripheral)Numeric (xxx)
MTBFNumeric (xxxxxxx) hours
MTTRNumeric (xxxxxxx) hours
Unit of Measureeach or lot
Unit of Measure QuantityNumeric (xxx)
Warranty AvailabilityOEM, OEM Pass Thru, CHS
Warranty Period1, 2, 3, 4, 5 Yr
EULA InformationAlpha-Numeric
Photo or SchematicAttachment (file)

Configuration Tracker Configuration Change Tracker Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract no
Base_Part_NoTextYesBase part no
Revision_Change_NoTextYesRevision change no suffix
Base_Item_NameTextBase item short name
Base_Item_DescriptionTextBase item long description
New_Configuration_Part_NoTextNew configurtion part no
New_Item_NameTextNew item short name
New_Item_DescriptionTextNew item long description
New_SLINTextNew configuration SLIN
Date_Configuration_AddedDateDate new configuration added to contract
New_OEM_Part_NoTextOEM part noAlso appears in the Product Specification table
NotesTextNotes

Configuration Relationship Configuration Relationship Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract no
Part_NoTextYesPart no of base unit
Related_Part_NoTextYesRelated partnoConfiguration orderable partno or component partno in the case of an OTC (Operational Transit Case), Accessory
Related_Item_Type_RoleTextCS (configuration selectable) or CC (configuration component), ACC (accessory), CON (consumable), ANC (ancillary)
Item_DescriptionTextItem long description
Related_Item_DescriptionItem long description
NotesTextNotes

Warranty Warranty Table – Data Fields BACK TO SUMMARY

Name Type Decimals Unique Record Key Fields Description Notes

Contract_NoTextYesCHS contract no
Serial_NoTextYesSerial no
Part_NoTextPart noMust be the same in all data tables
Item_NoNumbervariableItem numberMust be the same in all data tables
Item_NameTextShort item nameMust be the same in all data tables
Item_DescriptionTextLong item description
Customer_Program_NameTextCustomer Program NameMust be the same in all data tables
DD250_NoTextDD250 no
DD250_DateDateDD250 date
Delivery_Order_NoTextDelivery Order no
CHS_Customer_Order_NoTextCHS customer order no
SLINTextDelivery Order Slin
Warranty_Start_DateDateWarranty Start Date
Warranty_Stop_DateDateWarranty Stop Date
Warranty_TypeTextWarranty TypeCHS, OEM, OEM-PassThru, N/A, etc
Warranty_YearsNumberNumber of years warranty providedMay also be captured in other table(s)
Warranty_Extended_AvailableTextIndicates whether Extended Warranty is availableIndicated as Yes or No
Warranty_Extended_ExercisedTextIndicates whether Extended Warranty was purchasedIndicated as Yes or No -- update Warranty_Stop_Date if Yes
NotesTextNotes

Repairs Repairs Table – Data Fields BACK TO SUMMARY

NameTypeDecimalsUnique Record Key FieldsDescriptionNotes
Must be unique and uniform in all tables
Contract_NoTextYesCHS contract noMust be unique and uniform in all tables
Repair_Order_NoTextYesRepair order noMust be unique and uniform in all tables
Part_NoTextPart no
StatusTextStatus: for instance open, closed
Repair_TypeTextRepair Type: Warranty, OTFWT, OOW, Retrofit, etc
Item_DescriptionTextItem descripton
Customer_Program_NameTextCustomer Program NameMust be unique and uniform in all tables
Date_Repair_OpenedDateDate repair opened
Time_Repair_OpenedTimeTime repair opened, hours and minutes, military time
Problem_DescriptionTextProblem description
Resolution_DescriptionTextResolution description -- or no evidence of failure (NEOF)
Caller_NameTextCaller name or person dropping off equipment
Caller_Telephone_NoTextCaller telephone no
Caller_E-mail_AddresssTextCaller e-mail address
Alternate_Customer_ContactTextAlternate customer contact name
Alternate_Customer_Contact_Tel_NoTextAlternate customer contact Tel No
Drop_Off_LocationTextDrop off location
Vendor_SerialTextVendor serial no
VersionTextItem versionMust be unique and uniform in all tables
Unit_NameTextUnit or organizaton dropping off equipmentMust be unique and uniform in all tables
Commander_NameTextUnit commander name
Commander_EmailTextUnit commander E-mail
Vendor_NameTextVendor NameMust be unique and uniform in all tables
Vendor_RMATextVendor RMA
Repair_CenterTextRepair CenterMust be unique and uniform in all tables
Transportation_Company_NameTextTransportation company name
Tracking_NumberTextTransportation company tracking no
Transportation_Date_ShippedDateTransportation compnay date shipped
Date_Equipment_ReceivedDateDate equipment received
Time_Equipment_ReceivedTimeTime equipment receivedTime in hours and minutes, military time
Date_ClosedDateDate repair closed
Time_ClosedTimeTime repair closedTime in hours and minutes, military time
Date_ShippedDateDate equipment shipped
Time_ShippedTimeTime equipment shippedTime in hours and minutes, military time
Elapsed_TimeTimeCalculated elapsed timehours and minutes
Task_Order_TEP_NoTextTask Order or TEP no
Swap_Serial_NoTextSwapped Serial No
Repair_CodeTextRepair code description
Failed_Part_NoTextFailed part no
Failed_Serial_NoTextFailed serial no
Replacement_Part_NoTextReplacement part no (for items repaired by replacement)
Replacement_Serial_NoTextReplacement serial no (for items repaired by replacement)
OTFWT_Damage_NotesTextDescribe OTFWT equipment damage
Eval_CostCurrencyCost to Evaluate Failed Item (for OTFWT and OOW)
Repair_or_Replacement_Cost_TotalCurrencyTotal Cost to Repair/Replace Item (for Warranty, OTFWT, and OOW)
Repair_or_Replacement_Cost_LaborCurrencyLabor Cost to Repair Item (for Warranty, OTFWT, and OOW)
Repair_or_Replacement_Cost_Each_ComponentCurrencyMaterial Cost of each Repaired/Replaced Component (for Warranty, OTFWT, and OOW)
Repaired_or_Replaced_ComponentsTextListing of Components Repaired or Replaced (for Warranty, OTFWT, and OOW)

Product Categorization Product Specifications Table – Product Categorization Reference Table BACK TO SUMMARY

Tier 1Tier 2Tier 3
SoftwareCHSOS
SoftwareCHSApplication Software
SoftwareCHSData Communication Software
SoftwareCHSSoftware Drivers
SoftwareCHSSoftware Maintenance
SoftwareCHSLicenses
HardwareMaintenanceMaintenance
HardwareMaintenanceLicenses
HardwareComputersLaptops
HardwareComputersServers
HardwareComputersOthers
HardwareComputersHandhelds
HardwareComputersWorkstation
HardwareNetwork DevicesRouters
HardwareNetwork DevicesSwitches
HardwareNetwork DevicesFirewall Appliances
HardwareNetwork DevicesMedia Converters
HardwareNetwork DevicesTest Equipment
HardwareNetwork DevicesOther Network Equipment
HardwareNetwork DevicesSecurity Appliances
HardwareCables and AccessoriesCables
HardwareCables and AccessoriesCables and Accessories
HardwarePeripheralsPrinters
HardwarePeripheralsPower Supplies
HardwarePeripheralsStorage Devices
HardwarePeripheralsDisplays
HardwarePeripheralsOther Peripherals
HardwarePeripheralsUPS
HardwarePeripheralsKeyboard
HardwarePeripheralsBattery
HardwareTransit/Carrying CasesOTC
HardwareTransit/Carrying CasesInstallation Kits
HardwareTransit/Carrying CasesOther Cases
HardwareTransit/Carrying CasesCarry Case
HardwareTransit/Carrying CasesTransit Case
HardwareStorageHard Drive
HardwareStorageSSD
HardwareStorageRaid
HardwareCommunication DevicesRadios
HardwareCommunication DevicesPhones
HardwareCommunication DevicesAntennas
HardwareCommunication DevicesOther Communication
HardwarePeripheralsModules
HardwarePeripheralsModems
HardwarePeripheralsMounts
HardwarePeripheralsKits
HardwarePeripheralsAdapters
HardwarePeripheralsTeleconferencing
HardwarePeripheralsSpecial Purpose Cards

File details come from the government source that posted it. Updated .