Source Files
Data Asset
Workday Account Tree
Legal Entity
Extract_Cost_Centers
Extract_Projects v2 all projects
Project Codes - Client IDs
GL Trial Balance
GL Balance Table - Average Deposits
Stat Account Balances
Property Counts File
Workday Account Tree Hierarchy
Client Mapping
Cost Center Hierarchy
Headcount Stats
SOR
Workday
Workday
Workday
Workday
Workday
Workday
Enterprise
Enterprise
REVs Property Counts
Workday
Workday
Workday
FPA
Data Class
GL Account
Legal Entity
Cost Center
Project Code
Counterparty
GL Balance
GL Balance
GL Balance
GL Balance
Financial Hierarchy
Counterparty Hierarchy
Cost Center Hierarchy
GL Balance
File
Source file has a duplicate header
Manually produce file which originated from Armen/Andrew's Excel workbook
Workday GL Trial balance source files are preprocessed via the linked file (these lack uniqueness and have null values for key data elements)
Manual process to calculate the average monthly deposits by client using the Comptroller query export
Manual process to calculate the number of loans and deals by customer
Manual process to normalize the property count numbers by client from the REVs teams Property Counts 04-17-24.xlsx report
Source file has a duplicate header