Supporting Documentation: Transfer payments as per the Public Accounts of Canada
General Notes
As of the 2025 release, the following columns were renamed to improve readability and bilingualism:
FSCL_YR was renamed to Fscl-yr_Ex-fin
MINC was renamed to Min-code
MINE was renamed to Min-portfolio_Portefeuille-min_eng
MINF was renamed to Min-portfolio_Portefeuille-min_fra
DepartmentNumber-Numéro-de-Ministère was renamed to Dept-nbr_No-min
DEPT_EN_DESC was renamed to Dept-name_Nom-min_eng
DEPT_FR_DESC was renamed to Dept-name_Nom-min_fra
PYMT_TYP_EN_DESC was renamed to Pymt-desc_Desc-paimt_eng
PYMT_TYP_FR_DESC was renamed to Pymt-desc_Desc-paimt_fra
AVLBL_PREV_YR_AMT was renamed to Avail-auth-prev-FY_Aut-disp-EF-prec
MAIN_ESTMT_AMT was renamed to Auth-requested_Dep-demandees
SPLMTRY_ESTMT_AMT was renamed to Supl-amt-reqstd_Mnt-supl-demandee
ADJ_AMT was renamed to Adj-amt_Mnt-redress
WRNT_AMT was renamed to Wrnt-amt_Mnt-mndt
TRNFR_AMT was renamed to Xfr-amt_Mnt-vrmt
TP_EN_DESC was renamed to Xfr-pymt_Paimt-trnsf_eng
TP_FR_DESC was renamed to Xfr-pymt_Paimt-trnsf_fra
TP_DTL_EN_DESC was renamed to Xfr-pymt-desc_Desc-paimt-trnsf_eng
TP_DTL_FR_DESC was renamed to Xfr-pymt-desc_Desc-paimt-trnsf_fra
CRNT_YR_USED_AMT was renamed to Net-exp-curr-yr_Dep-nettes-ex-en-cours
C_VRNC_AMT was renamed to Curr-var-amt_Mnt-ecart-crnt
AVLBL_SBSQT_YR_AMT was renamed to Avail-auth-subs-FY_Aut-disp-EF-ult
NET_XPND_PY_AMT was renamed to Net-exp-prev-yr_Dep-nettes-ex-prec
The (S) in the Xfr-pymt_Paimt-trnsf_eng column stands for statutory.
As of 2022, the amounts presented in columns C_ADJ_WRT_TRN_AMT & C_TTL_AVL_USE_AMT have been removed from the dataset since they were subtotals of other columns. Column C_ADJ_WRT_TRN_AMT can be calculated with the sum of Adj-amt_Mnt-redress, Wrnt-amt_Mnt-mndt and Xfr-amt_Mnt-vrmt amounts and column C_TTL_AVL_USE_AMT with the sum of all columns from Avail-auth-prev-FY_Aut-disp-EF-prec to Xfr-amt_Mnt-vrmt.
For records where the Xfr-pymt_Paimt-trnsf_eng and Xfr-pymt_Paimt-trnsf_fra text fields end with one or more foreign currency values shown in brackets (ex: "United Nations Educational, Scientific and Cultural Organization (US$4,189,387) (4,825,881 Euro)") these values represent expenditure amounts in the indicated currency. The total of these expenditures sum to the value contained in the Net-exp-curr-yr_Dep-nettes-ex-en-cours column, which is given in Canadian Dollars.
