Matching dept codes from multiple sources and formats

**zmbd** · Jul 2 '13, 07:54 PM

You have one "*" of a mess here.
Working on the concept that you added the text "Water Lines" (otherwise, why not use that?) and what you actually have is the numeric values to work with then looking at your example data, it appears that:
"10301 Water lines" has the most in common with the remaining members.
IFF this holds true in that there are simular commonalities then you have a hope of an easy solution in that you can use the replace function to remove the dashes and then use the right function to return the last five digits.

However, life is rarely that nice.

One way I might do this is to have a table with the unique names like "water," "pen," etc.. then a table with the outside codes, who from, the unique name, the location code. Then either use a linking table, or even in the second table have the relationship to the first.

On first blush it would start out along these lines:

tbl_db_location code:
[db_locationcode _pk] autonumber; primary key.
[db_locationcode _name] text(50); required, no duplicate
(this will become your databases internal standardized location code)

tbl_os_source:
[os_source_pk] autonumber; primary key.
[os_source_name] text(50); required, no duplicate
(Use this table to help standardize the source names such as NCCI and Payroll etc...)

tbl_os_location code:
[os_locationcode _pk] autonumber; primary key.
[os_locationcode _fk_os_source] 1 to many on tbl_os_source PK
[os_locationcode _fk_db_location code] 1 to many on tbl_os_source PK
[os_locationcode _code] text(50); required; no duplicates.
{{Should Add compound key on
[os_locationcode _fk_os_source]
[os_locationcode _code]
- needs to be unique to prevent adding the same source and location codes more that once}}
(Now this table will have one entry for each source's location code... so you get a table with the information much like you listed in your post)

tbl_metricdata:
[metricdata_pk] autonumber; primary key.
[metricdata_fk_D B_locationcode] 1 to many on tbl_db_location code
[metricdata_(... )]

(( or maybe
tbl_metricdata:
[metricdata_pk] autonumber; primary key.
[metricdata_fk_O S_locationcode] 1 to many on tbl_OS_location code
[metricdata_(... )]
))

Setting up tbl_os_location code:
Now in your query, build a query on tbl_os_location code pulling in all of the fields (do not use the star).
You will setup the lookup control for the fields [os_locationcode _fk_os_source] and [os_locationcode _fk_db_location code] based on their tables... this way you can use the human readable "Name" fields.
You can build a form that is bound to this query, if you use the wizard it should setup comboboxes for the two lookups if not, then you can do this by hand.

Setting up tbl_metricdata
Depending on which one you use, either query based on the db_locationcode or,
Very simular in that you would use a query, build a lookup field against your source and location fields (concatenate the source and location code) and enter your other data. Same thing within your forms.

Here's the deal, you can now pull the outside and internal location codes by source (payroll, ncci, etc...) or by outside codes, or the internal db code etc... and by relationships query the metrics table

It should be noted that this is just an initial thought without a formal analysis of the database design that I would normally do to construct something like this... basically, I've left out some of the details; however, I hope you can see what I'm doing here
(> Database Normalization and Table Structures. )

**ADezii** · Jul 2 '13, 10:05 PM

Assuming your Location Codes are minimally consistent, namely: There is some kind of Pseudo Numeric Code up to a Maximum of 12 Characters followed by a single Space and then some kind of Identifier (will use Utility in this case), you can:

Append all Location Codes into a single TEXT Field.
Create a Query using a Calculated Field. This Calculated Field will pass the Value of each Location Code where it will be parsed, analyzed, properly formatted, then become the return Value of the Function.

Sample Data, your Original and some Added:

Code:

Codes
0010-301 Water lines
0010-301 Water lines
10010-0010-301 Water lines
10010-0010-301 Water lines
10301 Water Lines
1299-098 Gas Lines
23345555555 Gas Lines
3456-245 Gas Lines
1234 Electric Line
9876----612 Elec
12-77-99-876 Elctrc
99876-721345 Nonsense Entry

Query Definition assuming a Table Name of Table1 and a Location Code containing these Values named Codes:
Code:
```
SELECT Table1.Codes, fFormatCodes([Codes]) AS New_Code
FROM Table1;
```

Function Definition:

Code:

Public Function fFormatCodes(strCode As String)
Dim varSplit As Variant
Dim strNewCode As String
'Extract only the Numeric Component, 1st Element in Array
strNewCode = Trim(Split(strCode, " ")(0))

'Remove any Dashes (-)
strNewCode = Replace(strNewCode, "-", "")

'Standardize the Code Length based on the greatest displayed
strNewCode = Format(strNewCode, "0000-0000-0000")

'Return the Newly generated Codes with appropriate Designators
Select Case Left$(Split(strCode, " ")(1), 1)
  Case "W"         'Water Lines
    fFormatCodes = strNewCode & "-WL"
  Case "E"      'Electric
    fFormatCodes = strNewCode & "-EL"
  Case "G"      'Gas
    fFormatCodes = strNewCode & "-GA"
  Case Else
    fFormatCodes = strNewCode & "-UNK"
End Select
End Function

Outcome after Query execution:

Code:

Codes	                     New_Code
0010-301 Water lines	      0000-0001-0301-WL
0010-301 Water lines	      0000-0001-0301-WL
10010-0010-301 Water lines	1001-0001-0301-WL
10010-0010-301 Water lines	1001-0001-0301-WL
10301 Water Lines	         0000-0001-0301-WL
1234 Electric Line	        0000-0000-1234-EL
12-77-99-876 Elctrc	       0001-2779-9876-EL
1299-098 Gas Lines	        0000-0129-9098-GA
23345555555 Gas Lines	     0233-4555-5555-GA
3456-245 Gas Lines	        0000-0345-6245-GA
9876----612 Elec	          0000-0987-6612-EL
99876-721345 Nonsense Entry   0998-7672-1345-UNK

**zmbd** · Jul 2 '13, 10:17 PM

ADezii:
Along the lines of what I was suggesting; however much improved and pretty slick!
And I can see by automating that in the query how it could lead into the rest of what I was thinking about by using the result and going from two to one table and a query.

**ADezii** · Jul 2 '13, 11:29 PM

Thanks zmdb. Figuring and implementing the Logic was the easy part - trying not to Double Post was not so easy! (LOL). Can you DELETE the first Post for me? Thanks.

**jbryant** · Jul 3 '13, 01:26 PM

Thanks Guys, I will try to work with ADezii's suggestion. Kind of new to Access and working hard to build a system which takes less than 3 months to compile data. Some data is in Excel, some in CSV, some in DIF and some in simple text. To help with understanding scope, there are 412 separate department codes, my equipment file has over 40,000 items and I have to produce loss cost for all major lines of insurance (12 types) produce budget by department for each insurance expense, determine cost for 5 year average for losses to self insured fund (actuarially sound) and determine the cost per hundred of payroll for a few hundred NCCI codes.

**jbryant** · Jul 3 '13, 01:33 PM

Additional issue, Water lines and other departments are broken down:
Water Lines
10010-0123 sub EB meter 017
10010-0123 sub WB meter 026
10010-0126 sub EB dist 014
10010-0126 sub WB dist 015
10010-0348 sub EB rehab 017
etc

**ADezii** · Jul 3 '13, 02:14 PM

You definitely have your work cut out for you! I hope you are earning 6 figures (LOL).

**zmbd** · Jul 3 '13, 04:47 PM

And a 2nd on that!

What a mess.
I think that you're going to have to take an approach that combines both ADezii's automation and my relational tables.

As we progress thru this project, please keep in mind that Bytes is neither a code writing nor homework service. Attempting to help you develop the entire project is certainly beyond what we can offer. You can google and find sites such as Part I: Relational Database Design (I haven't looked entirely thru this site; thus, user beware :) ) to help you with modeling the database structure.

Break down of data from your post:
412 separate department codes.
my equipment file has over 40,000.
major lines of insurance.
department.
payroll.
NCCI codes.

Let us take a look at your equipment file.
Are there truely 40,000 unique items in this file, or is it more likely that there are only a few hundred basic items purchased from multiple venders?
Do this same thing with the remaining data...

412 separate department codes AND departments ... these are a related and more than likely should be in two seperate tables, and the codes are related to the equipment...

We're here to help when you get stuck.

**jbryant** · Jul 3 '13, 05:12 PM

I wish there was a way to send you some of my data and a portion of completed work so you could see the cluster **&*

**ADezii** · Jul 3 '13, 07:11 PM

Can you 'Attach' one of the Multiple Data Sources, preferably one that is truly representative of the other Data Sources? I am not speaking for zmbd, but I'm pretty sure that we both would like to assist you in tackling this Project. Without some Hard Core Data we are pretty much stuck in the mud at this point.

**jbryant** · Jul 3 '13, 08:18 PM

Code:

FNDNO	DPTNO	SUB1	DESC	STAT
2830			DRAIN & SEWER WAREHOUSE	A
2850			CONSOLIDATED WATER	A
2850	3907		CONSOLIDATED WATER	A
2860			ENVIRONMENTAL AFFAIRS	A
2880			INSPECTION & CODE	A
2880	3650		INSPECTION & CODE DIRECTOR	A
2930			PARKWAYS/RECREATION	A
10010			GENERAL FUND	A
10010	10		PARISH COUNCIL	A
10010	10	1	COUNCIL DISTRICT #1	N
10010	10	2	COUNCIL DISTRICT #2	N
10010	10	3	COUNCIL DISTRICT #3	N
10010	10	4	COUNCIL DISTRICT #4	N
10010	10	5	COUNCIL DISTRICT #5	N
10010	10	6	COUNCIL DISTRICT #6	N
10010	10	7	COUNCIL CHAIRMAN	N
10010	10	8	CHIEF OF STAFF TO COUNCIL	N
10010	10	9	PARISH CLERK	N
10010	10	10	RESEARCH & BUDGET	N
10010	10	11	COUNCIL RETIREES	N
10010	10	301	Council District No. 1	A
10010	10	302	Council District No. 2	A
10010	10	303	Council District No. 3	A
10010	10	304	Council District No. 4	A
10010	10	305	Council District No. 5	A
10010	10	306	Council-at-Large (A)	A
10010	10	307	Council-at-Large (B)	A
10010	10	308	Chief of Staff to the Council	A
10010	10	309	Parish Clerk	A
10010	10	310	Research & Budget	A
10010	10	311	Council Retirees	A
10010	11		LEGISLATIVE DELEGATION	A
10010	18		GOV AND ETHICS COMPLIANCE	A
10010	19		ADJUDICATED PROPERTY	N
10010	20		DISTRICT ATTORNEY	A
10010	20	12	DA Administration	A
10010	20	13	DA Felony Division	A
10010	20	14	DA 1st Parish Court Division	A
10010	20	15	DA 2nd Parish Court Division	A
10010	20	16	DA Screening/Records Division	A
10010	20	17	DA Research & Appeals	A
10010	20	18	DA Consumer Protection	A
10010	20	19	DA Juvenile Division	A
10010	20	20	DA Pre Trial Division	A
10010	21		LAW	A
10010	21		LAW - Administration	A
10010	21	355	Risk Management	A
10010	22		DISTRICT COURTS	A
10010	22	114	DISTRICT COURTS - Administration	A
10010	22	130	Court Reporters	A
10010	22	131	Law Clerks	A
10010	22	150	COURT COMMISSIONERS	N
10010	22	154	Judicial Secretaries	A
10010	23		FIRST PARISH COURT	A
10010	23	114	FIRST PARISH COURT - Administration	A
10010	23	132	DWI Division	A
10010	24		SECOND PARISH COURT	A
10010	24	114	SECOND PARISH COURT - Administration	A
10010	24	132	DWI Division	A
10010	25		JUVENILE COURTS	A
10010	26		PRO-TEM JUDGE	N
10010	27		JUSTICE OF THE PEACE	N
10010	28		CONSTABLES	N
10010	29		MISCELLANEOUS JUDICIAL	N
10010	30		PRE-TRIAL RELEASE	N
10010	31		DOMESTIC RELATIONS COURT	N
10010	31	114	Administration	A
10010	31	150	COURT COMMISSIONERS	N
10010	32		DRUG COURT	N
10010	32	151	I CAN DRUG COURT	N
10010	32	153	DRUG COURT DIVISION S	N
10010	40		PARISH PRESIDENT	A
10010	40	349	PUBLIC INFORMATION OFFICE	N
10010	50		ELECTIONS	N
10010	51		REGISTRAR OF VOTERS	A
10010	60		FINANCE DIRECTOR	A
10010	61		ACCOUNTING\PAYROLL	A
10010	62		BUDGET	A
10010	63		INTERNAL AUDITOR	A
10010	64		PURCHASING	A
10010	65		GENERAL SERVICES	A
10010	65	114	GENERAL SERVICES - Administration	A
10010	65	160	Courthouse	A
10010	65	161	Courthouse Annex	A
10010	65	162	CORRECTIONAL CENTER	N
10010	65	163	Yenni Building	A
10010	65	164	DAN HOGAN BUILDING	N
10010	65	165	Sheriff Admin Building	A
10010	65	166	First Parish Court	A
10010	65	168	EB Health Unit	A
10010	65	169	WB Health Unit	A
10010	65	170	Juvenile Justice Center	A
10010	65	171	Senior Citizen Centers	A
10010	65	172	Parking Lot	A
10010	65	173	Energy Conservation	A
10010	65	174	Central Plant	A
10010	65	175	District Attorney's Bldg	A
10010	65	176	WB Parking Garage	A
10010	65	177	Odom Building	A
10010	65	178	EB Juvenile Svc Bldg	A
10010	65	179	ODOM BLDG-HUMAN SVCS AUTH	A
10010	65	181	General Gov't	A
10010	65	182	Second Parish Court	A
10010	65	183	Clerk of Court Bldg	A
10010	65	184	Local History Center	A
10010	65	185	Other Facilities	A
10010	65	347	911/ EOC MAINTENANCE	N
10010	66		PERSONNEL	A
10010	67		ADMIN	A
10010	67		HUMAN RESOURCE MANAGEMENT	A
10010	67	114	HUMAN RESOURCE - Administration	A
10010	67	356	Safety	A
10010	68		PLANNING	A
10010	69		PLANNING ADVISORY BOARD	A
10010	70		RISK MANAGEMENT	A
10010	79		CENTRAL PRINTING	A
10010	79	126	CENTRAL PRINTING - EB	A
10010	79	127	CENTRAL PRINTING - WB	A
10010	80		MISC GENERAL SERVICES	N
10010	81		SURPLUS PROPERTY	A
10010	82		ONE STOP DEVELOPMENT	N
10010	100		PUBLIC SAFETY	N
10010	105		BOARD OF ZONING ADJUSTMENTS	A
10010	110		CODE ENFORCEMENT	A
10010	110	21	Inspection and Code Enforcement	A
10010	110	22	Taxi Cab Bureau	A
10010	110	23	Weed Control & Lot Fill	A
10010	110	24	Administrative Adjudication	A
10010	110	225	ONE-STOP DEVELOPMENT	N
10010	111		BUREAU ADMINISTRATIVE ADJUDICATION	A
10010	119		COMMUNITY JUSTICE AGENCY	A
10010	119	114	COMMUNITY JUSTICE - Administration	A
10010	119	291	Computer Center	A
10010	120		CORRECTIONS	A
10010	120	25	CORRECT CTR MEDICAL UNIT	N
10010	120	26	Correctional Ctr - Operations	A
10010	120	27	Home Detention	A
10010	130		FIRE SERVICES	A
10010	130	134	Emergency Medical Services	A
10010	130	136	VOLUNTEER FIRE	N
10010	130	137	Fire Training Facility	A
10010	140		EMERGENCY MANAGEMENT	A
10010	140	114	EMERGENCY MANAGEMENT - Administration	A
10010	140	135	Public Sheltering	A
10010	200		PUBLIC WORKS	N
10010	300		HEALTH & WELFARE	N
10010	300	114	HEALTH & WELFARE - Administration	N
10010	300	114	HEALTH & WELFARE - EB Administration	N
10010	300	114	HEALTH & WELFARE - WB Administration	N
10010	310		COUNTY AGENT	N
10010	320		SERVICEMEN'S ASSISTANCE	N
10010	330		JEFF CAP	A
10010	330	114	HEALTH & WELFARE - Administration	A
10010	330	138	Transportation	A
10010	330	230	Avondale Neighborhood Ctr	A
10010	330	231	Harvey Neighborhood Ctr	A
10010	330	248	Commodity Program	A
10010	330	282	Gretna Center	A
10010	330	341	Marrero Community Center	A
10010	340		OFFICE OF CITIZEN'S W/DISABILITIES	A
10010	340	340	DISABILITY AFFAIRS	N
10010	400		CULTURE AND RECREATION	N
10010	410		CITIZEN'S AFFAIRS	A
10010	410	114	CITIZEN'S AFFAIRS - Administration	A
10010	410	133	Parades & Special Events	A
10010	410	134	Emergency Medical Service	A
10010	410	289	Gaming Regulatory	A
10010	410	339	Senior Affairs	A
10010	420		TAXI CAB BUREAU	N
10010	850		NON-DEPARTMENTAL (Transfers out)	N
10010	860		PARISH PHOTOGRAPHER	A
21000			STATE GRANTS	N
21000	1000		STATE GRANTS	N
21000	1000	244	LITTER ABATEMENT PROGRAM	N
21000	1000	265	POST TRAINING	N
21000	1000	279	LA UNIV MARINE CONSORTIUM	N
21000	1000	290	CHILDREN'S TRUST FUND	N
21000	1000	298	LCLE ELECTRONIC EQUIP	N
21000	1000	342	UNIFORM CONSTR CODE IMPLE	N
21020			JEFFCAP	A
21020	1010		JEFFCAP - HEADSTART	A
21020	1010	214	Central Office	A
21020	1010	250	Headstart Westbank	A
21020	1010	251	Headstart Gretna	A
21020	1010	252	Headstart Kenner	A
21020	1010	253	Headstart Bridge City	A
21020	1010	254	BARATARIA/LAFITTE HEAD ST	N
21020	1010	255	GRAND ISLE HEAD START	N
21020	1010	256	31ST STREET HEAD START	N
21020	1010	257	CLAY STREET HEAD START	N
21020	1010	258	7TH AVENUE HEAD START	N
21020	1010	285	CAUSEWAY HEAD START	N
21020	2540	253	Headstart Barataria/Lafitte	A
21030			JEFFCAP-LACAP/LIHEAP	A
21030	1020		U S HEALTH HUMAN SERVICE	A
21030	1020	204	CSBG ADMINISTRATION	N
21030	1020	205	CSBG NEIGHBORHOOD SVC CTR	N
21030	1020	206	CREATIVE COLLABORATION	N
21030	1020	210	LIHEAP	N
21030	1020	213	HS WRAP AROUND CHILD CARE	N
21030	1020	272	TEMP ASST NEEDY FAMILIES	N
21030	1020	297	TITLE IV-E	N
21040			COMMUNITY JUSTICE	A
21040	1030		U S JUSTICE	A
21040	1030	208	IMP CONTROL SUBSTANCE TST	N
21040	1030	209	WEEKEND ATTENTION PROGRAM	N
21040	1030	212	TRT OF JUVENILE OFFENDERS	N
21040	1030	215	MENTORING	N
21040	1030	216	INFO SYSTEMS UPGRADE	N
21040	1030	219	PRE-TRIAL INTERVENTION	N
21040	1030	224	SUBS ABUSE AFTER-SCHOOL	N
21040	1030	228	DOM PREP EQUIP SUPPORT	N
21040	1030	232	LCLE ADMINISTRATIVE FUNDS	N
21040	1030	233	TREAT OF ADULT OFFENDERS	N
21040	1030	237	CRIME VICTIM ASSISTANCE	N
21040	1030	245	DEVELOP JUV DRUG COURTS	N
21040	1030	267	JUVENILE ASSESSMENT CTR	N
21040	1030	268	WEED AND SEED PROGRAM	N
21040	1030	276	DRUG SCREENING	N
21040	1030	286	REPORT/RESOURCE CENTER	N
21040	1030	320	CJ INFRASTRUCTURE RECOVER	N
21040	1030	321	JUVENILE SERVICES GRANTS	N
21040	1030	327	PROBATION OFFICER TRAININ	N
21040	1030	328	FAMILY STRENGHENING PGRM	N
21040	1030	330	DMC COORDINATOR	N
21050	1040		U S ACTION	N
21050	1040	238	RETIRED SENIOR VOL PROG	N
21050	1040	345	RSVP - PARISH MATCH	N
21060			JEFFCAP-WEATHERIZATION	A
21060	1050		U S ENERGY	N
21060	1050	222	WEATHERIZATION	N
21060	1051		ENVIRONMENTAL GRANTS	N
21070	1060		U S DEPT OF AGRICULTURE	N
21070	1060	200	FAMILY DAYCARE HOMES	N
21070	1060	201	EMERGENCY FOOD ASST PROG	N
21070	1060	202	CHILD CARE FOOD PROGRAM	N
21070	1060	254	BARATARIA/LAFITTE HEAD ST	N
21070	1060	285	CAUSEWAY HEAD START	N
21080			U S DEPT OF EDUCATION	N
21080	1070		US DEPT OF EDUCATION	N
21170			C D B G 1986	N
21170	1080		CDBG 1986	N
21180			C D B G 1987	N
21180	1090		CDBG 1987	N
21190			C D B G 1988	N
21190	1100		CDBG 1988	N
21200			C D B G 1989	N
21200	1110		CDBG 1989	N
21210			C D B G 1990	N
21210	1120		CDBG 1990	N
21220			C D B G 1991	N
21220	1120		CDBG 1990	N
21220	1130		CDBG 1991	N
21230			C D B G 1992	N
21230	1140		CDBG 1992	N
21240			C D B G 1993	N
21240	1150		CDBG 1993	N
21250			C D B G 1994	N
21250	1160		CDBG 1994	N
21260			C D B G 1995	N
21270			C D B G 1996	N
21280			C D B G	A
21280	1170		SECTION 108 LOAN PAYOUT	N
21280	1171		INDIRECT COSTS	N
21280	1172		Block Grant - Administration	A
21280	1172	139	Block Grant - Administration	A
21280	1173		Public Infrastructure & Facilities	N
21280	1173	1	COUNCIL DISTRICT #1	N
21280	1173	2	COUNCIL DISTRICT #2	N
21280	1173	3	COUNCIL DISTRICT #3	N
21280	1173	5	COUNCIL DISTRICT #5	N
21280	1174		Public Services	N
21280	1174	1	COUNCIL DISTRICT #1	N
21280	1174	2	COUNCIL DISTRICT #2	N
21280	1174	3	COUNCIL DISTRICT #3	N
21280	1175		Economic Development	N
21280	1176		Housing Rehabilitation	N
21280	1177		Clearance Activity	N
21281			C D B G - R	N
21310			CDBG DISASTER RECOVERY PG	N
21310	1192		COMM DEV - CDBG ADMIN	N
21310	1193		CDBG DRP PUB FACILITIES	N
21310	1194		CDBG DRP PUBLIC SERVICE	N
21340			COMMUNITY DEVELOPMENT	A
21340	1180		HOME Program Administration	N
21340	1180	35	KENNER	N
21340	1180	139	CHDO Set-Aside Project Funds	A
21340	1180	223	ST CHARLES PARISH	N
21340	1181		Owner Occupied Rehabilitation Proj	N
21340	1181	35	KENNER	N
21340	1181	223	ST CHARLES PARISH	N
21340	1182		First Time Homebuyers	N
21340	1182	35	KENNER	N
21340	1183		Replacement/Affordable Housing	N
21340	1184		CHDO Operating Subsidy Funds	N
21340	1185		CHDO PROJECTS	N
21340	1186		Developmental Funding Pool	N
21340	1186	35	KENNER	N
21340	1187		Tenant-Based Rental Assistance	N
21350			CDBG RENTAL REHAB	N
21350	1190		CDBG RENTAL REHAB	N
21360			JOBS BILL APPROPRIATION	N
21360	1200		JOBS BILL APPOPRIATION	N
21370			HUD DISASTER RELIEF	N
21370	1210		CDBG DISASTER RELIEF FUND	N
21390			HUD EMERGENCY SHELTER	N
21390	1220		HUD EMERG SHELTER ADMIN	N
21390	1221		HUD EMER SHELTER PROGRAM	N
21391			HUD HOMLESS PRV AND REHOU	N
21391	1220		HUD EMERG SHELTER ADMIN	N
21391	1221		HUD EMER SHELTER PROGRAM	N
21400			U S HUD MISC PROGRAMS	N
21400	1230		US HUD	N
21400	1230	264	HUD HOUSING COUNSELING	N
21400	1230	280	SHELTER PLUS CARE	N
21410			U S MISC GRANTS	N
21410	1240		US MISCELLANEOUS PROGRAMS	N
21410	1240	240	STATE ESG	N
21410	1240	263	FEMA-EMER FOOD & SHELTER	N
21410	1240	270	FEMA-UNMET NEEDS PROGRAM	N
21410	1240	281	FEMA-ACQUISTION & ELEVAT	N
21411			LA HOMLESS PRV AND REHOUS	N
21411	1220		HUD EMERG SHELTER ADMIN	N
21411	1221		HUD EMER SHELTER PROGRAM	N
21411	1240		US MISCELLANEOUS PROGRAMS	N
21420			HUD YOUTHBUILD GRANT	N
21420	1250		HUD YOUTHBUILD PLANNING	N
21430			HOMELAND SECURITY	N
21430	1255		HOMELAND SECURITY	N
21430	1255	295	REGIONAL PLANNING GRANT	N
21600			WORKFORCE CONNECTION	A
21600	1280		WORKFORCE CONNECTION - Administration	A
21600	1280	203	WELF-TO-WORK COMPETITIVE	N
21600	1280	229	WORKFORCE INVESTMENT ACT	N
21600	1280	243	WELFARE TO WORK FORMULA	N
21600	1280	271	SECTORAL EMPLOYMENT DEMO	N
21600	1280	273	WELFARE TO WORK	N
21610			PARISH-MISC GRANT PROGRAM	N
21610	1290		PARISH MISC GRANTS	N
21610	1290	217	LOC LAW ENFORCE BLOCK GRT	N
21610	1290	218	HIDTA AFTER SCHOOL PROG	N
21610	1290	220	VICTIM NOTIFICATION	N
21610	1290	221	VIOLENCE PREVENTION	N
21610	1290	226	TITLE IVD CHILD SUPPORT	N
21610	1290	227	VICTIM ASSISTANCE	N
21610	1290	239	DOM VIOL PRG-SPOUSE ABUSE	N
21610	1290	241	DOMESTIC VIOLENCE PROSECU	N
21610	1290	242	PROSECTION TRAINING	N
21610	1290	246	ARTS PROGRAM	N
21610	1290	249	ARTIFICIAL REEF PROJECT	N
21610	1290	261	CHILD ADVOCACY PROGRAM	N
21610	1290	262	VICTIM ASST COORDINATOR	N
21610	1290	266	ELECTRONIC EQUIPMENT	N
21610	1290	278	JEFFCAP SERVICES	N
21610	1290	287	ENVIRONMENTAL MISC PROGR	N
21610	1290	294	WEST NILE GRANT	N
21610	1290	296	LA ASSOC OF COMM ACT PART	N
21610	1290	317	ALCOHOL MONITORING PRGM	N
21610	1290	318	GATES FOUNDATION GRANT	N
21610	1290	322	CHILDREN'S SUMMER PROJECT	N
21610	1290	323	FIT FOR LIFE	N
21610	1290	324	COURT EMPOWERMENT PROGRAM	N
21610	1290	325	MODELS FOR CHANGE	N
21610	1290	326	URBAN AND COMM FORESTRY	N
21610	1290	329	GOLDEN AGERS	N
21610	1290	331	LITTER PREVENTION	N
21610	1290	343	LA ECONOMIC DEVELOPMENT	N
21610	1293		MISC LIBRARY GRANTS	N
21610	1293	318	GATES FOUNDATION GRANT	N
21610	1294		PARISH MISC CJA GRANTS	N
21610	1294	325	MODELS FOR CHANGE	N
21640			N O A A GRANTS	N
21640	1291		NOAA GRANTS	N
21640	1291	234	COASTAL ZONE MANAGEMENT	N
21640	1291	235	CHRISTMAS TREE PROJECT	N
21640	1291	236	CZM-STORMWATER	N
21640	1291	247	WATER QUALITY PROJECT	N
21640	1291	269	FIVE STAR RESTORATION	N
21640	1291	288	COASTAL IMPACT ASSISTANCE	N
21650			U S ENVIRON PROTECT AGNCY	N
21650	1292		U S EPA	N
21650	1292	277	BROWNFIELD PILOTS COOP AG	N
21650	1292	284	VULNERABLTY ASSESS WATER	N
21660			FEDERAL TRANSIT ADMINIST	N
21660	4050		TRANSIT CAPITAL PROJECTS	N
21660	4050	207	FTA ASSISTANCE	N
21660	4050	211	JOB ACCESS	N
21660	4050	283	EB TRANSIT CENTER	N
21670			TRANSIT	A
21670	2000		TRANSIT - Administration	A
21670	2002		TAXI CAB	N
21680			TRANSIT - ELDERLY/HANDICAP (MITS)	A
21680	2001		TRANSIT - ELDERLY/HANDICAP (MITS)	A
21690			COMMUNITY JUSTICE AGENCY	N
21690	2100		CJA - ADMINISTRATION	N
21690	2101		CJA - COMPUTER CENTER	N
21700			JUVENILE DETENTION	A
21700	2150		Juvenile Detention - Administration	A
21700	2151		Detention	A
21700	2152		Probation	A
21700	2153		JUVENILE SVC - TREATMENT	N
21700	2154		JUVENILE SVC - VOL SERV	N
21700	2155		Community Program	A
21700	2155	155	DAY REPORTING CENTER	N
21700	2155	156	JUV DETENTION ALTERNATIVE	N
21700	2155	157	Truancy Assessment	A
21700	2155	158	CORRECTIONAL OPTIONS	N
21700	2155	159	Title IV - E	A
21710			ANIMAL SHELTER	A
21710	0	346	SPAY NEUTER PROGRAM	N
21710	2200		ANIMAL SHELTER - Administration	A
21710	2201		SPAY/NEUTER PROGRAMS	N
21720			MOSQUITO CONTROL	A
21720	2250		MOSQUITO CONTROL - Administration	N
21730			HEALTH UNIT	A
21730	2300		HEALTH UNIT - Administration	A
21740			HUMAN SERVICES AUTHORITY	A
21740	2350		HUMAN SERVICES AUTHORITY	N
21760			AMBULANCE DIST #1 LAFITTE	N
21760	2400		AMBULANCE DIST#1 LAFITTE	N
21770			AMBULANCE DIST #2 - GRAND ISLE	A
21770	2425		AMBULANCE DIST #2 - Administration	N
21790			LIBRARY	A
21790	2450		LIBRARY - Administration	A
21790	2451		LIBRARY - Libraries	A
21790	2451	28	E B Floaters and Substitutes	A
21790	2451	29	E B Regional	A
21790	2451	31	Old Metairie	A
21790	2451	32	Rosedale	A
21790	2451	33	Wagner	A
21790	2451	34	Harahan	A
21790	2451	35	KENNER	N
21790	2451	36	North Kenner	A
21790	2451	37	W B Floaters and Substitutes	A
21790	2451	38	W B Regional	A
21790	2451	39	Belle Terre	A
21790	2451	40	Grand Isle	A
21790	2451	41	Gretna	A
21790	2451	42	Lafitte/Barataria	A
21790	2451	43	Live Oak	A
21790	2451	45	Terrytown	A
21790	2451	46	Westwego	A
21790	2451	53	Lakeshore	A
21790	2451	89	LIBRARY - Maintenance	A
21790	2451	162	CORRECTIONAL CENTER	N
21790	2451	167	Riverside	A
21790	2451	180	Archives	A
21790	2451	312	River Ridge	A
21790	2451	351	JEFFERSON HWY 8908	A
21790	2452		LIBRARY - Automation	A
21790	2453		LIBRARY - Maintenance	A
21790	2454		LIBRARY - MRKTG AND DEVEL	N
21800			CONSOL PLAYGROUND DIST #1	N
21800	2500		PK/REC EB ADMINISTRATION	N
21800	2501		CONSOL PLAYGROUND DIST #1	N
21800	2502		PK/REC EB ATHLETIC PROGS	N
21800	2503		PK/REC EB LEISURE SERVICE	N
21800	2504		PK/REC EB PLAYGROUNDS	N
21800	2505		PK/REC EB SATELLITE SITES	N
21800	2505	58	AIRLINE TOT LOT	N
21800	2505	59	CAMP PARAPET	N
21800	2505	60	IVY STREET	N
21800	2505	61	LITTLE JEFFERSON	N
21800	2505	62	LITTLE METAIRIE	N
21800	2505	63	WILLIAMS PLAY LOT	N
21800	2505	147	BONNABEL BOAT LAUNCH	N
21800	2505	148	CAUSEWAY PROJECT	N
21800	2506		PK/REC EB GOLDEN AGERS	N
21810			CONSOL PLAYGROUND DIST #2	N
21810	2550		PK/REC WB ADMINISTRATION	N
21810	2551		WB - MAINTENANCE	N
21810	2552		PK/REC WB ATHLETIC PROGS	N
21810	2553		PK/REC WB LEISURE SERVICE	N
21810	2554		CONSOL PLAYGROUND DIST #2	N
21810	2554	72	CONSOL PLAYGROUND DIST #2	N
21810	2555		PK/REC WB SATELLITE SITES	N
21810	2555	77	BRIDGE CITY TOT LOT	N
21810	2555	78	DRAKE AVENUE PARK	N
21810	2555	79	GLISSON PARK	N
21810	2555	80	HOLMES BOULEVARD	N
21810	2555	81	LOWER LAFITTE	N
21810	2555	82	THOMAS JEFFERSON	N
21810	2555	83	WILSON STREET	N
21810	2555	84	WOODLAND WEST	N
21810	2555	85	WOODMERE	N
21810	2555	87	BENT TREE	N
21810	2555	88	OAK FOREST	N
21810	2555	90	N AVONDALE WALKING TRAIL	N
21810	2555	91	S AVONDALE WALKING TRAIL	N
21810	2555	92	BROWN ST	N
21810	2556		PK/REC WB GOLDEN AGERS	N
21810	2557		PK/REC PARC DES FAMILLES	N
21820			PLAYGROUND DISTRICT 10	N
21820	2600		ROSETHORNE - ADMIN	N
21820	2601		ROSETHORNE - MAINTENANCE	N
21820	2605		ROSETHORNE-SATELLITE SITE	N
21820	2605	79	GLISSON PARK	N
21820	2605	81	LOWER LAFITTE	N
21820	2606		ROSE-COMMUNITY & GOLDEN A	N
21830			CONSOLIDATED JEFFERSON RECREATION AND CO	A
21830	2530		RECREATION - Administration	A
21830	2531		RECREATION - Maintenance	A
21830	2532		RECREATION - Athletic Programs	A
21830	2533		RECREATION - Leisure Services	A
21830	2534		RECREATION - Playgrounds	A
21830	2534	39	Belle Terre	A
21830	2534	45	Terrytown	A
21830	2534	47	John Bright	A
21830	2534	48	Cleary	A
21830	2534	49	Delta	A
21830	2534	50	Girard	A
21830	2534	51	Jefferson	A
21830	2534	52	Jesse Owens	A
21830	2534	53	Lakeshore	A
21830	2534	54	Lemon	A
21830	2534	55	Little Farms	A
21830	2534	56	Metairie	A
21830	2534	57	Mike Miley	A
21830	2534	64	Avondale	A
21830	2534	65	Bridge City	A
21830	2534	67	Harvey	A
21830	2534	68	Kennedy Heights	A
21830	2534	69	King's Grant	A
21830	2534	70	Johnny Jacobs	A
21830	2534	71	Martin Luther King	A
21830	2534	72	Nicholson Place	A
21830	2534	73	Oakdale	A
21830	2534	74	Pard	A
21830	2534	76	Waggaman	A
21830	2534	85	WOODMERE	N
21830	2534	86	Rosethorne	A
21830	2534	93	Saints Drive	A
21830	2534	94	Bonnabel Boat Launch	A
21830	2534	114	Estelle	A
21830	2534	146	Operations	A
21830	2535		SATELLITE SITES	A
21830	2536		BUCKTOWN HARBOR	A
21850			ALARIO CENTER	A
21850	2615		ALARIO CENTER - Administration	A
21850	2616		SEGNETTE FIELD	A
21930			CENTER AND PLAYGROUND DISTRICT	A
21930			WEST JEFFERSON PARK AND COMMUNITY	A
21930	2660		WJ PARK & COMMUNITY - Administration	N
21930	2661		WJ PARK & COMMUNITY - Maintenance	N
21930	2662		WJ PARK & COMMUNITY - Security	N
21940			PLAYGROUND DIST #16	A
21940	2625		PLAYGROUND DIST #16	N
21950			LAFRENIERE PARK	A
21950	2650		LAFRENIERE PARK - Administration	A
21950	2651		LAFRENIERE PARK - Maintenance	A
21950	2652		LAFRENIERE PARK - Security	N
21960			TOURISM	N
21960	2675		TOURISM	N
21960	2675	152	BEAUTIFICATION	N
21970			LASALLE PARK	A
21970	2630		LASALLE PARK - Administration	A
21970	2631		LASALLE PARK - Maintenance	N
21970	2632		LASALLE PARK - Security	N
22000			COMMUNITY SERVICES	N
22000	2700		GAMING REGULATORY INSPECT	N
22000	2710		CITIZENS WITH DISABILITY	N
22000	2720		CD - MISCELLANEOUS	N
22000	2731		COMM SERV COUNCIL DIST #1	N
22000	2731	140	PUBLIC SAFETY	N
22000	2731	141	PUBLIC WORKS	N
22000	2731	142	TRANSIT	N
22000	2731	143	HEALTH & WELFARE	N
22000	2731	144	CULTURE & RECREATION	N
22000	2731	145	URBAN REDEVELOP & HOUSING	N
22000	2732		COMM SERV COUNCIL DIST #2	N
22000	2732	140	PUBLIC SAFETY	N
22000	2732	141	PUBLIC WORKS	N
22000	2732	142	TRANSIT	N
22000	2732	143	HEALTH & WELFARE	N
22000	2732	144	CULTURE & RECREATION	N
22000	2732	145	URBAN REDEVELOP & HOUSING	N
22000	2733		COMM SERV COUNCIL DIST #3	N
22000	2733	140	PUBLIC SAFETY	N
22000	2733	141	PUBLIC WORKS	N
22000	2733	142	TRANSIT	N
22000	2733	143	HEALTH & WELFARE	N
22000	2733	144	CULTURE & RECREATION	N
22000	2733	145	URBAN REDEVELOP & HOUSING	N
22000	2734		COMM SERV COUNCIL DIST #4	N
22000	2734	140	PUBLIC SAFETY	N
22000	2734	141	PUBLIC WORKS	N
22000	2734	142	TRANSIT	N
22000	2734	143	HEALTH & WELFARE	N
22000	2734	144	CULTURE & RECREATION	N
22000	2734	145	URBAN REDEVELOP & HOUSING	N
22000	2735		COMM SERV COUNCIL DIST #5	N
22000	2735	140	PUBLIC SAFETY	N
22000	2735	141	PUBLIC WORKS	N
22000	2735	142	TRANSIT	N
22000	2735	143	HEALTH & WELFARE	N
22000	2735	144	CULTURE & RECREATION	N
22000	2735	145	URBAN REDEVELOP & HOUSING	N
22000	2736		COMM SERV COUNCIL DIST #6	N
22000	2736	140	PUBLIC SAFETY	N
22000	2736	141	PUBLIC WORKS	N
22000	2736	142	TRANSIT	N
22000	2736	143	HEALTH & WELFARE	N
22000	2736	144	CULTURE & RECREATION	N
22000	2736	145	URBAN REDEVELOP & HOUSING	N
22010			C D OFF-TRACK BETTING FD	N
22010	0	1	COUNCIL DISTRICT #1	N
22010	0	2	COUNCIL DISTRICT #2	N
22010	0	3	COUNCIL DISTRICT #3	N
22010	0	4	COUNCIL DISTRICT #4	N
22010	0	5	COUNCIL DISTRICT #5	N
22010	0	6	COUNCIL DISTRICT #6	N
22010	2741		OTB COUNCIL DISTRICT #1	N
22010	2741	140	PUBLIC SAFETY	N
22010	2741	141	PUBLIC WORKS	N
22010	2741	142	TRANSIT	N
22010	2741	143	HEALTH & WELFARE	N
22010	2741	144	CULTURE & RECREATION	N
22010	2741	145	URBAN REDEVELOP & HOUSING	N
22010	2742		OTB COUNCIL DISTRICT #2	N
22010	2742	140	PUBLIC SAFETY	N
22010	2742	141	PUBLIC WORKS	N
22010	2742	142	TRANSIT	N
22010	2742	143	HEALTH & WELFARE	N
22010	2742	144	CULTURE & RECREATION	N
22010	2742	145	URBAN REDEVELOP & HOUSING	N
22010	2743		OTB COUNCIL DISTRICT #3	N
22010	2743	140	PUBLIC SAFETY	N
22010	2743	141	PUBLIC WORKS	N
22010	2743	142	TRANSIT	N
22010	2743	143	HEALTH & WELFARE	N
22010	2743	144	CULTURE & RECREATION	N
22010	2743	145	URBAN REDEVELOP & HOUSING	N
22010	2744		OTB COUNCIL DISTRICT #4	N
22010	2744	141	PUBLIC WORKS	N
22010	2744	144	CULTURE & RECREATION	N
22010	2745		OTB COUNCIL DISTRICT #5	N
22010	2745	141	PUBLIC WORKS	N
22010	2746		OTB COUNCIL DISTRICT #6	N
22010	2746	141	PUBLIC WORKS	N
22010	2746	143	HEALTH & WELFARE	N
22010	2746	144	CULTURE & RECREATION	N
22010	2746	145	URBAN REDEVELOP & HOUSING	N
22020			C D VIDEO POKER FUND	N
22020	0	1	COUNCIL DISTRICT #1	N
22020	0	2	COUNCIL DISTRICT #2	N
22020	0	3	COUNCIL DISTRICT #3	N
22020	0	4	COUNCIL DISTRICT #4	N
22020	0	5	COUNCIL DISTRICT #5	N
22020	0	6	COUNCIL DISTRICT #6	N
22020	2751		VIDEO POKER COUNC DIST #1	N
22020	2751	140	PUBLIC SAFETY	N
22020	2751	141	PUBLIC WORKS	N
22020	2751	142	TRANSIT	N
22020	2751	143	HEALTH & WELFARE	N
22020	2751	144	CULTURE & RECREATION	N
22020	2751	145	URBAN REDEVELOP & HOUSING	N
22020	2752		VIDEO POKER COUNC DIST #2	N
22020	2752	140	PUBLIC SAFETY	N
22020	2752	141	PUBLIC WORKS	N
22020	2752	142	TRANSIT	N
22020	2752	143	HEALTH & WELFARE	N
22020	2752	144	CULTURE & RECREATION	N
22020	2752	145	URBAN REDEVELOP & HOUSING	N
22020	2753		VIDEO POKER COUNC DIST #3	N
22020	2753	140	PUBLIC SAFETY	N
22020	2753	141	PUBLIC WORKS	N
22020	2753	142	TRANSIT	N
22020	2753	143	HEALTH & WELFARE	N
22020	2753	144	CULTURE & RECREATION	N
22020	2753	145	URBAN REDEVELOP & HOUSING	N
22020	2754		VIDEO POKER COUNC DIST #4	N
22020	2754	140	PUBLIC SAFETY	N
22020	2754	141	PUBLIC WORKS	N
22020	2754	142	TRANSIT	N
22020	2754	143	HEALTH & WELFARE	N
22020	2754	144	CULTURE & RECREATION	N
22020	2754	145	URBAN REDEVELOP & HOUSING	N
22020	2755		VIDEO POKER COUNC DIST #5	N
22020	2755	140	PUBLIC SAFETY	N
22020	2755	141	PUBLIC WORKS	N
22020	2755	142	TRANSIT	N
22020	2755	143	HEALTH & WELFARE	N
22020	2755	144	CULTURE & RECREATION	N
22020	2755	145	URBAN REDEVELOP & HOUSING	N
22020	2756		VIDEO POKER COUNC DIST #6	N
22020	2756	140	PUBLIC SAFETY	N
22020	2756	141	PUBLIC WORKS	N
22020	2756	142	TRANSIT	N
22020	2756	143	HEALTH & WELFARE	N
22020	2756	144	CULTURE & RECREATION	N
22020	2756	145	URBAN REDEVELOP & HOUSING	N
22030			WESTBANK C D TOURISM FUND	N
22030	0	1	COUNCIL DISTRICT #1	N
22030	0	2	COUNCIL DISTRICT #2	N
22030	0	3	COUNCIL DISTRICT #3	N
22030	2761		TOURISM COUNCIL DIST #1	N
22030	2761	140	PUBLIC SAFETY	N
22030	2761	141	PUBLIC WORKS	N
22030	2761	142	TRANSIT	N
22030	2761	143	HEALTH & WELFARE	N
22030	2761	144	CULTURE & RECREATION	N
22030	2761	145	URBAN REDEVELOP & HOUSING	N
22030	2762		TOURISM COUNCIL DIST #2	N
22030	2762	140	PUBLIC SAFETY	N
22030	2762	141	PUBLIC WORKS	N
22030	2762	142	TRANSIT	N
22030	2762	143	HEALTH & WELFARE	N
22030	2762	144	CULTURE & RECREATION	N
22030	2762	145	URBAN REDEVELOP & HOUSING	N
22030	2763		TOURISM COUNCIL DIST #3	N
22030	2763	140	PUBLIC SAFETY	N
22030	2763	141	PUBLIC WORKS	N
22030	2763	142	TRANSIT	N
22030	2763	143	HEALTH & WELFARE	N
22030	2763	144	CULTURE & RECREATION	N
22030	2763	145	URBAN REDEVELOP & HOUSING	N
22040			C D RIVERBOAT GAMING FD	N
22040	0	1	COUNCIL DISTRICT #1	N
22040	0	2	COUNCIL DISTRICT #2	N
22040	0	3	COUNCIL DISTRICT #3	N
22040	2771		RIVERBOAT GAMING C D #1	N
22040	2771	140	PUBLIC SAFETY	N
22040	2771	141	PUBLIC WORKS	N
22040	2771	142	TRANSIT	N
22040	2771	143	HEALTH & WELFARE	N
22040	2771	144	CULTURE & RECREATION	N
22040	2771	145	URBAN REDEVELOP & HOUSING	N
22040	2772		RIVERBOAT GAMING C D #2	N
22040	2772	140	PUBLIC SAFETY	N
22040	2772	141	PUBLIC WORKS	N
22040	2772	142	TRANSIT	N
22040	2772	143	HEALTH & WELFARE	N
22040	2772	144	CULTURE & RECREATION	N
22040	2772	145	URBAN REDEVELOP & HOUSING	N
22040	2773		RIVERBOAT GAMING C D #3	N
22040	2773	140	PUBLIC SAFETY	N
22040	2773	141	PUBLIC WORKS	N
22040	2773	142	TRANSIT	N
22040	2773	143	HEALTH & WELFARE	N
22040	2773	144	CULTURE & RECREATION	N
22040	2773	145	URBAN REDEVELOP & HOUSING	N
22050			WB RIVERBOAT MONITORING	N
22050	2800		WB RIVERBOAT MONITORING	N
22060			E B RIVERBOAT GAMING	N
22060	2810		EB RIVERBOAT GAMBLING	N
22070			EB RIVERBOAT MONITORING	N
22070	2820		EB RIVERBOAT MONITORING	N
22080			FIRE DISTRICT NO. 9 - GRAND ISLE	A
22080	2900		FIRE DISTRICT NO. 9 - GRAND ISLE	A
22090			FIRE DISTRICT NO. 4 - LAFITTE	A
22090	2910		FIRE DISTRICT NO. 4 - LAFITTE	A
22100			EB CONSOL FIRE DISTRICT	A
22100	2860		EB CONSOL FIRE - Hazardous Materials	A
22100	2920		EB CONSOL FIRE - Administration	A
22100	2921		EB CONSOL FIRE = Suppression	A
22100	2922		EB CONSOL FIRE - Prevention	A
22100	2923		EB CONSOL FIRE - Arson	A
22100	2924		EB CONSOL FIRE = Hazardous Materials	A
22100	2925		EB CONSOL FIRE - Fire Civil Service	A
22110			FIRE DISTRICT NO. 3 - RIVERRIDGE	A
22110	2930		FIRE DISTRICT NO. 3 - RIVERRIDGE	A
22120			FIRE DISTRICT NO. 5 - TERRYTOWN	A
22120	2940		FIRE DISTRICT NO. 5 - TERRYTOWN	A
22130			FIRE DISTRICT NO. 6 - HARVEY	A
22130	2950		FIRE DISTRICT NO. 6 - HARVEY	A
22140			FIRE DISTRICT NO. 7 - WESTWEGO AREA	A
22140	2960		FIRE DISTRICT NO. 7 - Administration	A
22140	2961		FIRE DIST NO 7--WKB	N
22150			FIRE DISTRICT NO. 8 - MARRERO	A
22150	2970		FIRE DISTRICT NO. 8 - MARRERO	A
22160			EMERGENCY COMMUNICATIONS	A
22160	2850		TELECOMMUNICATIONS	A
22160	2851		911/EOC OPERATIONS	N
22160	3951		CENTRAL TELEPHONE	A
22160	3964		CENT TELE CONTRACTUAL	A
22170			HAZ MATERIALS EMERG PREP	N
22170	2860		HAZ MATERIALS EMERG PREP	A
22180			SECURITY ENHANCEMENT DISTRICT	A
22180	0	274	STONEBRIDGE	N
22180	0	275	PLANTATION ESTATES	N
22180	0	350	ESPRIT AT STONEBRIDGE	N
22180	2870		STONEBRIDGE SECURITY DISTRICT	N
22180	2871		PLANTATION ESTATES SECURITY DISTRICT	N
22180	2875		ESPIRIT SECURITY DISTRICT	N
22190			24TH COURT COMMISSIONERS	A
22190	2880		CRIMINAL COMMISSIONERS	N
22190	2880	114	Criminal Commissioners - Administration	A
22190	2880	114	Criminal Commissioners - Commissioners	A
22190	2881		DOMESTIC COMMISSIONERS	N
22190	2881	114	Domestic Commissioners - Administration	A
22190	2881	332	Domestic Commissioners - Commissioners	A
22190	2881	333	Domestic Commissioners - Hearing Officer	A
22200			STREETS	A
22200	0	348	CPZ OPERATIONS	N
22200	3000		STREETS - Admin	A
22200	3002		STREETS - EB Maintenance	A
22200	3003		STREETS - WB Maintenance	A
22200	3005		STREETS - Traffic Engineering	A
22200	3050		PARKWAYS - Administration	A
22200	3050		PARKWAYS - Administration	N
22200	3051		PARKWAYS - EB Maintenance	A
22200	3052		PARKWAYS - WB Maintenance	A
22200	3053		STREETS - CPZ Maintenance	A
22210			PARKWAYS	A
22210	3050		PARKWAYS - Administration	N
22210	3051		PARKWAYS - EB Maintenance	A
22210	3052		PARKWAYS - WB Maintenance	A
22230			ROAD LIGHTING DIST. NO 7	A
22230	3100		ROAD LIGHTING DIST. NO 7	N
22240			CONSOLIDATED ROAD LIGHTING DISTRICT	A
22240	3110		CONSOLIDATED ROAD LIGHTING DISTRICT	A
22300			CONS. DRAINAGE DIST #1	N
22300	3150		CONS DRAIN #1 ADMIN	N
22300	3151		CONS DRAIN #1 CHANNELS	N
22300	3152		CONS DRAIN # 1 SPRAYING	N
22300	3153		CON DRAIN #1 GRASSCUTTING	N
22300	3154		CONS DRAIN # 1 SUBSURFACE	N
22300	3155		CONS DRAIN # 1 GIS	N
22300	3156		CONS DRAIN # 1 VACTOR	N
22300	3157		CONS DRAIN #1 MAINTENANCE	N
22310			FOURTH JEFF DRAINAGE DIST	N
22310	3200		4TH DRAIN - ADMIN	N
22310	3201		4TH DRAIN - CHANNELS	N
22310	3202		4TH DRAIN - SPRAYING	N
22310	3203		4TH DRAIN - GRASSCUTTING	N
22310	3204		4TH DRAIN - SUBSURFACE	N
22310	3205		4TH DRAIN - GIS	N
22310	3206		4TH DRAIN - VACTOR	N
22310	3207		4TH DRAIN - MAINTENANCE	N
22320			CONSOLIDATED DRAINAGE DISTRICT NO. 2	A
22320	3270		DRAINAGE ADMINISTRATION	A
22320	3270	114	Drainage Administration - Yenni Bldg	A
22320	3270	126	Drainage Administration - EB Rheem	A
22320	3270	127	Drainage Administration - WB LA18	A
22320	3270	186	EB PUMP STATIONS ADMIN	N
22320	3270	187	WB PUMP STATIONS ADMIN	N
22320	3271		CONS DRAIN - CHANNELS	N
22320	3272		CONS DRAIN - SPRAYING	N
22320	3273		CONS DRAIN - GRASSCUTTING	N
22320	3274		CONS DRAIN - SUBSURFACE	N
22320	3275		CONS DRAIN - GIS	N
22320	3276		CONS DRAIN - VACTOR	N
22320	3277		CONS DRAIN - MAINTENANCE	N
22320	3280		CONS DRAINAGE-MAINTENANCE	A
22320	3280	126	Drainage- Maintenance EB	A
22320	3280	127	District #1	A
22320	3280	127	District #9	A
22320	3280	127	Drainage- Maintenance WB	A
22320	3301		DRAINAGE - Eastbank Pump Station	A
22320	3301	89	DRAINAGE - Eastbank Maintenance	A
22320	3301	96	DRAINAGE - Eastbank P/S #1 Bonnabel	A
22320	3301	97	DRAINAGE - Eastbank P/S #2 Lake Villa	A
22320	3301	98	DRAINAGE - Eastbank P/S #3 Elmwood	A
22320	3301	99	DRAINAGE - Eastbank P/S #4 Duncan	A
22320	3301	100	DRAINAGE - Eastbank P/S #5 Parish Line	A
22320	3301	101	DRAINAGE - Eastbank Lift Station	A
22320	3301	313	DRAINAGE - Eastbank Line Repair	A
22320	3301	314	DRAINAGE - Eastbank Line Cleaning	A
22320	3301	315	DRAINAGE - Eastbank Canal Restoration	A
22320	3301	316	DRAINAGE - Eastbank Grass Cutting	A
22320	3302		DRAINAGE - WESTBANK PUMP STATIONS	A
22320	3302	67	DRAINAGE - Westbank Harvey	A
22320	3302	89	DRAINAGE - Westbank Mainenance	A
22320	3302	101	DRAINAGE - Westbank Electric	A
22320	3302	102	DRAINAGE - Westbank Cataouatche #1	A
22320	3302	104	DRAINAGE - Westbank Bayou Segnette	A
22320	3302	106	DRAINAGE - Westbank Westwego #2	A
22320	3302	107	DRAINAGE - Westbank Ames	A
22320	3302	108	DRAINAGE - Westbank Westminister	A
22320	3302	109	DRAINAGE - Westbank Cousins #1	A
22320	3302	110	DRAINAGE - Westbank Whitney Barataria	A
22320	3302	111	DRAINAGE - Westbank Planters	A
22320	3302	112	DRAINAGE - Westbank Hero	A
22320	3302	113	DRAINAGE - Westbank Estelle	A
22320	3302	313	DRAINAGE - Westbank Line Repair	A
22320	3302	314	DRAINAGE - Westbank Line Cleaning	A
22320	3302	315	DRAINAGE - Westbank Canal Restoration	A
22330			DRAINAGE DISTRICT #9	N
22330	3250		3250-DRAINAGE DISTRICT #9	N
22330	3251		3251-DRAINAGE DISTRICT #9	N
22330	3252		3252-DRAINAGE DISTRICT #9	N
22330	3253		3253-DRAINAGE DISTRICT #9	N
22330	3254		3254-DRAINAGE DISTRICT #9	N
22330	3255		3255-DRAINAGE DISTRICT #9	N
22330	3256		3256-DRAINAGE DISTRICT #9	N
22330	3257		3257-DRAINAGE DISTRICT #9	N
22340			CONSOLIDATED DRAINAGE - OLD	A
22340	3300		DRG PUMP STATIONS - ADMIN	N
22340	3301		EASTBANK PUMPSTATIONS	N
22340	3301	96	P/S #1- Bonnabel	A
22340	3301	97	P/S #2 - Lake Villa	A
22340	3301	98	P/S #3- Elmwood	A
22340	3301	99	P/S #4 - Duncan	A
22340	3301	100	P/S #5 - Parish Line	A
22340	3301	101	Electric	A
22340	3302		WEST BANK PUMP STATIONS	N
22340	3302	67	Harvey	A
22340	3302	101	Electric	A
22340	3302	102	Cataouatche #1	A
22340	3302	103	CATAOUATCHE #2	N
22340	3302	104	Bayou Segnette	A
22340	3302	106	Westwego #2	A
22340	3302	107	Ames	A
22340	3302	108	Westminister	A
22340	3302	109	Cousins #1	A
22340	3302	110	Whitney Barataria	A
22340	3302	111	Planters	A
22340	3302	112	Hero	A
22340	3302	113	Estelle	A
22390			CONSOLIDATED GARBAGE DIST NO. 1	A
22390	3340		CONSOLIDATED GARBAGE DIST NO. 1	N
22390	3340	126	CONSOLIDATED GARBAGE - EB - Dist No. 1	A
22390	3340	127	CONSOLIDATED GARBAGE - WB - Dist No. 2	A
22390	3340	127	Westbank	A
22390	3340	127	WB - District No. 6	A
22400			GARBAGE DISTRICT #1	N
22400	3350		GARBAGE DISTRICT #1	N
22410			GARBAGE DISTRICT #2	N
22410	3400		GARBAGE DISTRICT #2	N
22420			GARBAGE DIST #6 LAFITTE	N
22420	3450		GARBAGE DIST.#6 - LAFITTE	N
22430			LANDFILL DIVISION	A
22430	3500		LANDFILL DIVISION	N
22500			JEDCO	N
22500	3550		JEDCO	N
22510			ECONOMIC DEVELOPMENT	A
22510	3551		ECONOMIC DEVELOPMENT - Administration	N
22520			ECONOMIC INCENTIVE	N
22520	3552		ECONOMIC INCENTIVE - Administration	N
22530			CRIMINAL JUSTICE	N
22530	3553		CRIMINAL JUSTICE - Administration	N
22540			CULTURE & PARKS	N
22540	0	554	CULTURE	N
22540	0	555	PARKS	N
22540	3554		CULTURE & PARKS - Culture	N
22540	3555		CULTURE & PARKS - Parks	N
22560			SENIOR SERVICES	N
22560	3556		SENIOR SERVICES - GENERAL	A
22560	3556	114	Senior Services - Administration	A
22560	3557		SENIOR SERVICES CENTER	A
22560	3557	42	Senior Services Ctr - Lafitte Barrataria	A
22560	3557	44	Senior Services Center - Marrero	A
22560	3557	51	Senior Services Center - Jefferson	A
22560	3557	56	Senior Services Center - Metairie	A
22560	3557	65	Senior Services Center - Bridge City	
22560	3557	113	Senior Services Center - Estelle	A
22560	3558		SENIOR SERVICES - Golden Ages	A
22560	3558	126	Senior Services - Golden Ages - EB	A
22560	3558	127	Senior Services - Golden Ages - WB	A
22570			TERRYTOWN TIF	A
22570	2872		TERRYTOWN REDEVELOPMENT	N
22580			METAIRIE CBD	A
22580	2873		METAIRIE CBD ECON DEV DIS	N
22590			CHURCHILL ECON DEV DIST	N
22590	2874		CHURCHILL ECON DEV DIST	N
22600			INSPECTOR GENERAL	A
22600	0		REVENUES	A
22600	3560		INSPECTOR GENERAL	A
22600	3560	352	INSPECTOR GENERAL	A
22650	3559		PUB ED AND GOVT PROGRAMNG	N
36030			W W II CAPITAL ADDITIONS	N
36030	5001		WWII CAPITAL ADDITIONS	N
36050			W W II REV BOND RESERVE	N
36050	5002		WWII REVENUE BOND RESERVE	N
36960			WB II WATER REVENUE BOND	N
36960	5003		WB II WATER REVENUE BOND	N
37100			LO 10004 VETERANS SIDEWLK	N
37100	5011		LO10004 VETERANS SIDEWALK	N
37350			L O 132 VISTAS	N
37350	5012		LO 132 VISTAS	N
37450			L O 140 M BEHRMAN WALK	N
37460			L O 138 WALDO STREET	N
37460	5014		LO 138 WALDO STREET	N
37470			L O 139 M BEHRMAN WALK	N
37470	5080		L O 139 ST MARTIN	N
37490			L O 143 CLEARY	N
37490	5015		LO 143 CLEARY	N
37540			L O 151 ST MARTIN ST	N
37540	5016		LO 151 ST MARTIN ST	N
37550			L O 152 ST PETER'S PLANT	N
37550	5017		LO 152 ST PETER'S PLANT	N
37570			L O 154 NEW YORK AVE	N
37570	5084		L O 154 NEW YORK AVENUE	N
37620			L O 1015 VISTAS	N
37620	5018		LO 1015 VISTAS	N
37640			L O 1017 WALDO STREET	N
37640	5019		LO 1017 WALDO ST	N
37650			L O 1018 M BEHRMAN WALK	N
37650	5081		L O 1018 ST MARTIN	N
37660			L O 1019 M BEHRMAN WALK	N
37670			L O 1020 ST MARTIN ST	N
37670	5021		LO 1020 ST MARTIN ST	N
37680			L O 1021 ST PETER'S PLANT	N
37680	5022		LO 1021 ST PETER'S PLANT	N
37690			L O 1022 NEW YORK AVENUE	N
37690	5085		L O 1022 NEW YORK AVENUE	N
37790			L O 20005 MANHATTEN BLVD	N
37790	5023		LO 20005 MANHATTEN BLVD	N
37800			L O 20007 JONATHAN DAVIS	N
37800	5024		LO 20007 JONATHAN DAVIS	N
37810			L O 20004 SO NEW ORLEANS	N
37810	5025		LO 20004 SO NEW ORLEANS	N
37820			L O 20006 MEADOWCREST	N
37820	5026		LO 20006 MEADOWCREST	N
37830			L O 20001 LAPALCO	N
37830	5027		LO 20001 LAPALCO	N
38200			L O 25 VISTAS	N
38200	5028		LO 25 VISTAS	N
38210			L O 26 KENNER PROJECT	N
38210	5029		LO 26 KENNER PROJECT	N
38220			L O 27 KENNER PROJECT NW	N
38220	5030		LO 27 KENNER PROJECT NW	N
38240			L O 29 WALDO STREET	N
38240	5031		LO 29 WALDO STREET	N
38250			L O 30 M BEHRMAN WALK	N
38250	5082		L O 30 ST MARTIN	N
38260			L O 31 M BEHRMAN WALK	N
38280			L O 33 NEW YORK AVENUE	N
38280	5086		L O 33 NEW YORK AVENUE	N
38300			L O 2013 ST MARTIN ST	N
38300	5033		LO 2013 ST MARTIN ST	N
38310			L O SCIP C5713	A
38310	0		REVENUES	A
38310	5128		L O SCIP C5713	A
38580			L O 2008 LAPALCO	N
38580	5034		LO 2008 LAPALCO	N
38610			L O 2011 JOE FISHER	N
38610	5035		LO 2011 JOE FISHER	N
39000			ROAD DIST#1 SUB#1 DEBT	N
39000	5036		ROAD DIST #1 SUB#1 DEBT	N
39010			PARISH WIDE ROAD SINKING	N
39010	5037		PARISH WIDE ROAD SINKING	N
39020			LPFA REF BONDS SER 2004	N
39020	5107		LPFA REF BONDS SER 2004	N
39030			ROAD DIST A SF	N
39030	5039		ROAD DIST A S F	N
39040			2ND PAR COURT - SINKING	N
39040	5102		SECOND PAR CT BLDG SINK	N
39050			2ND PAR COURT - RESERVE	N
39050	5103		SECOND PAR CT BLDG RESERV	N
39060			ROAD DIST A SUB #1	N
39060	5040		ROAD DIST A SUB #1	N
39070			LPFA REV REFUND 1989 SINK	N
39070	5041		LPFA REV REFUND 1989 SF	N
39080			LPFA REV REF 89 RESERVES	N
39080	5042		LPFA REV REFUND 1989 RES	N
39080	5094		LPFA IMPROVEMENTS PROJECT	N
39090			EB OFFICE BLDG SERIES1994	N
39090	5043		EB OFFICE BLDG SERIES 199	N
39100			HOSPITAL DISTRIC NO 2	N
39100	5044		HOSPITAL DISTRICT NO 2	N
39110			NEW PARISH PRISON	N
39110	5045		NEW PARISH PRISON	N
39120			JUVENILE DETENTION HOME	N
39120	5046		JUVENILE DETENTION HOME	N
39140			FIRST PAR CT BLDG SINKING	N
39140	5047		FIRST PAR CT BLDG SINKING	N
39150			FIRST PAR CT BLDG RESERVE	N
39150	5048		FIRST PAR CT BLDG RESERVE	N
39160			LASALLE 96 REV REFUNDING	N
39160	5087		LASALLE REV REFND 1996	N
39170			LASALLE PROPERTY SINKING	N
39170	5049		LASALLE PROPERTY SINKING	N
39180			LASALLE PROPERTY RESERVE	N
39180	5050		LASALLE PROPERTY RESERVE	N
39190			LASALLE 1996 SERIES A REV	N
39190	5051		LASALLE SERIES A SINKING	N
39200			LASALLE 1996 SER B SINK	N
39200	5052		LASALLE SERIES B SINKING	N
39210			LASALLE 96 SER B REDEMPTN	N
39210	5088		LASALLE 96 SER B REDEMPTN	N
39220			LASALLE 96 REFUNDING RESV	N
39220	5089		LASALLE REFUNDING RESERVE	N
39230			CONS PLAYGROUND #2-SUB #1	N
39230	5063		CONS PLAY # 2 - SUB #1	N
39240			PLAYGROUND DIST NO 10	N
39240	5053		PLAYGROUND DIST NO 10	N
39250			PLAYGROUND DIST NO 11	N
39250	5054		PLAYGROUND DIST NO 11	N
39260			PLAYGROUND DIST NO 12	N
39260	5055		PLAYGROUND DIST NO 12	N
39270			PLAYGROUND DIST NO 13	N
39270	5056		PLAYGROUND DIST NO 13	N
39280			PLAYGROUND DIST NO 14	N
39280	5057		PLAYGROUND DIST NO 14	N
39290			PLAYGROUND DIST NO 15	N
39290	5058		PLAYGROUND DIST NO 15	N
39300			LAFRENIERE PK REV BD SINK	N
39300	5059		LAFRENIERE PK REV BD SINK	N
39310			LAFRENIERE PK REV BD RESV	N
39310	5060		LAFRENIERE PK REV BD RESE	N
39320			EB HOTEL OCCUP SINK FUND	N
39320	5061		EB HOTEL OCCUP SINK FUND	N
39330			EB HOTEL OCCUP RESERVE FD	N
39330	5062		EB HOTEL OCCUP RESERVE	N
39340			97 HOTEL OCCUP REF & IMP	N
39340	5090		97 HOTEL OCCUP REF & IMP	N
39350			97 HOTEL OCCUP REF RESERV	N
39350	5091		97 HOTEL OCCUP REF RESERV	N
39360			WJ PARK COMM REV BD SINK	N
39360	5106		WJ PARK COMM	N
39370			WJ PARK COMM REV BD RESV	N
39410			FIRE DIST NO 7	N
39410	5064		FIRE DIST NO 7	N
39420			FIRE DIST NO 6	N
39420	5108		FIRE DIST NO 6	N
39510			EB CONS SEWER	N
39510	5065		EB CONS SEWER	N
39520			SSTR REFUND 1991A SINKING	N
39520	5066		SSTR REFUND 1991A SINKING	N
39540			SSTR REFUND 1991 REVENUE	N
39540	5068		SSTR REFUND 1991 REVENUE	N
39550			SSTR REFUND 1991B SINKING	N
39550	5069		SSTR REFUND 1991B SINKING	N
39560			SST REV REF SERIES 1998	N
39560	5093		SST REV REF SERIES 98	N
39570			SST REVENUE SERIES 2001	N
39570	5099		SST REVENUE SERIES 2001	N
39580			SST REV REF SERIES 2002	N
39580	5100		SST REV REF SERIES 2002	N
39590			SST REVENUE SERIES 2005	N
39590	5109		SST REVENUE SERIES 2005	N
39600			LCDA SERIES GEN GOVT BLDG	N
39600	5101		LCDA SERIES 2001D ADMIN	N
39600	5105		LCDA SERIES 1999 #2 ADMIN	N
39610			LCDA LOAN SERIES 2001B	N
39610	5098		LCDA LOAN 2001 SERIES B	N
39620			HUD SECTION 108 LOAN PROG	N
39620	5097		SECTION 108 LAON PROGRAM	N
39630			LCDA LOAN PROGRAM	N
39630	5096		LCDA LOAN PROGRAM	N
39640			97 DRAINAGE SALES TAX REF	N
39640	5092		97 DRAINAGE SALES TAX REF	N
39650			24TH JDC PROJECT	N
39650	5104		24TH JDC PROJECT	N
39660			97 DRAIN IMP REFUNDING	N
39660	5083		97 DRAIN IMP REFUNDING	N
39670			91DRAIN SALES TAX SINKING	N
39670	5071		91 DRAIN SALES TAX SINKIN	N
39680			91DRAIN SALES TAX RESERVE	N
39680	5072		91 DRAIN SALES TAX RESERV	N
39690			PARISH WIDE DRAINAGE	N
39690	5073		PARISH WIDE DRAINAGE	N
39700			CONS DRAINAGE #1	N
39700	5074		CONS DRAINAGE #1	N
39710			4TH JEFFERSON DRAINAGE	N
39710	5075		4TH JEFFERSON DRAINAGE	N
39720			COMMUNITY DISASTER LOAN P	N
39720	5110		CDL LOAN	N
39730			LCDA SAFEHOUSE	N
39730	5111		LCDA SAFEHOUSE 2006	N
39730	5115		LCDA SAFEHOUSE SER 2007	N
39740			DRAINAGE 7	N
39740	5076		DRAINAGE 7	N
39750			DRAINAGE 9	N
39750	5077		DRAINAGE 9	N
39760			DRAINAGE 9 SUB #1	N
39760	5078		DRAINAGE 9 SUB #1	N
39770			LCDA GRAND ISLE PAVILION	N
39770	5112		LCDA GRAND ISLE PAVILION	N
39780			LCDA HURRICANE RELIEF PRO	N
39780	5113		LCDA HURRICANE RELIEF	N
39790			SST REV REF SERIES 2007	N
39790	5114		SST REV REF SERIES 2007	N
39800			SST REVENUE SERIES 2007B	N
39800	5116		SST REVENUE SERIES 2007B	N
39810			LCDA RECR & CULTURE 2007	N
39810	5117		LCDA RECR & CULTURE 2007	N
39820			LCDA SERIES 2008AB	N
39820	5118		LCDA SERIES 2008A	N
39820	5119		LCDA SERIES 2008B	N
39830			SST REVENUE SERIES 2009AB	N
39830	5120		SST REVENUE SERIES 2009A	N
39830	5121		SST REV REF SERIES 2009B	N
39840			LCDA SERIES 2009	N
39840	5122		LCDA SERIES 2009A	N
39840	5123		LCDA SERIES 2009B	N
39840	5124		LCDA SERIES 2009C	N
39850			LCDA SERIES 2010	N
39850	5125		LCDA SERIES 2010	N
39860			SST REV REF SERIES 2012AB	A
39860	0		REVENUES	A
39860	5126		SST REV REFUNDING 2012A	A
39860	5127		SST REV REFUNDING 2012B	A
39900			WW #2	N
39900	5079		WW #2	N
44100			ROAD DIST#1 SUB#1 KENNER	N
44100	4000		ROAD DIST A SUB #1 KENNER	N
44150			WEST NAPOLEON IMPROVEMENT	N
44150	4001		WEST NAPOLEON	N
44180			CAPITAL PROJECT - 07 ROAD & STREET	N
44180	4091		07 ROAD & STREET CAPITAL	A
44190			01 ROAD & STREET CAPITAL	N
44190	4089		01 ROAD & STREET CAPITAL	N
44200			ROADS/SEWER SALES TAX CAP	N
44200	4002		ROADS/SEWER SALES TAX CAP	A
44210			LIEN ORDINANCE IMPROVMENT	N
44210	4003		LIEN ORDINANCE IMPROVMENT	N
44280			ROAD DIST A SUB#1 MISC ST	N
44280	4004		ROAD DIST A SUB #1 MISC S	N
44340			MCDONOUGHVILLE/GOV HALL	N
44340	4005		MCDONOUGHVILLE/GOV HALL	N
44500			STREETS CAPITAL PROJECTS	N
44500	4070		STREETS CAPITAL PROJECTS	A
44510			PW REV SHAR PROJECTS	N
44510	4006		PW REV SHAR PROJECTS	N
44530			CAPITAL PROJECT - COUNCIL DISTRICT	N
44530	4007		COUNCIL DIST STREET PROJ	A
44560			PUBLIC WORKS CAPITAL PROJ	N
44560	4008		PUBLIC WORKS CAPITAL PROJ	A
44570			ROAD LIGHTING CAPITAL PRO	N
44570	4074		ROAD LIGHTING CAP PROJ	A
44590			R&B MISC. CONSTR. FUND	N
44590	4009		R&B MISC CONSTRUCTION FD	N
44600			BONNABEL BOAT LAUNCH	N
44600	4010		BONNABEL BOAT LAUNCH	N
44610			LINEAR PARK	N
44610	4011		LINEAR PARK	N
44630			FEDERAL AID URBAN SYS PH1	N
44630	4012		FEDERAL AID URBAN SYS PH1	A
44650			LAFRENIERE PARK	N
44650	4013		LAFRENIERE PARK	N
44660			CAPITAL PROJECT - ALARIO CENTER	N
44660	4069		ALARIO CENTER	A
44670			WB PLAYGROUND CAP IMPROV	N
44670	4014		WB PLAYGROUND CAP IMPROV	A
44680			EB PLAYGROUND CAP IMPROV	N
44680	4015		EBC PLY CAP IMP PROJECTS	A
44690			CONS PLAYGROUND #2 SUB #1	N
44690	4087		CONS PLAYGROUND #2 SUB #1	A
44780			LIBRARY CAPITAL IMPROV	N
44780	4016		LIBRARY CAPITAL IMPROVE	A
44850			FIRE DISTRICT #3	N
44850	4017		FIRE DISTRICT #3	N
44860			FIRE DIST #6 - MARRERO	N
44860	4018		FIRE DISTRICT #6 HARVEY	N
44870			FIRE #5 STONEBRIDGE	N
44870	4019		FIRE #5 STONEBRIDGE	N
44880			EBC FIRE CAP IMPROVEMENTS	N
44880	4020		EBC FIRE CAP IMPROVEMENTS	A
44890			FIRE DIST #7 CONST. FUND	N
44890	4021		FIRE DIST #7 CAPITAL IMP	A
44900			FIRE DIST #8 CONST. FUND	N
44900	4022		FIRE DIST #8 CONST FUND	A
44910			FIRE TRAINING FAC IMPROVM	N
44910	4086		FIRE TRAIN FAC CAP IMPROV	A
44920			FIRE DIST #7 CAPITAL 2000	N
44920	4021		FIRE DIST #7 CAPITAL IMP	A
44940			CONSOL SEWER CAP PROJECTS	N
44940	4023		CONSOL SEWER CAP PROJ	A
44960			PUB UTIL WHS & ADM BLDG	N
44960	4024		PUB UTIL WHS & ADM BLDG	A
45000			EB SEWER LIEN ORDINANCES	N
45000	4025		EB SEWER LIEN ORDINANCES	A
45030			ZONE V EAST BANK	N
45030	4026		SEWERAGE - CAPITAL SEW PR	A
45040			EB SEWER IMPROV & RENOV	N
45040	4027		EB SEWER IMPROV & RENOV	A
45050			WB SEWER IMPROV & RENOV	N
45050	4028		WB SEWER IMPROV & RENOV	A
45080			WB SEWER LIEN ORDINANCES	N
45100			PUB UTIL WEST BANK YARD	N
45100	4030		PUB UTIL WEST BANK YARD	N
45110			JP MITIGATION FUND	N
45110	4031		JP MITIGATION FUND	A
45120			LSALVADORE SHORELINE PROJ	N
45120	4032		L SALVADORE SHORELINE PRO	A
45160			COUNCIL DRAINAGE CAPITAL	N
45160	4075		COUNCIL DRAINAGE CAPITAL	A
45170			CONS DRAINAGE CAPITAL	N
45170	4033		DRAINAGE #1 CAPITAL IMPS	A
45180			LCDA DRAINAGE PROJECTS	N
45180	4034		LCDA DRAINAGE PROJECTS	A
45190			DRAINAGE #9 CAP IMPS	N
45190	4035		DRAINAGE #9 CAPITAL IMPS	A
45200			91 DRAINAGE SALES TAX CAP	N
45200	4036		91 DRAINAGE SALES TAX CON	A
45210			CONSOL DRAINAGE IMPROVEMN	N
45210	4037		PUMP STATION IMPROVEMENTS	A
45220			USDA WATERSHED PROGRAM	N
45220	4038		USDA WATERSHED PROJECTS	A
45230			DRAINAGE CAPITAL PROG PRO	N
45230	4039		DRAINAGE CAPITAL PROJ PRG	A
45250			URBAN FLOOD CONTROL	N
45250	4040		URBAN FLOOD CONTROL	A
45260			MARRERO AREA DRAINAGE	N
45260	4041		MARRERO AREA DRAINAGE	A
45270			SELA MILLAGE IMPROVEMENTS	N
45270	4090		SELA MILLAGE IMPROVEMENTS	A
45280			DRAIN DIST#9 SUB#1 CONST	N
45280	4042		DRAIN DIST #9 SUB #1 CONS	A
45300			FEMA DRAINAGE CAPITAL	N
45300	4043		FEMA DRAINAGE CAPITAL	A
45310			09 DRAINAGE CAPITAL IMPS	N
45310	4077		09 DRAINAGE CAPITAL IMPS	A
45360			WW 1 CAPITAL PROG PROJ	N
45360	4044		WWI CAPITAL PROG PROJECTS	A
45400			CONS WATER CAPITAL	N
45400	4045		CONS WATER - AD VALOREM	A
45460			CONS. W.W.#2 CONST. FUND	N
45460	4046		CONS WW#2 CONSTRUCTION FD	A
45470			W.W. #2 CONSTR. PROJECTS	N
45470	4047		WW#2 CONSTRUCTION PROJECT	A
45480	4048		WATER #2 CAPITAL PROGRAM	A
45500			WB WATER LIEN ORDINANCES	N
45500	4049		WB LEIN ORDINANCES	A
45600			MILLAGE CAPITAL IMPS	N
45600	0	552	ECONOMIC DEVELOPMENT	N
45600	0	553	CRIMINAL JUSTICE	N
45600	0	554	CULTURE	N
45600	0	555	PARKS	N
45600	4076		MILLAGE CAPITAL IMPS	N
45660			CAPITAL PROJECT - ALARIO CENTER	N
45670			TRANSIT CAPITAL PROJECTS	N
45670	4050		TRANSIT CAPITAL PROJECTS	N
45680			CAPITAL PROJECT - EB ANIMAL SHELTER	N
45680	4051		EAST BANK ANIMAL SHELTER	A
45690			HEALTH UNIT CAPITAL IMPRO	N
45690	4052		HEALTH UNIT CAPITAL IMPRO	N
45700			NEW PRISON	N
45700	4067		NEW PRISON	N
45710			CIVIC & SENIOR CENTER IMP	N
45710	4053		CIVIC & SENIOR CENTER IMP	A
45780	4054		1ST PAR CT REV BD CAP PR	N
45790			CAPITAL PROJECT - 1ST PAR CT REV BD	N
45790	4054		1ST PAR CT REV BD CAP PR	A
45800			CAPITAL PROJECT - JUDICIAL BUILDING FUND	N
45800	4055		JUDICIAL BUILDING FUND	N
45810			CAPITAL PROJECT - JUVENILE SVC CONS	N
45810	4056		JUVENILE DET CONSTR FUND	N
45830			CAPITAL PROJECT - PARISH ARCHIVES  BLDG	N
45830	4057		PARISH ARCHIVES BUILDING	N
45840			CAPITAL PROJECT - EMERGENCY COMM	N
45840	4058		EMERGENCY COMMUNICATIONS	A
45850			CAPITAL PROJECT - PARISHWIDE GOVT BLDGS	N
45850	4085		PARISWIDE GOVERNMENT BLDG	A
45860			CAPITAL PROJECT - LASALLE REV BD SER A&B	N
45860	4071		LASALLE SERIES A & B	A
45870			CAPITAL PROJECT - LASALLE PARK ACQUISITI	N
45870	4068		LASALLE PARK ACQUISITION	A
45880			CAPITAL PROJECT - EB OCCUPANCY TAX	N
45880	4059		EB OCCUPANCE TAX PROJECT	A
45890			CAPITAL PROJECT - WBANK CONVENTION CTR	N
45890	4060		WEST BANK CONVENTION CTR	A
45900			CAPITAL PROJECT - CONS GARBAGE	N
45900	4061		CONSOL GARBAGE PROJECTS	A
45910			CAPITAL PROJECT - EMERGENCY MANG	N
45910	4062		EMERGENCY MANAGEMENT	N
45920			CAPITAL PROJECT - CENTRAL GARAGE IMPROVE	N
45920	4072		CENTRAL GARAGE IMPROVMNTS	N
45930			97 HOTEL OCCUP REF & IMP	N
45930	4073		97 HOTEL OCCP REF IMP CAP	N
45940			MIS COMPUTER ENHANCEMENTS	N
45940	4088		MIS COMPUTER ENHANCEMENTS	A
45950			ZONE II - BRIDGE CITY	N
45950	4063		ZONE I - BRIDGE CITY	N
45960			ZONE II - MARRERO	N
45960	4064		ZONE II - MARRERO	N
45970			ZONE III - HARVEY	N
45970	4065		ZONE III - HARVEY	N
45980			ZONE IV - LAFITTE	N
45980	4066		ZONE IV - LAFITTE	N
45990			GENERAL GOVT CONTINGEN	N
45990	4099		GENERAL GOVT CONTING	A
45999			GENL GOVT CONTINGENCIES	N
53000			CONSOLIDATED SEWER DISTRICT NO. 1	A
53000	3850		SEWER 1 - Administration	A
53000	3850	114	CONSOLIDATED SEWER 1 - Administration	A
53000	3851		EB CONSOLIDATED SEWER DISTRICT NO. 1	A
53000	3851	89	CONSOLIDATED SEWER - EB Maintenance	A
53000	3851	117	Line Rehabilitation and Repair	A
53000	3851	118	EB - Treatment Plant	A
53000	3851	119	EB - Lift Stations	A
53000	3851	120	Collections Lines	A
53000	3852		WB CONSOLIDATED SEWER DISTRICT NO. 1	A
53000	3852	89	CONSOLIDATED SEWER - WB Maintenance	A
53000	3852	117	Line Rehabilitation and Repair	A
53000	3852	119	WB - Lift Stations	A
53000	3852	120	Collections Lines	A
53000	3852	121	Bridge City Treatment Plant	A
53000	3852	122	Harvey Treatment Plant	A
53000	3852	123	Marrero Treatment Plant	A
53000	3852	124	Jonathan Davis Treatment Plant	A
53000	3852	125	Rosethorne Treatment Plant	A
53010			CONSOLIDATED WATERWORK DISTRICT NO. 1	A
53010	3900		CONSOLIDATED WATERWORK - Administration	A
53010	3901		Water Treatment Plant	A
53010	3901	126	EB - Water Treatment Plant	A
53010	3901	127	WB - Water Treatment Plant	A
53010	3902		Water Distribution	A
53010	3902	126	EB - Water Distribution	A
53010	3902	127	WB - Water Distribution	A
53010	3903		Water Quality Lab	A
53010	3904		WATER WAREHOUSE	N
53010	3907		Utility Billing	A
53010	3907	126	EB - Utility Billing	A
53010	3907	127	WB - Utility Billing	A
53010	3907	344	WB - Terry Pkwy	A
53010	3910		Grand Isle	A
63500			CENTRAL FLEET MAINTENANCE	A
63500	3950		Central Garage Operations	A
63500	3956		Central Tire	A
63500	3962		Central Garage Contractual	A
63500	3965		Central Motor Pool	A
63510			CENTRAL TELEPHONE	N
63510			TELECOMMUNICATION	A
63510	3971		TELECOMMUNICATION	A
63520			EIS MANAGER	A
63520	3952		MIS OPERATIONS	A
63520	3959		GIS OPERATIONS	A
63520	3961		EIS DIRECTOR'S OFFICE	N
63530			PARISH PHOTOGRAPHER	N
63530	3953		PARISH PHOTOGRAPHER	N
63540			CENTRAL PRINTING	N
63540	3954		CENTRAL PRINTING	N
63550			RISK MANAGEMENT	N
63550	3955		RISK MANAGEMENT	N
63550	3963		HUMAN RESOURCES - SAFETY	N
63560			SAFETY & SECURITY MGMT	A
63560	3963		HUMAN RESOURCES - SAFETY	N
63560	3968		Security Program	A
63600			CENTRAL TIRE	N
63810			ENGINEERING	A
63810	3957		ENGINEERING - Administration	A
63810	3957	128	General	A
63810	3957	129	Traffic	A
63810	3957	149	CAPITAL PROJECTS	N
63810	3960		SCADA Operations	A
63810	3966		PW ADMIN & WAREHOUSE - Administration	A
63810	3967		Warehouse	A
63810	3969		CAPITAL PROJECTS	A
63830			PW ADMIN & WAREHOUSE	A
63830	3966		PW ADMIN & WAREHOUSE - Administration	N
63830	3967		PUBLIC WORKS - Warehouse	N
63830	3970		PUBLIC WORKS DIRECTOR	A
63830	3972		FLOODPLAIN MGMT AND HAZMI	A
63830	3976		PW ADMIN & WAREHOUSE - Rehab	A
63840			WATER QUALITY LAB	N
63840	3903		WATER QUALITY LAB	N
63860			ENVIRONMENTAL AFFAIRS	A
63860	3640		Environmental Impact (Solid Waste)	A
63860	3958		Environmental Control	A
63970			GIS OPERATIONS	N
66750			HOSPITALIZATION LIABILITY	N
66750	5008		HOSPITALIZATION LIABILITY	N
66760			CLAIMS LIABILITY	N
66760	5009		CLAIMS LIABILITY	N
66770			UNEMPLOYMENT COMP LIAB FD	N
66770	5010		UNEMPLOYMENT COMPENSATION	N
66780			OTHER POSTEMPLOYMENT BENF	N
66780	6000		OTHER POSTEMPLOYMENT BENF	N
70000			DEFERRED COMPENSATION	N
70003			DISTRICT COURTS ODW	N
70003	7003		DISTRICT COURT ODW	N
70004			INDIGENT TRANSCRIPT FUND	N
70004	7004		INDIGENT TRANSCRIPT FUND	N
70010			24TH JDC INT PROB DRUG CT	N
70010	7009		DRUG COURT ADM-SUPREME CT	N
70010	7009	151	I CAN DRUG COURT	N
70010	7009	292	DRUG COURT LEASE	N
70010	7010		DIST COURT - I CAN HELP	N
70010	7010	292	DRUG COURT LEASE	N
70011			24TH JDC INTENSIVE PROBAT	N
70011	7050		INTENSIVE PROBATION SERV	N
70012	7005		24TH JDC GRANTS	N
70013			24TH JDC DWI COURT	A
70013	0		REVENUES	A
70013	7006		24TH JDC DWI COURT	A
70013	7007		24TH JDC DWI COURT ADMIN	A
70080			COURT LAB	N
70080	7008		COURT LAB	N
70111			1ST PARISH COURT EXP	N
70111	7011		1ST PAR CT EXPENSE	N
70112			1ST PAR CRT DWI PROGRAMS	N
70112	7012		1ST PAR CT DWI PROGRAMS	N
70113			1ST PARISH COURT ODW	N
70113	7013		1ST PAR CT ODW	N
70114			1ST PARISH CRT COMPUTER	N
70114	7014		1ST PAR CT COMPUTER	N
70115			1ST PAR CRT SEC 894 PROB	N
70115	7015		1ST PAR CT SEC 894 PROB	N
70116			1ST PAR CRT SEC 895 PROB	N
70116	7016		1ST PAR CT SEC 895 PROB	N
70119			1ST PAR CT DRIVING SCHOOL	N
70119	7019		1ST PAR CT DRIVING SCHOOL	N
70120			1ST PAR CRT TRAFFIC LIGHT	N
70120	7020		1ST PAR CT TRAFFIC LIGHT	N
70215			2ND PAR CRT SEC 894 PROB	N
70215	7030		2ND PAR CRT TRAFFIC LIGHT	N
70221			2ND PARISH COURT EXPENSE	N
70221	7021		2ND PARISH COURT EXPENSE	N
70222			2ND PARISH COURT DWI	N
70222	7022		2ND PAR CT DWI	N
70223			2ND PARISH COURT ODW	N
70223	7023		2ND PAR CT ODW	N
70224			2ND PARISH COURT COMPUTER	N
70224	7024		2ND PAR CT COMPUTER	N
70225			2ND PAR CT PROBATION	N
70225	7025		2ND PAR CT PROBATION	N
70226			2ND PAR CT CONTEMPT	N
70226	7026		2ND PAR CT CONTEMPT	N
70229			2ND PAR CT DRIVING SCHOOL	N
70229	7029		2ND PAR CT DRIVING SCHOOL	N
70230			2ND PAR CRT TRAFFIC LIGHT	N
70230	7030		2ND PAR CRT TRAFFIC LIGHT	N
70333			JUVENILE COURT ODW	N
70333	7033		JUVENILE CT ODW	N
70411			DISTRICT ATTORNEY GRANTS	N
70411	7041		DIST ATTORNEY GRANTS	N
70411	7041	216	INFO SYSTEMS UPGRADE	N
70411	7041	219	PRE-TRIAL INTERVENTION	N
70411	7041	220	VICTIM NOTIFICATION	N
70411	7041	221	VIOLENCE PREVENTION	N
70411	7041	226	TITLE IVD CHILD SUPPORT	N
70411	7041	227	VICTIM ASSISTANCE	N
70411	7041	239	DOM VIOL PRG-SPOUSE ABUSE	N
70411	7041	241	DOMESTIC VIOLENCE PROSECU	N
70411	7041	242	PROSECTION TRAINING	N
70411	7041	261	CHILD ADVOCACY PROGRAM	N
70411	7041	262	VICTIM ASST COORDINATOR	N
70411	7041	266	ELECTRONIC EQUIPMENT	N
70411	7041	293	DRUG TESTING	N
70411	7041	299	DNA EQUIPMENT DOJ	N
70411	7041	319	HURR KATRINA EMERG FUNDS	N
70600	7060		FIREFIGHTER RELIEF FUND	N
92000			JEDCO BIDS	A
92000	9920		JEDCO BIDS	A

**jbryant** · Jul 3 '13, 08:19 PM

HMMMMM I do not think that was best way to attach

**zmbd** · Jul 3 '13, 09:55 PM

That's ok, With Rabbit's help it works.
So, what am I looking at?
I've a little accounting background and it looks like a schdule of accounts and already in a good place for a table perhaps.
[FNDNO] [DPTNO] [SUB1] [DESC] [STAT]
It appears that if you take the first three fields here, you have a unique reference to every entry. Personally, I'd replace all of the empty values with zeros, remove the "Header" record and push it into its own table as it sets the value in [FNDNO] so you get something like this for one subsection.

Code:

10010         GENERAL FUND           A 
10010    10         PARISH COUNCIL         A 
10010    10    1    COUNCIL DISTRICT #1    N 
10010    10    2    COUNCIL DISTRICT #2    N 
10010    10    3    COUNCIL DISTRICT #3    N 
10010    10    4    COUNCIL DISTRICT #4    N

Becomes

Code:

10010    10    0    PARISH COUNCIL         A 
10010    10    1    COUNCIL DISTRICT #1    N 
10010    10    2    COUNCIL DISTRICT #2    N 
10010    10    3    COUNCIL DISTRICT #3    N 
10010    10    4    COUNCIL DISTRICT #4    N

and because I hate compound keys we can add a new primary key so now you get

[PK] [FNDNO] [DPTNO] [SUB1] [DESC] [STAT]

thus the data becomes (I'll start with 9900 just as an example... the autonumbering would normall start with 1)

Code:

9911   10010    10    0    PARISH COUNCIL         A 
9912   10010    10    1    COUNCIL DISTRICT #1    N 
9913   10010    10    2    COUNCIL DISTRICT #2    N 
9914   10010    10    3    COUNCIL DISTRICT #3    N 
9915   10010    10    4    COUNCIL DISTRICT #4    N

Now in a relational database, I would suspect that [FNDNO] would be related to a table wherein the static information for that information would be found, as mentioned in the "header record" comment, and the same with [DPTNO] its own table etc...

The changes can be made via, maybe three update queries: One to copy the "header record" to a new table, one to remove the "header record", last to add the 0 for the empty [SUB1] record field.

**jbryant** · Jul 5 '13, 03:25 PM

Hope this is better

Sorry, had meetings to go to and finished up late. I am off today but did want to share this data with you. Drop and drag is most of my Access exposure, but now I need to get more involved. I feel like the more I dig the more lost I become. If you would like, you can contact me at [[[Removed the Personal Contact Informationn]]] on Monday afternoon.

Thanks

Bodcode headers

Fndno main fund number
Dptno department
Sub1 sub-department

Equip Headers

Amhor1 main fund
Amhor2 Department
Amhor3 sub-dept

WC Actuary

Loc all 12 numbers together

Matching dept codes from multiple sources and formats

Matching dept codes from multiple sources and formats

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment