Wednesday, November 19, 2008
Who gains from Collin County’s suit against its auditor?
Email
|
Print
|
Tell us your story
|
Comments (17)
|
More stories about Collin County politics:
In May of this year, the Collin County Commissioners filed a lawsuit against the County Auditor in an attempt to stop the auditor from gaining access needed to audit the county's numerous computer programs that generate reports on all facets of county financial operations including, cash receipts, payroll, fines, expenses and tax collections.
Donald Cozad, the County Auditor had been trying for several years to gain "read only" access to the tables, calculations, permissions and formulas that these systems used to create the reports that are summarized in the county's financial statements.
Last month visiting Judge Calhoun ruled (PDF) for the second time against the commissioners court, and acknowledged that the Auditor has all the rights to the software that he had been requesting. So far, these suits have cost the Collin County taxpayer over $300,000. [see Turf battle costs taxpayers over $300,000, CCO, Nov. 9, 2008]
The costs to the taxpayer will continue to rise, and probably double as the county has filed a notice of appeal.
One question that nags anyone who has examined the issues in this dispute is "Who gains from a successful suit by the Commissioners Court?". The commissioners warn of disastrous financial consequences if the auditor is allowed to prevail. A closer look at the issues and players involved with this suit suggests that there may be hidden agendas that have nothing to do with saving taxpayer money.
A "power grab"
For years now, the commissioners have coveted and expressed resentment over any county operation they do not control. Texas state law, in providing for a system of checks and balances has placed several departments beyond the authority of the commissioners court. These departments include the County Auditor, the Purchasing Agent, Court Reporters, and Juvenile Probation.
The commissioners complain that they are responsible for the budget, but 10% of the budgeted funds are spent by officials the commissioners have no authority over. Commissioners want the final policy and hiring authority over all non-elected department heads.
During the last legislative session, the commissioners tried and failed to get the Texas Legislature to allow the commissioners to replace court reporters with electronic taping systems, even over objections from an elected judge. This year they are asking the legislature to prohibit the auditor from accessing and auditing software and from controlling payroll. They are also asking that they be given control over the purchasing department.
In their suit against the auditor, the commissioners claim that granting the auditor's demands will be burdensome and expensive.
In their filings with the 219th District Court (PDF), the commissioners charge that, "The Auditor’s Questions are proposals for radical change to Collin County’s computer systems masquerading as an innocent effort to clarify his statutory duties as the county auditor."
Claiming that the auditor is engaging in a "power grab", the commissioners wrote that, "The Auditor seeks to vastly increase his influence and power in the Collin County government." and that "the additional powers the Auditor seeks would have disastrous consequences for Collin County’s taxpayers."
These "disastrous consequences" to the Collin County taxpayer were at the heart of the the commissioners' argument before the court.
Millions of dollars
The commissioners charge that, "the Auditor’s proposed changes would cost the taxpayers of Collin County millions of dollars in vendor modifications to computer software and hardware and lost man-hours for county employees."
In a sworn affidavit (PDF), Collin County's IT Director, Caren Skipworth told of the Auditor's requests to gain "read only" access to the major IT systems -
Ms. Skipworth wrote that with one major software package, the multi-million dollar installation of "PeopleSoft", the vendor was able to make the changes that allowed Mr. Cozad 'read only' access. Another huge program named "Land Deeds and Vitals System" that is used by the County Clerk could be modified to meet the requirements of the auditor for only $5,000.
However, with the $7 million dollar installation of the court room management software package called "Odyssey" it was a different matter. Odyssey was developed and sold by Tyler Technologies of Dallas. According to Ms. Skipworth, Odyssey's vendor has told her that the required changes could not be made.
Ms. Skipworth also wrote that, "Typically, however, vendors do not develop software applications with view inquiry access to configurations, workflow, user profiles and security". "More over", Skipworth wrote, "it is highly unusual for a vendor to be willing or able to alter an application to allow for something like view inquiry access after the program's development."
Really?
Auditor's portals
PeopleSoft was able to offer the modifications easily. Land Deed and Vitals was able to do so cheaply. Only Odyssey seems to be impossible to modify - even by the programmers who wrote it.
A look at Tyler Technologies' website shows that Tyler offers custom programming and development. It would seem extraordinary that they can customize other operations, but can't fix their own programming to meet current accounting standards.
I've spoken to several vendors of large ERP systems. (ERP stands for Enterprise Management Program.) ERP systems are large programs designed to run entire corporate finance, production, and logistics departments. Without exception, these vendors all offer "read only" audit access. One salesman told me he wouldn't even try to sell a large software system without an "auditor's portal". No one would buy it.
Because, in the world after Enron and Worldcom, such audit functions are required by law. The Sarbanes-Oxley Act, enacted in 2002 makes such auditor oversight mandatory for public corporations - but not for government.
I also spoke with experts who deal with regulatory software - the large programs that are used by, for example, food processors to insure regulatory compliance. These programs too must contain "read only" access to base functions for auditing.
What's the deal with Odyssey?
Odyssey was born out of a vision by the Texas Legislature and Texas Supreme Court to automate much of the functions of the court system in such a way that would enable efficiencies in automated filing and allow communication between the trial courts and the appellate courts.
In the late 1990's the 75th Texas Legislature created the Judicial Committee on Information Technology (JCIT). The JCIT is made up of judges, lawyers and DA lawyers from around the state.
The JCIT was tasked to, "establish standards and guidelines for the systematic implementation and integration of information technology into the trial and appellate courts in Texas." In other words, the JCIT was to write the program specifications for automating the court systems.
From 2001 to 2003, the JCIT solicited input from courts and vendors, developed program parameters, and published standards to be incorporated into courtroom software.
One of the companies that gave input into the process and developed software to meet these new standards was Tyler Technologies. Their Odyssey program is a suite of software programs designed to automate courts, jails and justice operations.
In 2006, the Conference of Urban Counties (CUC) selected Odyssey in a $12.4 million software license agreement under its TecShare program (PDF) for joint use and license by its members. The CUC is a non-profit organization composed of 34 member counties representing nearly 80 percent of the population of Texas.
The agreement gave existing CUC members the right to adopt Tyler's Odyssey Case Manager and Odyssey Prosecutor software applications. The agreement also gave CUC members that adopt the court management system access to other applications in Tyler's Odyssey suite of applications, such as Law Enforcement, Jail Manager and Check Manager.
Collin, Dallas, Galveston, Denton, Fort Bend, Grayson, Guadalupe, Hidalgo, Kaufman, Kerr, Nueces, Tarrant, Taylor and Williamson counties are among the CUC members that have signed contracts and are adopting Odyssey.
Peter S. Vogel
The JCIT, Gardere and Tyler Technologies
Remember that the base criteria and specifications for Odyssey were written by the JCIT. The chairman of the JCIT was and is Peter S. Vogel, a partner at the Dallas law firm of Gardere, Wynne Sewell LLP.
Mr. Vogel is also Collin County's lead attorney in its suit against its auditor.
Critics have charged that Mr. Vogel is defending software written to his specifications using Collin County tax dollars.
Mr. Vogel's law firm Gardere, Winn Sewell, LLP can also count Tyler Technologies as one of its major clients. A quick Google search will turn up many SEC filings by Tyler Technologies - all prepared by or signed off by Gardere, Winn Sewell, LLP.
If the Auditor wins the appeal, this kind of "read only access" to county computer systems will likely become the de facto standard for all counties in Texas.
Tyler Technologies' Odyssey suite has a large Texas county customer base. It would be reasonable to believe these installations will sooner or later require the same modifications requested by the Collin County auditor - Tyler Technologies would then have to reprogram every Texas installation of Odyssey and any other program it sells without "read only" audit capabilities to county governments.
Tyler could try to bill the counties for this service. One would suspect that if they did, the law suits would fly from many directions. Tyler Technologies is a growing company that sells software exclusively to governments. It wants more business, not lawsuits from its customers. In all probability, Tyler would have to reprogram all these Odyssey installs at its own expense - but only if the Collin County Commissioners lose their appeal to the 5th Court of Appeals.
The total cost to Gardere's other client of such a reprogramming is unknown, but other than the costs of this litigation, it shouldn't cost the Collin County taxpayers a dime.
Not one dime.

Pegasus News content partner - The Collin County Observer
Related stories
- Where in the world is Collin County auditor Don Cozad? (June 15, 2009)
- Collin County vs. Auditor: Who won? Who lost? (May 4, 2009)
- 2008 in review: Why I write the Collin County Observer (Dec. 29, 2008)
- Pegasus News week in view: Accolades edition (Nov. 19, 2008)
See more stories in:
Find...
Today
Candlelight Vigil for Soldiers at Fort Hood Just a day before Veteran's Day, UT-Arlington students remember the soldiers wounded and killed at Fort Hood on Thursday. The public is invited to share this somber event with students. More info
Latest comments
- genghis65 on Dallas city leaders plan to help homeless: I have lived in downtown since 2004 and have only seen the homeless problem increase since the openi...
- Jason Rice on Lewisville resident breaks Guinness World Record for longest drum roll: ok that snare is definitely DEFINITELY hot. True enough. (no really, witness, ye, a moment of non-sa...
- dianamoya on The Living Opera in Richardson shut down permanently: Are you guys doing Educational Outreach Tour? We would like to see what you do. We’re in Frisco,TX...
- Collin Gouldin on Lewisville resident breaks Guinness World Record for longest drum roll: Not at all, i got a Guinness World Record. (and um… you did see that sweet snare right?)...
Latest reviews
- Colby Walton on Si Tapas and Spanish Cuisine: Just visited this place for the first time, and found the quality of the food, the service, the atmo...
- cindyallentx on India West Fine Dining & Lounge: I went to this restaurant last friday had a wonderful experience. Love the low light romantic feel o...
- jognmcdermott on India West Fine Dining & Lounge: This place has it all good food sweet service. I proposed to my fiance here it was perfect! we loved...
Things you can't miss
Latest stories
- Jupiter House Coffee opens new location in Denton
- St. Thomas Aquinas students inspire local artist to auction painting for art education
- Interview with comic Todd Barry: Rock halls versus comedy clubs
- The Brad reports on Stephan Pyles' 10th Celebrity Chef Dinner Sunday at Stephan Pyles Dallas
- Folks from Rogers Wildlife Rehab in Hutchins introduce us to their owl friends

Comments
Pavel Lishin Verified
Uh, why doesn't every taxpayer have access to all the financial data of their government?
11 months, 3 weeks ago ( Link to this comment | Suggest removal )
Jason Rice Verified
That data sometimes has sharp pointy edges and could hurt you so your government needs to protect you.
11 months, 3 weeks ago ( Link to this comment | Suggest removal )
Bill Baumbach Verified
=>Uh, why doesn't every taxpayer have access to all the financial data of their government?
They do.
Federal issues - Freedom of Information Act
Texas and Local - Open Records Act
Bill
11 months, 3 weeks ago ( Link to this comment | Suggest removal )
alexander troup Verified
If they did,they could bribe someone to change it, beside cheating is done on the other side, in side and out....now who is cheating who....back in the old days, they would just burn a Court House down..A.T,once upon a time Tax Clerk.
11 months, 3 weeks ago ( Link to this comment | Suggest removal )
Travis Bush Verified
This is what happens when you get relatively unknown companies to write proprietary software for your business and institution. Eventually these "software companies" will go out of business and the counties who bought into it will be left with crap software and no technical support. You see it all the time in small businesses.
11 months, 3 weeks ago ( Link to this comment | Suggest removal )
kcook1 Anonymous
$7 million for the Odyssey software! I know what this software does and this cost should raise even more questions!
11 months, 2 weeks ago ( Link to this comment | Suggest removal )
dfwenigma Anonymous
I have never heard such malarkey in my life. As the article said this is a power play. Much of the enterprise class software out there today - let's face it it's Microsoft .NET technology. That means that permissions of various kinds are possible. .NET apps have literally thousands of user permissions associated with the applications. Adding a user account with 'read-only' access absolutely does not require extensive programming. But if I were a software company - and I've worked for a few like this - the customer controls the environment. The customer controls who gets what access, where and when. This article ends up playing this situation off as if the players are all the same page. I've seldom seen organizations where everyone plays nicely in the sandbox. Let's not assume that the evil-doer here is the vendor. The vendor is legally bound by its contract. The customer is in the driver's seat. It sounds to me like the IT director here has seen which side her bread is buttered on and knows that the auditor is not her boss. I don't blame her. But to say that a .NET app can't generate user id's with read-only access makes me scratch my head. Would it be easy as pie? Probably not. Is it un-doable? Me thinks the Lady she doth protest TOO much. We may have just identified the wrong villain here and I'm thinking that he with the most turf is he with the most to lose. The software company probably has more than one customer and if adding user types were such a huge issue - with 'read-only' access I kind of think that the software company would have had customers who were a bit irate and that we MIGHT just have heard of this before. Since this is the first time - I have some doubts here. Something's rotten in McKinney.
6 months, 3 weeks ago ( Link to this comment | Suggest removal )
Pavel Lishin Verified
dfwenigma, a well designed program should be capable of the things you're talking about, sure. But having worked on a few projects from hell, I can tell you that it's entirely possible that adding a read-only user could take weeks if someone contrived to write the app in a shabby enough manner.
6 months, 3 weeks ago ( Link to this comment | Suggest removal )
Jason Rice Verified
This came up at a meeting I attended a while back.... by the end of the conversation I gathered the use/case spec for the software was a nightmare. It sounded like they really tried to codify office politics into the app. <shudder>
6 months, 3 weeks ago ( Link to this comment | Suggest removal )
dfwenigma Anonymous
Paul Lishin it sounds as if you are saying what I was trying to say - the County in question has the ability to add a user type with the required access but as Jason Rice has commented - they chose not to. So the software vendor undoubtedly gave the County the 'key's but County officials chose to play politics. Once that gets in to the mix it is very convenient to blame software developers, software companies, etc.
6 months, 1 week ago ( Link to this comment | Suggest removal )
Scott Doyle Verified
Paul Lishin
6 months, 1 week ago ( Link to this comment | Suggest removal )
Jason Rice Verified
Can we blame Windoze 7 yet?
I just can't wait to blame Windoze 7.
6 months, 1 week ago ( Link to this comment | Suggest removal )
dfwresponder Anonymous
Travis Bush wrote: "relatively unknown companies to write proprietary software", "You see it all the time in small businesses.". This is way off the mark. While I am not a fan of this company, Tyler Technologies is traded on the NYSE.
This software may be .NET technology, but not all software in this market is. Either way, it should not be difficult to create view only user profiles for any office that requests it. Don't assume that it wasn't designed originally to handle this. These security settings are written into the software and typically found in all apps sold to this market.
Sounds to me like the Vendor is saying whatever the county who just happens to be who they sell to) wants them to say in order to hold off the Auditor. On the flip side, maybe the CUC should have actually researched vendors before endorsing a vendor known to have a court management system.
Be very wary of how much control and power are granted to County Auditors. They are not elected officials and subsequently can't be held accountable to the voter!
On another thought. If the CUC (of which Collin County is a member) gave a $12.4M contract(which appears to have a deadline of March 2011) to Tyler Tech. and Collin County spent $7M on court room management software, what did the $12.4M buy? The article states that it gave access to many different apps to all existing members of the CUC (many apps for many different counties). But one additional app(court room management) for 1 county cost $7M!
A note to consider.....
While the CUC is not exactly a governmental entity, they are at least partially funded (if not fully) by the 34 member counties. Just a lot more tax dollars (12.4 + 7) at work (more like wasted) for the voting public!
Wonder what the vendor had to do to get this setup?
5 months, 3 weeks ago ( Link to this comment | Suggest removal )
dfwresponder Anonymous
Sorry for the error in paragraph 3!
Sounds to me like the Vendor is saying whatever the county (who just happens to be who they sell to) wants them to say in order to hold off the Auditor. On the flip side, maybe the CUC should have actually researched vendors before endorsing a vendor known to have a SUBPAR court management system.
5 months, 3 weeks ago ( Link to this comment | Suggest removal )
Pavel Lishin Verified
dfwresponder: do you actually write software?
5 months, 3 weeks ago ( Link to this comment | Suggest removal )
Jason Rice Verified
Pavel, you thinking what I'm thinking?
I haven't seen a piece of financial software ever that was fresher than a decade old in its baseline. Some of the "newest" stuff is Cro-Magnon with a shiny front-end cobbled on to it.
5 months, 3 weeks ago ( Link to this comment | Suggest removal )
Pavel Lishin Verified
I never know what anyone's thinking, so maybe?
But yeah. The logic in that software must be pretty convoluted; systems like this are typically somewhat outdated as soon as the requirements are submitted, unless we're talking about something that takes ages to change. And, true, government finances might be one of those things, but still.
Bottom line, I've seen terrible software. Until you see the code, or at least the interface, you can't say "It's easy to make it do X!" like so many clients do. (We hate those guys, by the way.) You might as well claim that performing an appendectomy is easy, and why can't you install a cow stomach while you're there? I mean, you just stitch it to the intestine, right? Easy fix, takes a day!
5 months, 3 weeks ago ( Link to this comment | Suggest removal )
Post a comment