8.9.2.16 Transfer Price Audit Trail Report

Table 8-111 Transfer Price Audit Trail Report

Report Name Transfer Price Audit Trail Report
Description This report shows the audit details of the Transfer Price process.
Dashboards Prompts

Prompt - Process Id

  • Process Id

Prompt - Process Name

  • Process Name
Report Criteria "Fact FTP Audit Trail"."Instrument Type Code", "Fact FTP Audit Trail"."ID Number", "Fact FTP Audit Trail"."Identity Code", "Fact FTP Audit Trail"."As Of Date/MIS Date", "Fact FTP Audit Trail"."Transfer Price Sys Id", "Fact FTP Audit Trail"."Tp Method", "Fact FTP Audit Trail"."TP IRC", "Fact FTP Audit Trail"."TP Accrual Frequency Code", "Fact FTP Audit Trail"."Accrual Basis Code", "Fact FTP Audit Trail"."All in TP Rate Formula", "Fact FTP Audit Trail"."Adjustment Sys ID","Fact FTP Audit Trail"."Liquidity Adjustment Method Code", "Fact FTP Audit Trail"."Liquidity Adjustment IRC", "Fact FTP Audit Trail"."Basis Adjustment Method Code", "Fact FTP Audit Trail"."Basis Adjustment IRC", "Fact FTP Audit Trail"."Other Adjustment Method Code", "Fact FTP Audit Trail"."Pricing Adjustment Method Code", "Fact FTP Audit Trail"."Pricing Adjustment IRC", "Fact FTP Audit Trail"."Breakage Adjustment Method Code", "Fact FTP Audit Trail"."Breakage Adjustment IRC", "Fact FTP Audit Trail"."Adjustment Accrual Frequency Code", "Fact FTP Audit Trail"."Rate Lock - Discount Curve Code", "Fact FTP Audit Trail"."Rate Lock - Volatility Curve Code", "Fact FTP Audit Trail"."Economic Value - Cash Flow Interest Type", "Fact FTP Audit Trail"."Economic Value - IRC", "Fact FTP Audit Trail"."Stochastic Rate Index Sys ID", "Fact FTP Audit Trail"."Term Structure Model Code", "Fact FTP Audit Trail"."Option Cost - Accrual Frequency Code", REPLACE("Fact FTP Audit Trail"."Propagation Type 1", '_', ' '), REPLACE("Fact FTP Audit Trail"."Propagation Type 2",'_',' '), REPLACE("Fact FTP Audit Trail"."Propagation Type 3",'_',' '), REPLACE("Fact FTP Audit Trail"."Propagation Type 4",'_',' '), "Fact FTP Audit Trail"."Batch Id"
Conditions
Compound Layout

Title

Table

Title 2

Note:

The FTP Dashboards contain a prompt for Legal Entity. This prompt refers to Legal Entity data loaded directly from the Staging Area to the Reporting Data Model. If Legal Entity is not required, you can ignore this step and either delete the Legal Entity prompt or ignore it on the relevant FTP dashboards.