KBA-01503: qAlias Bookmarks for CCO (Commitment Change Order) fields

Problem:

When working with the CCO (Commitment Change Order) template, you can use the following qAlias bookmarks if you first add the qAlias bookmarks into the QueryConfig rule using the script below.

Bookmark	Description
qCCOAmt_ThisChangeAmt	Amount of This Commitment Change Order
qCCOAmt_ApprovedExpense	Amount of Prior Approved Commitment Change Orders
qCCOAmt_ApprPendExpense	Amount of Prior Approved and Pending Commitment Change Orders
qCCOAmt_PendingChangeExpense	Amount of Prior Pending Commitment Change Orders
qCCOAmt_ContractAmtOrig	Original Commitment Amount
qCCOAmt_ContractAmt	Current Commitment Amount
qCCOAmt_ContractAmtPend	Current Commitment Amount with Prior Pending
qCCOAmt_ContractAmtNew	New Commitment Amount (includes Prior Approved and this Change)
qCCOAmt_ContractAmtNewPend	New Commitment Amount with Pending (includes Prior Approved, Prior Pending, and this Change).

Solution:

For Spitfire V2017+, the query alias is ready to use; no additional steps are required.

Prior to V2017, deployment is simple. Use the script below:

BEGIN TRANSACTION
DELETE FROM dbo.xsfRuleItem WHERE TestValue LIKE 'qCCOAmt:Alias%';
INSERT INTO dbo.xsfRuleItem VALUES
 ('b28a206d-cca3-41ba-83f9-6cfcebf86fd1','0A5F5872-04C8-43AC-B2F6-35ADB1B696A2',
  0,0,'qCCOAmt:Alias',null,'EXEC dbo.pqa_CCOAmt @pDocMasterKey, @pProject',null,default);
COMMIT

Additional Comments:

The rule can be found in the QueryConfig rule group.

KBA-01503; Last updated: September 20, 2017 at 12:24 pm
Keywords: qAlias Bookmarks