Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Data Steward data fields into business system report #483

Open
hatfieldjm4 opened this issue Sep 16, 2024 · 2 comments
Open

Add Data Steward data fields into business system report #483

hatfieldjm4 opened this issue Sep 16, 2024 · 2 comments
Assignees
Labels
application A task/issue involving work on the application code database A task/issue involving work on the database documentation Improvements or additions to documentation

Comments

@hatfieldjm4
Copy link
Collaborator

We are now receiving 2 new data fields from the Archer XML export:

  • ex:Data_Steward_Full_Name
  • ex:Data_Steward_Email

We will need to add these fields to:

  1. the obj_fisma_archer table in the database
  2. the API that feeds the business systems report,
  3. the business systems list view (i.e. report view),
  4. the business systems modal (in the business tab, in the "Points of Contact" table -- list these 2 new fields last in this table),
  5. the data dictionary,
  6. the API documentation
@hatfieldjm4 hatfieldjm4 added documentation Improvements or additions to documentation database A task/issue involving work on the database application A task/issue involving work on the application code labels Sep 16, 2024
@hatfieldjm4 hatfieldjm4 self-assigned this Sep 16, 2024
@hatfieldjm4
Copy link
Collaborator Author

hatfieldjm4 commented Sep 16, 2024

SQL script for adding the 2 new fields:
ALTER TABLE `gear_schema`.`obj_fisma_archer` ADD COLUMN `ex:Data_Steward_Full_Name` VARCHAR(100) NULL DEFAULT NULL AFTER `ex:ContractingOfficer_Representative2_eMail`, ADD COLUMN `ex:Data_Steward_Email` VARCHAR(100) NULL DEFAULT NULL AFTER `ex:Data_Steward_Full_Name`;

This has already been added to dev. We will need to add it to prod once tested in dev.

@hatfieldjm4 hatfieldjm4 moved this from Backlog to In progress in Deploy GEAR 3.0 Sep 16, 2024
hatfieldjm4 added a commit that referenced this issue Sep 16, 2024
…t (list) view, and modal view. This satisfies issue #483
@hatfieldjm4 hatfieldjm4 moved this from In progress to Needs Review in Deploy GEAR 3.0 Sep 16, 2024
@hatfieldjm4
Copy link
Collaborator Author

The SQL script to add the 2 new data steward fields have been executed in both the dev and prod databases.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
application A task/issue involving work on the application code database A task/issue involving work on the database documentation Improvements or additions to documentation
Projects
Status: Needs Review
Development

No branches or pull requests

1 participant