pii-ner-exclude.txt

MonthlyFigureFactory
export_edit_forecast_data_cost_centre
Apr/May
I3
X3
SUM(I3
X4
Y4
Z1
Cost Centre
CommandLog
executed_by
history_id
history_change_reason
EventLog
RedisCache
DefaultClient
StreamHandler
HSTS
JS
CRSF
Tells Django
FFT
NULL
is_staff
Treasury
l2 long
l3
l3 long
l4
l4 long
GROSS
N/A'
OUTTURN
SimpleHistoryHistoricL5Account
L2 Long Name
Control Budget Code
Control Budget Long Name
Control Budget Detail Code
Row Sort Order
Row Long Name
PESA Regional Code
Segment Grand Parent Code
Segment Grand Parent Long Name
Segment Long Name
accounting_authority_DetailCode
UKT013.GROUP
" Define SegmentGrandParent Factory
" Define SegmentParent Factory
" Define Segment Factory
Define EstimateRow Factory
" Define SubSegment Factory
u'I
f'{context.base_url}/
ROW_NUMBER
f'OVER
mar
f'coalesce(adj3
f'on b.financial_code_id
b.financial_year_id =
f'WHERE coalesce(f.archived_period_id
DROP VIEW
monthly_forecast_sep CASCADE
monthly_forecast_jan CASCADE
monthly_forecast_feb CASCADE
monthly_forecast_mar CASCADE
monthly_forecast_adj1 CASCADE
a.id GROUP
CREATE VIEW
a.archived_period_id
CREATE VIEW monthly_forecast_aug
CREATE VIEW monthly_forecast_dec
CREATE VIEW monthly_forecast_mar
CREATE VIEW monthly_forecast_adj1
CREATE VIEW monthly_forecast_adj2
MonthlyOutturn
NAC
Provide
Historical NAC
Expenditure
the Expenditure Category
Historical Expenditure Category
the Commercial Category
Analysis 1
Analysis 2
Upload the Trial Balance for a specific month
treasurySS
DEL ADMIN'
DEL PROG'
NON-BUDGET'
NON-DEPT AME'
NVT
NON-VOTED_NIF'
NON-VOTED_CEX'
Oscar
Raises
HawkFail
HAWK_INCOMING_ACCESS_KEY
access_key_id}'
sha256
access_key_id
WWW
AuthenticationFailed
DRF
Hawk
Server-Authorization'
Content-Type'
costcentre.change_costcentre
analysis_1
historicalnaturalcode/<year>/
historicalfinancecategory/<year>/
historicalcommercialcategory/<year>/
historicalanalysis1/<year>/
historical_analysis_2
historicalprogrammefilter/<year>/
historical_programme_filter
historicalprojectfilter/<year>/
historicalfcofilter/<year>/
historical_fco_filter
C901
r"\t
CC
choose_cost_centre
Define Analysis1 Factory
" Define Analysis2 Factory
" Define NACCategory Factory
" Define OperatingDeliveryCategory Factory
Define ExpenditureCategory Factory
Test Archived Budget Category'
" Define CommercialCategory Factory
" Define NaturalCode Factory
Programme Test
" Define ArchivedProgrammeCode Factory
" Define InterEntityL1 Factory
Define InterEntity Factory
Define ProjectCode Factory
Project Description
" Define ArchivedProjectCode Factory
Define FCOMapping Factory
" Define ArchivedFCOMapping Factory
Programme Description
chartofaccountDIT.ArchivedAnalysis1
csv
Account L5 Description'
PESA Economic Group Code'
Account L1 Code
Account L1 Long Name
Account L0 Code"
Account L3 Code
Account L3 Long Name
Account L5 Code"
Account L5 Long Name
Account L5 Description"
Economic Budget Code
Estimates Column Code
forecast.can_archive_end_of_month
Supplier
BudgetType
Government Bodies'
NAC Description'
ProjectCode
Project Code'
Project Description'
Project'
Programme Code'
Budget Grouping'
ORACLE - Inter Entity Code'
ORACLE - Inter Entity Description'
Treasury - CPID (Departmental Code No
Inter-Entity'
FCO Mapping'
Historic Programme Code'
PO/Actuals NAC'
Budget/Forecast NAC'
Historic Natural Account Code
Historic Inter-Entity'
Historic FCO Mapping'
Historic Budget Category'
Historic Commercial Category'
Archived Market (Analysis 2
ProgrammeCode
InterEntity
Inter-Entities'
FCO Mappings'
Historic Project'
Historic Programme Codes'
Historic Natural Account Codes
Historic Inter-Entities'
Historic Budget Categories'
is_superuser
Gift and Hospitality Admin
Authorization
Programme
F1"
MAY
K1
M1"
SEP
N1
OCT
DEC
JAN
Q2
R2"
MAR
Gift
Hospitality
Hospitality Types'
Gift Hospitality
Grade
Grade Description'
Gift and Hospitality Company'
DIT
DIT Staff'
Action3
DIT Group'
coalesce(budget
coalesce(sep
coalesce(oct
coalesce(jan
coalesce(mar
fc.id
FRONT_END_SERVER
LOG_TO_ELK
L1 Code
Estimate Column
L3 Account
l0
0.00
Description Natural Account code
Date Actuals Group
Group code Directorate
Cost Centre code Budget Grouping Expenditure
\\n123456 Test 111111 Test
Description Programme
\\n123456 Test 999999 Test
April"
111111 Test 333444 Test
UK TRADE & INVESTMENT
Project Code
Expenditure Type
Project
entered_date_stamp_to
Date Entered From:
gte
Max
costcentre.add_businesspartner
DownloadLog
CC TRAV'
Trainline
Admin Tool'
NAC H'
NAC Hierarchy
Download Type'
Download
Download Log'
Download Logs'
Grade Description"
entered_by
the Financial Forecast Tool</h1
the Live Services Team
Digital
Data and Technology (DDaT
Finance
the Financial Forecast Tool
the Financial Forecast
JAWS
NVDA
VoiceOver)</li>
accessible:</p
Mobile Applications
the Public Sector Bodies
&lt;dt&gt
Account
Gifts & Hospitality
the Financial Forecast System
ARIA
HTML5
Accessibility Guidelines
02.02.2022.</p
uploaded_at
EventType
financial_year_display'
HistoricalUser
HistoricalPermission
HistoricalGroup
CostCentre
OSCAR
SimpleHistoryFinancialCode
financial_row_unique_5a'
financial_row_unique_5c
BudgetUploadMonthlyFigure_unique1
ActualUploadMonthlyFigure_unique1
" Define L1Account Factory
" Define L2Account Factory
Define L3Account Factory
" Define L4Account Factory
" Define L5Account Factory
" Define HistoricL5Account Factory
Define DepartmentalGroup Factory
FBP
Define CostCentre Factory
Test Cost Centre
Set the Actual
Cost Centre for
Cost Centre Hierarchy
Admin Tool
Download Type
Download Log
Download Logs
forecast_cost_centre
2222222
E501
programme_details_directorate
update_forecast_figure
View Forecast' CC
Edit Forecast'
View Forecast'
Checks Directorate
Edit Forecast
the 'View Forecast'
Tests 'Edit Forecast'
ROUND(SUM(CASE
ON
ON "treasurySS_subsegment"
NULL GROUP BY coalesce("chartofaccountDIT_naturalcode"
m.financial_year_id
ON m.financial_code_id
ON ff.programme_id
EstimateRow
estimates_row_code'
Define GiftsAndHospitality Factory
Define GiftsAndHospitalityCategory Factory
archived_financial_row_unique_6
PO/Actual NAC
Budget Type
AD2
export_forecast_data_project_detail_cost_centre
Original Record Id"
Gift or Hospitality
Venue
DIT Group
Action Taken
f'SimpleHistory{x}'
Archived Natural Account Code
Archived Natural Account Codes
Archived Programme Codes'
Archived Commercial Category'
Archived Budget Category'
Archived Inter-Entity'
Archived Programme Code'
Archived Project'
f"csrftoken={os.environ['CRSF_TOKEN
CRSF_TOKEN
Gift and Hospitality Type
Gift and Hospitality Types
Gift and Hospitality Category
Gift and Hospitality Categories
DIT Staff
Gift and Hospitality Company
Gift and Hospitality Companies
CharField("DIT Group
Gift and Hospitality
-id
Oct"
Mar
Programme Resource'
Admin
Admin Resource'
forecast_forecastmonthlyfigure.archived_status_id
NULL GROUP BY
OSCAR L5 Mapping"
L6"
L6_NAME
DFF-Economic Budget
BEIS
Oscar Upload
Resource, Capital
Convert
Budget Categories
Approvers
L1 Value
L1 Description"
Test Grade
Normal Venue'
FD
end_of_month/end_of_month_archive.html
archivable_month
account_L5_code__account_l4__account_l3__account_l2
download_oscar_report/
download_mi_report/"
DjangoCelery
financial_year_display
Finance Business Partners
directorate__group__group_code
give_permission_form
" Define DownloadLog Factory
Chart of Account
Null
A2
BSCEEmail
BusinessPartner
Business Partner
Business Partner'
Business Partners'
Group Name'
Departmental Group'
Departmental Groups'
Cost Centre Name'
Historic Cost Centre'
Directorate
Hierarchy Responsibility'
Finance Business Partner'
Cost Centre'
Historic Cost Centres'
budget_type_descr
Budget/Forecast NAC
PO/Actuals NAC
Operational Delivery Plan
DEL
ADMIN
NON-PAY
Admin, Capital or Programme
Departmental Group
Group
NAC Expenditure
Budget/Forecast NAC Description
Account Codes
Market (Analysis 2
Markets (Analysis 2
Budget Groupings
Budget
Archived Budget Category
Archived Budget Categories
Commercial Categories
Archived Commercial Category
Archived Commercial Categories
Level 1
UKTI
L5_OSCAR_Upload"
Programme Name
Programme Codes
Archived Programme Code
Archived Programme Codes
ORACLE - Inter Entity Description
Archived Projects"
FCO Mapping
Action Time
Content Type
message)s
CREATE VIEW mi_report_data_forecast_actual_query
f.financial_period_id
mi_report_data_query
SELECT coalesce(b.financial_code_id
OscarReturnConfig
ForecastConfig
CoreConfig
DownloadFileConfig
PingdomConfig
MiReportDataConfig
dal_select2
DjangoTemplates
OPTIONS
ELASTIC_APM_ENVIRONMENT
ELASTIC_APM_SECRET_TOKEN
NAME
VERBOSE_LOOKUPS
GIT_COMMIT
TEMP_FILE_AWS_ACCESS_KEY_ID
CacheControl
CssFinder
WhiteNoiseMiddleware
core.no_cache_middleware
SessionStorage
DatabaseCache
Home 2
Home.as_view
chartofaccountDIT/"
mi_data
Financial Period Code
Financial Period Name
Content-Disposition"
filename={self.filename}.csv
gtm.start
Date().getTime
https://www.googletagmanager.com/gtm.js?id=
charset="utf-8"/
sizes="167x167
sizes="152x152
Forecast Tool</span></a
aria-controls="navigation
navigation">Menu
request.path|startswith:'/chartofaccountDIT/
request.path|startswith:'/gifthospitality/
Gifts &amp
href="/download_file
Download MI
MI
Download OSCAR
Project Percentages
target="_blank
Accessibility Statement
viewBox="0 0 483.2
height="17
8.7 39.7 21.8l42.7-27.2A97.63
GOVUKFrontend.initAll
Download MI Data
Compile
npm
Dev
Hospitality Register
Download Oscar
handle_validated_user
Control
Sub Segment
Project Percentages
f"ON
f"{period_id}
PingdomConfig
dal_select2
DjangoTemplates
ELASTIC_APM_ENVIRONMENT
ELASTIC_APM_SECRET_TOKEN
NAME
VERBOSE_LOOKUPS
GIT_COMMIT
CacheControl
CssFinder
WhiteNoiseMiddleware
Budget / Forecast NAC Description
E501
Budget Type Display
Project Codes{%
Project Codes</h3
Content-Disposition"
u"\ufeff
3000-30000-{}-{}-{}-00000-00000-0000-0000-0000'
3000-30000-{}-{}-000000-00000-00000-0000-0000-0000'
Wrong Title'
Project Percentages'
Upload Percentage
"Clear the Cost Centre, Directorate and Group
self.create_departmental_group('8213CC
Admin DEL'
Project 1
Project 2
Project 3
Project 4
Project 5
Staff Welfare
ner_output_file.txt
Tests 'Edit Forecast'
Checks Directorate
r"\t
Excel
SQL
Forecast
COLOUR_GREEN=\033[32;01
COLOUR_YELLOW=\033[33;01
migrate$(COLOUR_NONE
Compile SCSS
elevate$(COLOUR_NONE
test$(COLOUR_NONE
create_data_lake_stub_data
CROSS
mi_report_empty_data
VIEW
financial_row_unique_5a
financial_row_unique_4b
Centre
E722
BaseModel
FinancialPeriod
get_monthly_figure_serializer'
financial_year>/
view.cost_centre_details.cost_centre_code  view.financial_year %
gtm.start
Date().getTime
https://www.googletagmanager.com/gtm.js?id=
charset="utf-8"/
sizes="167x167
sizes="152x152
Forecast Tool</span></a
aria-controls="navigation
navigation">Menu
Gifts &amp
href="/download_file
Download MI
target="_blank
Accessibility Statement
viewBox="0 0 483.2
height="17
8.7 39.7 21.8l42.7-27.2A97.63
GOVUKFrontend.initAll
Download MI
type="submit
role="alert
download_budget_name
Luis
Table
/Reducers/Edit'
{ OPEN_FILTER_IF_CLOSED }
SET_SELECTED_ROW
selectedRow > -1
window.actuals && window.actuals.length >
event.preventDefault
Tab
event.shiftKey && document.activeElement
event.shiftKey &&
&&
getCellId(targetRow
document.activeElement.blur(
nextId
targetMonth++
Jump
INPUT
EditForecast
f"Error
type="text" className="govuk-input
Cost Centre{%
export_forecast_data_cost_centre
data</a>
view.cost_centre_code
0 &&
f'window.financialYears
financial year</h3
Forecast/Actuals
clear_financial_codes
Upload the Trial Balance for a specific month and year
Europe
Download OSCAR Return
OSCAR Returns
OSCAR Return
Project Codes{%
Project Codes</h3
ec
f"t.financial_code_id
f"t.financial_period_id = u.financial_period_id
u.financial_year_id
Resource or Capital
310940
T123
310940
00798
Formula
f"Cannot
f"User
f"In
directorate_code=
GGGG1
remove_user_from_cost_centre
Formula
financial_code_%(app_label)s_%(class)ss
financial_archived_period_%(app_label)s_%(class)ss
Dataworkspace
ReportYTDView(UniqueDataKeyWithArchived
adj2
public.previous_years_archivedforecastdata
cost_centre_code
a_cc on cost_centre_id =
a_a2.id
COALESCE(c.analysis2_code_id
unnest(array
Data Workspace
DROP VIEW IF EXISTS mi_report_monthly_forecast_apr
DROP VIEW IF EXISTS mi_report_monthly_forecast_dec
DROP VIEW IF EXISTS mi_report_monthly_forecast_adj1
CREATE VIEW mi_report_monthly_forecast_apr
SELECT
CREATE VIEW mi_report_monthly_forecast_may
SELECT archived_period_id
CREATE VIEW mi_report_monthly_forecast_aug
CREATE VIEW mi_report_monthly_forecast_sep
CREATE VIEW mi_report_monthly_forecast_oct
CREATE VIEW mi_report_monthly_forecast_dec
CREATE VIEW mi_report_monthly_forecast_feb
mi_report_monthly_forecast_adj1'
ReportAugDataView
mi_report_monthly_forecast_aug
mi_report_monthly_forecast_feb
mi_report_monthly_forecast_jul
mi_report_monthly_forecast_may
mi_report_monthly_forecast_sep'
mi_report_monthly_forecast_sep
mi_report_monthly_forecast_jan
mi_report_monthly_forecast_adj1
ReportBudgetArchivedData
DROP VIEW IF EXISTS
archived_id
ON cost_centre_id = p.cost_centre_code AND c.natural_account_code_id
f"{drop_previous_year_sql
ReportPreviousYearData(UniqueDataKeyWithArchived
# Archived
CREATE VIEW last_year_financial_code as SELECT p.id
Download MI Forecast Data
Download MI Budget Data
Download Previous Year Data
NULL AND forecast_forecastmonthlyfigure.financial_period_id IN
CREATE VIEW public.mi_report_current_forecast AS
MIReportCurrentActualData'
MIReportCurrentForecastData
ReportYTDView(UniqueDataKey
DROP VIEW mi_report_current_period
CREATE VIEW mi_report_current_period
CREATE VIEW mi_report_current_forecast
DROP VIEW IF EXISTS mi_report_current_period
CREATE VIEW mi_report_archived_budget_view
SELECT f.financial_code_id
f.archived_status_id
f.expenditure_type
CREATE VIEW dw_current_year_outturn
EXISTS dw_actual_ytd
Actual Loaded"
DROP VIEW IF EXISTS dw_current_year_outturn
DROP VIEW IF EXISTS dw_prev_year_outturn
run_rate_ytd
pa_ytd.previous_year_ytd
pa_ytd
public.dw_budget_ytd b_ytd
current_year_forecast_budget_variance
actual_forecast_budget_variance_ytd
COALESCE(rates.run_rate_ytd
COALESCE(b.financial_period_code
ON fa_ytd.financial_code
a_ytd
ON rates.financial_code
rates.financial_period_code
COALESCE(cy_o.current_year_outturn
previous_year_ytd
t3 WHERE dw_simulation_mi_report_previous_year_actual.financial_code = t1.financial_code
t2.financial_code AND dw_simulation_mi_report_previous_year_actual.financial_code =
DELETE
t3
t3 WHERE
Previous Financial Code ID
DROP VIEW IF EXISTS dw_current_year_data
DROP TABLE IF EXISTS public.dw_simulation_mi_report_forecast_actual
CREATE VIEW dw_current_year_data as SELECT COALESCE(b.financial_code
Download Period
p.expenditure_type
COALESCE(c.ytd_actual_forecast_budget_variance
COALESCE(c.full_year_budget
COALESCE(c.full_year_actual_forecast_budget_variance
ON COALESCE(c.cost_centre_code
b_o
DROP VIEW IF EXISTS dw_budget_full_table
CREATE VIEW dw_budget_full_table
FROM dw_budget_full_table GROUP
DROP TABLE IF
coalesce(nov,0
DROP VIEW IF EXISTS dw_previous_period_forecast
DROP TABLE
CREATE VIEW dw_previous_period_forecast
CREATE VIEW dw_prev_year_outturn
COALESCE(fp.previous_period_forecast
ON fp_o.financial_code
Download Future Year Data
Future Forecast
Download Future Year Data
Future Forecast
Forecast Data
Download Future Year Budget Data
data_lake_mi_report_future_year_forecast_data/
Forecast Data
Download Future Year Budget Data
data_lake_mi_report_future_year_forecast_data/
0004_full_data
DROP VIEW IF EXISTS dw_full_year_future_years
DROP VIEW IF EXISTS dw_no_data_future_year_full_table
u CROSS
e.archived_financial_period_code
CREATE VIEW dw_full_year_future_years
FROM dw_future_year_budget_forecast GROUP
DROP VIEW IF EXISTS dw_current_past_year
CREATE VIEW dw_current_past_year
DROP VIEW IF EXISTS dw_future_year_data
DROP VIEW IF EXISTS dw_ytd_future_years
DROP VIEW IF EXISTS dw_budget_forecast_future_years
FROM dw_budget_forecast_future_years GROUP
b_ytd
CREATE VIEW dw_future_year_data
SUM
p.programme_code
ReportBudgetPeriod0Data
ReportPeriod0DataView
DROP VIEW IF EXISTS mi_report_forecast_period_0_view
DROP VIEW IF EXISTS mi_report_budget_period_0_view
" CREATE VIEW mi_report_forecast_period_0_view
CREATE VIEW mi_report_budget_period_0_view
mi_report_forecast_period_0_view"
mi_report_budget_period_0_view
0007_future_year_period_0
Finance Forecast Tool Admin
" Django settings for
Django 2.0.2
VCAP_SERVICES
future_years.apps
FutureYearsConfig
previous_years.apps
treasurySS.apps
end_of_month.apps
importdata.apps
BACKEND
AutoField
AUTHBROKER_CLIENT_ID
AWS
SessionMiddleware
django.middleware.common
CommonMiddleware
AuthenticationMiddleware
MessageMiddleware
AxesMiddleware
AxesBackend
ClamAVFileUploadHandler
django_chunk_upload_handlers.s3.S3FileUploadHandler
Order
django.core.cache.backends.db.
Archived Financial Period Name
Year
Archiving Year
Exclude Adj
Previous Year Actual
CREATE VIEW mi_report_forecast_period_0_view
SELECT 0
EXISTS
mi_report_forecast_period_0_view
mi_report_monthly_forecast_apr
mi_report_monthly_forecast_nov
mi_report_monthly_forecast_adj3
BigIntegerField(default=0
financial_year_id
CREATE VIEW mi_report_future_year_period_0_budget
download_mi_report_data
jun
jul
coalesce(sep,0
w[l].push
dataLayer
equiv="X-UA-Compatible
sizes="16x16 32x32 48x48
href="/profile">Ross#}
role="button
Level Navigation
Chart
Home
svg aria-hidden="true
Crown
data_lake_financial_year
mi_report_budget_data/
mi_report_financial_period_in_use/
Test Group
Test Directorate
Django 3.2.16
f"Invalid
REFRESH MATERIALIZED VIEW mi_report_monthly_forecast_dec
f"financial_code_id
=
Reconciliations
Contract Reconciliation (Analysis 1
Archived Contract Reconciliations (Analysis 1
NP
Commercial Category
level1
NA
ORACLE - Inter Entity Code
FCO Mappings
Gross/Income
Expenditure Category
Financial Year
L0 Code
L2 Code
L2 Name
L3 Code
L3 Name
L4 Code
L4 Name
L5 Code
L5 Name
L5 Description
NAC_pay_non_pay
Cash/Non Cash
BigAutoField
Cash/Non Cash
BigAutoField
SET
import_chart_of_account_uploadnaturalcode
CREATE OR REPLACE VIEW public.forecast_forecast_budget_view AS SELECT COALESCE(b.financial_code_id
f.financial_code_id
COALESCE(f.aug
COALESCE(f.adj1
COALESCE(f.adj2
COALESCE(o.previous_outturn
ON o.financial_code_id = f.financial_code_id
CREATE OR REPLACE VIEW public.forecast_current_budget_previous_outurn_view AS SELECT COALESCE(o.financial_code_id, b.financial_code_id) AS financial_code_id
ON o.financial_code_id = b.financial_code_id
COALESCE(b.previous_outturn
Budget / Forecast NAC
PO / Actuals NAC
Gross / Income
{{ block.super }
the Department for Business and Trade
keyboard</li
VoiceOver)</li
groups, &lt;script&gt
elements.</li
Equality Advisory and Support Service
class="govuk-body">The Department for Business and Trade
the Web Content Accessibility Guidelines
DBT Group
DBT Representative
DBT
{{ block.super }
ADI
MonthlyFigure
Read the ADI
DBT Information
DBT Oracle Code
DBT Oracle Description
account_L6_code_fk__expenditure_category__NAC_category
DBT Chart of Account
DBT Group'
DBT Staff'
Oracle (DBT) Description
DBT Staff
Department
Normal Venue
html.parser
Forecast / Historical
Commercial
the Overseas Team
EU
ODA
Parliament Control Total
DEL/AME
Admin/Programme
Purchase Orders
Project Codes
TPG
Estates
Contract Reconciliation"
view.group_name
view.cost_centre_name
forecast_cost_centre" view.cost_centre_code view.period %
export_forecast_data_cost_centre'
allCC && myCC
Original Record Id
Date Of Event / Gift
NB
the Business Support Centre of Excellence
NON-VOTED_NIF
NON-BUDGET
DEL ADMIN
DBT Budget Code
f"{self.sub_segment_code} - {
f"{self.sub_segment_code} - "
Archived Treasury Segment
Segment Grand Parent
Sub Segment Code
Sub Segment Long Name
natural_account_code_description
Oracle) Description
Oracle Code
Oracle Description
Cost Centre Description
Departmental Groups,
BSCE
BP Name
BP
Groups
Surname
Gifts
Hospitality Records
Add Gift/Hospitality Received
Register
The DBT Gifts & Hospitality Policy
Add Gift/Hospitality Offered
Completed Gift/Hospitality Offered Form
Completed Gift/Hospitality Received Form
Add Gift/Hosp Received
Add Gift/Hosp Offered
Archived Treasury Segment'
Sub Segment'
Oscar Return'
Project Details - DBT{%