Joint Training Institute (JTI) and Joint Safety Institute (JSI) Financial Data
controllerdata.lacity.org | Last Updated 10 Jan 2017The ledger of assets, revenues, and accounts for the Joint Safety Institute and the Joint Training Institute. Financial documents and underlying data relating to City Controller Ron Galperin's audits of two trusts, the Joint Training Institute and the Joint Safety Institute. The two trusts are fully funded by the Department of Water and Power (DWP) and managed by an appointed board made up of equal numbers of representatives from DWP management and from the International Brotherhood of Electrical Workers (IBEW) Local 18, which represents the majority of workers at the DWP. All information below was compiled by the City's auditors for these two audits. For more information, visit: https://controllerdata.lacity.org/Audits-and-Reports/Joint-Training-Institute-JTI-and-Joint-Safety-Inst/4i3e-krmq
This dataset has the following 15 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Type | type | text | Check Deposit CHECK Check General Journal view top 100 |
| Date | date | calendar_date | 2013-06-30T00:00:00.000 2011-06-30T00:00:00.000 2010-06-30T00:00:00.000 2012-06-30T00:00:00.000 2013-09-30T00:00:00.000 view top 100 |
| Entity | entity | text | JTI JSI view top 100 |
| Name | name | text | Visa Department of Wat… Beginning Balance Canon Financial S… Diners Club view top 100 |
| Description | description | text | Citibank Checking CD Interest Citibank Money Market ABB Checking Peer Lead Training Instructors view top 100 |
| Memo | memo | text | Deposit Deposit Safe Start Interest DEPOSIT view top 100 |
| Amount | amount | number | 0.00 200.00 -200.00 500.00 -500.00 view top 100 |
| Account | account | text | Asset Expense Expense Income Income view top 100 |
| Sub Account | sub_account | text | Cash Interest Income Training Expenses Conferences, Conventions and Meetings Salary Expense view top 100 |
| Split | split | text | 1000 Citibank Checking 1000-CITIBANK CHECKING 1000 Citibank Checking 5131 1015 ABB Checking view top 100 |
| Year | year | number | 2013 2012 2011 2010 2014 view top 100 |
| FYE | fye | text | FYE 2014 FYE 2013 FYE 2012 FYE 2010 FYE 2011 view top 100 |
| Check Number | check_number | number | 268 223 279 233 397 view top 100 |
| Account Number | account_number | number | 1000 4010 1010 1015 5131 view top 100 |
| Month | month | number | 6 9 11 5 7 view top 100 |