Treasury Symbol Agreement Validations FY17 February Release User Training

1. Treasury SymbolAgreement ValidationsFY17 February Release User Training February 22, 2017

2. Training Agenda Total Training Time  1 hour Introduction  5 min Agreement Validations & Transmission Revisions  10 min OMIS Application Changes  15 min ITSS Funding Application Changes  15 min Reporting Changes  10 min Questions  5 min

3. Release Details Production Release – February 23, 2017 • Cutover – as of February 24th, changes take effect Post Release Support • Portal announcement, posted 2/24 • Release Notes, posted to portal 2/24 • Training deck, after training & will post to portal week of 2/27 • Live Training Session #2, 2/28 • Training Docs, week of 2/27 posting to portal • Training Videos, mid March posting to Vimeo; link to be provided on portal • Help desk support • akimpo@techflow.com

4. Treasury Symbol Treasury Symbol – also referred to as Treasury Account Symbol • A single code comprised of eight different component values used by the treasury to identify critical information about financial transactions reported (i.e. regulatory code) • Examples - [057 X1007000] // [2201905720172017 1007000] // [019057 X1007004] • For more information, check the Treasury site https://www.fiscal.treasury.gov/fsservices/gov/acctg/cars/factsheet_tas.htm • It is always best to consult with LOA codes provided by clients as there are thousands of valid TSYM component combinations • If valid TSYM component combinations are not available in Pegasys, they may be added by contacting the Financial Services Division (FSD) managers who will submit the request for addition Component Treasury Symbol Individual Components  8 separate fields • Customer Sublevel Prefix (SP) + Allocation Transfer Agency (ATA) + Requesting Agency (AID) + Beginning Period of Availability (BPOA) + Ending Period of Availability (EPOA) + Availability Type + Main Account (Appropriation) + Sub Account

5. Project Drivers Project drivers • Enable users greater flexibility to enter TSYM component values directly onto funding artifacts (OMIS Funding Documents & ITSS Funding Citations) • Reduced support intervention to modify funding artifacts and resolve agreement errors • Reducing agreement errors reduces billing file errors as billing files include the same TSYM fields present on funding artifacts • Implement validations that identify and flag funding artifacts that contain invalid TSYM component values • Modify agreement transmissions to Pegasys to include all TSYM values saved directly to funding artifacts • Provide reports to assist users with invalid TSYM error resolution and research

6. Agreement Validations Logic and Application • Evaluates TSYM component values entered on funding artifacts and compares them against the TSYM lookup table from imported from Pegasys • Funding artifacts are flagged and error messages displayed to users • Displayed after funding artifact creation, in view mode, in active-edit mode, and after edit • Agreements with TSYM errors will still transmit to Pegasys and be allowed to error • Errors display on Agreement Transactions Page, BAAR History Report and BAAR Rejected Reports • When TSYM errors are present, users will not be able to adjust funding amounts • OMIS Adjust Funding Amount link • ITSS Funding Create Amendment button not displayed Exceptions to Agreement Validation Logic • Validations do not apply to funding artifacts for internal agreements • Validations do not apply to funding artifacts for SAF agreements until restriction removed • Validations do not apply to funding artifacts for single year and multi-year agreements that have EPOA values older than 6 years from the current fiscal year

7. Agreement Transmission Mapping from AASBS Funding Artifacts

8. Agreement Transmission Enhancements – External Agreements Transmission Changes • Customer Sublevel Prefix – added to transmission; taken from funding artifacts • Allocation Transfer Agency – value transmitted from funding artifacts; changed from NULL transmission • Availability Type – value transmitted from funding artifacts; changed from hardcoded NULL or ‘X’ values Subject to Availability of Funds (SAF) Agreements • TSYM values are not transmitted when SAF restriction is on, TSYM validations will not apply, and agreement line amounts will not transmit • Once removed, the TSYM values will transmit, TSYM validations will apply, and agreement line amounts will transmit Agreements with EPOA > 6 fiscal years ago • TSYM values are not transmitted for single or multi-year agreements where the EPOA is more than 6 years older than the current fiscal year; TSYM validations also do not apply • Treasury drops valid TSYM combinations after 6 years

9. TSYM Fields on OMIS Funding Documents New fields • TSYM Allocation Transfer Agency • TSYM Customer Sublevel Prefix • TSYM Availability Type Existing fields modified • Treasury Sub Account Existing fields unchanged • Requesting Agency • Appropriation • Funds Available From • Funds Available To

10. OMIS Funding DocumentTSYM Customer Sublevel Prefix New Optional Field • Must either be blank or a 2-digit numeric value • Form level validations display below the field when clicking away from the field and one of the following conditions are met: • Alpha characters are entered • Blank spaces are entered • Single digit numeric value entered • Any combination of blank spaces, alpha, and numeric values

11. OMIS Funding DocumentTSYM Allocation Transfer Agency New Optional Field • User selects the value using an agency drop down list; values are populated in the list from the TSYM lookup table values • The drop down values are displayed when the user selects the drop down arrow • Values selected are removed by selecting the ‘Choose One’ value from the list

12. OMIS Funding DocumentTSYM Availability Type New Optional Field • Only active when LOA Type of Funds ‘No Year’ drop down value selected; inactive otherwise • Defaults to value of ‘X’; single digit value accepted; can be blank • Blank space will be normalized to complete blank value • Lower case letters will be normalized to upper case • A form level validation displays below the text entry field when entering a value that is not blank or alpha-numeric • Soft validation displays in a pop up when saving funding doc and field value is blank • YES continues with save; NO returns user to form without saving

13. OMIS Funding DocumentTreasury Sub Account Modified Existing Required Field • Must be a 3-digit numeric value • Defaults to ‘000’ • Changed from a drop down list to a text entry field • Field is now editable after creating the funding document • Form level validations display below the field when clicking away from the field and one of the following conditions are met: • Completely blank • Alpha characters are entered • Blank spaces are entered • 1 or 2 digit numeric values entered • Any combination of blank spaces, alpha, and numeric values

14. Agreement Validation Messages & Funding SummaryOMIS Funding Documents After Saving (Create and Edit) & in View and Active-Edit Modes • Displayed in a yellow banner after saving when the user is returned to the funding summary; slightly different text between create, edit and view New TSYM Field Values have also been added to Funding Summary

15. TSYM Fields on ITSS Funding Citations New fields • TSYM Availability Type • TSYM Allocation Transfer Agency • TSYM Customer Sublevel Prefix Existing fields modified • Treasury Sub Account Existing fields unchanged • Requesting Agency • Appropriation • First FY Available • Last FY Available

16. ITSS Funding CitationTSYM Customer Sublevel Prefix New Optional Field • Must either be blank or a 2-digit numeric value • Form level validations display in a pop up when saving citation and one of the following conditions are met: • Alpha characters are entered • Blank spaces are entered • Single digit numeric value entered • Any combination of blank spaces, alpha, and numeric values

17. ITSS Funding CitationTSYM Allocation Transfer Agency New Optional Field • User selects the value using an agency list pop up; values are populated in the list from the TSYM lookup table values • The pop up list is displayed when the user select the ‘Pick From List’ button • Values selected are removed by selecting the ‘Clear’ button

18. ITSS Funding CitationTSYM Availability Type New Optional Field • Only displayed when LOA Type of Funds ‘No Year’ radio button selected; hidden otherwise • Defaults to value of ‘X’; single digit value accepted; can be blank • Blank space will be normalized to complete blank value • Lower case letters will be normalized to upper case • Form level validation displays in a pop up when saving citation with a value that is not blank or alpha-numeric • Soft validation displays in a pop up when saving citation and field value is blank • OK continues with save; Cancel returns user to form without saving

19. ITSS Funding CitationTreasury Sub Account Modified Existing Required Field • Must be a 3-digit numeric value • Defaults to ‘000’ • Changed from a drop down list to a text entry field • Form level validations display in a pop up when saving citation and one of the following conditions are met: • Completely blank • Alpha characters are entered • Blank spaces are entered • 1 or 2 digit numeric values entered • Any combination of blank spaces, alpha, and numeric values

20. Agreement Validation Messages ITSS Funding After Saving (Create and Edit) • Displayed in a pop up message after saving when the user is returned to the citation’s funding document package; slightly different text between create and edit In View and Active-Edit Modes • Displayed in a yellow banner at the top of the citation form; same message for both modes

21. Reporting Enhancements TSYM Search Report – New Report • Displays valid TSYM component combinations recognized in Pegasys • To be used by users to research TSYM components & resolve TSYM validation errors • Source table populated nightly BAAR Reports (History Report) – Modified Existing Report • TSYM component columns added to Agreements Tab & Billings Tab • Populated with values sent to Pegasys BAAR Rejected Reports – Modified Existing Report • TSYM component columns added to Agreements Tab & Billings Tab • Populated with values sent to Pegasys

22. Questions?