United States Department of Agriculture

CPAIS Release 2.22 Emergency CR0032372 Release Notes

• CR32372 – INC0034849 - CPAIS-RP "roll" to FY17

CPAIS Release 2.22 Emergency CR0032275 Release Notes

• CR32275 – INC0031085 - Separate FRPP query for records with data anomalies

* A separate query was created for the Owned Buildings and Leased buildings tabs only that will query only records with anomalous data. The previous query was restored so that only data gaps and errors are queried.

CPAIS Release 2.22 Emergency CR0032258 Release Notes

• CR32258 – INC0031015 - FS Floor Room Space Usage value updating

* Created a process to update FS replicated Floor/Room records which had a Space Usage value that was not valid in CPAIS as of the v2.22 release.

CPAIS Release 2.22 Release Notes

• CR31056 – INC0014871 - Change GSA Assign Mod creation process
• CR31069 – INC0014842 - GSA Assignments module updates
• CR31100 – INC0014848 - Revise GSA Assignments module
• CR31974 – INC0024545 - Prevent the same user from initiating a Lease Transfer and accepting/rejecting it
• CR31975 – INC0024687 - Recalculation updates required for FY16 FRPP reporting
• CR31976 – INC0024519 - FY16 FRPP Data Validation and Verification required to match OMB direction
• CR31977 – INC0025693 - CPAIS updates needed to comply with the FY16 FRPP Data Dictionary
• CR31978 – INC0021815 - Update the Floor Room Usage Space Usage LOV/SU Type LOV for USF/UR calculation

CPAIS Release 2.21 Release Notes

• CR31144 – INC0015261 - Replace the User Access Discoverer report.
• CR31543 – INC0018674 - Total Usable Space (SF) field/data derived incorrectly.
• CR31621 – INC0020087 - User View - Fix Date "Where" clause.
• CR31626 – INC0019872 - Create history records for LAND AOC/AOC override changes bug fix.
• CR31627 – INC0019833 - GSA User View - Org Code displays Bureau Code bug fix.
• CR31629 – INC0019981 - History form does not launch when History button is clicked.
• CR31630 – INC0019991 - Annual Operating Cost returns two rows for one year.
• CR31644 – INC0018309 - Change STAR and CBR references to REXUS and CBR to OA ID.
• CR31648 – INC0020208 - Fix Post 2.19 UAT issues (1) - Lease Module.
• CR31654 – INC0020209 - Fix Post 2.19 UAT issues (2) - RPM223L Rpt.
• CR31655 – INC0020210 - Fix Post 2.19 UAT issues (3) – Leases with no property.
• CR31656 – INC0020212 - Fix Post 2.19 UAT issues (4) – with Collocation Module.
• CR31657 – INC0020260 - New transfer and transfer accept/reject forms.
• CR31674 – INC0020378 - Complete the Contact Module as proposed in the original v2.19 requirements.
• CR31675 – INC0020381 - Create New HUD tab/report for Owned Assets.
• CR 31702 – INC0020650 - Users (RPM Property Manager Role) are unable to update Org values on property records due to a database trigger error.

CPAIS Release 2.19 Release Notes

• CR 31052 - INC0014839 - FMP Data Roll Script Revisions
• CR 31060 - INC0014726 - Update the ARS Admin and Managing Org codes
• CR 31061 - INC0014841 - Modifications to Colocations Form
• CR 31066 - INC0014716 - Add the agency code and org to the view CPAIS_HIST_DELETED_ASSET_VW
• CR 31082 - INC0014727 - FRPP Explorer Data Script to update FRPP views and procedures
• CR 31073 - INC0014859 - update the History (tracking) form so that it records the Status for a deleted Status History record
• CR 31079 - INC0014860 - Disposed Details User View update the report script so that land type values are also displayed
• CR 31106 - INC0014731 - Add a column to the Reduce the Footprint baseline table and to the features or building details table to store a Y or N

CPAIS Release 2.18 Release Notes

• The Discoverer reports are no longer available.
• Premier Support for Oracle Application Server 10g has ended.
• This upgrade will simplify desktop administration and ensure future supportability of the application.

CPAIS Release 2.17 Release Notes

• Total Capitalized Value and Total Accumulated Depreciation fields to the Acquisition Sub tab.
• The available UOM LOV values are based on the Space Usage value.
• Several Forest Service Structure Type Categories were missing from the CPAIS LOV. These have been added to the LOV.

CPAIS Release 2.16 Release Notes

• The new User ID field will be auto populated with the User ID of the user adding the record.
• Identify records missing Installation ID, Installation Site and Installation Name as data gap records.
• Fixed the Using Organization field List of Values (LOV).

CPAIS Release 2.15 Release Notes

• History button on the Navigation Bar
• Status field displays the whole word value for each status value.
• The ‘Shared?’ checkbox can be selected or deselected when a Floor/Room Usage record is created or modified.

CPAIS Release 2.14 Release Notes

• CR 199367 - Allow Zero Personnel and Workstations for Excess and Abandoned Assets
• CR 270287 - Add/Modify Predominant Usage Subcategory Values
• CR 292734 – Report FRPP Assets in Next FY

CPAIS Release 2.13 Release Notes

• The field title on the Explorer: FRPP Assets/ Owned and Leased Building tabs has been changed from “Gross Sqft” to “Square Feet”.
• The new field “Repair Needs” will be populated with the reported asset’s current year Deferred Maintenance.
• The existing Lease Authority LOV value “Provider of Choice Authority-GSA” was changed to “General Purpose Space-GSA”.

CPAIS Release 2.12 Release Notes

• The loophole that allowed edit access to be granted in error when the access should be read-only has been removed.
• Allows USDA to link the GSA billing records to the agreement records in CPAIS.
• Revised the Update Baseline button function found on the Comparison tab so that the GSA-provided rent and security charges for the user entered OA ID (former CBR) are loaded in the GSA Rent and Security Charges block.

CPAIS Release 2.10 Release Notes

• Added new status values “Erroneous” and “Cancelled” to the drop down list of values on the property forms/tab.
• Added new value “Broadcasting Board of Governors” with new code of 6600 to Using Organization (II_CONTACTS). Removed current code value of 9568.
• Hid the Restrictions data element field from view; this field will not be available to be viewed by users on the Explorer: FRPP Assets form – ALL Leased and Owned tabs.

CPAIS Release 2.8.2 Release Notes

• Ensured that the value of Historical Status is not included for the reporting of State and Foreign Owned Assets.
• Changes were made to disposed buildings, disposed land and disposed structures.
• Changes were made to the XML Schema for Adding Owned and Otherwise Managed Land Records.

CPAIS Release 2.7 Release Notes

• FRPP Data Form title was changed to Explorer: FRPP Assets.
• An edit was placed on the Predominant Usage field to ensure that field is not blank when saved.
• The Annual Operating Cost Process (II annual operating cost) was modified to not calculate the post annual operating cost amounts for agency 11.

CPAIS Release 2.6 Release Notes

• The GSA Assignments Form was modified to be updateable by the user for more accurate GSA assignment maintenance.
• The Leased Features and Leased Building Space Discoverer Reports selection criteria were modified to ensure that all leased data is reflected on the reports.
• The RPA107L Feature Inventory Report was modified to display the data in ascending order by agency, org, project group and asset id. New parameter fields were added and the header fields were also updated.

CPAIS Release 2.4 Release Notes

• Added the 6 FMMI accounting fields (Business Area, Fund, Budget Period, Cost Center, WBS, and Functional Area) to forms and reports.
• Modified field labels to reflect both Financial Systems (FFIS/FMMI) connected with CPAIS.
• Modified form and report processing logic to include functionality with the FMMI system using the FMMI specific fields as well as the current logic accessing FFIS.

CPAIS Release 2.1 Release Notes

• Several forms were modified to blank out the Congressional District field when the State is changed.
• The FRPP process was modified to report the current Fiscal Year on the XML created for reporting.
• The GSA FRPP Totals by Agency form was modified to show the query only fields in the color gray to keep within CPAIS application standards.

CPAIS Release 1.8 Release Notes

• Several Predominate Usage Sub-Categories where added for Buildings. Laboratory Facilities, Animal Facilities, and Greenhouses are a few while the complete list can be viewed within CPAIS.
• The Predominant Use Category of “Museum” was added to the valid list of values for Buildings and Other Structures.
• The valid list of values of “Utilization” for the TYPE field on the Agency Certification tab of the Agency Data Certification form was removed.

CPAIS Release 1.7 Release Notes

• After implementation of CPAIS release 1.7 CPAIS users will log on with their eAuth username and password.
• When you logon to the new version of CPAIS you will not see any Forms modules listed.
• The AD-1143 form will no longer be used to request new access or changes to profiles, this can all be accomplished in UMA.

CPAIS Release 1.4 Release Notes

• Various Change Requests implemented on March 22, 2017