Code Monkey home page Code Monkey logo

itdb-schema's Introduction

IT Collect-schema

This Github repository is supplied by GSA for the IT Portfolio Management (ITPfM) Community in support of modernized IT Collect API. Here ITPfM developers can find the latest ITPfM policy Guidance and the API Schema specs that show the direction of IT Collect data architecture. The repository’s aim is to provide real-time updates to the IT Collect API. It will serve as living documentation of the latest changes.

  • Community members should be able to download the latest A-11 Section 55, and find the BY 2025 Submission Overview on the IT Dashboard.
  • Community members should be able to view the IT Collect BY 2025 ITPfM API Schema.
  • Community members should be able to view the former IT Collect BY 2024 ITPfM API Schema.
  • As changes are made by IT Collect developers, the Open API spec will be automatically updated.
  • Members of this repository receive alerts when files are updated, assuming they subscribe to GitHub notifications.
  • A core team will monitor this repository for issues, questions and pull requests and will respond as issues and questions are raised and changes are proposed.

IT Collect Documents

IT Collect How-To Guides and FAQ documents can be found in the IT Collect Docs folder in this repository. You can expect existing documents to be updated and new guides to be uploaded occasionally. We will communicate new document releases with the vendor community.

Asking questions and getting help

We encourage the IT Collect community to comment and ask questions here on GitHub. Go to the Issues and add comments and questions. If you wish to contribute to the code base please fork this repository and, after committing your changes to the schema files, create a pull request. As issues are updated, community subscribers will receive automated updates from Github. You can check the status of your issue by visiting the issue page.

We recommend the following format for submitting issues:

  • Name: Your name here
  • Organization: Your organization here
  • Urgency: Critical/High/Medium/Low
  • Description of Issue: Describe your issue here
  • Associated Links: Put internal and external links to resources or data related to this issue here

When submitting issues on GitHub, do not include any sensitive data. If you have questions or issues pertaining to agency specific data, please directly contact [email protected].

Below you will find documentation outlining the GitHub Issue Process:


itdb-schema's People

Contributors

acharya-upama avatar austin-moffa avatar cdaytcg avatar chrismurphytcg avatar dstevenson-tcg avatar gihavillazon avatar gjmitche11 avatar gperatcg avatar jeremiah-tcg avatar kimlercorey avatar lschwenkebah avatar matthew-tcg avatar mayuri-khatri avatar mitchelltcg avatar ojedanico avatar richardcsmith-itc avatar rydougherty avatar samanthathomas20 avatar samirari avatar scottmccaughey avatar toddtcg avatar tsitsil avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

itdb-schema's Issues

Errors and Submission Scenarios

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Medium
Description of Issue: There are currently two AITPS validation errors that are listed Github, which will prevent Agencies from executing the submission scenarios laid out within the three white-boarding sessions and the following deck released to vendors and the community.

One error prevents eliminated investments from having either BY or CY funding. And another error prevent new investments from having a Prior UII. Is OMB planning on updating these errors?

Data Center ID Submission

Name: Ryan Dougherty
Organization: eCPIC PMO (BAH)
Urgency: Medium
Description of Issue: If an Investment has multiple Data Center IDs associated with it, should the Investment submit multiple nodes under a single investment, or should all Data Center IDs be included within the same node?
Associated Links: None

Investment Report OMB IDs: investmentReportID

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Low
Description of Issue: Underneath the towerDetails node there is space for an investmentReportID node. What is the purpose of this node? Each investment will only submit one Details section, there will never be a need to submit multiple towerDetails nodes per investment.

There is no OMB ID for the investmentDetails, the Business case equivalent of towerDetails.

Investment Report OMB IDs: costID

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: High
Description of Issue: It appears that each Category within the Cost Details table will have an OMB ID associated with it. Is there a reason each Category needs an OMB ID? Presumably no one would submit Transition Services nodes (from the Network Cost Details table) more than once.

The Cost Pools and IT Towers have a similar set up, and they don't have any OMB IDs.

Baseline Change for Standard Investment Reports

Name: Daniel York
Organization: GSA eCPIC PMO
Urgency: High
Description of Issue: Will Standard Investments reports require rebaseline change requests to change certain fields, like the the End User Standard Investment Reports Project table or project table.

Optional Data within the AITPS

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: High
Description of Issue: How should Agencies submit data for optional Cost Pools and IT Towers they wish to omit from their submissions this September?

I have noticed if you drop a CostPool or ITTower parent node (so no Category, PY, CY, and BY nodes) your submission successfully validates. So, presumably you could not report any External Labor or Application if desirable. However, you are unable to report BY values for an individual Cost Pool or IT Tower and omit PY or CY nodes. You are also unable to send blank values within the cost nodes(PY,CY, and BY). Is this by design or should you able to drop any cost node?

Updated Schema for Week of 6/26

Name: Alex Unger
Organization: Booz Allen, supporting eCPIC PMO
Urgency: High
Description of Issue: Is OMB still planning to post an updated schema this week? On last weeks ITDB Developers call, it was said that there'd be an updated schema posted each Monday evening.

Internal Server Error on AITPS Submission

Name: Alex Unger
Organization: Booz Allen, supporting eCPIC PMO
Urgency: High
Description of Issue: When submitting an AITPS Request, the server error below is returned. Note: The XML validates successfully. An email will be sent to the ITDB group with the XML request.

{
"ok": false,
"error": true,
"metadata": null,
"httpStatusCode": 500,
"httpStatusMessage": "Internal Server Error",
"responseTime": 0.60042214393616,
"result": null,
"errors": [
{
"code": 0,
"message": "Fatal Error: Error inserting into itPortfolioTBMAudit table, Error inserting into itPortfolioAudit table"
}
]
}

Submission Tentative Dates

As discussed and committed during the meeting, we are providing the tentative dates below:

  • Final Draft Guidance and A-11 July 31st (tentative)
  • Pre-submission Aug 21 (tentative)
  • Budget Submission Sept 11 (tentative)

Thank You.

Government FTE Nodes

Name: Ryan Dougherty
Organization: eCPIC PMO (BAH)
Urgency: Medium
Description of Issue: Government FTE nodes are still in the Life Cycle Costs table with no indication of switch to the Internal Labor language. Will the nodes continue to reference Government FTEs or will Internal Labor nodes be introduced to the Life Cycle Costs Table and the Internal Labor Cost Pools?
Associated Links: None

TBM Data for Type 04 Investments

Name: Alex Murray
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Medium
Description of Issue: The latest guidance version specified that Type 04 investments will not need to submit IT Tower and Cost Pool data. Will this change be implemented by making those nodes optional for Type 04? Or will these nodes not be accepted for Type 04?

Investment Reports - Validate Only

There isn't a tag to indicate that the submission is validateOnly for the reports like we have for all of the other submission reports. Will we have this option?

Eliminated Investments Funding Breakdown

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Low
Description of Issue: Should eliminated investments with PY and CY funding break out their total PY and CY costs into IT Towers and Cost Pools aside from Security and Internal Labor?

Draft Schema Questions

Name: Ryan Dougherty
Organization: eCPIC PMO (BAH)
Urgency: Medium
Description of Issue: Paperwork Reduction Act OMB Control Number is not included in the Draft Schema. Will this eventually get added to the Investment Details Section? If so, can the Data Type and Text Length also be provided?
Associated Links: None

Working Whiteboard 2nd Session Topics

We hope you all have found much value out of the previous session, and we are continuing to provide the support needed to get the environments ready for FY19.

Any questions or concerns to be discussed during the 2nd whiteboard session please post here.

Thank You.

Warning Message - for CIO Evaluation

Good Afternoon,

As discussed, on the importance of having a warning message for the CIO Evaluation piece of the submissions.
Please provide ideas on what the "Warning" Message should appear as.

We have also opened up a jira ticket as soon as the error message is finalized we will work towards implementing it.

Thank You.

V1.9.4 Updated Schema Changes Synopsis

Tag v1.9.4 created.

Changes since v1.9.3:

IT Budget

  • Made “DataCenterInventory" optional in schema (only required for certain types of investments)

Business Case

  • Added “records management” option to “eliminationReductionType" list

Investment Report

  • Added “contractID" to “contracts" definition
  • Added “investmentReportID" to “towerDetails" definition
  • Added “metricID" to “metrics" definition
  • Added “metricActualID" to “metricActuals" definition
  • Removed “agencyId" from “metrics" definition
  • Removed “agencyId" from “metricActuals" definition
  • Changed “investmentCostDetail” definition from a type reference to a local definition
  • Moved “projectName" in “projects” definition
  • Updated sample files

Data Dictionary

  • Added BRM codes

Investment Reports - Projects, Contracts, and Performance Metrics

It's my understanding that on the Investment Reports, investments can have one to may Projects, Contracts, and Performance Metrics (where applicable...not all investment reports call for these). This is similar to how the Major IT Business Case Details accepts submission. However, there doesn't seem to be a way for us to do that with these reports.

If we're only expected to send/update one record of each type per report - please let me know. Otherwise, we need a method to identify which records we are adding and which we are updating (in the Details report, we use agencyIds (or OMBIds depending on the vendor) and statuses.

Please let me know which direction you will be going in so we can prepare properly. Thanks!

Investment Report - Performance Metrics

My understanding is that the Performance Metrics included in some of the investments reports can have one to many Performance Metric Actuals (similar to the rule in the Major IT Business Case Details report). However, based on the schema you've posted, Metric Actuals are separate from Performance Metrics.

Working Whiteboard session topics

At the session today I would like to spend some time on talking through 'transition' issues from the previous investments submitted to the new submissions.
Can old infrastructure investments be categorized as standard infrastructure? Are standard infrastructure investments expected to get new UIIs? What is the status change from an existing investment broken into standard infrastructure investments? What happens to their 'old' projects and performance measures?

On projects, 'old' closed projects that are closed, will they need to update their SDLC to the new values? Will old values be grandfathered/retained? What if I need to submit a correction later for a project for an actual cost or actual date? Will the SDLC validation flag?

These are the type of questions that can come up after basic new/update investment testing.

Mission Area Reference Table

Name: Ryan Dougherty
Organization: eCPIC PMO (BAH)
Urgency: Medium
Description of Issue: The Mission Delivery and Management Support Area Field in the Guidance states:

"Mission Delivery and Management Support Area [2-digit code] (variable element)
These two digits indicate the mission delivery and management support areas. Agencies should assign a unique code for each mission delivery and management support area reported. Agencies shall provide a reference table for mission areas to the ITDB to include:
o Agency Code [3-digits]
o Mission Delivery and Management Support Area [2-digit code]
o Description [500 characters]"

The guidance doesn't indicate how this will be provided to OMB this year. Will Agencies email it to their desk officers like they did last year? The reference table requirements make it appear as though it will be submitted electronically, but it does not appear in the draft schema.
Associated Links: None

V1.9.2 Updated Schema Changes Synopsis

Please review the changes Below for V1.9.2:

"Tag v1.9.2"

Renamed "updateCIORating" operation as "setCIORating" to distinguish between actual update operations (the former adds to the historical record, while the latter alters an existing record)

Business Case:

  • Added ombControlNumbers to investmentDetails
  • Added solicitationId to plannedAcquisitions
  • Added analysisConclusion to operationalAnalysis
  • Modified SDLCmethodology in projectDetail to use new BY19 options
  • Removed several deprecated fields from lifeCycleCosts
  • Removed EVMRequired from existingContracts
  • Removed securityCostsAndCapabilities section
  • Removed otherSDLC from projectDetail
  • Removed projectedStartDate, projectedCompletedDate and projectedTotalCost from agileProjectActivity

Removed outdated header comments from several files
Updated sample XML, making sure it conforms to current schema
Added sample XML for Standard Investment Reports

For any further questions or clarification please comment back within this thread.

Thank You.

Number of Required Performance Metrics for Standard IT Investment Reports

Name: Daniel York
Organization: GSA, eCPIC PMO
Urgency: Medium
Description of Issue: The 95% FY19 IT Budget Guidance states that Network and End User Standard Investment Reports must provide a minimum of five performance metrics. In a Q&Z session with agencies, members of OMB OFCIO have said that it was OMB's intent not to set a required number of performance metrics for the Network and End User Standard Investment Reports. Will the v.1.9 xsd release candidate (set to be released on July 5th) include any requirements for the Network and End User Standard Investment Reports to have any number of performance metrics aligned to of of the Performance Measurement Categories?

Standard Investment coding tin the IT Portfolio

Name: Tom Milligan
Organization: Treasury
Urgency: High
Description of Issue:
Treasury will not implement the optional Standard reports for Network, Data Center, and End User for the BY19 submission.

In this case are the following combinations valid?

Standard Investment

(ITP 6) Part of Agency IT Portfolio Summary

(ITP 7) Standard IT Infrastructure and Management Category

(ITP 9) Type of Investment

N/A

Part 1

01: Not Applicable

01: Major IT Investments
02: Non-major IT Investments
03: IT Migration Investment
04: Funding Transfer Investments

N/A

Part 2:

01: Not Applicable

01: Major IT Investments
02: Non-major IT Investments
03: IT Migration Investment
04: Funding Transfer Investments

IT Security and Compliance

Part 3

02: IT Security and Compliance

05: Standard IT Infrastructure Investment

IT Management

Part 3

03: IT Management

05: Standard IT Infrastructure Investment

Network

Part 3

01: Not Applicable

06: Non-Standard Infrastructure Investment

Data Center and Cloud

Part 3

01: Not Applicable

06: Non-Standard Infrastructure Investment

End User

Part 3

01: Not Applicable

06: Non-Standard Infrastructure Investment

Output

Part 3

01: Not Applicable

06: Non-Standard Infrastructure Investment

Application

Part 3

01: Not Applicable

06: Non-Standard Infrastructure Investment

Delivery

Part 3

01: Not Applicable

06: Non-Standard Infrastructure Investment

Costs and Capabilities Nodes

Name: Ryan Dougherty
Organization: eCPIC PMO (BAH)
Urgency: Medium
Description of Issue: Costs and Capabilities Table is still in the Schema for the Major IT Business Case, albeit as an optional set of nodes. Will the Costs and Capabilities nodes be removed from the Major IT Business Case?
Associated Links: None

AITPS Validations

Name: Ryan Dougherty
Organization: eCPIC PMO (BAH)
Urgency: Medium
Description of Issue: When performing AITPS Validations (validateOnlyIndicator=”true”) if there are no errors returned in the response file, then, regardless of whether warnings should get returned, no warnings will be returned in the response file. If there are errors returned or if you are submitting (validateOnlyIndicator=”false”), warnings will get correctly returned where applicable. In other words, if I am validating the AITPS and I address all the issues that are triggering errors, I will no longer be able to see what warnings are getting triggered until after I have submitted.
Associated Links: None

New Capability Codes

Name: Alex Murray
Organization: eCPIC
Urgency: Medium
Description of Issue: The current schema does not outline the enumerations for the new capabilities within the Costs and Capabilities table. In order to update our template for this table, we need the codes that will be associated with each new capability. Is there a timeline for publishing these codes?

CIO Rating Submissions

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Medium
Description of Issue: Was there a final decision regarding whether or not the CIO Rating will be submitted separately from other files? For example, will the CIO Rating still be submitted as part of the the Business Case in the Annual?

IT Budget and Business Case Synchronized Data

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: High
Description of Issue: After successfully submitting an IT Budget to the myuat-2019 Dashboard, I am unable validate or submit any investments through the Annual Operation. I was able to submit a sample IT Budget and verify a successful save through the GetITBudgetReport operation. However, when attempting to perform a annual update for one of the investments in my portfolio, I receive the following error:

<sr:message level="error" xpath="/tns:operations[1]/tns:investmentInformation[1]/tns:annualSubmission[1]/tns:updateInvestment[1]">IT Budget does not have a record for unique investment identifier 011-000002502</sr:message>

Kim Test

This is just a test to see if I can enter an issue and see it's status.

Draft FY19 AITPS submission process

Name: Daniel W. York
Organization: GSA, eCPIC PMO
Urgency: Medium
Description of Issue: The 95% FY 19 IT Budget Guidance says "Details and instructions for submitting the verification of eGov/LoB contributions and the Draft Agency IT Investment Portfolio Summary will be forthcoming." Can OMB OFCIO expand on how it will be expecting to collect the Draft FY19 AITPS submission from Agencies? In the past OMB has asked for this data in a number of ways from posting them to an OMB MAX page, to emailing them to their OFCIO Desk Officer, to submitting them via API to the ITDB. The answer to this question may impact the prioritization of work items for CPIC Vendors, especially if OMB OFCIO is planning to ask for Agency Draft FY19 AITPS submission via API.

Input Controls

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: High
Description of Issue: The Input Controls (Character Count Restrictions) are still undefined for several of the new fields associated with the Standard Investment Reports. The three Acquisition Strategy fields within the Future Contracts Tables, and the two Brief Description fields located in Projects Tables are defined as only "Text" fields.

V1.9.3 Updated Schema Changes Synopsis

Please review the changes Below for V1.9.3:

Tag v1.9.3 created.

Changes since v1.9.2:

No code changes (all commits changed comments and whitespace only)

We have been working hard to QA Validations.

BY19 Schema Questions

Name: Sriram Avasarala
Organization: Treasury
Urgency: High
Description of Issue:
Hi,

We have following questions regarding draftBY19 schema. Can you please review them and provide the response?

A. IT Towers: Fields 56 to 85 (part 1 and part 2 investments) These fields are optional and required based on various validations. Our question is whether we need to include them in XML with zeros or not when they are optional.

  1. Does OMB expect us to submit XML with all IT tower categories? For example : If I have an investment that has only Data Center Cost, how do we submit the data Option A or Option B
    A) Total Data Center Cost PY, Total Data Center CY and Total Data Center BY with values and rest of the IT Towers with zero values.
    B) Total Data Center Cost PY, Total Data Center CY and Total Data Center BY with values and no need to submit the rest of the IT Towers with zero values

  2. How do we submit the updates to IT towers? Does it work similar to Funding Source Line Items? For example : If we submit with Data Center Cost IT Tower in September 2017 and if we want to replace Data Center Cost with Compute Cost IT Tower, how do we submit the data in Jan 2018
    A) Total Data Center Cost PY, Total Data Center CY and Total Data Center BY with zero values and Total Compute Cost PY, CY and BY values
    B) Total Compute Cost PY, CY and BY values and no need to include Data Center Cost with Zero values

B. Valid submission : Can you please validate the following Part , Type and Standard Investment combination and let us if this combination (IT Portfolio) is allowed to be submitted or not? Can we submit the optional business case for this IT Portfolio combination?

Part of the IT Portfolio Investment Type Standard Investments
Part 3 6 - Non-Standard Infrastructure Investments Network
Part 3 6 - Non-Standard Infrastructure Investments Data Center and Cloud
Part 3 6 - Non-Standard Infrastructure Investments End User

C. As per the baseline validations (BY19 CPIC Validations List.xlsx.pdf) released last week, the following combination is invalid and not allowed to submit the Business Case, Investment Report and CIO Rating. If we have a Part 3 security investment with projects and metrics, what options should we choose on IT Portfolio so that the Business Case and CIO Rating report submission are allowed.

Part of the IT Portfolio Investment Type Standard Investments Status
Part 3 1 - Major IT Security & Compliance Invalid
Part 3 5 - Standard Infrastructure Investments IT Security & Compliance Not Allowed

Thanks,

Sriram Avasarala
IT Specialist
Digital Services
Enterprise Business Solutions
Office of the Chief Information Officer
U.S. Department of Treasury
Customer Support: 202-622-5555
Office: 202-622-6643
Mobile: 202-486-2610
Submit a WebTrack Ticket

Expiration of UAT Tokens

Name: Alex Unger
Organization: Booz Allen, supporting eCPIC PMO
Urgency: High
Description of Issue: Currently the MyUAT-2019.itdashboard.gov tokens have a 12 hour expiration. Could the ITDB group extend the expiration of these UAT tokens to at least a week?

Cost Detail Category Enumerations

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Medium
Description of Issue: In the updated Example files for the Investment Reports posted yesterday it insinuates that the Category field within the Cost Details tables will submit a code value to the IT Dashboard, instead of the the category name. Is this by design? If so, is OMB planning on releasing an updated enumerations document listing the Category to Code conversions?

Tags Missing in MITBC

In testing and reviewing the MITBC, it seems that the planningBudgetaryResource and dmeBudgetaryResources tags are no longer allowed. Will this be fixed?

MITBC - Replaced Contracts

Based on the documentation I've reviewed, replacedContracts should be optional, but in testing MITBC validations, I'm getting errors indicating those tags are expected and required.

Investment Report OMB IDs: projectID

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Low
Description of Issue: Within both the Network and End User Projects Tables, there is a Project ID field. It is therefore unclear whether or not the projectID field in the xsd represents the Project ID field in the guidance or the OMB ID for that row item.

The business case solves a similar dilemma by having both a projectID field (OMB ID) and a uniqueProjectID field (field listed in Guidance).

Capability Codes

Name: Ryan Dougherty
Organization: Booz Allen, supporting eCPIC PMO
Urgency: Medium
Description of Issue: The 95% XSD for the Investment Report shows Security investments will submit values for both the NISTFrameworkCategory and the capability, for each item in the Cost and Capabilities table. Last year, only the capability codes where submitted for each item within the Cost and Capabilities table. Each capability code acts as a unique identifier on its own. Is OMB planning on requiring the NISTFrameworkCategory submissions?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.