NEDi Data Models

1. legend

1.1. non-sarah data integration

1.1.1. OOT

1.1.2. PTS

1.2. question about field

2. Masters

2.1. id (itemNumber)

2.2. attributes

2.2.1. drawingNumber

2.2.2. side

2.2.3. size

2.2.4. asBuiltNumber

2.2.5. description

2.2.6. responsibleContract

2.2.7. stockUnitOfMeasurement

2.2.8. currentEcl

2.2.9. currentRtgRev

2.2.10. type

2.2.11. category

2.2.12. abcClass

2.2.13. stockArea

2.2.14. BinLocation

2.2.15. lowLevelCode

2.2.16. cycleCount

2.2.17. wrntyLength

2.2.18. objectClass

2.2.19. requiresInspection (inspect_flag)

2.2.20. multiWhse

2.2.21. status

2.2.22. isPhantom (phantom_flag)

2.2.23. floorStock (floorStockFlag)

2.2.24. isSerialized (serial flag)

2.2.25. isLotControlled (lot_control)

2.2.26. isSideControlled (side_control)

2.2.27. isSizeControlled (size_control)

2.2.28. isProjectControlled (project_control)

2.2.29. ceiNumber

2.2.30. levelOne

2.2.31. fedCode

2.2.32. hdwTrackFlag

2.2.33. enteredBy

2.2.34. equipmentGroup

2.2.35. hasAdp (adp)

2.2.36. isSoleSourced (sole_source_flag)

2.2.37. initReasonCode (reason_init_code)

2.2.38. isReplRecieved (repl_rec_flag)

2.2.39. vendorCode

2.2.40. isNonMetallic (non_metallic_flag)

2.2.41. isPhotoEquipment (photo_equipment_flag)

2.2.42. limitedLifeCode

2.2.43. isHazardousMaterial (hazardous_material_flag)

2.2.44. expendRefurbCode

2.2.45. defaults

2.2.46. calibration (cal)

2.2.47. certification (cert)

2.2.48. isEarlyReturn (early_ret_flag)

2.2.49. isFirstFlown (first_flown_flag)

2.2.50. isKsc (ksc_flag)

2.2.51. isEngineeringInit (eng_init_flag)

2.2.52. historySequence (hist_seq)

2.2.53. requiresEngineeringReview (eng_review_flag)

2.2.54. requiresImoReview (imo_review_flag)

2.2.55. hardwareSource

2.2.56. hasJ9 (J9_flag)

2.2.57. requiresQualityRecordsTracking (qr_track_flag)

2.2.58. hasCleanTrack (clean_track_flag)

2.2.59. sequenceNumber (seq_no)

2.2.60. initDocument

2.2.61. vendorItemNumber

2.2.62. inventoryMethod (inv_method)

2.2.63. criticalityCode (crit_code)

2.2.64. isFractureCritical (fracture_critical_flag)

2.2.65. weight (item_weight)

2.2.66. isPreProcessedHardware (preprocessed_hdw_flag)

2.2.67. federalStockCode (fsc)

2.2.68. greenProcurement

2.2.68.1. gpCategoryCode (gp_cat_code)

2.2.68.2. gpCategory (gp_cat)

2.2.68.3. gpSubCategory (gp_subcat)

2.2.68.4. isGp (gp_flag)

2.2.69. programCode

2.2.70. propertyCategory

2.2.71. material

2.2.71.1. isFlightMaterial

2.2.71.2. isGroudMaterial

2.2.71.3. isTestMaterial

2.2.71.4. isTrainingMaterial

2.2.71.5. isPreciousMetal

2.2.72. isArtifact

2.2.73. comments

2.2.74. predisposition

2.3. quantities

2.3.1. onHand

2.3.2. planned

2.3.3. allocatedSales

2.3.4. allocatedMfg

2.3.5. onOrder

2.3.6. short

2.3.7. floorStock

2.3.8. inReceiving

2.3.9. backOrdered

2.3.10. inInspection

2.3.11. reserved

2.3.12. inShipping

2.3.13. inMRB

2.3.14. inTransit

2.3.15. onOrbit

2.4. bill

2.4.1. parents

2.4.1.1. masters

2.4.2. children

2.4.2.1. masters

2.4.3. acls

2.5. limitedLife

2.5.1. usageLife

2.5.1.1. total

2.5.1.2. hasUsageLife (usage_life_flag)

2.5.1.3. unitOfMeasure

2.5.1.4. serviceDef (usage_life_svc_def)

2.5.2. cycleLife

2.5.2.1. hasCycleLife (cycle_life_flag)

2.5.2.2. total

2.5.2.3. unitOfMeasure

2.5.2.4. serviceDef (cycle_life_svc_def)

2.5.3. flightLife

2.5.3.1. hasFlightLife (flight_life_flag)

2.5.3.2. total

2.5.3.3. unitOfMeasure

2.5.3.4. serviceDef (flight_life_svc_def)

2.5.4. timeLife

2.5.4.1. total

2.5.4.2. hasTimeLife (time_life_flag)

2.5.4.3. unitOfMeasure

2.5.4.4. serviceDef (flight_life_svc_def)

2.5.5. shelfLife

2.5.5.1. hasShelfLife (shelf_life_flag)

2.5.5.2. total

2.5.5.3. unitOfMeasure

2.5.6. launchLife

2.5.6.1. hasLaunchLife (launch_life_flag)

2.5.6.2. total

2.5.6.3. unitOfMeasure

2.5.7. onOrbitLife

2.6. calibrations

2.7. Documents

2.7.1. type

2.7.2. attributes

2.7.3. approval

2.7.3.1. status (approval_status)

2.7.3.2. history

2.7.4. audit

2.7.4.1. insertDate

2.7.4.2. lastUpdate

2.7.4.2.1. date

2.7.4.2.2. by

2.8. Components

2.8.1. id (tracer)

2.8.2. itemNumber (master id)

2.8.3. drawingNumber

2.8.4. serialNumber

2.8.5. lotNumber

2.8.6. side

2.8.7. size

2.8.8. description

2.8.9. class

2.8.10. shortName (acronym)

2.8.11. asBuiltNumber

2.8.12. asDesignNumber

2.8.13. assembledOn (not a date)

2.8.14. quantity

2.8.15. currentLocation

2.8.16. bill

2.8.16.1. parents

2.8.16.1.1. Components

2.8.16.2. children

2.8.16.2.1. Components

2.8.16.3. audit

2.8.16.3.1. insertDate

2.8.16.3.2. lastUpdate

2.8.16.4. approval

2.8.16.4.1. status (approval_status)

2.8.16.4.2. history

2.8.16.5. acls

2.8.17. Documents

2.8.17.1. type

2.8.17.2. attributes

2.8.17.3. approval

2.8.17.3.1. status (approval_status)

2.8.17.3.2. history

2.8.17.4. audit

2.8.17.4.1. insertDate

2.8.17.4.2. lastUpdate

2.8.17.5. acls

2.8.18. audit

2.8.18.1. insertDate

2.8.18.2. lastUpdate

2.8.18.2.1. date

2.8.18.2.2. by

2.8.18.3. transactions

2.8.19. approval

2.8.19.1. status (approval_status)

2.8.19.2. history

2.8.20. acls

2.8.21. limitedLife

2.8.21.1. lifeLimitDescription

2.8.21.2. usageLife

2.8.21.2.1. total

2.8.21.2.2. hasUsageLife (usage_life_flag)

2.8.21.2.3. unitOfMeasure

2.8.21.2.4. serviceDef (usage_life_svc_def)

2.8.21.3. cycleLife

2.8.21.3.1. hasCycleLife (cycle_life_flag)

2.8.21.3.2. total

2.8.21.3.3. unitOfMeasure

2.8.21.3.4. serviceDef (cycle_life_svc_def)

2.8.21.4. flightLife

2.8.21.4.1. hasFlightLife (flight_life_flag)

2.8.21.4.2. total

2.8.21.4.3. unitOfMeasure

2.8.21.4.4. serviceDef (flight_life_svc_def)

2.8.21.5. timeLife

2.8.21.5.1. total

2.8.21.5.2. hasTimeLife (time_life_flag)

2.8.21.5.3. unitOfMeasure

2.8.21.5.4. serviceDef (flight_life_svc_def)

2.8.21.6. shelfLife

2.8.21.6.1. hasShelfLife (shelf_life_flag)

2.8.21.6.2. total

2.8.21.6.3. unitOfMeasure

2.8.21.7. launchLife

2.8.21.7.1. hasLaunchLife (launch_life_flag)

2.8.21.7.2. total

2.8.21.7.3. unitOfMeasure

2.8.21.8. onOrbitLife

2.8.22. calibrations

2.8.23. Events

2.8.23.1. bill

2.8.23.2. id (event_tag)

2.8.23.3. name

2.8.23.4. type

2.8.23.5. flight

2.8.23.5.1. id

2.8.23.5.2. name

2.8.23.6. crewMember

2.8.23.6.1. id

2.8.23.6.2. name

2.8.23.7. hardwareListNumber

2.8.23.8. status

2.8.23.9. acls

2.9. audit

2.9.1. insertDate

2.9.2. lastUpdate

2.9.2.1. date

2.9.2.2. by

2.10. approval

2.10.1. status (approval_status)

2.10.2. history

2.11. acls

3. Events

3.1. bill

3.2. id (event_tag)

3.3. name

3.4. type

3.5. flight

3.6. crewMember

3.6.1. id

3.6.2. name

3.7. hardwareListNumber

3.8. status

3.9. acls

4. Documents

4.1. id

4.2. type

4.3. attributes

4.4. approval

4.4.1. status (approval_status)

4.4.2. history

4.5. audit

4.5.1. insertDate

4.5.2. lastUpdate

4.5.2.1. date

4.5.2.2. by

4.6. acls

5. Shippers

5.1. type

5.2. Components

5.2.1. id (tracer)

5.2.2. itemNumber (master id)

5.2.3. drawingNumber

5.2.4. serialNumber

5.2.5. lotNumber

5.2.6. side

5.2.7. size

5.2.8. description

5.2.9. class

5.2.10. shortName (acronym)

5.2.11. asBuiltNumber

5.2.12. asDesignNumber

5.2.13. assembledOn (not a date)

5.2.14. quantity

5.2.15. currentLocation

5.2.16. bill

5.2.16.1. parents

5.2.16.1.1. Components

5.2.16.2. children

5.2.16.2.1. Components

5.2.16.3. audit

5.2.16.3.1. insertDate

5.2.16.3.2. lastUpdate

5.2.16.4. approval

5.2.16.4.1. status (approval_status)

5.2.16.4.2. history

5.2.16.5. acls

5.2.17. Documents

5.2.17.1. type

5.2.17.2. attributes

5.2.17.3. approval

5.2.17.3.1. status (approval_status)

5.2.17.3.2. history

5.2.17.4. audit

5.2.17.4.1. insertDate

5.2.17.4.2. lastUpdate

5.2.17.5. acls

5.2.18. audit

5.2.18.1. insertDate

5.2.18.2. lastUpdate

5.2.18.2.1. date

5.2.18.2.2. by

5.2.18.3. transactions

5.2.19. approval

5.2.19.1. status (approval_status)

5.2.19.2. history

5.2.20. acls

5.2.21. limitedLife

5.2.21.1. lifeLimitDescription

5.2.21.2. usageLife

5.2.21.2.1. total

5.2.21.2.2. hasUsageLife (usage_life_flag)

5.2.21.2.3. unitOfMeasure

5.2.21.2.4. serviceDef (usage_life_svc_def)

5.2.21.3. cycleLife

5.2.21.3.1. hasCycleLife (cycle_life_flag)

5.2.21.3.2. total

5.2.21.3.3. unitOfMeasure

5.2.21.3.4. serviceDef (cycle_life_svc_def)

5.2.21.4. flightLife

5.2.21.4.1. hasFlightLife (flight_life_flag)

5.2.21.4.2. total

5.2.21.4.3. unitOfMeasure

5.2.21.4.4. serviceDef (flight_life_svc_def)

5.2.21.5. timeLife

5.2.21.5.1. total

5.2.21.5.2. hasTimeLife (time_life_flag)

5.2.21.5.3. unitOfMeasure

5.2.21.5.4. serviceDef (flight_life_svc_def)

5.2.21.6. shelfLife

5.2.21.6.1. hasShelfLife (shelf_life_flag)

5.2.21.6.2. total

5.2.21.6.3. unitOfMeasure

5.2.21.7. launchLife

5.2.21.7.1. hasLaunchLife (launch_life_flag)

5.2.21.7.2. total

5.2.21.7.3. unitOfMeasure

5.2.21.8. onOrbitLife

5.2.22. calibrations

5.2.23. Events

5.2.23.1. bill

5.2.23.2. id (event_tag)

5.2.23.3. name

5.2.23.4. type

5.2.23.5. flight

5.2.23.5.1. id

5.2.23.5.2. name

5.2.23.6. crewMember

5.2.23.6.1. id

5.2.23.6.2. name

5.2.23.7. hardwareListNumber

5.2.23.8. status

5.2.23.9. acls

6. CrewMember

6.1. anthropometric

6.1.1. acls

7. Components

7.1. id (tracer)

7.2. itemNumber (master id)

7.3. drawingNumber

7.4. serialNumber

7.5. lotNumber

7.6. side

7.7. size

7.8. description

7.9. class

7.10. shortName (acronym)

7.11. asBuiltNumber

7.12. asDesignNumber

7.13. assembledOn (not a date)

7.14. quantity

7.15. currentLocation

7.16. bill

7.16.1. parents

7.16.1.1. Components

7.16.2. children

7.16.2.1. Components

7.16.3. audit

7.16.3.1. insertDate

7.16.3.2. lastUpdate

7.16.3.2.1. date

7.16.3.2.2. by

7.16.4. approval

7.16.4.1. status (approval_status)

7.16.4.2. history

7.16.5. acls

7.17. Documents

7.17.1. type

7.17.2. attributes

7.17.3. approval

7.17.3.1. status (approval_status)

7.17.3.2. history

7.17.4. audit

7.17.4.1. insertDate

7.17.4.2. lastUpdate

7.17.4.2.1. date

7.17.4.2.2. by

7.17.5. acls

7.18. audit

7.18.1. insertDate

7.18.2. lastUpdate

7.18.2.1. date

7.18.2.2. by

7.18.3. transactions

7.19. approval

7.19.1. status (approval_status)

7.19.2. history

7.20. acls

7.21. limitedLife

7.21.1. lifeLimitDescription

7.21.2. usageLife

7.21.2.1. total

7.21.2.2. hasUsageLife (usage_life_flag)

7.21.2.3. unitOfMeasure

7.21.2.4. serviceDef (usage_life_svc_def)

7.21.3. cycleLife

7.21.3.1. hasCycleLife (cycle_life_flag)

7.21.3.2. total

7.21.3.3. unitOfMeasure

7.21.3.4. serviceDef (cycle_life_svc_def)

7.21.4. flightLife

7.21.4.1. hasFlightLife (flight_life_flag)

7.21.4.2. total

7.21.4.3. unitOfMeasure

7.21.4.4. serviceDef (flight_life_svc_def)

7.21.5. timeLife

7.21.5.1. total

7.21.5.2. hasTimeLife (time_life_flag)

7.21.5.3. unitOfMeasure

7.21.5.4. serviceDef (flight_life_svc_def)

7.21.6. shelfLife

7.21.6.1. hasShelfLife (shelf_life_flag)

7.21.6.2. total

7.21.6.3. unitOfMeasure

7.21.7. launchLife

7.21.7.1. hasLaunchLife (launch_life_flag)

7.21.7.2. total

7.21.7.3. unitOfMeasure

7.21.8. onOrbitLife

7.22. calibrations

7.23. Events

7.23.1. bill

7.23.2. id (event_tag)

7.23.3. name

7.23.4. type

7.23.5. flight

7.23.5.1. id

7.23.5.2. name

7.23.6. crewMember

7.23.6.1. id

7.23.6.2. name

7.23.7. hardwareListNumber

7.23.8. status

7.23.9. acls