Format for Organizational Hierarchy Build Excel spreadsheet format. The spreadsheet includes the UIC of each serviced activity (CHILD) and “report to” (PARENT). CPOCs are responsible for building/validating the organizational hierarchy. Example of the Excel spreadsheet: A
B
AGCY/CMD
child UIC
C t38_city_base (Cleatext for Child UIC)
D
E
parent
parent
uic
t38_city_base (Cleartext for Parent UIC
F t38_county (Cleartext for Child)
G gsa geoloc (Child UIC)
ACTION: ADD EFF 01-JAN-2002 ARX7 ARCB ARCB
W4GH10 US ARMY TANK-AUTOMOTIVE&ARMAMENTS CMD WCWCAA HEADQUARTERS, 88TH MILITARY POLICE DET WCWC99 AUGMENTATION, 88TH MILITARY POLICE DET
W4GG21 TACOM ROCK ISLAND W0ATAA HQ U.S. ARMY JAPAN IX TAACOM W0ATAA HQ U.S. ARMY JAPAN IX TAACOM
BRISTOL, UK ZAMA, JAPAN ZAMA, JAPAN
UK1030000 JA9900000 JA9900000
US ARMY GARRISON, FORT MONROE
W3YTAA HQ US ARMY TRADOC CMD
FT MONROE, VA
511013650
US ARMY GARRISON, CARLISLE BARRACKS
W3YTAA HQ US ARMY TRADOC CMD
CARLISLE BARRICKS, VA
421105041
USA FIELD ARTILLERY CENTER & FORT BLISS
W0VHFF HQ USA AD ARTY CEN
FORT BLISS, TX
482433141
USA AIR DEFENSE CENTER, FORT BLISS
W0VHFF HQ USA AD ARTY CEN
FORT BLISS, TX
482433141
ACTION: CHANGE EFF 01-MAR-02 ARTC ARTC
ARTC ARTC
OLD W0UUAA NEW W0UUAA OLD W0VHAA NEW W0VHAA
FOR INFO ONLY - EXAMPLE OF A COMPLETE UIC HIERARCHY FOR UIC W0MT89 (CHILD THRU END OF CHAIN) IN MODERN. Note that the parent in this Example become a child and so on until the end of chain. ARTC ARTC ARTC ARTC ARTC ARTC ARCS ARCS
W0MT89 W0MT90 W0MT91 W0MTAA W4SYAA W3YTAA W0ZUAA W00EAA
MARSHALL UNIVERSITY (ROTC) WEST VIRGINIA STATE COLLEGE (ROTC) WEST VIRGINIA UNIVERSITY (ROTC) USA FIRST ROTC PROGRAM US ARMY ROTC CADET COMMAND HQ US ARMY TRADOC CMD CHIEF OF STAFF ARMY SECRETARY OF THE ARMY
W0MTAA W0MTAA W0MTAA W4SYAA W3YTAA W0ZUAA W00EAA DDAAAA
USA FIRST ROTC PROGRAM USA FIRST ROTC PROGRAM USA FIRST ROTC PROGRAM US ARMY ROTC CADET COMMAND HQ US ARMY TRADOC CMD CHIEF OF STAFF ARMY SECRETARY OF THE ARMY OFC SEC OF DEF
HUNTINGTON, WV INSTITUTE, WV MORGANTOWN, WV FORT BRAGG, NC FORT BRAGG, VA FT MONROE, VA WASHINGTON, DC WASHINGTON, DC
Column definitions: A = Agency Code/Sub-agency owning UIC (4 character in length) B = UIC of Child (6 Character in length) C = Clear text of Child UIC (Limited to 38 characters including spaces) D = UIC of (the report to) PARENT 6 Character in length)
E = Clear text of PARENT UIC (Limited to 38 characters including spaces) F = City/Town/Base/Fort & State of CHILD UIC (Limited to 25 characters including spaces) G = Geographic Location Code of Child UIC (9 Character code) (geoloc is from OPM table. For Overseas Location, the last three ‘3’ must = 000)
Note: First example: Request to add a child to the chain that already exists. Second example: Change request to an existing UIC. Third Example: Complete hierarchy from child thru end of chain.
541270011 541305039 541840061 371685051 371685051 511013650 110010001 110010001