CPATexasFleetSystem(TxFS).docVIP

CPA Texas Fleet System (TxFS) Batching Specifications January 12, 2011 Revision History Date Revision Number Deliverable Manager Revision Purpose 07/06/09 V1.0 Pascal Laumet Initial document for CPA comment 07/06/09 V2.0 Himanshu Waikar Addition of Appendix A tables 07/08/09 V2.1 Pascal Laumet Addition of GVW to Insert/Update Inventory Batch types 07/09/09 V2.2 Pascal Laumet Added out-of-service to Update Inventory Batch 07/14/09 V2.3 Pascal Laumet Modified to include comments from Dee Dee Evans 09/4/09 V2.4 Pascal Laumet Final Revision: Additional column in Inventory Batch types (Certified for Home Commute) + All lookups moved to UPPERCASE New lookup table 23 9/22/09 V2.5 Pascal Laumet Revision: GVW modified to GVWR for consistency with Equipment Inventory Labels in tables 2 and 3 Mapping for Engine Oil modified to be ENGOIL in table 21 10/12/09 V.2.6 Pascal Laumet Modified Table 9: lookup values Equipment Color as imported from FleetFocus 10/16/09 V2.7 Melissa Hernandez Date and footer corrections 10/26/09 V2.8 Ron Merz Correction to Table 7: Internal tank name is not a required field; Updated all tables for batch scenarios to correct sample data value for agency from 3-digit to 6-digit consistent w/ assigned mgmt. unit value; Added bookmarks for batch type tables and repaginated; 12/11/09 V2.9 Ron Merz Mapping table 2.3 column sequence corrected to match TxFS Import Runner Footer updated to reflect 2.9 version; title footer changed to reflect TxFS instead of TXFS 10/21/10 V3.0 Ron Merz Equipment purchase insert and equipment update batches changed to include two new columns for tier and bin Mapping tables updated; certain tables periodically updated have been displayed to show only a sample subset with user directed to get table values from TxFS (using Export to Excel command) 1/12/11 V3.1 Ron Merz Greenhouse Gas Score field changed to a required field per TPASS business need requiring reporting on this item. Table