93-20523 · 2011. 5. 13. · applications corporation (sra), under contract number 903-91-1-0061,...
TRANSCRIPT
IOffice of the Deputy Assistant Secretary of Defense,0Health Service Operations (ODASD(HSO))Medical Functional Integration Managment (MFIM)
o Medical LogisticsFunctional Integration Management -D r r
__ ~~Activity Based Costing l..o__ and Data Modeling Workshop 0fE1
7 ~~~MHS8. lids hwkim wod uub.~sdrkf(04.g nEasY, d~w oMraMW. sy emarIwb reL
kwimprove.i each of %tidi may
MATERIORGANIZATIONE
buiwf dftfoorbody o
dwp~j, nwexuia ofsb amn taqbu., tw Mr/ ipi
LppKWv" bw pebb OWuCm
Volume 11VsrIU~Usmi
93-20523
I ~~Febmrua 1,9IM *rougb April3 21M9
April 1993 "
This document was prepared by the Core Team of the Medical Logistics Workshop as aculmination of the Medical Logistics Functional Integration Management (FIMO ActivityBased Coting Group and Data Modeling Group efforts. Systems Research andApplications Corporation (SRA), under contract number 903-91-1-0061, providedworkshop facilitation at 2000 15th Street North, Arlington, Virginla, 22201.
Mr. Chuck Rounds may be contacted for additional Information or copies of this report.
This report was published in part to satisfy the intent of the Department of Defense(DoD) 8020.1-M (Draft), FRunconal Process mprovement Document.
Other reports published through this initiative:
0 Medical Logistics Functional Integration Management Basellne/ScoplngWorkshop Report, January 1993
REPORT DOCUMENTATION PAGE Form Aprovoed
E0M No 070 018.
Put' '7M ~ it" 2 :stt- A -7 " t oA' a2 Aa'tr, -,cu t~ v-e ¶nv r-vweW11, Mir U '-I -.1. 11- .1I ,,ijr '2 t a nee-j j afl MC TM2 i_ c ) t ie :'It cinmenis reaari thisbu a
" 1 ~It'tf 1,' WJ'*'.! '32 1,11ti~ Ptý'' ',,r 'p"U(r,r ?!',% 0,,fitO- t Vraitinl /vpnr Q uc r ,j i~t, LworClOrate t2! int~rmatt~ Jeion % .n
I. AGENCY USE ONLY (Leave olanx) 2. REPORT DATE 3. REPORT TYPE AND DATES COVERED
4 . TITLE AND SUBTITLE 5. FUNDING NUMBER$
Medical Logistics Functional Integration ManagementActivity Based Costing and Data Modeling Workshop
* Final Report, February 1, 1993-April 2, 1993, Viols II 116. AUTHOR(S
7. PERFORMING ORGANIZATION NAME(S) AND ADDRESS(ES) 8. PERFORMING ORGAii A,•iIUl.
REPORT NUMBE"
Office of the Deputy Assistant Secretary of DefenseHealth Service Operitions (ODASD(HS)))Medical Functional Integration Management (MFIM)
9 SF ONSOR!' . .. . - ..... ;. .. ';,. ' ! 71, SPONSORIN " .'tI: ,AGEI.:.
11. SUPPLEM T'14 , " T
SDISTRIBU1lO' AVAO LAbL'- IS p. MSTRILUTI0t.
Distribution AApproved f -Public Release;Distributio s Unlimited
The Activity Based Costing and Data Modeling Workshop convened in February1993. The workshop participants, known as the Core Team, includedrepresentatives from the Tri-Service-Medical Logistics community. The purpose ofthe workshop was to identify current business practices of the Department ofDefense (DoD) Medical Logistics community, data entities and attributes insupport of the current business, and associated activity costs. The workshop wasconducted using Corporate Information Management (CIM) methodology asprescribed by DoD Directive 8020.1-M. Vol I contains the exectuive summary,introduction, project plan, activity models and analysis, and recommendationsbased on the ABC Group findings. Vol II contains the AS-IS data model and itsappro priate definitions and business rules. In addition, Vol II contains the legacysystem matrices developed by the Data Modeling Group.
114. SUBJELT TERr.. I 4 3 2...CIM Collection__ ______
I 1i PRICE COll
17. S1•CURITY CLASSIFICATION I1L.. SECURITY CLASSIFICATIOr 1. SECURITY CLASSIFICATION 20. LIMITATI7I" OF A!'2TR,.2'fed ABSTRACT
qJ W is i i d Urfis~m f
Medical Logistics Activity Based Costing and Data Modeling WorkshopTable of Contents
Volume 11
Section 1 ...................................... MHSS AS-IS Logical Data Model
Section 2 ............. ................................. Data Element List
Section 3 .............................................. Entity Definitions
Section 4 ............................................ Attribute Definitions
SectW on 5 ................................................ Business Xwes
Section 6 ............................................. Derivable Elements
Section 7 .................................... MESS TO-BE Data Model Issues
Section 8 .................................... Legacy Systems Attribute Matrix
kee el j )n Fo r~
1 .t
ii
This Page Intentionally Left Blank
Section 1MHSS AS-IS Logical Data Model
The Medical Logistics data model represents the logical data entities and current business practices ofthe Services. Every unique feature of the legacy systems was identified and placed into the logicaldata model. Service functional representatives were in attendance to represent the legacy systems andto extract the necessary data hidden in the coding schemes of those systems. The data model wascompared to the Defense Finance and Accounting Service (DFAS) and Joint Logistics SystemCommand (JLSC) high-level data models and where possible was designed to conform to theseexisting entities.
1-1
This Page Intentionally Left Blank
1-2
COMMUNICA'lON-UNKMod"~a Log~bm AS-iS Data MOMe - APA 2 1993COM-MZW k
tac-id (61<)corf~ln kl-lye
pa " m~~ fv~d(FK) - ------
[Chidperlon-id peon-imd (FK) WEESCU-N
r WRLESS0MM-INKORGANIZATON-COAW~tNK-REASONfcoillunrabon-Imk-id (FK)
reisnto, cornmunkaborrn-ikkd (FK) - -
INDMDAbteOM-LterEAiOle.cORAIA1*-OIMWUNK-USAGE
kln~duuatlW mn -LWiink - - -t INDM OUAL-ZO~rM -LINK-USAL3E org-id (61<)
O~lNcEGOR = ~ p- id FK IZAT1ON-STRUCTUREFK ORC.ANIZATX1O.,LSER0CTUE-S
I, -uesbWnk-y-deS Cl(FK)fg. org-a (61<) 04 ussr-r &" f~ n -rsc or(FKdrs)ssnc cst-tr) ( _ __ _ __ _ __ _ __
IINV7UAfRLE EAON _
ORG-NIdAKNCTG R (61<)~ rd(F) I M =r-utu &q cperson-nd (6K)
- ~ IO R G A N I Z AAt- L O C A 1 O N - R E A SN 1 Is W t d t
org-loc-rsgdee
INOMDLAL-LOCAAT1 EAO N oi-i orgaiiizidblegmycd (FKperson-idUmtty (6) IFS EORL-R
mdleidul-ide-.,-cuW(6WideAtUACTURE
aaai C- Korg.4 IDMO UA) ROE vrid(WFch6-r-K (
or-tcuor-id n~ (At)
WHOORf-~w-eF&
ep--i (61<)kw.rdrds~deu Wffder4-c.*dLileV
(M fwW~ (FK)oj) MAUFAMU
ide.-e 999 LIK)
Wal ---------------------
SERVICE-STRUCTURE SERVICE-CATEGORY SERVICE-TYPE
chl-scca- mdsc-asRýd v-cat-namr ------- w typ.-wS
- - - - - - ---- - ---- - ---- - ------- -----
SEVCECTA[OW-TEMw~c-ca-t~ldSCHEDULED/UNSCHEOUILEO-CATEGORY
-- yec (F1 (FK)IId-lgoyc
l W C-Cat -
IEEY-EM PERFRMANELSEVIC reCE
Flw-caIw-h-* sy-a-r (F )I
U51DDE-RL ORG-ORDE-TER
SAFETY-CNSPTCAIT
PrinfI-dn- (FK) REPAIR__ F _nlttyOdSA ________________ -on -ion-il (FK)
C~~POF3~4O~_J (FK)i coirctK I--I q- -oWIUcd t(FK -
. . . . . . . . . . . . . . . . . . ..
COTAC-EROiRL Dfodjce _ _ _ _ ha____d-~
matrcatrbial, cofwin (IR)gt-awprIc~~~~~ ~ ~ ~ ~ Iofc~~w-w:d(K pof
ai-gmg-!
"MOM-
hillterbol" -- ---- -- -r - iK -4 ---_____ _____ ____- -__-_-_-_-_-_-_-_-_-_-_-__-_-_-_-_-_-_-_-_-_--
ow - ___a_____ _____
wen____________ ___________________________ silo______ 004
qftqEQ-STRIJCTURE ORDER-LINE-SThUCThRE- -.--. DCMNpeatorrlOder-10 Order-e (FK_) (paritnt-rder.Ima-orduriod order,id (FK)
ordertypeed didvrda-d~orderid (FK() powt-rorder-tw.wdwr-me. iod rcrer.-lrWI (FKFcMOaelmrde-lr.idordo,-.hne-r (Fro rtoC type
vhjil"rder-I gorder-Id Order-id (FK)
16 ORDER-LINEORDE AU---O
oredorder-Ire-aCn (FK
order-typod (FK) ty-olrderedc
stwtrje-cidpttonal
- -- -- - - -detmaCtd-cd~
- -- -- -- -- - -- -- -- -- opefM&OCIeor OIC)(
SERVICE-ORDER-LINE compi-dt - -rre qsorde-iereid (FIK) tatnlpefa
------------- 7 order-ld (FK) del".-OCler-nO/~tort,
WORK-<ORDER ta~ndwnscheduied-categiry-ed (FIK) nuwotd FCRDRLN
order-od (FIK) smee'c-order-ccor"Pbton-datestbrtol-C AOORL4mv4" -0 eml (K)vrw-odr-tatditturrir-e -wft order-Iew-id (PlO)
peuo-d Pr)MATERIEL-ORDER-LINIE torder-rifle-type-Cc .oeroo0 &FKq
~ritereart-d! 'order-here-id (PlO) Tac-id ýFK)-V-dbord L m-Nid o orrerid (PO)
rhoeed-try-WCt-pe73rt-id.pw-sW'-i (ME OVL-SOURCE-SVC-ORDIER.LN metcetBr-idtw rkioder-typeCd oroer-here-id (FK) _
"ordr-id (PlO)
NON-PERS-OIS-ORDER-LNSCo-rde-lre-id (PlO)order-id (PlO
GROUPL-MNGD-EMUPAlp-K-ORDEROrder-hd (PlO)
org-Id (Pl) soi4NAEGDYI R IDORER
a0.rgdma-qtM (PrO)
rIst-cst-Mtfrld (PlO)
e1ordef d (FK) i order-hie-d (PlO)
I _____________ uqued by
- --- - -- -_ _ j_ _______- _____ERLIS:UDA
order-Id (PlO
II '
FF
FAG-S7RUCTVRE F~-TYPE--- FAC-SYS CLASS. STRUC PJRE. c - £Sd
[ftrtntpfa c-rh -4 w to o a S s-m w *
FACI~~flYSTANDARO STDAA.-TRCTYR
F -is -**-(t c fad slt-ctogoly~a FFK
- - - - - -- - - - - - - -
1FK do-n FX aiatte tham'trdt
FACILITY__ M-URAC
FAT~lYSYM-TRC~JR (fc-aKg)yc (FK)Y STANA.!E STT1LC-TU'Lt
l't-f(FK i st" t oci (F(FKIdICqTC F) e,'y-: ~(FX) Lc-dI ftc-id (PlC) tocVi - fiflog ry4C tlubttsogf y*CII FR)
-__ _ _ _ _ _ _ _ _ _ - -----.--- -- -,te -ty - - - - - - - -e-cd-- - - - -l
$LAr-ORG-RSNCA
STNADFACILrTY-FUNTIL -UE t wIZATIwVdtFO Nt ntytumcvrvtee fu (inlcFKg) -d(R a-toclgr-oIR
OoJO-fPc feC-agor-4 (aegryK)(F
______ loC-aW (Fte) fac-tis.lI ZrZt-.FrK. ...
cidtc= flcorg-rt* (F X) i suffic Iio~yp dýK
~22 2 :d I I-____ fc-fyfe-Cd 6lLrfN
a____ oftc-Ide by
FAC-TEORL-NEWOR
wblýCMtc (F(FR
FA 4lYfUN~OFAteOGo dF ) _______ftW-x~l-C (K
adLZflNCTSO' tic) Id (FR)aac
STRUCTURE CAMPUS
CRGAMIA~i~qI-FLI~ UXCTINAA--JTTZA11O
firmeaoonal-cigýyd (FKR) ftii~ICi~~VC (FR)c d__ ___ __
II ~ liog-d (t1R) UTILIFK)INSALLAiONSTRUOUR
""manUEid~ to lJat-l-i (FR
- RALATO- 1.CXNA-nLZTO
1114
a'w-
Tr-i (F K)
oT)tlsUnm .LOT-G-NArDSPP MALO
**"-l~..cloc-ld (K) Ii fat-Clriký-.C tFK!_____Me h a wja~ loc-. (FK)
lot ýo ýFK
L -47Tt1 fix1g~4Gt0
LOC.ATION
-asaigfledby Mention Whf- rll~eb bedaIO
- -- - - - - - - - - - --
--- --- - - -1
I t 1aos j
CONR GR-G UNAIO-ATý c-SUPY . 0C
-~ ---- r ~ maat-aat."-r. ((Fr
lo101- no (F__j gr-g-~tdqpoPeamty
POSTAL-ZONE L G~lSR~Trel I i I cgnam d&naelsu-e-
W"-1 (FK) _____ mtc 0(C
-a reatad to
PROGRAMAD0RjSS ~~GROUP-MGEOILC
F I og~idFK)F o~(')Org-.o (FK) j mat-caltrid- (FK)I p~~~og~rain-type-cilleId(K
____c-. (FK) FK
Igroup-rnngd-aQ.ViprtylOZxl ý(FK) F mran-type-cd Imp
STATE I - - - - - - ~-
WIW-PROGRAA-TYPE
PROJEG`T-STRucTURE veneerWYRW-PfRGRAMrýý rv~W plgrlnt-51 (F pIOgtsm-id (Flodmc-rgam3pmrogrm-Id (PlO)WR-U-AC
pvIXýWC-eJ pfojftl-id (PlO) pmn-rg-typ-cd (PlO) - -- - WR-FNL__ Ccd-gwomsCt-Idi2 projecl-Id (FK) WrrIprog-Id (AKI) progWam-I (F'K)
enidgned-0'g-ld org-Id (PlO) kmine though F 1nd-acct.,d (PO) iSHLFcc-id (PlO) etiwmt
Sl*LPcmntd-wrnr-fundloo~j(PlO)oblqgWrilumd
PROJECT rllat
rp-9g-- (PlO)
CABWTorg-e orn "uprfwnt-W-elal-TAcflMTUE mV0P11v~ _ _)Mt-ng- 1m(K
F- W~~~rotm-ld (Frepoerrnndw-n cc- (FK) cm
re1u h - - -I - - - - - - - - - - I &
00oelW~ tem-l) proFaK) wrmPlO)s (pgami(__pmv proo oJFK-e (PlO) Int d I pfcl-m(F
tSOIW-4tgOW-N 001-) (Fufld""ypS-ed (PO)
wrrcath d (Ptlo) nafPfI@~~idfiln
-.4o- - - - - - - - - - - - - - - - - - -
T T ~ ~ ---------- - ----- -- -- _ _p __ sw~ ~ _
I I F
------------i ~F- - r--------- --- i ---------------- - -
- - - - - -- - -
-~SUP~tY Y-WER3ELofg-9- (FK) (FK A4JPMET1ATES4NT5r'T ANE.NGIATEO -
matzall-anldE~ *FK *QIMN-ATSiNsydy (FK) -corlabogi ;Iý ý I -j
Wfl~b-usp*Msd~f-qlýI yK cor'l-ro, (FK,
camnsW7- ýqt-jsnm GROUP-MNGD-EQUIPAENWT qCl-II-dtlts'
sum~~-qt-fec og-~(FK)SINGLY-MNGD-EQ4JIPmoupo~tymr rs-at-lty-i (FK) _ _ __ _ _ _
____cmnsumption-mt-spr org-ld (FK)conovTct~nofrO(K) mat-cat-iinld (FX) OSno--* Wrt4x 4ia r
I I cwtlvjmptflo-qty-jutl~I~--9-4S~WL-4A (FK cm'suwpnon-"~-*ugI ________rnt-aliti- (F) (FK)p1n~t~u EOUIPMENT-SN'STEWM-ATERIEL g-d{K
mat-c32-ltr-.- (FK) FK
cosunpborqty oc I o.gd (FK) ýtC~t-ft, ($Kl
consumpmF-q.;;n maf-cat-AM-id (FK) lcd(K
UNDATED-supPIy.YmAT cof g"I-Oo~-dnorp-id (FKg) dic-bntr-feleatg-, - decImat-cat-mn-O (FK) ,eu4-r40 C-C F
EOUIP-AVAIL-rYPE be~o
IEOUIPME4T-COND-STATUS - F - -___
------- -- ------- -4 - ---- ' ---
asins--+ -- -
1 ~ri-4nnj, ~rve for
- - - - - - - - - - - - - --- - - - -- ---- - - -~IJ4t
EOUIPMENiT SYSTEM
(~~~) ~EOUIPPMENT.SySSAU 6oqup-cftdtoýysillxM (FK) EOCt PMENTMrEM-STATIhS _____NC- NFIATJE
qwpd(F) 43,rn-txt"p-Cd(F} .q-tuctT mec
cotctn (K qulP-anlbh sn-cid (FK) I q 4 GýtCitd O( ___ cuinu.v-tywpi-if
4----~b -id_l~orta*&*W4 (FK)
equipuEndfcil
WRWWEIASSkGNED-SMElSUE _____(Vty~mngd-mvl.qt~o (K
ýýtd(rK)
I;-: ~ JITSMrYCNADTE-CoT~o'
matcatItn-4 matcK)a (Fm*cr-i (K . - C wtoLh
lot-no~~~ ~~~ ',noMAEIL AAOGIE
mg-gAm.i (PF( Ix
kit-nriioiur SU STT TEC TA O -r M (FKft
agly-mngd-mal-oqI-tx (FK)
Squo-nin-cd Udant0(SSUG
unkstastI
ma-cat-Intmatcot-n~ (F) RCKD-N-r*crbdechld (K) at-cavct- Cid-Id -stb ý (FK)
p4YI.CyCI 4ndcatI
LNC-d~ SERVICE-TASKIMFT-CAS h
MATERIL-DEVCE-SIIO.T Ifl¶MANAATEIEL-INPECTIN-TAS
aw-Wftr-na (FK -----I--- --------------------------------- Te noe to
ft-U
I-AEIE-E E-LS
- -- --- -- -- -- I ATRIm-DVN
I GRUN~Dr-~-ORG-ROLE FUND 1YPE IFUND-ACCT-rYPE FUND.ArCT-MTUCT
[email protected]. d(d4I cftd-etu"-&d twnO*W-d (FK)
ii t~d-typ-cd na-t4p.~nonb'1latut I c-ty wcdaeho44ttp-sro Cd4K~v-vtm~ -d(K
ii qF (F)I A.
tadOWl (F) tfle b tfodWt
mg-Id- (FK)I furfd-ecct-Id(FK)
I I O6ECT-CLASS
fIlýW-c - wK
II FUND-AC--T.PftoGRAM
IIFUND-ALLOCA~ONMt(tO,-W(Kthfld4SWtid (PlC)oboctýýC (PlC)
4 I auMII-NndI I nuad-ye-mfl
unoblp-yW4"u-c%"mtI
tuffn nocrs-mlt- fund-.cdd (FK) 4
___ _ _____ _____4mt4%ft
IIns~d e----- -- ----------------------
I 4I NON-DSOF-fUVNaACCTft dc~gtm d by I ___ _ _ _ fud-acrt-Id(FIC)
I 4 4 A-VERSKON
4 4 o -cd1 -----------4 -------
_______ __________ _______________ ____________I IUA,-TYPE-SIRLICTURE
parffjtm-u3"I-c ue-ns-cd (FIC)
"TYPE4AT-REW 1hd-u5-"fw-cd UWA-WfI. (PlC)
us4tc~ od t- ýri 4FK -tper e- "y.fw-3~ 7.d ttC~ ~ TC
ua-mt~ca-Im-d me-at-m-Id (FK)4 4oa to
s-veil-cd (F C 44u~eu-t""4du-~.iI ma-atS-I Pl)4 4 4
4 4 4yhvm*Wo*-uw
-- 4b-id (FK)
IT T
uW"c (PC) 4 "
-vo-Id (PK)(AC
a" (FMu (W)FK
------------------------ ------------- --
Section 2Data Element List
(PK=prinary key. FK=foreig key)
Entity: ACCOUNTABILITY-CATEGORYData Elements: accountability-caegory-cd(PKC)
accuntability-caegory-dese
Entity: ACQUISITON-ADVICE-CATEGORYData Elements: acquisition-advice-cd (PK)
acquisition-advice-desc
Entity: ADDRESSData Elements: loc-id (PK) (FK)
Entity: ASSIGNED-SMEIData Elements: singly-mngd-niat-eqt-itm (PK) (FK)
doc-no (FK)accountable-org-id (EK)authorized-org-id (FK)mat-cat-itin-id (FK)sterile-pk-id (PlC)
Entity: AUTH-DOCData Elements: doc-no (PK) (FK)
Entity: BINData Elemens: 1cc-id (PKC) (FK)
Entity: BUILDINGData Elements: fac-id (PK) (PlC)
Entity: BUYER-VENDOR-CONSTRAINTData Elements: buying-parent-org-id (PKC) (FK)
vendor-child-org-id (PKC) (PlC)org-stnzctire-reason (PKC) (PlC)daffy-dollar-val-inax-per-itindaily-dolia-val-max-tot
'Entity: CABINETData Eimzwinu: loc-id (PK) (PlC)
Entity: CALIBRATIOND~an Eleumum: svc-cat-itmn-id (C PC
Enfti: CAbMUSDNAt Mel.: fac-I (PKC) (FK)
2-1
Entity: CITYData Elaewet: loc-id (PK) (FK)
city-name
Entity: COMM-OUTLETData Elements: fac-std-category-cd (PK) (FK)
Entity: COMMUNICATION-LINKData Elements: communication-link-id (PK)
fac-id (F.K)comlink-type-cd
Entity: CONTRACTData Elements: contract-no (PK)
contract-type-descsui-of-work-textcontract-start-ditcontract-time-periodoption-flag
Entity: CONTRACT-PERSON-ASSOCIATIONData Elements: person-id (PK) (FK)
contract-no (PK) (FK)contract-person-role-cd (PK) (FK)
Entity: CONTRACT-PERSON-ROLEData Elements: contract-person-role-cd (PK)
contract person-role-desc
Entity: COST-CTRData Elemnts cost-ctr-id (PK)
Entity: COUNTRYData Elements: loc-id (PK) (FK)
country-name
Entity: DATED)-LOTData Elements: niat-ca-itm-id (PK) (FK)
mfr-org-id (PK) (FK)mfr-&
dest-flaglot-Do (PlC)(P)
2-2
Entity: PATED-SUPPLY-LOCData Elements- org-id (PK) (EK)
mal-c-a-ni-id (PK) (FK)mfr-org-id (PK) (FK)loc-id (PK) (FK)lot-no (PK) (FK)operatig-qtysusp-qty
Entity: DATED-SUPPLY-MATData Element: org-id (PK) (FK)
mat-w-at-m-id (PK) (FIC)ext-kmn-flag
Entity: DBOF-FUND-ACCTData Elements: fund-acct-id (PK) (FK)
op-wmt-authOP-atcdop-amt-oblig
Entity: DELIVERY-SERVICEData Elemwne: svc-cat-itm-id (PK) (FK)
Entity- DISBURSING-STNData Element: org-id (PK) (FK)
dssn
Entity: DOCUMENTData Elements: doc-no (PK)
Entity: DOD-ORGDaft Eleament: org-id (PK) (PlC)
cost-ct-id (FK)lp-surchg-rateko~ptional
Entity: ELEC-OUTLETData Element: fac-std-category-cd (PK) (FK)
dlec-outlet-type-cd
Entity: EQUIP-A VML-RSNData Eemerms: epp-avail-rsa-cd (PK)
equip-xvail-rwidmi
Ent~y: EQUIP-AVAIL-TYPEDaft Elemants equip-avail-ype-cd MPC
equip-avail~ype-&ws
2-3
Entity: EQUIP-SYS-ITMData Elements: singly-rnngd-mnat-eqT-itmn (PK) (FK)
equip.-sys-id (FK)
Entity: EQUIPMENT-COND-STATUSData Elements: equip-condition-status-cd (PK)
equip-condition-status-desc
Entity: EQUIPMENT-ITEM-STATUSData Elements: siiqgly-mngd-znat-eqt-itrn (PK) (FK)
equip-itemn-status-dt-time-cd (PK)e~qui-avail-type-cd (PK) (FK)equip-avail-mn-cd (PK) (FK)
Entity: EQUIPMENT-MAT-ASSIGNMENTData Elements: accountable-org-id (PK) (FK)
authorized-org-id (PK) (FK)mat-ca-itm-id (PK) (FK)doc-no (PK) (FK)qty-authqty-requested-for-authqty-in-useqty-on-loan
Entity: EQUIPMENT-MATERIELData Elements: org-id (PK) (PlC)
mat-cat-itmn-id (PK) (FK)crifical-itin-cd
Entity: EQUIPMENT-SYS-COMEPOSMTON-IHSTORYData Elements: equip-sys-id (PKC) (IFK)
stngly-mngd-mat-eqt-itm (PK) (FK)cuponent-sve-start-dt
comnponent-svc-end-dt\optional
Entity: EQU1PMENT-SYS-STATUSData Elements: equip-sys-id (PK) (FK)
equip-sys-status-dt-time-cd (PK)equip-vail-type-cd (PKC) (PlC)equip-avail-mu-cd (PKC) (FK)
Entity: EQUIPMENT-SYS-WORK-ORDERData Elaemns: order-id (PK) (FK
cqu#Hp-ssid (FK)
2-4
Entity: EQUIPMENT-SYSTEMData Elements: equip-sys-id (PK)
.quip-condition-stanis-cd (FK)doc-rK (FK)us-id (FK)maim-cry-id (FK)contract-no (FK)equip-sys-priority-cdaccountable-org-id (FK)authorize-org-id (FK)mat-cat-itin-id (FK)org-id (FK)maint-cat-cdequip-cond-cdequip-sys-scbed-svc-base-t
Entity- EQUIPMENT-SYSTEM-MATERIELData Elements: org-id (PK) (FK)
mat-cat-inn-id (PK) (FK)
Entity: EXTERNAL-NETWORKData Elements: fac-id (1%) (FK)
Entity: FAC-ORDER-LINEData Elements: order-line-id (PK) (FK)
order-id (PK) (FK)fac-id (FK)
Entity: FAC-OROData Elements: org-id (PK) (FK)
fac-id (PK) (FK)fac-org-rsn (FK)
Entity: FAC-ORG-RSNData Elements: fac-org-rsn (PK)
Entity: FAC-SITEData Elements: loc-id (PK) (FK
Entity: PAC-STRUCTUREData Elements: paremt-fac-id (PK) (FK)
child-fac-id (PK) (FK)
Evtit: FAC-SYS-CLASSDafta Elemefts: ficozys-cs-dý MPK
Entity: FAC-SYS-CLASS-STRUCTUREData Eamema: fae-sys-claus-cd (PK) (FK)
j 1 2-5
Entity: FAC-TYPEData Elements: fac-tPex-cd (PK)
fac-type-name
Entity: FACILITYD~ata Elements: fac-id (PK)
installation-id (EK)loc-id (FK)fac-type-cd (FM
Entity: FACILITY-COMPLEXData Elements: fac-id (PK) (FK)
Entity: FACILITY-FUNCTIONData Elements: fuci~onal-caegory-cd (PK) (FK)
fac-id (PK) (FK)
Entity:FACILIT-PROJECTData Elements: program-id (PK) (IFK)
project-id (PK) (FK)fac-std-category-cd (FK)fac-id (FK)
Entity: FACILIT-PROJECT-FUNDINGData Elements: programn-id (PK) (FK)
project-id (PK) (FK)fuind-typ-cd (PK) (FK)facility-project-fimd-amount
Entity: FACILIT-STANDARDData Elements: fac-std-caegory-cd (PK) (FK)
fac-id (PK) (FK)
Entity: FACILIT-SYSTEMData Elements: fac-id (PK) (FK)
ffacility-system-id (PK)fac-sys-clasc (FK)
Entity: FACILIT-SYSTEM-STRUCTUREData Elements: parent-fac-id (PK) (FK)
child-fac-id MPK (FK)parent-facility-system-id (PK) (FK)child-facility-system-id (PK) (FK)
Entity: FACILIT-UTILIZATIONData Elemnts: finctonal-category-cd (PK) (FE)
ntil-Wa-44 (PK) (EK)fac-id (MK (FK)
fw.-uti-workioa
2-6
Entity: FEDERAL-ORGDafta Elements: org-id (PK) (FK)
Entity, FUNCTIONAL-CATEGORYData Elements: functional-caegory-cd (PK)
functional-category-desc
Entity: FUNCTIONAL-UTILIZATIONData Elements: functional-category-cd (PK) (FK)
util-wa-cd (PK) (FK)
Entity: FUND-ACCTData Elements: fund-acct-id (PK)
fund-acct-type-cd (FK)fimd-type-cd (FK)
Entity: FUND-ACCT-NON-PROGRA&jMData Elements: fuind-acct-id (PK) (FK)
Entity: FUND ACCT-ORGData Elements: org-id (PK) (FK)
fiun-acct-id (PK) (FK)fund-acct-org-role-cd (PKC) (PlC)
Entity: FUND-ACCT-ORG-ROLEDafta Elements: fund-acct-org-role-cd (PKC)
fund-acct-org-role-name
Entity: FUND-ACCT-PROGRAMData Elements: find-acct-id (PKC) (FK)
Entity: FUND-ACCT-STRUCTData Elements: parent-fund-acc-id (PK) (FK)
child-fund-acct-id (PKC) (FK)
Entity: FUND-ACCT-TYPEData Elements: fuind-acct-type-cd (PKC)
fund-acct4ype-mame
Entity: FUND-ALLOCATIONData Elemns fund-acct-id (PK) (MlC
object-class-cd MPC (PlC)auth-findissue~yd-arnoblig-ytd-due-ou-azmunoblig-yd-&ae-out-amt
2-7
Entity: FUND-TYPEData Elements: ftuld-typ-cd (PK)
fuind-type-nomenclature
Entity: GAS-OUITLETData Elements: fac-std-category-cd (PK) (IFK)
Entity: GENERIC-EQUIPMENT-CLASSData Elements: line-item-no (PK)
Entity: GEOLOCATIONData Elements: 1cc-id (PK) (FPK)
Entity: GROUP-MNGD-EQUIP-LOCData Elemenets: org-id (PK) (FK)
mat-ca-itm-id (PK) (FK)Icc-id (PK) (FK)equip-conition-status-cd (EK)maint-org-id (FK)group-mngd-equip-qtygroup-priority-cdgroupsched-svc-base-dt
Entity: GROUP-MNGD-EQtJIP-WORK-ORDERData Elemns order-id (PK) (FK)
org-id (FK)mat-cat-itn-id (FK)
Entity: GROUP-MNGD-EQtflPMENTData Elements: org-id (PK) (FK)
mat-cat-inn-id (PK) (FK)ctract-no (FK)
Entity: GRP-MGD-UNDATED-MAT-SUPPLY-LOCData Elements: org-id (PK) (FK)
mat-ca-iftn-id (PK) (FK)Icc-id (PKC) (FK)grp-mgd-undated-sup-op-qtSrpmgd-tmdated-sup sp-qtgrp-mgd-undaed-suprep-qty
Entity: IMPROVED-LANDUDAMa Elemntsmi: installation-id (PlC) (PlC)
Entity: DIDIVIDUALData Eleminv: person-id (PlC)
2-4
Entity- INDIVIDIJAL-COMM-LINK-USAGEData Elements: person-id (PK) (FK)
comminication-link-id (PK) (FK)imlfividuat-conmn-link-rsn-cd (FK)
Entity- INDIVI9DUAL-COMM-LINK-REASONData Elements: individual-comm-link-rsn-cd (PKC)
individual-comm-link-rsn-desc
Entity- INDIVIDUAL-LOCATIONData Elements: persni-id (PK) (IFK)
Ioc-id (PK) (FK)individual-loc-rsn-cd (FK)
Entity: INDIYIDUAL-LOCATION-REASONData Elements: individual-loc-rsn-cd (PK)
individual-boc-rsn-desc
Entity: INDVIDUAL-ROLEData Elements: org-id (PK) (FK)
person-id (PK) (FK)imlividual-organization-rsn-cd (FK)
Entity: INIVIDUAL-ROLE-REASONData Elements: bidxividual-organization-rsn-cd (PKC)
imlividual-org-rsn-desc
Entity: INDIVIDUAL-STRUCTUREData Elements: parent-person-id (PKC) (FIC)
child-person-id (PKC) (FK)
Entity: INSPECTION-TASKData Elements: inspection-task-id (PK)
inspection-task-name
Entity: INSTALLATIONData Elements: installation-id (PK)
org-id (FK)
Entity: INSTALLATION-STRUCTUREData Elements: parent-installation-id (PKC) (MlC
child-installation-id (PlC) (PlC)
Entity: INSTALLED-EQTData Elements: uigya-mngd-mat-"q-lm (PK) (PlC)
fac-id (PlC)
Entity: LOCATIONData Elements: kic-id (PKC)
loc-inventory-freeze-flag
2-9
Entity: LOCATION-ASSIGNMENTData Elements: org-id (PK) (FK)
loc-id (PK) (FK)org-loc-rsn-cd (PK) (FK)
Entity: LOCATION-STRUCTUREData Elements: parent-loc-id (PK) (FK)
child-loc-id (PK) (FK)
Entity: LOTData Elements: mat-cat-itn-id (PK) (FK)
kotno (PK)mfr-org-id (PK) (FK)
Entity: LOT-MGD-UNDATED-SUPPLY-MAT-LOCData Elements: mfr-org-id (PK) (FK)
osg-id (PK) (FK)rn-at-w-it-id (PK) (FK)loc-id (PK) (FK)lot-no (PK) (EK)lot-mgd-undated-sup-op-qtylot-mgd-undated-sup-susp-qtylot -ngd-undated-sup-re-qty
Entity: MAINT-ORGData Elements: maimt-org-id (PK) (FK)
work-ct-cdlabor-rate
Entity: MAINTENANCE-SIGNIFICANT-ITEMData Elements: singly-mnngd-mat-eqt-itm (PK) (FK)
cwnulative-investment-rAtiocquip~yeoperational-status
Entity: MANAGED-MAT REPORTING-REQTData Elements: mat-cat-itm-id (PK) (FK)
org-id (PK) (FK)report-sttus
Entity: MANAGED-MATERLIEL-ITEMDataEleIn, umd-"a-itm-*d (PK) (FK)
En*it: MANUFACTURER
2-10
Entity: MATERIEL-CATALOG-ITM-MANUFACData Elemrnts: mnat-cat-itmn-id (PK) (FK)
mfr-org-id (PK) (FK)part-no
Entity: MATERIEL-CATALOG-ITEMData Elements: tnat-ca-itm-id (PK)
acquisition-advice-cd (FK)shelf-lifeaccountability-caegory-cd (FK)dated-item-cdunit-of-issueunit-of-packunit-of-measureunit-pricemateriel-nomenclatwreinspection-cycle-months-qtyreinspection-cycle-months-qtytracked-itni-indicator
Entity: MATERIEL-DE VICEData Elements: niat-cat-itin-id (PK) (FK)
ecri-device-cd (FK)
Enitity: MATERIEL-DEVICE-CLASSData Elements: ecri-device-cd (PK)
ecri-device-descriptionpni-cycle-nioscal-cycle-tubsstored-pm-cycle-inosstored-cal-cycle-mosstored-safety-insp-cycle-IDos
Entity: MATERIEL-DE VICE-S VC-TASKData Elements: ecri-device-cd (PK) (FK)
svc-type-cd (PK) (FK)svc-task-cd (PK) (FK)svc-task-seq-nosvc-task-expected-result
Enitity MATERIEL.INSPECflON-TASKData Elemnts: inspection-task-id (PK) (FK)
mat-cat-ur-id (PK) (FK)
Entity: MATERIEL-ORDER-LINEJ Data Elements: order-line-id (PK) (PlC)order-id (PKC) (FK)uu-at-w-tm-id (FK)
2-11
Entity: MATERIEL-STRUCTUREDiata Elements: pareMnr-mt-cal-ium-id (PK) (FK)
child-mnai-ca-inn-id (PK) (FK)materiel-structute-rsn-cd (FK)
Entity: MATERIEL-STRUCTURE-REASONData Eloewet: materiel-structure-rsn-,cd (PK)
maieriel-structure-rsn-desc
Entity: NON-DBOF-FUND-ACCTData IEai.s fud-acct-id (PK) (EK)
Entity: NON-PERS-O/S-ORDER-LNData Elements: order-line-id (PK) (FK)
order-id (PK) (FK)
Entity: OBJECT-CLASSData Elanm=: object-class-cd (PK)
object-class-name
Entity: ORDERData Elemeant: order-id (PK)
order-poc-person-id (FK)order-type-c (FK)order-placement-di
Entity: ORDER-LINEData Elememt: order-line-id (PK)
order-id (PK) (FK)document-id-cdmedia&status-cdorder-line-doc-noship-to-bill-to-mdfrdod-proj-rio/optionalqty-orderedadvice-cd~toptionaldemand-cdstatus-cdoptionaldate-expected-delytrans-ctl-no/optionalgovt-bil-of-lading/optionalprob-narrativegdc/qptionalpriority-desigreqd-deliv-dt"oder-Inse-nactiond/opcionalcop-.dtcall-no/optionaldeliv-order-no/optional
2-12
Entity: ORDER-LINE (cont'd)Data Elements: pchse-rdler-no.'optional
wtrm~and-condreimbursement-cdwnm-in-switchorder-line-tylxe-d
Entity: ORDER-LINE-FUND-ACCTData Elements: fund-accz-id (PlK) (FK)
order-line-id (PK) (FIC)order-id (PKC) (FK)
Entity: ORDER-LINE-STRUCTUREData Elements: parent-order-line-order-id (PK) (FK)
parent-order-line-order-line-id (PK) (FK)child-order-line-order-line-id (PK) (FK)child-order-line-order-id (PKC) (FK)
Entity: ORDER-STRUCTUREData Elements: parent-order-id (PKC) (PlC)
child-order-id (PKC) (FK)
Entity: ORDER-TYPEData Elements: ordler-type-cdl (PKC)
order-type-dlesc
Entity: ORG-ORDERData Elements: order-id (PK) (PlC)
org-id (PK) (FK)org-order-role-c (PKC) (PC)
Entity: ORG-ORDER-ROLEData Elements: org-order-role-cd (PK)
org-order-role-name
Entity: ORG-UA-TYPEData Elements: ua-vers-cd (PK) (FIK)
mat-cat-inm-id (PKC) (FK)org-id (PKC) (PlC)org-ua-qty-on-liandorg-ua-qlty-required
Entity: ORGANIZATIONData Eleen~ts: org-id (PlC)J ~ ~orgkamtion-categoty-ed(P)
unit-ype-cd (PlC)unit-identification-cdj ~routin-identifier-cdorlg-nmun
2-13
Entity: ORGANIZATION-CATEGORYData Elemenu,: organization-caegory-cd (PK)
orgain ztioD-cegory-desc
Entity: ORGANIZATION-COMM-LINK-USAGEData Elements: org-id (PK) (FK)
wummzunication-link-id (PK) (EK)4org-comnm-link-rsa-cd (PlC)
Entity: ORGANIZATION-COMM-LINK-REASONData Elements: org-com-Iink-rsa-cd (PKC)
org-omm-hink-rsfresc
Entity: ORGANIZATION-FUNCTIOND~ata Elements: functional-category-cd (PK) (FK)
oirg-id (PK) (PlC)
Entity: ORGANEZATION-LOCAT1ON-REASONData Elements: org-loc-rsn-cd (PK)
org-ioc-rsn-desc
Entity: ORGANIZATION-MATERIELData Elements: org-id (PKC) (PlC)
mat-ca-itzn-id (PIC) (FIOcperating-qty-on-bandhistory-begin-&dt-Iast-invqty-in-excessop>-reparable-qtywrm-reparable-qtyVecWa-proj-qty-on-band
Entity: ORGANICZATION-STRUCTREData Elements: parent-org-id (PKC) (FK)
cbild-org-id (PKC) (PlC)org-sftruue-,-reasn-cd (PKC)(l)
Entity: ORGANEZATION-STRUCTURE-RSNData Elements: org-strucar.-reason-cd (PKC)
Entity: ORGANIZATIONAL-SERVICEData EPlements: orgid (PK) (PlC)
ave-cat-in-id (PMC MPC
Emily: (XJT-SOURCE-SVC-ORDER-LNData Elames: order-line-id (PlC) MPC
order-ad (PlC)(h
j 2-14
Entity: OUTLET-TYPEDama Elements: outlet-type-cd (PK)
outlet-type-desc
Entity: PENDING-DISPOSITIONData Elements: singly-mngd-mat-eqt-itn (PK) (FK)
Entity: PENDING-ISSUEData Elements: singly-mngd-mat-eqt-itm (PK) (FK)
Entity: PERFORMANCE-SERVICEData Elements: svc-cat-itin-id (PK) (FK)
Entity: PERS-SVC-O/S-ORDER-LNData Elements: order-line-id (PK) (FK)
order-id (PK) (FK)
Entity: POSTAL-ZONEData Elements: loc-id (PK) (FK)' zip-code
Entity: PREVENTIVE-MAINTENANCEData Elements: svc-ca-itm-id (PK) (FK)
Entity: PROGPAMData Elemens: program id (PK)
org-id (FK)
Entity: PROGRAM-STRUCTUREData Elements: parent-program-id (PK) (FK)
child-program-id (PK) (FK)
Entity: PROJECTData Elements: pr6gram-id (PK) (FK)
project-id (PK)
Entity: PROJECT-STRUCTUREData Elemen: parent-program-id (PM) (FK)
child-program-id (PK) (FK)parent-project-id (PK) (FK)child-project-id (PK) (FK)
Ertity: RAW-LANDDaft Ebinws: inuallatiork-id (PKC) (MC
Entity: REPAIRData Ele.mm: syc-cat-lun-id (PK) (IFK)
2-15
Entity: RM-SURFACEData Elements: fac-std-caegory-cd (PK) (FK)
surf-ca-id (11K.)surf-finishsurf-heightsurf-widthsurf-length
Entity: ROOMData Elements: fac-id (PK) (FK)
Emily SAFETY-INSPECTIONData Eees: svc-cat-itni-id (PK) (FK)
Entity:SCHEDULED/UNSCHEDULED-CATEGORYData Elements: scheduled-category-cd (PK)
Entity: SERVICE-CATALOG-ITEMData Elements: svc-ca-itrn-id (PK)
svc-ca-cd (FK)svc-type-cd (FK)scheduled-catgory-cd (FK)
Entity: SERVICE-CATEGORYD=t Elements: svc-Ma-cd (PK)
svc-ca-namec
Emtity: SERVICE-ORDER-LINEData Elements: order-line-id (PK) (FK)
order-id (PK) (FK)svc-ca-itm-id (FK)scheduled-category-cd (FK)service-rder-cmnpletion-dateservice-order-start-date
Emtity: SERVICE-STRUCTUREData Elements: parent-svc-cat-itmi-id (PK) (FK)
child-svc-ca-itm-id (P)(FK)
Emtity: SERVICE-TASKData Elements: svc-mak-.cd (PK)
svc-rak-desc
Ewcky: SERVIMETYPEDoma Elemexits svc-Mype-d (PKC)
sve-type-desc
Entity:SHELFData Hulmas: loc-id (PlC) (FK)
2-16
Entity: SINGLY-MNGD-EQUIPDataElements: org-id (PK) (FK)
mat-cat-urn-id (PK) (FK)
Entity: SINGLY-MNGD-MAT-EQT-ITMData Elements: singly-mngd-znat-cqt-itm (PK)
equip-condition-status-cd (FK)uza-id (FK)maint-org-id (FK)contract-no (FK)smei-priority-cdindex-notech-lit-indicatoracquisition-dtdate-in-svcwarranty-exp-dt-partswarranty-exp-dt-laboracquisition-costsalvage-dollar-valuemaint-note-txorg-id (FK)mat-cat-itm-id (FK)bc-id (FK)holding-org-id (Kmodel-noserial-noservice-loc-id (EK)smei-sched-svc-base-dt
Entity: SINGLY-MNGD-WORK-ORDERData Elements: order-id (PK) (FK)
singly-mngd-mat-eqt-iuin (IFK)
Entity: SPECIAL-SERVICEData Elm-s svc-cat-itm-id (PK) (PlC)
Entity: STANDARD-FACILITY-FUNCTONAL-USEData Elements: bunctonal-category-ed (PK) (FK)
fic-std-category-cd (PKC) (PlC)
Entity: STANDARDS/CODE-DOCMIENTData Eleumnma: doe-no (PKC) (FK)
Entity:STATEData Elemuic: Icc-id (Pl)(K)
Enfti: STD-FAC (CRITERIA)Data Elemwn: fac-std-category-cd (PlC)
ft-ty (PlC)
2-17
Entity: STD)-FAC-STRUCTUREData Elements: parent-fac-std-category-cci (PK) (FK)
child-fac-szd-category-cd (PK) (FK)
Entity: STDFAC-EQTData Elements: fac-std-category-cd (PK) (FK)
sdl-fac-eqt-cd (PK)mat-vait-j-id (PK) (FK)
Entity: STD)-FAC-SYSData Elements: fac-std-category-cd (PK) (FK)
fac-sys-class-cd (PK) (FK)
Entity: STD-RMData Elements: fac-std-category-cd (PK) (FK)
nwise-lvl
Entity: STERILE-PACKData Elements: uzerile-pk-id (PK)
Entity: STRUCTUREData Elements: fac-id (PK) (IFK)
Entity: SUBSTITUTE-CATALOG-1TMData Elements: primice-aret-rnat-cat-itmi-id (PK) (FK)
sub-child-mat-ait-ju-id (PK) (FK)- uubprime-ratio
Entity: SUITEData Elements: fac-id (PK) 9;K)
Entity: SUPPLY-MATERIELData Elements: org-id (PK) (FK)
anut-cat-u-id (PK) (FK)safety-lvl-qteoq-lvIreqmt-odq~wpe-e-qtywrnmqwended-qty
rqurpf-ty-cw-haWconsunv~tion-qty-jancowmupinyo-qz-feb
wmmWuon-qty-apr
ca mpioyqty-jun
2-18
Entity: SUPPLY-MATERIEL (cont'd)D=t Elements: consuznption-qlty-jul
consumption-qty-augconsumption-qty-sepconsunq~don-qty-Wcconsumption-qty-novconsumption-qty-decdated-itm-fiaginventory-freeze-flag
Emtily: SURFACE-CATData Elements: surf-cat-id (PK)
Emtity: TA-MAT-RQMTData Elements: mat-cat-iun-id (PK) (FK)
doc-no (PK) (FK)
Entity: TASKDatm Elements: programn-id (PK) (FK)
project-id (PK) (FK)task-id (PK)
Entity- TASK-STRUCTUREDama Elements: paren-program-id (PK) (FK)
child-program-id (PK) (FK)parent-project-id (PK) (FK)parent-task-id (PK) (FK)child-project-id (PK) (FK)child-task-id (PK) (FK)
Entity: TBL-OF-ALLOWData Elements: doc-no (PK) (FK)
ta-no (MUI)
Entity: TRACKED-END-ITEMData Elements: mat-cat-jun-id (PK) (FK)
end-item-code
p EIiemma: UA-STRUCTURE,Data Eemwo: puent-ua-id (PK) (PlC)
child-ua-id M(PlC)crilticality-flag
2-19
Entity: UA-SUPPLY-MATERIELData Elements: ua-id (PK) (FK)
org-id (PKC) (FK)mat-cait-m-id (PKC) (FK)ua-swpplyw=a-qty--on-handua-supp-mat-qty-requiredua-supp-mat-qty-auth
Entity: UA-TYPEData Elements: ua-vers-cd (PK) (FK)
mat-cat-ium-id (PKC) (PlC)doc-no (PlC)
Entity: UA-TYPE-MAT-RBQMTData Elements: ua-mat-ca-itmn-id (PKC) (FK)
ua-vers-cd (PKC) (FK)reqd-ua-mnat-ca-itm-id (PKC) (FK)ua-znir-qty-reqd
Entity: UA-TYPE-STRUCTUREData Elements: parent-ua-vers-cd (PKC) (FK)
child-ua-vers-cd (PK) (IFK)parent-ua-vype-mat-cat-itm-id (PKC) (FK)cbild-ua-tyexna-cat-witin-id (PKC) (FK)ua-type-ua-qty
Entity: UA-VERSIONData Elements: ua-vers-cd (PK)
orig-fy
Entity: UNDATED-SUPPLY-MATData Elements: org-id (PKC) (FK)
mat-cait-j-id (PK) (FK)
Entity: UNIT-ASSEMBLAGEData Elements: ua-id (PKC)
ua-vers-cd (FK) (AKO1mat-ca-inn-id (JFK) (AKO1org-id (FK) (AKI)ua-seq-no (AKI)
F~dty:UNIT-TYPEDaft Elements: unit-Mvpcd (PK)
unit-ype-desc
Elar. UTIL-OUTLETDaoa Elmainco: fac-std-category-cd (l)(K
watet-type-cd (FK)util-outle~t-yj _ __ __ __ 2-20
Entity: UTILIZATION-CATEGORYData Elements: utiI-ca-cc (PK)
utd-cat-desc
Entity- VENDORData Elements: org-id (PK) (FK)
min-order-dollar-valuecage-cd
Entity: VENDOR-TERMData Elements: org-id (PK) (FK)
mat-cit-nm-id (PK) (FK)min-order-qtymax-order-qtyvendor-itm-cost-dollar-valvendor-itin-nomenclaturevendor-jtn-no
Entity: WIRED-COMM-LNKDaaElements: communication-link-id (PKC) (FK)
DntaiEemy ts WIRELESS-COMM-LNKDataElemnts: communication-link-id (PKC) (FK)
Entity: WORK-ORDERData Elements: order-id (PK) (FK)
rcvd-by-person-id (FK)order-receipt-dtorder-start-dtorig-action-cdcompletion-dtclosed-by-tech-person-id (FK)work-order-type-cd
Entity: WORK-ORDER-TECHData Elenmes: order-id (PK) (FK)
person-id (PKC) (FK)
Entity: WORK-SPACEDama Elements: tic-id MPK (FK)
Entity: WRM-FUND-ACCTData Efuiwits: program-id (IPl) (PlC)
fund-acct-id (PlO(K)miu-rmfundcrutd-wrm-mdobig-wmn-fundwrmflDo-amt
2-21
Entity: W#RM-PROG-MATERJELData Elements: org-id (PK) (FK)
mat-cat-itmn-id (PK) (FK)program-id (PK) (FK),doc-no (FK)wrm-auth-qtyWrm-on-hand-qtydue-in-wrmi-qtyWrm1-critical-itin-cdwrm-deferred-procurement-cdwrni-auth-doc-no/optional
Entity: WRM-PROGRAMData Eleames: programn-id (PK) (FK)
wrm-prog-type-cd (FK)wrm-prog-id (AK 1)assigned-org-id (FK)loc-id (FK)
Entity: wRm-PROGRAM-TYPEData Elemns wrm-prog-type-cd (PK)
wrm-prog-type-desc
Entity: WrRM-SMEIData EPlemunts: singly-mngd-rnat-eqt-itmn (PK) (FK)
org-id (FK)mat-cat-itm-id (FK)
prga-id (FK)
j 2-22
Section 3Entity Definitions
ACCOUNTABULTY-CATEGORY
The type of accountability required for the materiel: 'N' for non-expendable, 'D' for durable,and 'X' for expendable materials.
ACQUISITION-ADVICE-CATEGORY
Indicates how and under what restrictions an item will be acquired (DLA Customer AssistanceHandbook).
ADDRESS
A specific location of an individual, organization, or property such as a street address or apost office box.
r ASSIGNED-SMEI
Singly managed equipment item assigned to a specific customer for use and accountability.
AUTH-DOC
Document authorizing materiel to a specific organization that is mission driven.
BIN
An individual compartment or subdivision of a storage unit for less than bulk quantity.
BUILDING
A single physical structure, that supports a function or functions, that consists of rooms,
spaces, and building systems.
BUYER-VENDOR-CONSTRAINT
The terms and/or conditions between vendors and the government for agreements.
CABINET
A strage unit that can be comprised of bins, shelves, and drawers.
CALIBRATION
The systematic check and adjustment of a quantitative measuring instrument to a knownstandard in accordance with the manufacturer's specification.
11 3-1
CAMPUS
A set of geograpiiically co-located but unconnected iuildings or complexes.
MIY
A municipality with definite boundaries.
COMMUNICATION-LINK
Identifies devices used to transmit voice or data across LANs, telephone lines or satellites.Includes bulletin boards, datafax, telephones (e.g., mobile and cellular), radios, pagers,security systems, access codes, and personal identification machines.
COMMUNICATION-OUTLET
A subtype of utility outlet that provides communication services to a facility.
CONTRACT
Legally binding agreement between the U.S. Government and a vendor for a specific serviceor item for a stated amount.
CONTRACT-PERSON-ROLE
The role of a person with respect to a contract.
COST-CTR
An identifier for an organization for which costs are accumulated for expense reporting.
COUNTRY
The territory of a nation or state.
DATED-LOT
A grouping of items that has a specific manufacture date or expiration potency date thatindicates when an item is to be suspended or destroyed.
DATED-SUPPLY.LOC
Identifies the location of supply items which have a potency expiration date.
DATED-SUPIPLY-MAT
A classification of supply items that has a definite potency period.
3-2
I
DELIVERY-SERVICE
A type of service that engages the time and effort of a contractor to perform a specific task toproduce a deliverable product as required by the buyer.
DBOF-FUND-ACCT
The categorization of funds which are administered as a part of the Defense BusinessOperations Fund.
DISBLJRMG-STN
A DoD organization that has been granted authority to disburse government funds.
DOCUMNTW
A specification or standard used to develop medical systems.
DOD-ORG
j An organization that is a part of the DoD.
ELEC,4UTLE
A fixed receptacle at the user level for the delivery of electricity.
EQUIP-AVAIL-RSN
The reason equipment is available, deadlined, dispatched, or on loan.
EQUIP-AVAI,-TYfl
Determination whether an equipment item is available.
EQUIP-COND-STAIUS
A code indicating condition status of equipment.
EQUIP-ITEM-STATUS
The operational status of an equipment item.
EQUIP-MAT-ASSIGNMENT
Assigmenem of equipment materiel to an authorized organization.
EQUIP-SYS-OMPOSMTION-HSTOWRY
The co.piation of an equipment system's history.
3-3
EQUIP-SYS-rrEM
A singly managed equipment item that is part of an equipment system.
EQUIP-SYS-ATUS
Tbe opernional status of an equipment system.
EQUIP-SYSTEM-WORK-ORDER
Work order for a specific equipment system.
EQUIPMENT-MATERIEL
Equipmem materiel required to accomplish an organization's mission.
EQUU? ENT-SYSrEM
Individual equipment items that when utilized together perform a function.
EQUIPMENT-SYSTEM-MATEREEL
Individual equipment items collectively utilized.
EXTERNAL-NETWORK
Real improvements to facilities that occur outside the five-feet line (i.e., utilities, roads,pipelines, and communication networks),
FAC-ORG
Relationship that organizations have with facilities (e.g., own, maintain, occupy, and use).
FAC-ORG-RSN
Term used to explain the relationship between an organization and a facility.
FAC-SrIM
Description of the physical location of a facility.
FAC-STRUCTUR
Hiarchy of facilities and how they relate to acuh other.
FAC-TYPE
Gerund dlssification of use designated for a facility.
3-4
FACIITrY
A physical real property entity consisting of spaces, rooms, buildings, structures, utilitysystem, or other items of real improvement, each of which may be subject to separatereporting and recording.
FACILITY-COMPLEX
A collection (i.e., more than one) of facilities either contiguous or not linked by function,name, caegory or association with an organization or mission.
FACILITY-FUNCTION
A set of prescribed, organizationally related missions that are performed at a facility.Analogous to deparmnent and service.
FACELITY-ORDER-LINE
Description in the mechanism (e.g., agreement, contract, work order, job order, or othermeans) that allows for support of facility needs.
FACIITY-PROJECT
A plan, proposal, design, specification or scheme for an unbuilt facility.
FACILITY-PROJECT-FUNDING
Data about de source of money (i.e., financial resource) to accomplish a facility projectincluding planning and construction.
FAcILITY-STANDARD
Applied functional and facility system criteria (i.e., Industry or Government rules, laws,codes, criteria, and designs) that is specific to a given facility.
FACIU -SYSTEM
Facility couponens or subsystems combined to make a building or complex. Componentssuch as structure, sewage, water, electrical, telephone, LANs, and other conmumicationSystem.
SFACEL-YSYSTIM-43ASS
The classification of acili types (i.e., structurl, architectural, HVAC. plumbing, electrical,a andtio).
FACEATM4YMV-CL4ASS-STRUTURE
wThe relatlo ip of facility rystem clanes to another.
3-5
FACELTY-SYSTEM-STRUCTURE
The relationship of a facility system to another.
FACIITY-TYPE
Classification of facility types.
FACILITY-UTILIZATJON
Factors or measurements which define the capacity of workload, or resource consumption of agiven facility.
FEDERAL-ORGANIZATION
An activity belonging to the government.
FUNCTIONALCATEGORY
A method of identifying discreet functional subdivisions of facilities to include departments,cost centers, and clinics.
FUNCTIONAL-UTILIZATION
Data that describes the inherent capability or capacity of a given facility when matched againstpersonnel, monetary resources, and facility organizational mission.
FUND-ACCT-NON-PROGRAM
A categorization of fund account not assigned to a specific program.
FUND-ACCT-ORG-ROLE
The type of relationship between a fund account and an organization, including, but notlimited to, issuer, accounting organization, payee, holder, or performer.
FUND-ACCT-PROGRAM
A categorization of fund account that is assigned to a program.
FUND-ACCT-SFRUCT
The relaomwhip of on instan of a fund account to another.
FIJND-ACCT-TYfl
Identifies the type of fund accou•ts available (e.g., program or non-program).
3-6
FUND-ACCOUNT
The unique value and identification that represents the source of payment for an order line.
FUND-ACCOUNT-ORG
The between a fund ac•count and an organization.
FUND-ALLOCATION
Funds that have been identified for a specific purpose.
FUND-TYPE
The classification of fund accounts to include Operations and Maintenance (OMA), OtherProcurement Authority (OPA), Research and Development, Training and Education (RDT&E)and Defense Business Operations Fund (DBOF).
GAS-OUTLET
A fixed supply at user level for medical gasses.
GENEMC-EQUIPMENT-CLASS
Assigned to a specific name (i.e., generic nomenclature) of an item which is not consumed ordestroyed when used. (CDA Pamphlet No.18-1)
GEOLOCATION
Geographical location in the world where an organization is physically positioned.
GROUP-MNGD-EQUIP-LOC
The maintenance location assignment made for equipment items deemed not maintenancesignificant for a particular customer.
GROUP-MNGD-EQUIP-WORK-ORDER
A work order for a group managed equipment.
GROUP-MNGD-EQUIPMENT
ibase i•em of materiel both medical and mn-medical, which are managed collectively a a•. growp.
GROUP-MGD-UNDATEDMAT-SUPPLY-LOC
Identifies th location of supply lheam which do not have a potency e4paoo daue.
3-7
IMPROVED-LAND
Any Govermuent owned or leased real estate parcel witb real improvements to include utilitysysesm, infrastructure, roads, and buildings.
INDIPVU•AL
A human being of interest to the MHSS. This includes workers (e.g., military, civilian,comror, and volunteer), patients, beneficiaries, and representatives of suppliers, vendors,and facturs.
INDVIDUALCOMM-LINK-REASON
Tam used to identify and explain the need for an individual to have a telephone or othercommunication linI.
INDIVIDUAL-COMM-LINK-USAGE
An kidutifier that links an individual with a telephone.
INDIVIDUAL-LOCATION
A place used or occupied by an assigned individual.
NIVIDUALMLOCATION-REASON
Ta'm used to explain the location of an individual.
INDIVIDUAL-ROLE
Cmegory or classification of an individual as defined and/or assigned by an organization.
INDIVIDUAL-ROLE-REASON
Tam used to classify the relationship of an individual to an organization.
INDIVIDUAL-SUCTLE
Mirelatiomhip of an individual to other individuals (e.g., patient, doctor, and custodian).
OWCTON-TASK
Th. specific tk required to maintain the serviceability of supplies (i.e., check for
S~INgrTAIJTM(
CkGJ= dmasfkajo of nml propeny umed, owned, leased, or occupied by the Govenmemnta includes raw, improved, and semi-improved land.
34
INSTALLATION-STUCTURE
Relationships between installations or groups of facilities that comiprisc an installation.
INSTALLED-EQT
Items of equipment and/or subcomponents that when installed in a facility become realpsoperty. Generally there are two subtypes, non-medical installed equipment (i.e., boilers,HVAC, sinks, and cabinetry) and medical installed equipment.
LOCATION
A specific physical place or position that is used as a point of reference.
LOCATION-ASSIGNN0ET
ideuifim a specific location with a specific organization.
lOCATION-STUCTURE
Met entity that shows the relationship of locations to other locations.
LOT
A specific batch of a specific item as identified by the manufacturer.
LOT-Ml)4U ATED-SUPPLY-MAT-LOC
Te locmation of a supply item managed by manufactured lot number.
MAIN ANCE.SGNIRCANT-ITEM
Materiel requiring scheduled/unscheduled service and history.
MANAGED-MAT-REPORTING-REQT
MI gd materiel items that must be reported because of specific authorizatiots or needs.
MANAGED-MA WEITE
Ibmu that require specific managemet methods because of authorizations or oeeds.
f MANUFACIURER
An A ganmimjo dut makes hims from raw materials.
3-
I{
MATERIL-CATALOG-ITEM
A catalog of materiel which is potentially available for acquisition, including ships, tanks,self-propelled weapons, aircraft, etc., and related spares, repair parts, and support equipment,but excluding real property, installations, and utilities necessary to equip, operate, maintain,and sup•ort military activities without distinction as to their application for administrative orcombat purposes (QCS PubI-02 1989). Includes medical surgical supplies, drugs, medicalequipment, food, and items required for the provision of health care/medical related items.
MATERXLCATALOG-TM-MANUFAC
Identifies the manufacturer of items in the materiel catalog.
MATERIEL-DEVICE
A particular family of devices identified by a five character alphanumeric code.
MATERIEL-DEVICE-CLASS
A medical industry standard that generically identifies medical materiel groupings (child ofMateriel Device).
MATERIELDEVICE-SVC-TASK
A service task performed against medical materiel groupings.
MATERIEL-INSEC"1TON-TASK
The connection of inspection tasks to a specific materiel item.
MATEREL-ITUCTURE
A relatiomhip of one instance of materiel to another.
MATEREEL-TUCTURE-REASON
"TUe specific explanation for a given materiel to materiel relationship (e.g., substitutioi ofitems, and identifyi parts to equipment).
MATrERIEL,.ORtDE4JNE
An order le for nmaeriel.
NON-DOF-FUNVACC
A cateoll of fuwding accoums that are not a part of the DBOF.
NO-4PERS-O/S4.O ER4LN
An order line for a unopersonal service that could not be accomplished In-house.
3-10
OBJECT-CLASS
A DoD identifier for a type of expenditure.
ORDER
A request for goods, services, labor, or other requirements. To reiae specific actions takenin support of the mission to planned actions and to capture financial terms ;-verning thoseactions taken-
ORDER-IUNE
A distinguishable part of an order and its associated funding. To delineate performance ofmission elements, use of funds, and support entitlement determination and performance.
ORDER-LINE-FUND.ACCT
The relationship between an order line and a fund account.
"ORDER-LNE-STRUCTURE
The relationship between occurrences of an order line.
ORDER-STRUCTERE
The relationship between occurrences of an order.
ORDER-TYPE
Classification of order to include service, contracts, equipment authorization request, facility,MILSTRIP, and local purchase orders.
ORG-ORDER
The relationship between an organization and an order.
ORG-ORDER-ROLE
The function performed on an order by an organization to include initiating, administering,perfonrins, conacting, paying.
ORG-UA-TYPE
A unit ausmublage type for which an organization is accountable.
ORGANIZATION
An dm sai or functional busins sructure or body of perso stablished for a
Particular pupose. (ICS Pub 1)
3-11
ORGANIZATION-CATEGORY
The classification of the types of organization,
ORGANIZATION-COMM-LINK-REASON
The rationale for an organization to use communication devices.
ORGANIZATION-COMM-LINK-USAGE
Categorizes the way in which the organization uses a telephone line (e.g., FAX, modem, andvoice).
ORGANIZATION-FUNCTION
Respective roles or roles (i.e., missions) that dictate functions to provide a service, or
perform a mission, that may require space to accomplish.
ORGANIZATION-LOCATION-REASON
Identifies the purpose of an organization having a specific location.
ORGANIZATION-MATERIEL
The association between an organization and a materiel catalog item for which theorganization is accountable.
ORGANIZATION-STRUCTURE
The relationship between one organization and another.
ORGANIZATION-SMUCTURE-RSN
Rationale or justification for the relationships between organizations.
ORGANIZATIONAL-RVICE
A function performed by an organization in admiustering a service.
OUT-SOURCF-SVC-ORDIER-LN
A service order line that is being performed by an agency tha is not a part of the logisticsOfamnizrja
OUTLCr-TYn-CATEGORY
amificat of typ of utility services provided in faciliies.
3-12
PENDING-DISPOSITION
A tur -in equipment materiel item awaiing reassignment or disposal.
PENDING-ISSUE
A. materife equipment ite-m awaiting ,i'tse to a customer for use and accountability.
PERFORMANCE-SERVICE
A type of service that engages the time and effort of a contractor who works under the directsupervision of the government.
PERS-SVC-O -ORDER-LN
A specific type of order line where the person performing the service is treated as anemployee of the receiving organization.
POSTAL-ZONE
A geographic area designed for the purprse of delivering mail.
PREVENTIVE-MAINTANCE
Systematic and/or prescribed maintenance intended to reduce the probability of failure. (JCSPubl)
PROGRAM
A planed mission to provide logistics support for the accomplishment of an assigned task.May inlude deployable hospitals, fixed contingency hospitals, or hospital expansion.
PROGRAM-UIRUCTURE
"the relationship between one occurrence of a program and another.
PROJECT
A plaumd underaking of something to be accomplished, produced, or constructed, having afinite beginnng and ending.
PROJECT41TRUCflJRE
l1e rdag whip between ow occurrence of a project and another.
RAW-LAND
Reald ate owned by the Governmen that contains no improvement (i.e.. is in a natuil
3-13
REPAIR
The restorationi of an item to serviceable conditioi through correction of a specific failure orunserviceable condition. (JCS Publ)
ROOM
A discrete physical entity within a facility or building that occupies physical space.
ROOM-SURFACE
Description of the physical attributes of the walls, floor and ceiling of the interior of afacility.
SAFETY-INSPECTON
Inspection of a piece of equipment materiel to ensure both operator and patient safety.
SCHEDULED/UNSCHEDULED-CATEGORY
The two possible types of maintenance provided: scheduled or unscheduled.
SERVICE-CATALOG-ITEM
An availabie performance or delivery service.
SERVICE-CATEGORY
A categorization of the types of methods for procuring a service. Services are procured eitheras performince services or delivery services.
SERVICE-ORD LINE
An order line for the procurement of a service.
SERVICE-SF'AUCTURE
The rdadomuip between service catalog items.
SERVICE-TASK
A catalog of tasks that cam be completed on a supply materiel.
mVICE-TYM
A caOf services tam can be performed.
A type of woa• IL.
3-14
SINGLY-MNGD-EQUIP
An association between an o:ganization and a materiel catalog e-quipment item that anorganization chooses to manage individually.
SINGLY-MNGD-MAT-EQT-ITM
A specific Rem of org'nization equipment that is managed individually.
SINGLY MNGD-WORK-ORDER
A work oider for a specific singly managed materiel item.
SPECAL-SVICE
A type of service not covered under calibration, preventive maintenance, safety or repairincluding, but not limited to site surveys, acceptance inspections, staff assistance visits andin-service taining.
STANDARD-FACELITY-FUNCTIONAL-USE
Standard classification of the utilization of resources in a facility (i.e., time, space, money,and people) based on criteria.
STANDARDS/CODE-DOCUMEqT
Generally acknowledged and published industrial measures or criteria used in comparingqualitative or quantitative values.
STATE
Autonomous territorial entity and/or political units composing a federation under a sovereign'overm-I.
STD-FAC
The facility specific or applied information, standards, codes and rules that provide thefraimewok for refining the physical and functional attributes for a facility.
STD-FACIQUUWNMT
The specific or applied information, standards, codes and rules that provide the frmnework forrefining dke physical and finctional attributes for facility equipment.
STD-FAC STUR
The relationship of building or facility system to each other.
I 3-15
STD-FAC-SYSTEMS
The information, standards, codes and rules that provide the framework for refining thephysical and functional attributes for facility systems.
SID-ROOM
An ideal representation of a functional space or room that depicts satisfaction of functionaland physical needs.
STERILE-PACK
A collection of materiel catalog items that are packed to use for a particular procedure.
STRUCTURE
A non-occupied facility type, such as a transformer, power plant, bridge, fence, road, watertank, or other real improvement, that is part of an installations' infrastructure.
ST ITi Z, IATALOG-ITM
An item that may be used in place of another catalog item.
SUITE
An assembly of spaces or room facilities that is organized to perform a specific function.
SUPPLY-MATERIEL
The association between an organization and a materiel catalog supply item for which theorganization is accountable.
SURFACE-CATEGORY
Classification of types of surfaces (e.g., walls, ceilings, floors, and windowalls).
TA.MAT-RQMr
A unique materiel catalog item required on a table of allowance.
TASK
A discreet piece of work performed as part of a project.
TASK-STRUCTURE
The rationship between project tasks.
3-16
TBL-OF-ALLOW
A doumnt outlining authorizations for an organiztion.
TRACKED-END-ITEM
A type of equipment for which repair parts usage is captured (through the use of an End ItemCode (EIC)).
UA-STRUCTURE
The relationship between occurrences of unit assemblage.
UA-SUPPLY-MATERUEL
Materiel used for unit assemblages.
UA-TYPE
A type of unit assemblage (e.g., J-D301 and M-D307).
UA-TYPE-MAT-REQM1T
A materiel catalog item required for a unit assemblage type.
UA-TYFE-SMUCTURE
The relationship between one occurrence of a UA-TYPE and another.
UA-VERSION
A particular version of a unit assemblage type (i.e., "data base").
UNDATED-SUPPLY-MAT
A type of supply materiel which is not labeled with its expiration date. However, its shelflife may be derived from date of manufacturer and the shelf life code listed in the materielCatalog.
UNIT-ASSENUIAGE
A collection of materiel catalog items that have been assigned to an organization toaccomplish an assigned mission.
UNfT-TYMR
A code to determine contingency identities for an organization.
j 3-17
IUIITY-OUTLET
Terminus of utility services (e.g., communications, electrical, plumnbiiig, medical gasses, andHVAC) in rooms, spaces, or other facilities.
UTILIZATION-CATEGORY
A classification of use related to both function and space in a facility. Such classification isusually identified with a utilization code.
VENDOR
A business entity that sells goods and services to the government. The entity can be amanufacturer or distributor.
VENDOR-TERM
Tbe t dictated by a vendor for a specific item.
WIRED-COMM-LINK
Coumunication link established through wired building or facility system including data,voice, LAN, nurse-call, and network.
WIRELESS-COMM-ULNK
C on .u ions link established or provided by radio, microwave, satellite, cellular, or othernon-wired mechanism.
,, 3RK-ORDER
A type of an order for service on equipment.
WORK-ORDER-TECH
The uniqte identifier of a technician assigned to a work order.
WORK-SPACE
A discreet facility type either unconfined or within another space, room, or building where afunction is accammdate.
WRM-FUND-ACI•C
A categry of funds with the specific purpose of procuring war reserve materiel.
WRM-PROG-MATERIEL
Stock reserved .. contirjencies.
3-18
I
WRM-PROG-TYPE
The purpose for contingency meriel.
WRM-PROGRAM
A contingency mission for which stock is maintained.
WRM-SMEI
A singly managed materiel item assigned to a specific war ready materiel program.
I
1 3..19
This Page Intentionally Left Blank
I 3-2o
Section 4Attribute Definitions
aocouotahlfty-eattegry-cd
accowitabity aegory code
An identifier that determines the level of accountability that is required for a catalog item.
accomodabilty-category-desci accowubiky category dacricpton
The description of the accountability category.
accwubil~yorgwuiwsonal identifi~er
The unique identifier of the organization that is responsible for accoumntg for an item.
acquiston..dvice-eacquiitonoadvice code
A one character alpha field which indicates how and under what restrictions an item will beacquired. Valid characters include A, D, L, Y, V, and others.
acqaulsio adice describpon
A description of the acquisition advice.
acqWsaon cost
The cost of the singly managed equipment item at the time of acquisition.
dacidsidoui doe
The date an individual item was procured.
advice coe
An infomzatlon code provided to the suply source on the management of an order line (e.g.,"02CO indicates do not back order).
4Ii4 1
assigned-org-d
assigned organization identifier
Identifies the organization identifier where a WRM project is assigned.
auth-doc-.audworiwdat dearuem nwmber
The identifier of the document which authorizes an equipment item.
auth4rmudauthorizedpfmd
13= dollar amount of funds that have been approved for use.
auth-rg-idauthorized organizaion identifier
The identifier of the organization for which the authorization was approved.
authorized wrm quantity
The quantity of a war reserve item that is required to support the assigned mission.
adwiauthorization sow=e
The source for an organization requesting equipment (e.g., TOE, TOD, and Table ofAllowanw).
avhoiramd-qomdtauthorized qumtty
The quantity of equipment that has been authorized from a particular authorization source.
bu*g pared wganization iden••fier
Identifies die organization identity of the buyer.
cage code
An identifier that is assigned by the DLA to uniquely identify vendors, manufacturers, andOter Sovauumn Ageuces.
4.2
calendar cycle mouths
Prescribed number of months between scheduled calibration services on an equipment item.
ch~d-ua-ld.ua-dchild unit assemblage idenmfler.unit assemblage identfier
Unique identifier of a unit assemblage contained by another unit assemblage.
ciy name
City name.
in-Iiuik.4dcommunication link identifer
A unique identifier for a comnmunication vehicle.
completion date
The date a work order is completed.
compowdmt •nd
cwmponen service end date
The date a component is removed from the system.i •mDpmuft..4YCltat-dt
cononent service start date
The dae a component is placed in the system.
committed wrmfiud
Funds that have had order lines placed against them and have a contract that has not beencomplete.
Common status Cde
The unique code identifynig condition smaus of equipment.
conudition status desciption
I A descripive nam identifying the condition status of equipinem.
1 4-3
~1
condltlon-status-cdrondition status code
Identifies the operational status of an individual item of equipment.
cmm~ption-qty-aprconsumption quantity april
The quantity of an individual supply item that has been recorded as a recurring issue duringthe month of April.
consumption quantity august
The quantity of an individual supply item that has been recorded as a recurring issue duringthe month of August.
eomunsption-qty-decconsunpton quantity december
The quantity of an individual supply item that has been recorded as a recurring issue duringthe month of December.
emuumpdon-qty-febconsumplion quantityfebruary
The quantity of an individual supply item that has been recorded as a tecurring issue duringthe month of February.
eeosumptiou-qty-janconsumption quantity january
The quantity of an individual supply item that has been recorded as a recurring issue duringthe month of January.
em3Dmpaofrqty-julconmpiWon quawtyjuly
The quantity of an individual supply item that has been recorded as a recurring isse duringthe month of July.
a-InPdan-y-JimwnWL pon qmwui*tyj
T'e quantity of an individual supply item that has been recorded as a recurring issue duringthe manh Of June.
4-4
consuWnyk quanuty mxarch
.e quantity of an individual supply item that has been recorded as a recurring issue duringthe Month Of March.
wpdo.-qty-suayvonswnnlion QUWaity may
The quantity of an individual supply item that has been recorded as a recurring issue duringthe month of May.
conswIIMd=U quantity november
The quantity of an individual supply item that has been recorded as a recurring issue duringthe mouth of November.
consispsion quantity october
The quantity of an individual supply item that has been recorded as a recurring issue duringthe month of October.
cmmmpdmquantifymty m
Mwe quantity of an individual supply item that has been recorded as a recurring issue duringthe month of September.
contract nwnber
A unique identifier for a contract.
contrac person role code
A code idantifying the role of the contract person.
contract person role daaci~ptox
"Ii,. description of the role of the contract person
contrac strt daft
The dat the contract takes effect.
4-3
I -
enuiract dm..PffWo
The length of the contract.
"conUcT 1'w description
The description of the type of contract.
cmotl organization idenifier
The identification of the organization that controls the operation of the In-Use Equipmentaccount (e.g., Army - Property Book, Air Force - Medical Equipment Management Office(MEMO)).
cud-wf4dcost center identification
A unique identifier of an organization that can transact business with the logistics operation.
coWmy awne
Coanry name.
crithe14t-cd
CriticOl itlen code
Identifies equipment items that are mission essential to the organization.
ahdcility4qacttaakliayflag
Idemifiles whether or not a unit assemblage is critical to the mission of the unit assemblagewhich contains it.
aommalative.-4ivetme-ratioaundazhv' inunient ratio
The percetage of the acquisition cost that may be expensed against a maintenance significantitm during its fif.
Car mt-EM40-Wewref man iam qu- -niy
The quantity of an individual supply item tat has been recorded as a recurring issue duringthe cumen mnmth.
4-6
daily-doliar-val-max-per-ttmdaly d4,tar value maximum per item
The maximum dollar amount that may be ordered against a supply materiel item in a givenday from a given vendor.
dally-doilar-vai-mnax-ot
daily doUar vlue maximwu total
The maximum dollar amount that may be ordered against all supply materiel items in a givenday from a given vendor.
dabeeqwded-deydate - -ey
The date that the ordered items are expected to be delivered.
date in sernce
j The date an equipment materiel item was placed in use by the maintenance facility.
dateditem-cd
Identifies whether a materiel catalog item has an expiration date and, if it does, whether ornot that expiration date can be extended.
dated-st=*-codedated item code
Identifies whether a materiel catalog item has a potency period and, if so, whether or not thatpotency period can be extended.
demand-cddemad code
A code in the order line which signifies whether the demand for the item is recurring or non-
"Aftdafroy flag
Identifies if a particular lot of an item is to be destroyed.
doe-"v
A unique identifier for documents containing standards.I'4-_
docnuut-id-cd
doawNIO kdm er code
A code that identifies a specific order line to its intended purpose or usage.
dscmaNeut-nodocument number
A unique identifier for a specific order line.
dod-proJ..M (opdoul)deparnmet of defense project number
Identifier in the order line for a DoD project.
disbursing uation
A unique identifier for a disbursing station.
dt4-last.4nvdate As innvenmoied
The last time organizational materiel was formally inventoried so that the next inventory cyclecan be acurately calculated.
dtisn-ddate thne code
The code identifying the date and time of equipment item status.
due in *wm quanmiy
The quantity of WRM items due-in for a specific WRM Project.
ead-devica, cd
Sen dewce code
A five position code developed by ECRI, Inc. that groups medical devices into generic
Te genetic nomeclamcb associated with an ecri-device-cd.
4-8
dedc owle• te code
A unique code for the type of electrical outlet.
end &orn code
A unique identifier for major items of equipment that are made up of several components(i.e., x-ray systems).
econmic order qwmiy level
The quantity of a supply item required during an economic period that is a part of the stockcontrdl level.
equip-avail-muequipment availability reason
The reason equipment is available, deadlined, dispatched, or on loan.
equ4pment-avWziaiiy code
A odle dot indicates the reason equipment is available.
aepip-vm aequipment availability reason description
The description of the reason equipment is available.
Sapdq va8-4ypeequiont avadbility type
Determination whether an equipment item is available or not.
-pnw -v~t toe code
A code that identfies the type of equipment available.
eqajwpm aWzilab dncripdoa
"be dripsion of the type of equ#ipm available.
!4
equipment condition code
The code used to describe the operational condition of equipment.
equipment condition item status code
A code indicating the condition status of equipment.
The operational status of an equipment item.
eqip4-t u s-m &-dm-dequipment item saatus date time code
A code that identifies the status of an equipment item on a certain date and time.
equip-ma&.-caftoryequpment maintenance category
The source of maintenance effort on an equipment item.
equip-mo-essigmmutequipment materiel assignment
The assignment of equipment materiel to an authorized organization.
equp4yux-=poston-uhstw7ryequipment system composition history
The comilation of all history on an equipment system.
equip"*4--tequipment system identification
The unique identification of an equipment system.
eqtd• y4k
A sinl managed equipment item hti is pan of an equipment system.
equipmen Misen -rbrt co*e
A code that indicates the priority of an equipment system.
4-10
equipment system sdceduled service base date
The date from which scheduled service periods for an equipment system are computed.
equipm ys-tmt t
The operational status of an equipment system.
eqjp4ys-N.twd-& me-cdequipment system status date tme code
A code that identifies the status of an equipment system on a certain date and time.
equIp4ys-weequipmut system work order
Work order for a specific equipment system.
eqwpment O
qType Of equipment-
equipment maeriel item code
A unique code that identifies equipment materiel items.
,quipmmmt-,stme.aý elequpmet system materiel
Ifdividual equipment items collectively utilized.
eirxiram date
The Mietification of the year and month a particular lot of an item reaches its potency-tim date.
extauld m flag
An dicator that the expiration datepotency period of an item has been extended.
w--M
The unique identification of a fcility.
4-11
fac-std-categorv-cd
facility standcrd airegory code
The code for category of facility standards.
facWys-dass;-dfacility system classificahon code
A unique code that identifies the types of facility systems.
f•cfacility system dassificmwon descrprian
A description of the types of facilities.
fac-type-dfacility Oejp code
A code that identifies the designated use for a facility.
fac-type-namefacility type name
The descriptive name of a facility type.
fac-util-capactyfacility ualization capacity
The maximum utilization level for a function at a facility.
fac-util-woridoadfacility tailizuon workload
The currt•t workload level for a function at a facility.
faclity-rg-rmfacility organzmtion reason
Explains the relationship between an organization and a facility.
faixty-projecttAd4mmuntfaciliy project fumding amount
The amount of money used for the accomplishment of a facility project.
fadalty-SYstun-kfacility system &daiifW
A unique identifier for a facility system.
4-12
fed-gupply-dasm4dfederal supply cdass identifier
Separates federal materiel into generic classes (e.g., Class "6505" is drugs and Class "6520"is dental items).
FA -etfatgory-cd
fuc•ciona/-category code
A unique code that identifies a functional category.
m tionsal-•ategory-descfiuncional category description
A description of the unique identifier for a functional category.
fumd-acct-idfuid account idenifier
An unique identifier to differentiate specific fund accounts.
ftmd-ac ctd-org e-cdflmd-account orgaonizoaon role code
The unique identifier of a role between an organization and fund accounts.
hn-•W-rm-ae-namefuid-account organization role name
Descriptive name of the role an organization plays in fund accounts.
fmd-mcd-typve.flmd-cc u type code
The unique code that identifies the type of fund account.
-ind account type namwe
The descriptive name of a fund account type.
jud type aed
Classifies the kinds of funds.
fluid type nomenclatre
The descriptive noaw of te types of fimd type.
~j 14413
poup-mnnd.equiplocgroup managed equipment lotion
The maintenance location assignment made for equipment items deemed not maintenancesignificant for a paticular customer.
groupumngd-equipqtygroup managed eqwipment qua'aity
The quantity of a specific type of group managed equipment at a specific location.
group-m -udated-upply-at-itm-rep-qtygroup managed undated supply materiel item repair quantity
The quantity of a group managed undated supply materiel item that is unavailable for use untilit has been repaired.
roup-pirty-cdgroup priority code
A code to identify the priority of group managed equipment.
group sdedaded service base date
The date from which scheduled service periods for a group managed location are computed.
hisory begin date
The date that records when an organization materiel item began processing recurring issuedenands. It is used in the leveling process.
indu number
A unique identifier of a singly managed equipment item or equipment system assigned at theoganizational level.
ndhlvamdl-conm4ink-raosmindivda communication link reason
Explains why an individual is assigned a telephone or other communications device.
-didub mm4Ank-r-cdidividua fimunicatonlk remoc code
A code that idemtifies the reason why an individual is assigned a telephone.
j 4-14
Individual-com.-lnk-rsn-desc
indi a conmzusiaion link reason description
Describes the reason why an individual is assigned a telephone.
=didnalybenso -eindividual locario reason code
A code that identifies the reason an individual is assigned to a specific location.
iadi al locaton reason description
A description of why an individual is assigned to a specific location.
Inl•ulml4oeatlon-resonindividual locaion reason
Explains why an individual is assigned in a specific location.
ld~vdt W-or-riicdidWiidual organbaton reason code
A code that identifies the reason an individual is assigned to a specific organization.
indiwdaal organiradon reason description
A description of why an individual is assigned in a specific organization.
h~lridual-organzaio-ressoindividual organization reason
Explains why an individual is assigned in a specific organization.
- qde monds quantity
Idenifies the period in months when initial inspection for serviceability must be performed.
impecdOl Mk M~d e
Idenifies an inpection ask.
Desc•ibes a tsk for catalog itens to be inspected or reinspected for sericesbility.
I ~4-5
tnstallafion4d
installation identfier
Unique identifier for an installation.
bsued-yd-wWissued year to date amount
The dollar amount of funds that have been expended to date.
bibor-rste
labor rate
The rate charged for labor.
IaAtnvufty -datelast invmory date
The last time an equipment item was formally inventoried so that the next inventory cycie canbe accurately calculated.
iie-ttem-no
fin item number
Number assigned to a specific name of an item which is not consumed or destroyed whenused.
lec-Id
locaion idneifler
A unique identifier for a specific physical place or position that is used as a point ofreference.
Ioc-invem=toy-frem4faglocation invemnoryfreeze flag
An indicator that items at a specific location are currently being inventoried.
lot g u 4 4upo I
Jao managed zdwed smpply operating quantiy
The quanity of an operational lot managed undated supplies.
lot managed aundaed supply repairab/e quantity
DIe quantity of a repairable lot managed undated mpliea.
4-16
dated•p.sup-qty
Axt managed undated supply suspended quantity
The quantity of a suspended lot managed undated supplies.
lot managed undated supply materiel item repair quantity
The quantity of a group managed undated supply materiel item that is unavailable for use utilit has been repaired.
W-100Mo number
A unique identifier for an occurrence of a lot number.
local purchase surcharge rate
The local purchase surcharge rate for a DoD organization.
mmaint-cat-cdmaintenance ategory code
A unique identifier for a maintenance category.
xnat-cst-m-ldmateriel catalog item identfier
A mnique identifier for materiel catalog item.
matind e• z •materiel device service task
Catalog of tasks that can be completed during schedule services on a materiel device.
materiel nomendatue
A description of the characteristics of a catalog item.
Matede srucure reason CAe
A code wbich idemifies why one materiel itm is related to another.
mat e sruture reaon daiWm
A dmeciptin• of why one materiel item is related to another.
4-17
mm-arder-qty
maximum order quantify
The maximum quantity a vendor will sell on a specific order for a specific item.
media and status code
A code in the order line that is used in processing MILSTRIP orders.
nzaurated ldate
The date a specific lot of an item was manufactured.
mwioder-dUs.r-valueminimum order dollar value
The minimum dollar value a vendor will sell on a particular order.
minimum order quantity
The minimum quantity a vendor will sell on a specific order for a specific item.
=&-qty-nminimum quanti required
The mininum quantity required to meet table of allowance specifications.
mission idennfler
A unique identifier for each assigned mission.
=odd-ewmodd nmber
The mmfacturer's assigned identifier for a specific grouping of an equipment item.
nato dau cade
The part of the NSN that shows which NATO country manufacaurd, or is ordering a catalog
4-18
-ato dais descripton
The name of the NATO country that corresponds with the NATO Class code. For example,"(00" and "01" identify the United States.
nalse4Mlnoise lew
The specified noise level for a standard room.
.bjae-dt -a
objed dasgscation code
TMe unique identifier for a specific purpose for which money was provided.
bjuet-das-=umniobjeac dass&Jation name
h descriptive name of the object class code.
SAlk-wrni-kind
oblgated wrm find
Funds that have had order lines placed against them and a contract has been completed.
obigated yer so date due-omt amowu
The dollar amount of funds held in reserve for order lines when stock is not available.
Smo hand wrm quant4
Identifies the quantity on hand for a specific WRM Project and materiel catalog item.
&iwaatig amm athor~zed
IThIe dolar amount on a DBOF account that has been authorized for spending for a period oftime.
i "fTb. dollar amount on a DBOF account that has been reserved to fund order lines for which acanuac bas not been issued.
4j I 4-19
op-min-chtg
operating iunn obligated
The dollar amount on a DBOF account that has been ordered or received and was for agoveramnt activity or a contract that has been awarded.
op~due4n-qtyoperating due in quantty
Identifies quantities due-in for operating requirements. This quantity is derived from theindividual materiel order lines.
op.de.out-qtyoperating due owt qunity
Identifies quantities due-out for operating requirements. This quantity is derived from theindividual materiel order lines.
op-qtyoperating qinaudt
The demand driven quantity of a lot managed undated supply materiel item that is reservedfor use in operating the supply activity.
1op-ep"xaielftoperating reprabke quantity
Quantities of durable or equipment items that are unserviceable and are not available for issuewhile awaking repair.
operating sspended quantity
Quantities of a supply item that are unserviceable and not available for issue to customers.
operating quantity
An 1munmt of a specific item that is on hand for the day-to-day operation of a MedicalLoIsAi's operation.
era u tity on hand
The quantity of an organizaona materiel that is available for issue to umminer.
The Indca of an kem denoting whether it is operatioa or non operational.
4-20
it
opton-flagoption flag
Indicates whether or not the contract has option years.
order-idorder identifier
A data scheme for insuring that each order is uniquely identified.
order-line-doc-noorder line document nmnber
A unique identifier for an order line document.
rder4ine-f, md-,corder line fund account
The fund account required to pay for the goods and services being procured through theorder-line.
order4ine4dorder line identifier
A data scheme for insuring that each line of an order is uniquely identified.
order placement date
The date an order was placed.
ordr-reaeipt-dtorder receipt date
TIe date that an order is received.
ordw-tatt-k
order starr date
The date in which an order is started.
order we Code
Code that idenifies the type of order.
order jWe descrpi
ITh description of the order ty.
4-21
arg-omm-nku-m-e
organization communcation Unk reason code
The code that identifies the reason for telephones in the organization.
mlg-U s-rm-descorganization commwucation link reason description
The descriptive reason for telephones in the organization.
organization identifier
Uniquely identifies an organization.
organkation location reason code
Code that defines the reason for an organization's location.
organization location reason description
The description of the reason for organization's location.
=1-hcadon-remsorganrztion location reason
Explains why an orgardization is assigned to its location.
erg-mmaeorgamization w•e
Th descriptive name of an organization.
organizaton order line role idmnifier
Explains the role an organization plays with an order line.
orgaia•aim orde roe code
Identifies the role an organization has with order.
orsamdon wder rke mimwe
Name hat identifis the role of the organization related to an order.
4-22
org-tucue naorwgamatido s•t•rure reason
Identifies the reason one organization is related to another.
organization unit assemblage quantity authorized
T1e quantity of a unit assemblage type authorized for an organization.
W W.7t handorgaiiir ati unit assemblage quandty on hand
The quantity on-hand of a unit assemblage type for an organization.
wg-=--requthdorganizaton unit assemblage quantty required
The quantity of a unit assemblage type required by an organization.
orgdido imegory code
tA unique identifier for the organization category.
rgamatflo-caftgory-descanization category description
The description of an organizational category.
originating ac code
A code that identifies the originating type of order.
wfZtiqYflscu year.
The fiscal year that when combined with a version code, uniquely identifies a unit
A code that identifies the type of utility service.
A description of the type of utility service.
4-23
iiI'
Pj'at-iaa-d.uaidparent Wiit asr~emblage idennfier.amit assemblage identifier
Unique identifier of a unit assemblage which contains another unit assemblage.
part-Wpart munber
A unique vendor identification of a part.
A unique identifier for periods.
pownodperson idenifier
A unique identifier for individuals.
preventive maintenance cycle month
Prescribed number of months between scledmed preventive maintenance service on
puineVrI-mat-cat-iten-idprime parent materel catalog item identifier
An identifier for prime items which have a substitute in the catalog.
prograzm identifier
An identifier for different programs.
projed4dproject identiflaion
A unique identifier for a specific project.
qty
The quantity ot a group managed item in a specific location.
qty-=&qundty aw•Soniad
Mae quaity of an equipment item that ha been authorized.
4-24
=I illII. ]
qty-in-ezcms
quantity inss
Those quantities which have been determined to be excess to local needs.
qty4n-usequantity in mse
The quantity of a materiel equipment item that has been placed in use.
qty-on4onquantity on loan
The quantity of a materiel equipment item that has been placed on loan by the holdingorganization.
qty-orderedquandty ordered
The quantity ordered in the order-line.i qty-r ,e4ted-fwnt
The quantity of an equipment item that has been requested but has not yet been approved.
rcvd.by-pmn4dreceived by person identifier
An identifier of the person who received a work order.
reinspedtion cycle msonths quantity
Identifies period in months when reinspection for serviceability must be performed.
remaiing ife remxcy code
Idenfifies bow many years of life can be expected on a specific equipment item after it hasbee placed in service.
The quantity ofa lot managed undated supply materiel item that is unavailable for use until itja 4be2
i4 2
repairfpjrts-qty-ota-bandl
rewir party quantity on hand
Quantity of supply items that are used to maintain equipment.
report-statusreorrt Sttus
Identiri-s t•ose managed materiel items that must be reported to a commanding echelon.
reqd-ua-ma-cat-itm-id.nat-t-itm-idrequired unit assemblage materiel category item identifier.materiel category item identfie'r
The identification of a catalog item required by a unit assemblage.
reqmt-cdrequirement code
A code to group issue demands for calculating stock control levels, reader points, and safetylevels.
rouftig4dendfife-cdrouting identifier code
A comumnication address within the supply distribution system, or an item's next highersource of supply, or a local source of supply established within the logistics system.
'fety-,4vJ-qtysafety level quantity
The minimum quantity of supply materiel that should be on hand to prevent stockouts.
salvg-ofr~ar-wlsalvage dollar value
The residual value of equipment at the time of disposal.
sebduiedcatwory.cdscheduled category code
A fiag to identify whether services to be performed are scheduled or unscheduled.
9w n--mWatmserial number equipment matie item
The namnfacturer's assigned identifier for a specific equipment item.
4-26
anice-cattm-Idservice catalog item identtier
A unique identifier for a service catalog item.
oawue-ardw-ampletion-dateserice order completion date
The date a service order has been completed.
an'Ic.-order-,trt-dateservice order start date
The date work began on a service order.
uuvlce-org-sole-Idservice organization role identifier
An identifier for an organization's role in providing services.
service type
A categorization of services that can be performed.
adeif-lfeshef ife
The nmmber of months from manufacture that a supply materiel item may be expected toretain its serviceability.
ddp4o/bW4.-mftship tobill to modifier
Modification of the ship to/bill to address on an order line.
*O~yA=Wd4.qidp-wOsingly nawgef eqwmewu workorder
Work order for a specific singly managed equpment item.
sgtly hanaged materel eqsi. pa irm
Idetifier for a singly managed equipment item.
j j4-27
T
mei-priority-cdsingly managed materiel item priority code
A unique identifier for the priority of a singly managed equipment item.
smei-i• -Im~se-dt
smei scheduled service base date
The date from which scheduled service periods for a singly managed equipment item are
spewW-piroJ-qty-due-inspecal project quaniy due in
Identifies the quantity of items t'hat have been ordered for a special purpose.
spe al-projqty-on-handpecialproject quantity on hand
Identifies quantities of items that are on hand for a special purpose.
state-name,state namle
State name.
utatement-of-work-textstatement of work tea
Narrative in the contract that describes in detail the work the contractor is required to
states-cid
stau code
A code in the order line that indicates status information.
-undardfaiy e-ument code
A unique identfier for the standards of refining the physical and functional attributes of afacility system.
starga-j*4dsterile pack kdnrofl
A unique idetifier for a sterile puk.
4-28
stock-sostock number
The number assigned to each item of supply. The number may be a standard NSN or a localstock number assigned by the Medical Treatment Facility or the part number of the item.
stored calibration cyde months
Pracibed number of months between scheuled calibration services on equipment items thatare stored.
dstredinm-eyde-mosstoredprevamive maintenance cycle months
Prescribed number of months between scheduled preventive maintenance service on anequipmet item that is stored.
stored-saety4wp-cyde-ms
stored sa4ety inspection cycle months
Prescried number of months between safety inspection services on equipment that is stored.
storing organization identifier
A unique identifier for the organization that has physical possession of an equipment item.
sub-daild-aat-cat4tm4dsubstiute chile materiel catalog item identifier
An identifier for substitute items which have a prime item in the catalog.
wb/1
sub/prbme raio
The ratio for computing quantities of substitute items to be used in place of a prime item.
vuif-cst4dmwface cateory idfe
An identifiri of the type of su~rfiace (e.g., wall. ceiling, and floor).
swfaceflrdeh
Ibe materiel used in finishing a romsurface.
1, 4-29
surf-rb~surfae Adeght
The height of a room surface.
surf4engthsurface lSgth
The length of a room surface.
msrf-widthsurface *!dA*
The widt of a room surface.
suspended flag
An indicator that a specific lot of an item has been suspended from use.
suspended quauity
The quamnty of dated supply materiel at a location that is unavailable for use.
svc-cat-cdservice category code
A code that identifies the service category.
svc-cat-descserWce category description
A description of the service category.
wc,4ask-cdserce task code
A unique code for a particular service task to a supply materiel item.
seriic task daacIptim
The descr#lon of a service task to a supply materiel item.
zervk• task eCeata rant
The epectd result of a vic(s) performed.
4-30
3vcs.sk-seq-oservice task sequence number
The unique service task on a materiel device.
serwce type Code
A unique code for a particular service type.
Svc"ype-descservice type description
The description of a particular type of service that can be performed.
systeni~d
sjystem idendficaton
A unique identifier to differentiate between systems used in the facility (e.g., heating systemand elevator system).
_table of alww number
A unique identifier of a specific table of allowances.
task-id
tak identfter
A unique identifier for a task.
teh-UIt-ndictortechnical literature indicator
A code indicating local technical literature availability.
acked-tm4 d tortrao* item i•dcator
Part of the Army's LIN.
fWn in credlt arwut
The dollar anmum of funds of the order linmes used to return items from customemr wn creditwas -maed.
4-31
tma-lA-m3-end-amtumn in number credit amount
The dollar amount of funds of the order lines used to return items from customers when nocredit was granted.
ua4dwnit assemblage identyier
A unique identifier of a unit assemblage.
unit assemblage minimum quantity required
The minimum quantity of a materiel catalog item that must be present within a unitassemblage type.
Ua"Seq-nounit assemblage sequence number
A unique identifier for the sequence of a unit assemblage.
ua-supp-um-qty-authwit assemblage supply materiel quantity authorized
The quantity of a supply materiel item authorized for a particular unit assemblage.
ua-sppv-M-qty-reqIredunit assemblage supply materiel quantity required
The quantity of a supply materiel item required for a particular unit assemblage.
u py-mMat-qty-onhband
unit assemblage sWply matenel quantity on hand
The quantity of a supply materiel item that is on hand for a unit assemblage.
wait assemblage type wai assemblage qatity
The amowt of a type of urit assemblage.
MUni aswn~e veriau cde,
A uniqu identifier for a pardculr version of a unit assemblage (e.g., J, K, and L).
4-32
unlqukelvl-cdl
wdwkue code
Identifies whether a level is demand driven or locally managed.
unit idenufimcaion code
The identification of a specific organization.
unlt-d4ssiuawl of issue
The standard unit quantity in which a materiel catalog item is normally available.
Unit-o4-Measmunit of easure
The lowest unit in which a unit of issue may be broken down.
j unt-or-pack
unit of pact
Mh standard quantity of units of issue that are placed in a larger shipping container.
u -pricent price
The standard price of a materiel catalog item.
,ant We code
Identifies a type of organization.
unft~ype-desani tgpe dawjpion
Descrbs a type of organization.
anoSaWyeadyr to date dke out amowit
The dollar amount of funds for order lines when stock was not available and must be paid for=n receip.
jmauceadud caU cosw
The =mner of tmes a maintenance significant ftem has been repaired.
4-33
zailiratio ctegory code
A code which identifies the classification of use related to both function and space in afacility.
Uf-mii-desti
uli ation category description
A description of the classification of a utilization category.
ul-outet-qty
udtility outlet quantity
The number of utility outlets.Vaidor-d"-org4d
vendor child organization identifier
Identifies a vendor who places some type of constraint on the procurement process.
veador-tm-cod-dollar-valvendor item cost dollar value
Specifies dollar value limitations against a specific vendor.
vendor-nm"ovendor itdm number
The unique number assigned by a vendor to an item.
vemdor-Itm-nommdaturevendor fte. nomenclature
The descriptive name of a vendor item.
vratrany-exp-lt4aborwranuy exiration date labor
The date indicating the expiration of any labor warranties in effect for an equipment item.
Warraty-exp~dtjmilwafwaty eiradon date pans
"The date idicating the expiration of any pan waranties in effct for an equipant item.
Wrk cMtar code
A code which idenifies a work cener.
4.34
workorder-teWh
worn~rder tedwidan
The unique identifier of a technician assigned to a workorder.
watdoc-no (optional)wrm authority document number
The unique identification (table of allowance) for a specific WRM authorization.
wrm auhorikedfunds
The asmon of money that has been provided for processing WRM order lines.
wa-crical-tIm-edwrm critical iem code
Identifies WRM items that are critical to accomplishing the assigned mission (e.g., blood bagsin a Blood Donor Center).
wrxn-deFer~procr-mment-cdwrm deferredprorement code
Identifies if a WRM project materiel item must be on hand at all times or if procurement canbe delayed until a change takes place in the defense smtcture.
wrn-prog-type-dewrm program type description
The descriptive name of a specific WRM program type.
wru-pmoJect4dwrm project idenafer
A unique identifier for a WRM project.
wrm-proje-tn edwrm project type code
Identifies the type of WRM project such as Blood Donor Center.
wrm rqwara k ma
"1%e quantity of a WRM supply or equipment item that is not serviceable and is unavailable.
4-35
wrm-sale-amt
wrm sale mnount
The reimbursement amount received from the sale of WRM items.
zi code
A code that identifies a specific postal zone.
4-36
Section 5Business Rules
CONTRACT PERSON ROLE# Individuals
Role Per ContractA. Sales Rep 0-NB. Service Rep 0-NC. Vendor Billing POC 0-1D. Buyer i-NE. Administrator 1F. Contracting Officer Rep 0-NG. Contracting Officer Tech Rep 0-NH. Quality Assurance Evaluator 0-NI. Contracting Officer 1
Persons in role A, B, and C cannot fill roles D through I on same contract.
DATED LOT
Manufacture date must be less than expiration date; if the suspended flag equals zero, and thedestruction flag equals zero, then the expiration date must be greater than today.
DBOF FUND ACCT
For apportioned DBOF fund account the operating amount authorized must be greater than orequal to operating amount committed plus operating amount obligated.
EQUIPMENT MATERIEL ASSIGNMENT
The sum of quantity in-use and on-loan cannot exceed the quantity authorized.
FUND ALLOCATION
The total of issue year-to-date amount plus obligated year-to-date due out amount minus turnin credit amount must be less than or equal to authorized funds.
If authorized funds minus issued year-to-date amount minus obligated year-to-date due outamount plus turn in credit amount is insufficient for the total cost of the order line the orderline will be rejected.
5-1
ORGANIZATIONAL MATERIEL
At the time of the first recurring issue demaid a history begin date will be recorded. Untilthat time, history begin date will be null.
To maintain stock control levels a history begin date must be present.
Operating quantity on hand, quantity in excess, operating reparable quantity, WRM reparablequantity, and special project quantity on hand are mutually exclusive balance quantities.
Quantities of items in operating reparable quantity and WRM reparable quantity areunserviceable and are not available for use.
ORGANIZATION UNIT ASSEMBLAGE TYPE
Organization unit assemblage quantity on hand must be less thar or equal to the organizationunit assemblate quantity required. Organization unit assemblage quantity on hand must be lessthan the organization unit assemblage quantity authorized.
Organization unit assemblage quantity authorized must be less than or equal to organizationunit assemblage quantity required.
SERVICE ORDER LINE
The start date cannot be greater than the completion date.
SINGLY MANAGED EQUIPMENT ITEM
The acquisition date must be less than or Lqual to date in service.
Warranty expiration date for parts must be greater than or equal to date in service.
Warranty expiration date for labor must be greater than or equal to date in service.
The salvage dollar value must be less than the acquisition cost.
SUPPLY MATERIEL
Consumption quantity relates only to operating quantity issued. Suspended quantities are notissuable.
Operating suspended quantity and WRM suspended quantity are not part of the safety levelquantity.
5-2
UNIT ASSEMBLAGE SUPPLY MATERIEL
Unit assemblkage supply materiel quantity on hand must be less than or equal to unitassemblage supply materiel quantity authorized. Unit assemblage supply materiel quantity onhand must be less than unit assemblage supply materiel quantity required.
Unit assemblage supply materiel quantity authorized must be less than or equal to unitassemblage supply materiel quantity required.
WORK ORDER
The receipt date cannot be greater than the start date.
The start date cannot be greater than the completion date.
WRM PROJECT MATERIEL
On hand qui .. 'y plus due in quantity must be less than or equal to authorized quantity.
5-3
This Page Intentionally Left Blank
5-4
Data Model Business Rules
Parent Entity: ACCOUNTABILITY-CATEGORYVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: MATERIEL-CATALOG-ITEM
Parent Entity: ACQUISITION-ADVICE-CATEGORYVerb Phrase: categorizesCardinality: zero, one, or manyChild Entity: MATER!ELCATALOG-ITEM
Parent Entity: AUTH-DOCVerb Phrase: authorizesCardinality: zero, one, or manyChild Entity: WRM-PROG-MATERIEL
Parent Entity: AUTH-DOCVerb Phrase: authorizes assignment ofCardinality: zero, one, or manyChild Entity: EQUIPMENT-MAT-ASSIGNMENT
Parent Entity: COMMUNICATION-LINKVerb Phrase: facilitatesCardinality: zero, one, or manyChild Entity: INDIVIDUAL-COMM-LINK-USAGE
Parent Entity: COMMUNICATION-LINKVerb Phrase: facilitatesCardinality: zero, one, or manyChild Entity: ORGANIZATION-COMM-LINK-USAGE
Parent Entity: COMMUNICATION-LINKVerb Phrase: is obtained byCardinality: zero, one, or manyChild Entity: ORDER
Parent Entity: CONTRACTVerb Phrase: hasCardinality: zero, one, or manyChild Entity: CONTRACT-PERSON-ASSOCIATION
Parent Entity: CONTRACTVerb Phrase: provides service forCardinality: zero, one, or manyChild Anity: EQUIPhMEN-SYSTEM
IS5-
Parent Entity: CONTRACTVerb Phrase: provides service forCardinality: zero, one, ar manyChild Entity: GROUP-MNGD-EQUIPMENT
Parent Entity: CONTRACTVerb Phrase: provides service forCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: CONTRACT-PERSON-ROLEVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: CONTRACT-PERSON-ASSOCIATION
Parent Entity: COST-CTRVerb Phrase: relatesCardinality: one or manyChild Entity: DOD-ORG
Parent Entity: DATED-LOTVerb Phrase: is located atCardinality: zero, one, or manyChild Entity: DATED-SUPPLY-LOC
Parent Entity: DATED-SUPPLY-MATVerb Phrase: consists ofCardinality: zero, one, or manyChild Entity: DATED-SUPPLY-LOC
Parent Entity: EQUIP-AVAIL-RSNVerb Phrase: describesCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYS-STATUS
Parent Entity: EQUIP-AVAIL-RSNVerb Phrase: pertains toCardinality: zero, one, or manyChild Entity: EQUIPMENT-ITEM-STATUS
Parent Entity: EQUIP-AVAIL-TYPEVerb Phrase: categorizesCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYS-STATUS
Parmut Entity: EQUIP-AVAIL-TYPEVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: EQUIPMENT-ITEM-STATUS
5-6
, iI i |
Parent Entity: EQUIP-SYS-ITMVerb Phrase: hasCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYS-COMPOSITJON-HJSTORY
Parent Entity: EQUIPMENT-COND-STATUSVerb Phrase: describesCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYSTEM
Parent Entity: EQUIPMENT-COND-STATUSVerb Phrase: describesCardinality: zero, one, or manyChild Entity: GROUP-MNGD-EQULIP-LOC
Parent Entity: EQUIPMENT-COND-STATUSVerb Phrase: describesCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: EQUIPMENT-MAT-ASSIGNMENTVerb Phrase: assignsCardinality: zero, one, or manyChild Entity: ASSIGNED-SMEI
Parent Entity: EQUIPMENT-MAT-ASSIGNMENTVerb Phrase. assignsCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYSTEM
Parent Entity: EQUIPMENT-MATERIELVerb Phrase: is assigned viaCardinality: zero, one, or manyChild Entity: EQUIPMENT-MAT-ASSIGNMENT
Parent Entity: EQUIPMENT-SYSTEMVerb Phrase: containsCardinality: two or manyChild Entity: EQUIP-SYS-ITM
Parent Entity: EQUIPMENT-SYSTEMVerb Phrase: may requireCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYS-WORK-ORDER
Parent Entity: EQUIPMENT-SYSTEMVerb Phrase: relates toCardinality: zero, oe, or manyChild Entity: EQUIPMENT-SYS-COMPOSITION-HISTORY
5-7
Parent Entity: EQUIPMENT-SYSTEMVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYS-STATUS
Parent Entity: EQUIPMENT-SYSTEM-MATERIELVerb Phrase: consists ofCardinality: zero. one, or manyChild Entity: EQUIPMENT-SYSTEM
Parent Entity: FAC-ORG-RSNVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: FAC-ORG
Parent Entity: FAC-SYS-CLASSVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: FACILITY-SYSTEM
Parent Entity: FAC-SYS-CLASSVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: STD-FAC-SYS
Parent Entity: FAC-SYS-CLASSVerb Phrase: is documented byCardinality: zero, one, or manyChild Entity: STANDARDS/CODE-DOCUMENT
Parent Entity: FAC-SYS-CLASSVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: FAC-SYS-CLASS-STRUCTURE
Parent Entity: FAC-SYS-CLASSVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: FAC-SYS-CLASS-STRUCTURE
Parent Entity: FAC-TYPEVerb Phrase: classifiesCardinafity: zero, one. or manyChild Entity: FACILrIT
Parent Entity: FAC-TYPEVerb Phrase: is classified byCardinalky: zero, one, or manyChild Entity: STD-FAC (C•1TERIA)
j 5-8
Parent Entity: FACILITYVerb Phrase: may requireCardinality: zero, one, or manyChild Entity: FACILITY-PROJECT
Parent Entity: FACILITYVerb Phrase: may requireCardinality: zero, one, or manyChild Entity: FAC-ORDER-LINE
Parent Entity: FACILITYVerb Phrase: containsCardinality: zero, one, or manyChild Entity: FACILITY-FUNCTION
Parent Entity: FACILITYVerb Phrase: containsCardinality: zero, one, or manyChild Entity: FACILITY-SYSTEM
Parent Entity: FACILITYVerb Phrase: containsCardinality: zero, one, or manyChild Entity: INSTALLED-EQT
Parent Entity: FACILITYVerb Phrase: hasCardinality: zero, one, or manyChild Entity: COMMUNICATION-LINK
Parent Entity: FACILITYVerb Phrase: is associated withCardinality: zero, one, or manyChild Entity: FAC-ORG
Parent Entity: FACILITYVerb Phrase: is evaluated byCardinality: zero, one, or manyChild Entity: FACILITY-UTILIZATION
Parent Entity: FACILITYVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: FAC-STRUCTURE
Parent Entity: FACILITYVerb Phrase: relates,Carinality: zero, one, or manyChild Entity: FAC-STRUCTURE
5-9
' . ,iii I I II"i
Parent Entity: FACILITYVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: FACILITY-STANDARD
Parent Entity: FACILITY-PROJECTVerb Phrase: is funded byCardinality: zero, one, or manyChild Entity: FACILITY-PROJECT-FUNDING
Parent Entity: FACILITY-SYSTEMVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: FACILITY-SYSTEM-STRUCTURE
Parent Entity: FACILITY-SYSTEMVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: FACILITY-SYSTEM-STRUCTURE
Parent Entity: FUNCTIONAL-CATEGORYVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: STANDARD-FACILITY-FUNCTIONAL-USE
Parent Entity: FUNCTIONAL-CATEGORYVerb Phrase: classifies the use ofCardinality: zero, one, or manyChild Entity: FACILITY-FUNCTION
Parent Entity: FUNCTIONAL-CATEGORYVerb Phrase: determinesCardinality: zero, one, or manyChild Entity: FUNCTIONAL-UTILIZATION
Parent Entity: FUNCTIONAL-CATEGORYVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: ORGANIZATION-FUNCTION
Parent Entity: FUNCTIONAL-UTILIZATIONVerb Phrase: detenninesCardinality: zero, one, or manyChild Entity: FACILITY-UTILIZATION
Parent Entity: FUND-ACCTVerb Phrase: fundsC~ar iy:- zero, one, or manyChild Entity: ORDER-LINE-FUND-ACCT
5-10
Parent Entity: FUND-ACCTVerb Phrase: fundsCardinality: zero, one, or manyChild Entity: WRM-FUND-ACCT
Parent Entity: FUND-ACCTVerb Phrase: has usage defned byCardinality: zero, one, or manyChild Entity: FUND-ACCT-ORG
Parent Entity: FUND-ACCTVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: FUND-ACCT-STRUCT
Parent Entity: FUND-ACCTVerb Phrase: relatesCardinality: zero, one, or manyChild Entity: FUND-ACCT-STRUCT
Parent Entity: FUND-ACCT-ORG-ROLEVerb Phrase: describesCardinality: zero, one, or manyChild Entity: FUND-ACCT-ORG
Parent Entity: FUND-ACCT-TYPEVerb Phrase: relatesCardinality: zero. one, or manyChild Entity: FUND-ACCT
Parent Entity: FUND-TYPEVerb Phrase: applies toCardinality: zero, one, or manyChild Entity: FACILITY-PROJECT-FUNDING
Parent Entity: FUND-TYPEVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: FUND-ACCT
Parent Entity: GENERIC-EQUIPMENT-CLASSVerb Phrase: identifies a typeCardinality: zero, one, or manyChild Entity: MANAGED-MATERIEL-iTEM
Parent Entity: GROUP-MNGD-EQUIPMENTVerb Phrase: is located inCardinality: zero, one, or manyChild Entity: GROUP-MNGD-EQUIP-LOC
5-11
Parent Entity: GROUP-MNGD-EQUIPMENTVerb Phrase: may requireCardinality: zero, one, or manyChild Entity: GROUP-MNGD-EQUIP-WORK-ORDER
Parent Entity: IMPROVED-LANDVerb Phrase: is used byCardinality: zero, one, or manyChild Entity: FACILITY
Parent Entity: INDIVIDUALVerb Phrase: completesCardinality: zero, one, or manyChild Entity: WORK-ORDER
Parent Entity: INDIVIDUALVerb Phrase: holdsCardinality: zero, one, or manyChild Entity: INDIVIDUAL-ROLE
Parent Entity: INDIVIDUALVerb Phrase: is point of contact forCardinality: zero, one, or manyChild Entity: ORDER
Parent Entity: INDIVIDUALVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: INDIVIDUAL-STRUCTURE
Parent Entity: INDIVIDUALVerb Phrase: may function asCardinality: zero, one, or manyChild Entity: WORK-ORDER-TECH
Parent Entity: INDIVIDUALVerb Phrase: participates inCardinality: zero, one, or manyChild Entity: CONTRACT-PERSON-ASSOCIATION
Parent Entity: INDIVIDUALVerb Phrase: receivesCardinality: zero, one, or manyChild Entity: WORK-ORDER
Parent Entity: INDIVIDUALVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: INDIVIDUAL-STRUCrURE
5-12
Parent Entity: INDIVIDUALVerb Phrase: usesCardinality: zero, one, or manyChild Entity: INDIVIDUAL-COMM-LINK-USAGE
Parent Entity: INDIVIDUALVerb Phrase: usesCardinality: zero, one, or manyChild Entity: INDIVIDUAL-LOCATION
Parent Entity: INDIVIDUALCOMM-LINK-REASONVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: INDIVIDUAL-COMM-LINK-USAGE
Parent Entity: INDIVIDUAL-LOCATION-REASONVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: INDIVIDUAL-LOCATION
Parent Entity: INDIVIDUAL-ROLE-REASONVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: INDIVIDUAL-ROLE
Parent Entity: INSPECTION-TASKVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: MATERIEL-INSPECTION-TASK
Parent Entity: INSTALLATIONVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: INSTALLATION-STRUCTURE
Parent Entity: INSTALLATIONVerb Phrase: relatesCardinality: zero, one, or manyChild Entity: INSTALLATION-STRUCTURE
Parent Entity: LOCATIONVerb Phrase: holdsCardinality: zero, one, or manyChild Entity: GROUP-MNGD-EQUIP-LOC
t Parent Entity: LOCATIONVerb Phrase: identifiesCardinmlity: zero, one, or nmyChild Entity: INDIVIDUAL-LOCATION
5-13
Parent Entity: LOCATIONVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: LOCATION-ASSIGNMENT
Parent Entity: LOCATIONVerb Phrase: is normal location ofCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: LOCATIONVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: LOCATION-STRUCTURE
Parent Entity: LOCATIONVerb Phrase: is service location ofCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: LOCATIONVerb Phrase: locatesCardinality: zero, one, or manyChild Entity: DATED-SUPPLY-LOC
Parent Entity: LOCATIONVerb Phrase: primary storage forCardinality: zero, one, or manyChild Entity: WRM-PROGRAM
Parent Entity: LOCATIONVerb Phrase: relatesCardinality: zero, one, or manyChild Entity: LOCATION-STRUCTURE
Parent Entity: LOCATIONVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: FACILITY
Parent Entity: LOCATIONVerb Phrase: specified byCardinality: zero, one, or manyChild Entity: GRP-MGD-UNDATED-MAT-SUPPLY-LOC
Parent Entity: LOCATIONVerb Phrase: specified byCardinality: zero, one, or manyChild Entity: LOT-MGD-UNDATED-SUPPLY-MAT-LOC
I5-14
Parent Entity: LOTVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: LOT-MGD-UNDATED-SUPPLY-MAT-LOC
Parent Entity: MAINT-ORGVerb Phrase: maintainsCardmnality: zero, one, or manyChild Entity: EQUIPMENT-SYSTEM
Parent Entity: MAINT-ORGVerb Phrase: maintainsCardinality: zero, one, or manyChild Entity: GROUP-MNGD-EQUIP-LOC
Parent Entity: MAINT-ORGVerb Phrase: maintainsCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: MAINTENANCE-SIGNIFICANT-ITEMV-rb Phrase: described byCardinality: zero, one, or manyChild Entity: EQUIPMENT-ITEM-STAThs'
Parent Entity: MANAGED-MATERIJL-ITEMVerb Phrase: requiresCardinality: zero. one, or manyChild Entity: MANAGED-MAT-REPORTING-REQT
Parent Entity: MANUFACTURERVerb Phrase: has producedCardinality: zero, one, or manyChild Entity: LOT
Parent Entity: MANUFACTURERVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: MATERIEL-CATALOG-ITM-MANUFAC
Parent Entity: MATERIEICATALOG-iTEMVerb Phrae: comprisesCardinality: zero, one, or manyChild Entity: UA-TYPE-MAT-REQMT
' Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: hasCardinality: zero, one, or manyChild Entity: MATERIEL-INSPECTION-TASK
5-15
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: MATERIEL-CATALOG-ITM-MANUFAC
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: STD-FAC-EQT
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: is associated withCardinality: zero, one, or manyChild Entity: ORGANIZATION-MATERIEL
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: is associated withCardinality: zero, one, or manyChild Entity: VENDOR-TERM
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: is classified byCardinality: zero, one, or manyChild Entity: UA-TYPE
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: is ordered byCardinality: zero, one, or manyChild Entity: MATERIEL-ORDER-LINE
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: MATERIEL-STRUCTURE
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: is required byCardinality: zero, one, or manyChild Entity: TA-MAT-RQMT
Parent Entity: MATERIEL-CATALOG-ITEMVerb Phrase: produced inCardinality: zero, one, or manyChild Entity: LOT
Parent Entity: MATERIEL-CATALOG-rITEMVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: MATERIEL-STRUCTURE
5-16
T
Parent Entity: MATERIEL-DEVICE-CLASSVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: MATERIEL-DEVICE
Parent Entity: MATERIEL-DEVICE-CLASSVerb Phrase: requiresCardinality: zero, one, or manyChild Entity: MATERIEL-DEVICE-SVC-TASK
Parent Entity: MATERIEL-STRUCTURE-REASONVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: MATERIEL-STRUCTURE
Parent Entity: NON-DBOF-FUND-ACCTVerb Phrase: containsCardinality: zero, one, or manyChild Entity: FUND-ALLOCATION
Parent Entity: OBJECT-CLASSVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: FUND-ALLOCATION
Parent Entity: ORDERVerb Phrase: containsCardinality: one or manyChild Entity: ORDER-LINE
Parent Entity: ORDERVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: ORDER-STRUCTURE
Parent Entity: ORDERVerb Phrase: relates toCardinality: wero, one, or manyChild Entity: ORDER-STRUCTURE
Parent Entity: ORDERVerb Phrase: represented inCardinality: zero. one, or manyChild Entity: ORG-ORDER
Pamm Entity: ORDER-LINEVerb Phrase: is funded byCardinality: one or many3 Child Entity: ORDER-LINE-FUND-ACCT
i1 5-17
Parent Entity: ORDER-LINEVerb Phrase: is related toCardinality: zero, ore, or manyChild Entity: ORDER-LINE-STRUCTURE
Parent Entity: ORDER-LINEVerb Phrase: relates toCardinality: zero. one, or manyChild Entity: ORDER-LINE-STRUCTURE
Parent Entity: ORDER-LINEVerb Phrase: supportsCardinality: zero, one, or manyChild Entity: PROGRAM
Parent Entity: ORDER-TYPEVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: ORDER
Parent Entity: ORG-ORDER-ROLEVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: ORG-ORDER
Parent Entity: ORG-UA-TYPEVerb Phrase: consists ofCardinality: zero, one, or manyChild Entity: UNIT-ASSEMBLAGE
Parent Entity: ORGANIZATIONVerb Phrase: accountable forCardinality: zero, one, or manyChild Entity: ORGANIZATION-MATERIEL
Parent Entity: ORGANIZATIONVerb Phrase: assigned by missionCardinality: zero, one, or manyChild Entity: WRM-PROGRAM
Parent Entity: ORGANIZATIONVerb Phrase: assignsCardinality: zero, one, or manyChild Entity: INDIVIDUAL-ROLE
Parent Entity: ORGANIZATIONVerb Phrase: authorizesCardiality: zero. one, or manyChild Entity: EQUIPMENT-MAT-ASSIGNMENT
5-18
I
Parent Entity: ORGANIZATIONVerb Phrase: hasCardinality: zero, one, cr manyChild Entity: FUND-ACCT-ORG
Parent Entity: ORGANIZATIONVerb Phrase: has a requirement forCardinality: zero, one, or manyChild Entity: ORG-UA-TYPE
Parent Entity: ORGANIZATIONVerb Phrase: holdingCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: ORGANIZATIONVerb Phrase: is assignedCardinality: zero, one, or manyChild Entity: ORGANIZATION-FUNCTION
SParent Entity: ORGANIZATIONVerb Phrase: is associated withCardinality: zero, one, or manyChild Entit): FAC-ORG
Parent Entity: ORGANIZATIONSVerb Phrase: is associated with
Cardinality: zero, one, or manyChild Entity: ORGANIZATIONAL-SERVICE
Parent Entity: ORGANIZATIONVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: ORGANIZATION-STRUCTURE
Parent Entity: ORGANIZATIONI Verb Phrase: may haveCardinality: zero, one, or manyI Child Entity: PROGRAM
Pareat Entity: ORGANIZATIONVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: ORG-ORDER
~ Paret Entity: ORGANIZATIONVerb Phrase: relates toCmaiumity: zero, one, or many' Child Entity: ORGANIZATION-STRUCTURE
S 15-19
Parent Entity: ORGANIZATIONVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: INSTALLATION
Parent Entity: ORGANIZATIONVerb Phrase: reportsCadinality: zero, one, or manyChild Entity: MANAGED-MAT-REPORTING-REQT
Parent Entity: ORGANIZATIONVerb Phrase: requires/linksCardinality: zero, one, or manyChild Entity: ORGANIZATION-COMM-LINK-USAGE
Parent Entity: ORGANIZATIONVerb Phrase: usesCardinality: zero, one, or manyChild Entity: LOCATION-ASSIGNMENT
Parent Entity: ORGANIZATION-CATEGORYVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: ORGANIZATION
Parent Entity: ORGANIZATION-COMM-LINK-REASONVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: ORGANIZATION-COMM-LINK-USAGE
Parent Entity: ORGANIZATION-LOCATION-REASONVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: LOCATION-ASSIGNMENT
Parent Entity: ORGANIZATION-MATERIELVerb Phrase: which may be used asCardinality: zero, one, or manyChild Entity: WRM-PROG-MATERIEL
Parent Entity: ORGANIZATION-STRUCTIURE-RSNVerb Phrase: justifiesCardinality: zero, one, or manyChild Entity: ORGANIZATION-STRUCTURE
Parent Entity: OULMET-TYPEVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: LUIL-OUTLET
5-20
Parent Entity: PROGRAMVerb Phrase: implemented viaCardinality: zero, one, or manyChild Entity: PROJECT
Parent Entity: PROGRAMVerb Phrase: is relaed toCardinality: zero, one, or manyChild Entity: PROGRAM-STRUCTURE
Parent Entity: PROGRAMVerb Phrase: relatesCardinality: zero, one, or manyChild Entity: PROGRAM-STRUCTURE
Parent Entity: PROJECTVerb Phrase: broken intoCardinality: zero, one, or manyChild Entity: TASK
Parent Entity: PROJECTVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: PROJECT-STRUCTURE
Parent Entity: PROJECTVerb Phrase: relates toCardinality: zuo, m, or manyChild Entity: PROJECT-STRUCTURE
Parent Entity: SCHEDULED/UNSCHEDULED-CATEGORYVerb Phrase: categorizesCardinality: zero. one. or manyChild Entity: SERVICE-CATALOG-ITEM
Parent Entity: SCHEDULED/UNSCHEDULED-CATEWORYVerb Phrase: categorizesCardinality: zero, one, or manyChild Entity: SERVICE-ORDER-LINE
Parent Entity: SERVICE-CATALOG-ITEMVerb Phrase: is initiated byCardinality: zero, ae, or manyChild Entity: SERVICE-ORDER-LINE
' Parent Entity: SERVIC-CATALOG-ITEMVerb Phrase: is wbld toCardinality: zero, am, or manyChild Entity: SERVICE-STRUCTURE
5-21
7
Parent Entity: SERVICE-CATALOG-ITEMVerb Phrase: may requireCardinality: zero, one, or manyChild Entity: ORGANIZATIONAL-SERVICE
Parent Entity: SERVICE-CATALOG-ITEMVerb Phrase: relates toCardinality: ero, one, or manyChild Entity: SERVICE-STRUCTURE
Parent Entity: SERVICE-CATEGORYVerb Phrase: categorizesCardinality: zero, one, or manyChild Entity: SERVICE-CATALOG-ITEM
Parent Entity: SERVICE-TASKVerb Phrase: identifiesCardinality: zero, one, or manyChild Entity: MATERIELADEVICE-SVC-TASK
Parent Entity: SERVICE-TYPEVerb Phrase: categorizesCardinality: zero, one, or manyChild Entity: SERVICE-CATALOG-ITEM
Parent Entity: SERVICE-TYPEVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: MATERIEL-DEVICE-SVC-TASK
Parent Entity: SINGLY-MNGD-EQUIPVerb Phrase: onsists ofCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: SINGLY-MNGD-MAT-EQT-ITMVerb Phrase: may requireCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-WORK-ORDER
Parent Entity: STANDARDS/CODE-DOCUMENTVerb Phrase: is documented byCardinality: zero, one, or manyChild Entity: STD-FAC (CRITERIA)
Parent Entity: SID-FAC (CRITERIA)Verb Phrase: guidesCardinality: zero, one, or manyChild Entity: FACILITY-PROJECT
5-22
iI
ii
Parent Entity: STD-FAC (CRITERIA)Verb Phrase: identifiesCardinality: zero, one, or manyChild Entity: STANDARD-FACILlTY-FUNCTIONAL-USE
Parent Entity: STD-FAC (CRITERIA)Verb Phrase: is associated withCardinality: zero, one, or manyChild Entity: FACILITY-STANDARD
Parent Entity: STD-FAC (CRITERIA)Verb Phrase: is related toCardinality: zero, one, or manyChild Entity: STD-FAC--STRUCTURE
Parent Entity: STD-FAC (CRITERIA)Verb Phrase: relates toCardinality: zero, one, or manyChild Entity: STD-FAC-STRUCTURE
Parent Entity: STD-FAC (CRITERIA)Verb Phrase: relates toCardinality: zero, one, or manyChild Entity: STD-FAC-EQT
Parent Entity: STD-FAC (CRITERIA)Verb Phrase: relates toCardinality: zero, one, or manyChild Entity: STD-FAC-SYS
Parent Entity: STD-RMVerb Phrase: identifies type ofCardinality: one or manyChild Entity: RM-SURFACE
Parent Entity: STD-RMVerb Phrase: identifies type ofCardinality: zero, one, or manyChild Entity: UTIL-OUTLET
Parent Entity: STERILEPACKVerb Phrase: consists ofCardinality: zero, one, or manyChild Entity: ASSIGNED-SMEI
S Paren Entity: SUPPLY-MATERIELVerb Phrase: may be used asCurdinality: zero, one, or manyChild Entity: UA-SUPPLY-MATERIEL
I 5-23
Parent Entity: SURFACE-CATVerb Phrase: relates toCardinality: zw'ro, one, or manyChild Entity: RM-SURFACE
Parent Entity: TASKVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: TASK-STRUCTURE
Parent Entity: TASKVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: TASK-STRUCTURE
Parent Entity: TBL-OF-ALLOWVerb Phrase: describesCardinality: zero, one, or manyChild Entity: UA-TYPE
Parent Entity: TBL-OF-ALLOWVerb Phrase: mandatesCardinality: zero, one, or manyChild Entity: TA-MAT-RQMT
Parent Entity: UA-TYPEVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: UA-TYPE-STRUCTURE
Parent Entity: UA-TYPEVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: UA-TYPE-STRUCTURE
Parent Entity: UA-TYPEVerb Plrase: requiresCardinality: zero, one, or manyChild Entity: UA-TYPE-MAT-REQMT
Parent Entity: UA-TYPEVerb Phrase: supportsCardinality: zero, one, or manyChild Entity: ORG-UA-TYPE
Parent Entity: UA-VERSIONVerb Phrase: categorizesCardinality: zero, one, or manyChild Entity: UA-TYPE
5-24
Parent Entity: UNDATED-SUPPLY-MATVerb Phrase: stored atCardinality: zero, one, or manyChild Entity: GRP-MGD-UNDATED-MAT-SUPPLY-LOC
Parent Entity: UNDATED-SUPPLY-MATVerb Phrase: stored atCardinality: zero, one, or manyChild Entity: LOT-MGD-UNDATED-SUPPLY-MAT-LOC
Parent Entity: UNIT-ASSEMBLAGEVerb Phrase: containsCardinality: zero, one, or manyChild Entity: UA-SUPPLY-MATERiEL
Parent Entity: UNIT-ASSEMBLAGEVerb Phrase: containsCardinality: zero, one, or manyChild Entity: EQUIPMENT-SYSTEM
Parent Entity: UNIT-ASSEMBLAGEVerb Phrase: is related toCardinality: zero, one, or manyChild Entity: UA-S fRUCTURE
Parent Entity: UNIT-ASSEMBLAGEVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: UA-STRUCTURE
Parent Entity: UNIT-ASSEMBLAGEVerb Phrase: relates toCardinality: zero, one, or manyChild Entity: SINGLY-MNGD-MAT-EQT-ITM
Parent Entity: UNIT-TYPEVerb Phrase: definesCardinality: zero, one, or manyChild Entity: ORGANIZATION
Parent Entity: UTILIZATION-CATEGORYVerb Phrase: detemnninesCardinality: mero, ae, or manyChild Entity: FUNCTIONAL-UTILIZATION
Parent Entity: VENDORVerb Phrase: offersCardinality: zero, one, or manyChild Entity: VENDOR-TERM
j 5-25
Parent Entity: WORK-ORDERVerb Phrase: requiresCardinality: zero, one, or manyChild Entity: WORK-ORDER-TECH
Parent Entity: WRM-PROG-MATERIELVerb Phrase: may haveCardinality: zero, one, or manyChild Entity: WRM-SMEI
Parent Entity: WRM-PROGRAMVerb Phrase: is funded throughCardinality: zero, one, or manyChild Entity: WRM-FUND-ACCT
Parent Entity: WRM-PROGRAMVerb Phrase: requiresCardinality: one or manyChild Entity: WRM-PROG-MATERIEL
Parent Entity: WRM-PROGRAM-TYPEVerb Phrase: classifiesCardinality: zero, one, or manyChild Entity: WRM-PROGRAM
5-26
T-
Section 6Derivable Elements
Accumulated Maintenance Cost
The accumulated maintenance cost of a specific materiel equipment item. Calculated by
adding the cost of all work orders for that item.
Available Days
The total number of days the equipment was fully mission capable. Calculated by adding thedays between completion of an unscheduled work order and receipt date of the nextunscheduled work order during a period.
Average Number of Days Between Failures
The average number of days between failure or repair of a piece of equipment. Calculated bydividing the total number of available days by the number of unscheduled work orders.
Average Pipeline Time in Days/Order and Ship Time in Days
the average number of elapsed days calculated from the day the order leaves the requestingunit to the day the requested materiel arrives.
Awaiting Manpower
The number of services awaiting manpower that are between a certain age. Calculated byadding all work orders with a receipt date but without a start date and grouping them asfollows:0 to 30 days old31 to 60 days old61 to 90 days old91 + days old.
Calibrations Completed
The number of calibrations that were completed during the period. Calculated by adding thenumber of completed calibration work orders.
Calibrations Received
The number of calibration requests that were received during the period. Calculated byadding the number of all calibration work orders generated.
I 6-1
Completed Scheduled Work Order Percentage
The percent of scheduled senrices completed for a month. CalcLlated by adding the numberof scheduled work orders with completion dates during the month divided by the number ofwork orders open during the month.
Currenit Expenditures
The total expenditures against a given equipment item. Calculated by adding all costs forcontracts, labor, and parts for a given equipment item.
Daffy Demand Rate
The quantity of recorded recurring demands that are placed each day. It is calculated fromthe total quantity of recorded demands divided by the number of days over which the quantityof demands occurred.
Date Last Scheduled Work Order
Date the last scheduled work order was completed. Derived from the order line of the lastscheduled work order.
Date Last Unscheduled Work Order
Date the last unscheduled work order was completed. Derived from the order line of the lastunscheduled work order.
Date Next CAL
The anticipated date when a new calibration workorder is expected to be generated.Calculated by adding the CAL interval to the date of last CAL.
Date Next PM
The anticipated date when a new preventive maintenance workorder is expected to begenerated. Calculated by adding the PM interval to the date of last PM.
Date Next Safety
The anticipated date when a new safety inspection workorder is expected to be generated.Calculated by adding the safety interval to the date of last safety inspection.
Demand Frequency by Month
The number of recurring customer order lines for a supply materiel item for each givenmonth.
6-2
Demands filled
The number of recurring order lines for stocked items with the quantity issued equal to thequantity requested.
Dunands for Stocked Items
The number of recurring order lines for stocked items.
Due-In Total
The number of due-ins that were created. Calculated by adding the number of materiel orderlines created during the period.
Due-In with High Priority
The number of due-ins that were created with a high priority. Calculated by adding materielorder lines with a priority of 1 through 8.
DueOut Balance
The quantity of an item that has been requested by customers and is not available for issue.Calculated by totaling the quantity fields of all the order lines for a catalog item that are in abackorder status.
Equipment Density
The nmbnt of items of equipment in use. Calculated by adding the number of groupmanaged equipment items by group location.
Wfe Expectancy Remaining
The years of service remaining on an equipment materiel item. Calculated by using the lifeexpectancy in the catalog and subtracting the number years since the item was placed inservice.
Maximum. Cumulative Expenditure Limit
A two character numeric field expressed as a decimal used to assist in determining if anequipment materiel item qualifies for repair or replacement. Identifies that portion of themaximum cumulative expenditure limit which is still available for repairs of that item.
Number of Completed Work Orders
The total number of work orders completed. Calculated by adding the number of workordety with a completion date within the period.
IJ 6-3
Parent Entity: MATERIEL-ATALOG-ITEMVerb Phrase: reaics toCardinality: zero, one, or manyChild Entity: MATERIEL-STRUCTURE
5-16
Number of Demands
Calculated :y adding the number of recurring customer order lines for a supply materiel iter.i.
Number of Modifications
The number of times an item of equipment has been modified in accordance withmanufacturer specifications. Calculated by totaling the work orders which have an actioncode of "Modification" performed.
Projected Date of Retirement
Anticipated date a piece of equipment will be removed from service. Date in Service plus thelife expectancy in years.
Number of Work Orders Referred
The total number of work orders referred. Calculated by adding the number of referred workorders within a period.
Number of Work Orders Waiting for Parts
The total number of work orders with outstanding part order lines.
Number Work Orders Assigned
Total number of work orders assigned to a team or technician. Calculated by adding allworkorders assigned to a work center or technician.
Order Line Denials
The number of order lines for which a materiel release was created but for which stock couldnot be located in full quantity.
Order Ship Tune Level
The quantity required during the average pipeline time. Calculated by multiplying dailydemand rate by the days in the average pipeline time.
Organizational Not Mission Capable for Supply (NMCS) Days
The total number of days the equipment was not mission capable awaiting supply at theorganizational level. Calculated by adding the total number of days work orders for a materielequipment item are open awaiting parts from organizational supply during the period.
6-4
I
Organizational Not Mission Capable for Maintenance (NMCM) Days
The total number of days the equipment was not mission capable awaiting maintenanceservices at the organizational level. Calculated by adding the total number of days workorders for a piece of equipment are open for repair by organizational maintenance during theperiod.
Outstanding Scheduled Work Order Count
Scheduled workorders that have not been completed. Derived by counting all workorderlines that are coded as scheduled and have not been closed.
Outstanding Unscheduled Work Order Count
Unscheduled workorders that have not been completed. Derived by counting all workorderlines that are coded as unscheduled and have not been closed.
PM Completed
The number of preventive maintenance services that were completed during the period.
PM Requests Received
The number of preventive maintenance requests that were received during the period.
Possible Days
The total number of days the equipment was on-hand. Calculated by subtracting reportingperiod date from date placed in service.
Quantity Waiting for Support
The number of items waiting for support maintenance. Computed by adding all work orderswaiting for support maintenance.
Remaining Ufe One Time Expenditure Limit
The maximum amount that may be expensed against a particular equipment materiel item thatmay be expended on one repair.
Reorder Point/Proposed Reorder Point
The point in the stock control level where requisitions are generated. It may be expressed asa quantity ((number of days in the Safety level plus number of days in the average pipeline)times the daily demand rate). It may also be expressed as a percentage ((the number ofdays in the safety level plus the number of days in the average pipeline time) divided by(number of days in the requisition objective plus the number of days in the safety level plusthe number of days in the average pipeline time)).
6-5
Reportable Items at Zero Balance
The number of reportable items %ith al active balance of 0 or not listed in the stock recordfile.
Requisition Objective/Proposed Requisition Objective
The quantity of an item that is consumed during a given period. Low dollar annualrequirements result in a higher number of days in the requisition objective and high dollarannual requirements result in a lower number of days in the requisition objective. It iscalculated by multiplying the number of days in the requisition objective times the dailydemand rate.
Stock Control Level/Proposed Stock Control Level
Identifies the actual unit of issue or unit of measure quantity of stock a customer shouldmaintain based on the customer's demands to the supporting supply activity. Calculated bythe number of days in the stock control level ((days in Economic Order Quantity (EOQ)period, plus number of days in the average pipeline, plus number of days in the safety level)times the daily demand rate).
Stocked Items at Zero Balance
The number of stocked items with a zero active balance at the end of the period.
Stratification of Work Orders Awaiting Man Hours
The number of unassigned work orders open currently in a work center, stratified by age.0 to 30 days old.31 to 60 days old61 to 90 days old91 + days old.
Stratified Awaiting Parts
The number of services awaiting parts that are between certain periods. Calculated by addingthe work orders awaiting parts with receipt dates that are within the following time periods:0 to 30 days31 to 60 days61 to 90 days91+ days.
6-6
Strafified Deferred Work Orders
The number of deferred services. Determned by counting the number of work orders withdeferred action code and a receipt date between the following time periods:0 to 30 days31 to 60 days61 to 90 days91 + days.
Stratified Refermd Services
The number of referred services work orders stratified by age:Referred 0 to 30 days oldreferred 31 to 61 days oldreferred 61 to 90 days oldreferred 91+ days old.
Support NMCM Days
The total number of days the equipment was not mission capable awaiting maintenance at thesupport level. Calculated by adding the total number of days work orders for a piece ofequipment are open for repair at a support level shep during the period.
Support NMCS Days
The total number of days the equipment was not mission capable awaiting supply at thesupport level. Calculated by adding the total number of days work orders for a piece ofequipment are open for supply at the support level during the period.
Total Assigned Hours
Total number of hours that have been assigned to the team or technician.
Total by FY Repair Hours
Total hours a given assigned equipment item has been not mission capable awaiting repair.Computed by adding all hours between I October and 30 September a given equipment itemhas been non-operational for repair during any given year.
Total by FY Parts Cost
Total cost spent on a given equipment item for repair parts. Computed by adding all costscharged to a given equipment item between 1 October and 30 September for repair parts forany given year.
I; Total by FY Ciotraet Cost
Total contract costs charged against a given equipment item. Computed by adding costsbetween 1 October and 30 September charged to a given equipment item for contract repairsduring any given year.
6-
Total by FY PM Hours
Total hours PM hours scheduled. Computed by adding all stheduled PM hours between 1October and 30 September for any given Work Center for any given year.
Total by FY Not Mission Capable Hours
Total hours a given assigned equipment item has been not mission capable. Computed byadding all hours between 1 October and 30 September an equipment item has been non-operational for any given year.
Total by FY Not Mission Capable Days
Total days a given equipment item has been not mission capable. Computed by adding alldays between 1 October and 30 September an equipment item has been non-operational forany given year.
Total by FY Repair Labor Cost
Total costs charged for labor on a given equipment item for repair. Computed by adding alllabor costs charged between 1 October and 30 September for a given equipment item for anygiven year.
Total Calibrations
The total number of times that calibration has been completed on a particular piece ofequipment.
Total Completed Calibrations
The total number of scheduled calibration work orders completed during a given month.
Total Completed Preventive Maintenance
The total number of scheduled preventive maintenance work orders completed during a givenmonth.
Total Completed Safety Inspections
The total number of scheduled safety inspections completed in a given month.
Total Cost
The total cost for labor and parts for a given piece of equipment.
Total labor Cost
The total cost for labor to complete a work order.
6-8
I
Total Number of Repairs
The total number of repairs that have been performed on a particular piece of equipment.
Total Number of Demands
The total number of order lines received during the period.
Total Parts Cost
The total cost for parts to complete a particular work order.
Total Preventive Maintenance
The total number of times preventive maintenance has been completed on a particular piece ofequipment.
Total Repair Cost
The total cost of labor and parts for a given work order.
I Total Reportable Items
The number of items that were identified as reportable.
Total Safety Inspections
e The total number of safety inspections completed on a specific materiel equipment item.
Total Scheduled Calibrations
The total number of calibration hours scheduled during a given month.
Total Scheduled Preventive Maintenance
The total number of preventive maintenance work orders scheduled during a given month.
Total Scheduled Safety Inspections
SThe total number of scheduled saety inspections for a given month.
Total Stocked Items
The number of demand supported items.
~ Unit of Measure Price
The price of the unit of measure. Calculated by dividing the standard unit price by the unit of
I measure quantity.
1 6-9
Unscheduled Service Requests Received
The number of unscheduled service requests that were received during the period. Calculatedby adding the number of unscheduled work orders with a receipt date during the period.
Unscheduled Services Beginning Balance
The number of unscheduled services that had not been completed at the beginning of theperiod. Calculated by adding the number of unscheduled work orders remaining open fromthe previous period.
Unscheduled Services Completed
The number of unscheduled services that were completed during the period. Calculated byadding the number of unscheduled work orders with a completion date during the period.
6-10
Section 7TO-BE Data Model Issues
INSURING MEDICAL EQUIPMENT
BACKGROUND
Currently, the maintenance and repair of r•idical equipment items in military treatment facilities areprovided by in-house medical equipment repair personnel or by outsource contracts. Civilianhospitals manage their medical equipment in a similar fashion; however, they also consider theconcept of insuring their capital property if it offers less cash outlay in the long run. Insuringproperty is not practiced by the federal government. This concept should be investigated todetermine if it is a viable option.
DISCUSSION
While specific terms and conditions of insurance agreements/contracts vary among civilian hospitals,the basic concept is to pay premium fees to an insurance company for a list of equipment items.When one of the equipment items requires maintenance or repair, a service company is called to
I perform the required services. The service company is then paid by the insurance firm. There arepros and cons to this concept. One can argue that it is less expensive for the military to maintain apool of trained equipment repair technicians who can perform the required services and/or contractout services at competed prices. On the contrasy, it can be argued that it is less expensive to insurethe equipment and reduce training and contract costs. Since this option is being exercised by manyhospitals instead of in-house or out-source capability as a cost-cutting measure, it should beconsidered in the TO-BE environment.
III
1 7-1
-w
TRACKING OF WRM REPARABLE OR SUSPENDED ITEMS BY WRM PROJECTS
BACKGROUND
War Reserve Materiel (WRM) items are assigned to a specific WRM Project. When a notice isreceived to suspend WRM items, the items are physically segregated from the usable or serviceableitems. The WRM project identity of these suspended items is lost. When a notice is later receivedextending the shelf life of previously suspended WRM items, it does not identify the WRM project towhich the items belong. The task of matching the numerous WRM items to their specific WRMprojects becomes very laborious and time-consuming.
DISCUSSION
As part of the contingency strategy, WRM projects require special and preferential attention. Thecradle-to-grave management of WRM supplies and equipment must ensure an efficient process in whichthey are readily identifiable to specific WRM projects. For a command managing numerous WRMprojects, matching WRM items to WRM projects can greatly consume man-hours. (The Air Forcecurrently performs this task manually, but is in the process of mechanizing it.)
7-2
RELATIONSHIP OF CONSUMABLESTO EQUIPMENT USING THOSE CONSUMABLES
BACKGROUND
Equipment items often require expendable items during the course of their use. It is difficult for supplyand maintenance personnel to order correct consumables to support the equipment in the user'senvironment. For example, a catalog lists different types of paper, batteries, and electrodes, but doesnot specify the piece of equipment for which the consumable is designed.
DISCUSSION
The TO-BE system would allow supply and maintenance personnel to look up the consumable item andsee the NSN, manufacturer, and model number of the equipment which uses that consumable. This datacould also be accumulated under the NSN of the equipment to obtain a list of all consumables used bythat end item.
7
I !
PROPERTY EPRECIATION
BACKGROUND
When a company buys a depreciable property, it increases the value of its property asset while itreduces its cash. The property is then depreciated each year of its useful life. This is the process ofallocating the cost of an asset to the periods of benefit. This process results in identifying the realnet value of the property in any given period. Civilian hospitals practice this process ofdepreciation.
Currently, depreciation of property is not practiced by the military. When a military organizationbuys capital equipment, the total cost is incurred at that period. This overstates capital equipmentexpenditures during a period and overstates the value of capital equipment.
There is now an interest within the DoD to include the practice of property depreciation in its asset
management.
DISCUSSION
Performing Medical Logistics includes the procurement, maintenance, and repair of depreciableproperty. Equally important, it includes capturing related cost. The TO-BE model must address theinterface between logistics and financial functions in depreciating property.
7-4
RESOLVE IDENTIFICATION OF DURABLE SUPPLY ITEMS
I BACKGROUND
Currently medical equipment and supplies are identified by one of three accounting requirementcodes N(non expendable), D(durable), E(expendable). These codes are used to determine the levelof property accountability an item receives.
j DISCUSSION
There appears to be little value in the classification of durables. The items which carry a D* classification do not appear to require the restrictive issue controls or the more expensive property
accountability and contract methods utilized with non expendable items. It appears that theelimination of the D classification and movement of these items into the E grouping would be agood business decision.
II
It
IS7-5
CUSTOMER CRITICAL ITEM MANAGEMENT
BACKGROUND
Currently, materiel managers manage a list of materiel items considered critical for the organization.This critical list of items is based on organization mission or local commander's requirement tonever be without certain item,. Current legacy systems are not capable of customizing such a list.
DISCUSSION
Manual or automated systems can be configured to provide the most efficient system of managingmateriel inventories. Such systems, however, rely on number and frequency of materiel issue toderive efficient and effective inventory levels. The TO-BE model should allow management toidentify items that their organization deems critical to effective operation.
7-6
STANDARDS FOR FACILITIES
BACKGROUND
There is currently no centralized source of information for all the mandated standards required byvarious (government or non-government) agencies in building fully functioning medical facilities.Facility managers must work with various agencies (i.e., local, state, federal, OSHA, JCAHO) toensure that facility projects comply with their standards.
DISCUSSION
The Medical Logistics community already has standards for equipment and supplies. Sinceproviding Medical Logistics support includes cradle-to-grave management of facilities, standards forthis commodity should be incorporated into the TO-BE model.
I
I
|
1 7-7
equipment item are open awaiting parts from organizational supply during the period.
6-4
CODE DECOMEPOSITION
BACKGROUND
Legacy systems are full of codes which alone or in combination with other codes provide certaintypes of information related to materiel items. During the AS-IS logical data modeling workshopsome of these "smart codes" were decoded. Many of the codes appear in the model under severaldifferent names.
DISCUSSION
Each service legacy system has different alpha or numeric codes for the same data. To ensureconsistent data accumulation across the services, these "smart codes" must be decomposed,reviewed, and incorporated into the TO-BE model.
7-8
EQUIPM[ENT AUTHORIZATION, BUDGET REQUEST,AND FACILITY AS TYPE OF ORDER LINE
BACKGROUND
In the AS-IS logical data model, equipment authorization, budget request and acquisition of facilitycan be acquired through the entity called Order-Line. This was based on the DFAS definition of anOrder-Line which is the entity that processes requests for goods and services.
DISCUSSION
Since this is DFAS driven, it may be necessary to discuss this issue with DFAS staff. A completeattribution of these Order-Lines will occur in the AS-IS or TO-BE data model.
7
II
i
1 7-9
WAREHOUSE LOCATION PLANOGRAPH
BACKGROUND
During the Data ModelnL-g session, the group identified the need for a warehouse plaaaograph thatcan provide and graphically represent warehouse storage spaces and layouts. Such storagerepresentation furnishes materiel managers with the ability to identify and assign appropriatelocations for different types of materiel.
DISCUSSION
A warehouse planograph that provides a detailed graphical representation of storage spaces andlayouts will assist materiel managers in the management and storage of their materiel assets.Storage spaces for items requiring special handling (e.g., acid, narcotics, gold, silver) should beclearly identified in the planograph. Currently, storage planographs are not available. Incorporatingthis into the TO-BE model will enable materiel managers to efficiently utilize their storage spaces.
7.-10
I
Section 8Legacy Systems Matrix
During the analysis of current business practices, data elements from the legacy systems were mappedto entities of the AS-IS logical data model. This Section contains the AS-IS data model entities listed inalphabetical order and relates them to the corresponding legacy systems and associated data.
8
I
j
iIIIII
j 8-I
x m -x-
- x x
x x
ou x xx x Xx Xa = Com-m = -
xxxx x xxix x
x I
040
0
0 0 000
9-2
-~ W -2 -A - -
S.. . • . • ..:•... ::".-. ,-.• - - - - = = -. =
-- -• wo u A4 -inmin
-.-.-
8-3~
I.
- = - = = - - = - - I = - - I = -. * -
= = = = - m �--mm
--- -= = ------- =_________j I== ---- ==== --- =
-------------- =
- - x
----- --- === =I=== ====== ---Jr ii 1
I', II 11 _ 1-- 11= = =� III I J �
� �-�- �---=-=. *=-= - _
I0
I ,�IEuu�3jEV
U� �/) ri� �
S I I I I
______ IIIIIIIII:1211- --- m m m - �
8-4
__
I
-.... = = == -
4A- - - - - =
" _-_I_'__ I;:-- -- *• - _ _,
Ix
oz
iiS. I R I
I "<" "<+ <~ <<< • '
8-5
•-1 = - - - - 1= -
.' --,- = t .= = • ".¸
•6 [M_ _ 4n. .
u - - = = = - -. .__,_ I _II_ H•
-.- - - -. =,-.- -' , "..,
"•8I
S! 0
_____31 11 11 13 g1
1- m9 -v -. m -
otI
= = = = = m - - -
~~Zx
= 0-- - - - =
8-7- - - = =
it.•
8.-8
ix
x -
__ __ _ I: I = OZ 01LI0______..L119
-0 040
LiLi I[EDI- I
_KZR ilz111:1:~u LLiF l 'IU~g~ liii] >IIIHLI
______ Ipi IPEl z
0ZZZZZZZZZZOn 0
8-10
* - = - = - = -= -=
0 iT x
I -- A= X
=1- 11=x x x xxI- -C 2 - = wI =
x
=u =- -= .±Hi iELIjKc
t ~ lixI! 'I(JOW~ -I-
wQ :iI : :ý 0
x U -A
-- - -- -A x
EiLLLILIE:_IVFiI111L
= = = = =
OX
w>CA.(48-12
Ii
I
---------- ----
I - - -i,-,- -,, , - =, .... - ,, -
__ _ _ _ I-- - - - -- -
- -- ====
I.v
A. -t- w --
____I ' I I"..X- - X---X
SI
8-14
Iz=~ -
x -0 x x
====x = x--
UIo1
8-15 -= -
tI
This Page Intentionally Left Blank
8-16