Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
DCN: 10305
TABS TABS Data Data Overview Overview
Data support Team 25 June 2004
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
1
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Learning Outcomes Desired At the Completion of This Block of Instruction, TABS Analysts Should Know: • The Status of Installation Data Calls. • How to Gain Access to RPLANS, ASIP, and ISR. • The Requirements for Certifying and Maintaining Other Source Data. • Current Plans for Accessing the TABS Database
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
2
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Learning Outcomes Desired At the Completion of This Block of Instruction, TABS Analysts Should Know: ü The Status of Installation Data Calls. • How to Gain Access to RPLANS, ASIP, and ISR. • The Requirements for Certifying and Maintaining Other Source Data. • Current Plans for Accessing the TABS Database
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
3
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Status of Installation Data Calls Data Call #1--Capacity • Original Data Call – 548 questions released on 5 Jan 04 – Certified on 29 Mar 04 • Changes – 191 questions updated – Posted at J:Data Changes/Army DC1 Changes • New Capacity Questions - H SA (23) - Medical (9) - Industrial (132) - E&T (69) - S&S (none to Army) Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
4
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Status of Installation Data Calls Data Call #2—Military Value • Phase I (TABS Questions) –
35 questions released on 20 Apr 04
–
Certified on 7 Jun 04
• Phase II (JPAT 7, JCSG, JAST) – JPAT 7 (10), Medical (57), S&S (58): released on 4 Jun – H SA (23) & Industrial (350): released on 18 Jun – E&T (161): awaiting final coordination CD from OSD – Technical (30): TABS reviewing questions – JAST: AF (72), Navy (106)
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
5
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Learning Outcomes Desired At the Completion of This Block of Instruction, TABS Analysts Should Know: ü The Status of Installation Data Calls. ü How to Gain Access to RPLANS, ASIP, and ISR. • The Requirements for Certifying and Maintaining Other Source Data. • Current Plans for Accessing the TABS Database
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
6
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Gaining Access to RPLANS, ASIP, and ISR • RPLANS – TABS RPLANS has been loaded on your machine – I have the list of your login and password – Help Desk number (540) 343-4154 • ASIP – Apply for account at ASIP.HQDA.PENTAGON.MIL – Help Desk (703) 561-4078 – Mike Maguire is our resident expert! • ISR – Accounts being created for you (you will receive e-mail from ISR WEB with you account information
– All accounts should be created by 2 July – Information about ISR contact Doug Macherey at (703) 377-0508
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
7
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Learning Outcomes Desired At the Completion of This Block of Instruction, TABS Analysts Should Know: ü The Status of Installation Data Calls. ü How to Gain Access to RPLANS, ASIP, and ISR. ü The Requirements for Certifying and Maintaining Other Source Data. • Current Plans for Accessing the TABS Database
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
8
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Requirements for Certifying “Other Source” Data • Data from non-DoD sources (e.g. Census data) – Data certified as to the source by analyst – Hard copy of signed memo and data for file record • Data provided from DoD databases – Data certified by the proponent of the database (GO level) – Hard copy of signed memo and database printout for record • Data from DoD sources (e.g. DoD Pricing Guide) – Data certified by analyst – Hard copy of memo and data printout for record • Derived data – Data that is converted into “derived data” through the application of a formula or inclusion in a matrix
– Data certified by analyst – Hard copy of memo and computations for record Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
9
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Learning Outcomes Desired At the Completion of This Block of Instruction, TABS Analysts Should Know: ü The Status of Installation Data Calls. ü How to Gain Access to RPLANS, ASIP, and ISR. ü The Requirements for Certifying and Maintaining Other Source Data. ü Current Plans for Accessing the TABS Database
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
10
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
The Army’s Data Collection Process Prepare DEs and Questions
Coordinate, Task, and Monitor
TABS TABS (BRAC (BRACOffice) Office) HQ HQIMA IMA// MACOMs MACOMs
ODIN ODIN Database Database
Analytical Analytical Database Database
Extract Relevant Data
Analyze
Review
IMA IMARegions Regions
Distribute Questions
Installation Installation Command Command Functional Functional Proponents Proponents
AAA AAA Review and Certify
üüWeb-Based Web-BasedCollection Collection üüCertified Certifiedthroughout throughout the thecollection collectionprocess process üüAAA AAAAudited Audited
Answer Questions
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
11
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Data Migration Process Full FullODIN ODIN Database Database (Oracle) (Oracle)
Certified CertifiedData Datain: in: -Oracle -Oracle --Collection Collectionstructure structure
Extract Certified Data
Transform data structure and database format
Certified CertifiedData Datain: in: -MS SQL Server -MS SQL Server --OSD OSDstructure structure
Analytical Analytical Database Database Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
12
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Analytical Database Overview •
Relational database built on Microsoft SQL Server product suite – Hosted at IMCEN – Maintained by TABS with assistance from VISTA
•
Accessibility – MS Access user interface – Only from inside local network – ARDA account holders
•
Interface functionality – Update data based on field input – Create data file to export to OSD – View data for analysis – Export data to MS Excel Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
13
Draft Deliberative Document – For Discussion Purposes Only – Do Not Release Under FOIA TRAINING PURPOSES ONLY
Learning Outcomes Desired At the Completion of This Block of Instruction, TABS Analysts Should Know: • The Status of Installation Data Calls. • How to Gain Access to RPLANS, ASIP, and ISR. • The Requirements for Certifying and Maintaining Other Source Data. • Current Plans for Accessing the TABS Database
Transforming Through Base Realignment and Closure
[email protected] (703) 696-9588
14