Contract Batch Import File Layout/Format User Guide
Contents
1. clarity Name Action Date Vivek Natani Initial Draft 10 26 2011 Vivek Natani Revised based on Bill DuBose 11 7 2011 feedback Vivek Natani Revised implemented Changes 11 16 2011 for Agency Source Number and Method of Procurement Vivek Natani Separated the Appendix in the 11 21 2011 separate SCRS Validation Tables Document Vivek Natani Combined two files in one file 12 01 2011 Vivek Natani Revised based on Bill DuBose 12 02 2011 feedback Vivek Natani Revised the Budget and Budget 12 13 2011 Change Information based on Bill s feedback Vivek Natani Revised to incorporate the Change 12 28 2011 Requests after the last two policy group meetings Robert Foster Updated general comment and 2 16 2012 error information Vivek Natani Updated the conditional rules for 2 22 2012 Deliverable record Vivek Natani Corrected the data element 3 21 2012 Authorized Advance Payment as required Vivek Natani Added Do not publish this 6 4 2013 contract on the FACTS website and Deliverable Number data elements Bill DuBose Inserted cover page and edited for 6 5 13 6 26 2013 2 40 00 PM 17 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Bill DuBose Addition of Instructions and Validation Code Tables 6 26 13 6 26 2013 2 40 00 PM 18 of 182. Florida Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide June 2013 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Table of Contents o A TN 3 Agency ASSUMPTIONS orisiirisii eiiiai eai dad dada aaa Adelaida sidad 3 References AN 3 User Interface Batuta adn a ia ence dene 4 Ag ney Batch TRANSMISSION ih ninia A a 6 Contract Batch Import File Format Tables cccccessssccececessesssseseceeccssseseaaeseceeeceseeseaaeseceeecssceseaaeaeeeeeesssessaeaeeeeeess 7 Main Contract Information RECOM ccsccescessceseceeeeeeeeeeeeeeeeeeaeecacecaeecaaecsaecsaeceaecuaeseaeesseeseeeeeeseaeeeaeeeeeeaeeaaes 7 Contract Change Amendment Information Record ssccccsseceescecsssceessececssecesseccsseeecaececseeceseecesseeecaaeeeeseeees 12 Contract s Budget Information Record ccccccccssscesesssececeesececeeaeeecsesaececsesseeececsaseeseesaeeeceesaeeecsesaeeeceeaaeeeeees 13 Contract s Vendor Information RecOrO ccooocccnncccnoncccnonnnonannnnnonononenononn nano nnnnnn cnn enn enn n nan nn nn name idoni iieaeoe nansa 14 Contract s Deliverable Information Record cccessseseceeseceseceseceaeceseeeseeeeeeeeeseaeeeaeeeaeesaeecaaeeaaesaeeeaeeeaeeeaeees 14 Contract s CSFA Information Record ccccecceescee
3. Regional and Language Options dialog box appears click Customize 4 When the Customize Regional Options dialog box changes click the Numbers tab enter the Pipe character in the Line separator field Hold Shift key and press the Back Slash key and click Apply 5 Note After saving the data file in the prescribed text format you may want to change the List separator setting back to the comma 6 When the next dialog box appears click OK Back at the Excel sheet click Save As Other Formats 8 When the Save As dialog box appears enter the prescribed file name e g Batch_OLO Number_YYYY_MM_DD then select CVS Comma delimited in the Save as type field click Save 9 When the next dialog box appears click Yes The saved file will look like this when opened with Microsoft Notepad Bacth_480000_20120110 Notepad LEX File Edit Format View Help Maximize IAIN MAIN ADD 480000 Race To The Topl Services A 9 1 2010 6 30 2014 Entitlement YIN N N A Implementation has not egun N O Em DLBL other Florida s participating local education agencies LEAs receive an award of their share of 350 000 000 based on the Title I formula In order to receive an award each participating LEA must have an approved Final scope of work detailing their activities and deliverables across 13 projects aligned to the Memorand
4. N No Functions Considered for Insourcing back to the State Did the Vendor Text 1 Y Yes Yes Make Capital N No Improvements on State Property 6 26 2013 2 40 00 PM 10 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Data Element Type Size Allowed values in case Required Comments Name Detail of code values Capital Text 1000 Conditionally Required if Did the Improvements Required Vendor Make Capital Description Improvements on State Property Y Value of Capital Numeric 13 2 Conditionally Required if Did the Improvements Required Vendor Make Capital Improvements on State Property Y Value of Numeric 13 2 Conditionally Required if Did the Unamortized Required Vendor Make Capital Capital Improvements on State Improvements Property Y Do not publish Text 1 Y Yes No The system will default this contract on N No the value to N if not the FACTS website provided 6 26 2013 2 40 00 PM 11 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Contract Change Amendment Information Record Provide only the Change records that need to be added or updated For example if a contract has th
5. Code Required Non Price Justification Validation Tables Contract Wide for code details Consequences The value in this case will be BK Contract s Major Numeric 13 2 Yes May be zero Deliverable Price Non Price Text 150 Please see the Conditionally Only required if the Justification FACTS Code Required Contract s Major Deliverable Validation Tables Price is zero for code details Contract s Text 2000 Conditionally Not Required if the Non Price Performance Required Justification Contract Wide Metrics Consequences Contract s Financial Text 2000 Conditionally Not Required if the Non Price Consequences Required Justification Contract Wide Consequences Source Text 250 No Documentation Page Reference Deliverable Text 25 No Number 6 26 2013 2 40 00 PM 15 of 18 Contract s CSFA Information Record Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Data Element Type Size Allowed values in Required Comments Name Detail case of code values Contract Record Text 4 CSFA Yes Always pass this value for Type Contract CSFA Information Contract s CSFA Text 6 Yes This must be a valid FLAIR CSFA Code code This will be validated Contract s CFDA Information Record Data Element Type Size Allowed values in Required Comments Name Deta
6. must have an approved Final of work detailing their activities and deliverables across 13 projects aligned to the Memorandum of Understanding mou th igned in order to participate MOU and projects are aligned to the four assurance areas of the Race to the Top program as identifi y the U S Department of Education Standards amp ASsessments Using Data to Improve Instruction Gre Teachers and Leaders d Turning Around the Lowest Achieving schools other 1 A AN MAIN MAIN ADD 480000 Race To The Top services Al 9 1 2010 6 30 2014 lEentitlement l IYINI I DLBL DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 350 000 000 based on the Title I formula In order to receive an award each participating LEA must have an approved Final Scope of work detailing their activities and deliverables across 13 projects aligned to the memorandum of Understanding mou they Stoned in order to participate mou and projects are aligned to the four assurance areas of the Race to the Top program as identified by the U S Department of Education Standards Assessments Using Data to Improve Instruction Great Teachers and Leaders and Turning Around the Lowest Achieving schools other 1 AAN MAIN MAIN ADD 480000 Replacement Kitchen Hood Exhaust sys Rhode Bldg other A 8 11 2003 9 9 9999 Exempt 11 None specified No N A N N A Y Project cancelled N A DLBL DLBL N A Replacem
7. 830000_2012_03_ 31 B Transmit the batch file with the Agency s sFTP client software user name and password provided by FACTS Info MyFloridaCFO com C The sFTP client will provide a confirmation that the file was transmitted successfully or a notification that an error occurred If an error was experienced in saving the Agency Batch data load investigate and resubmit prior to 5 PM 6 26 2013 2 40 00 PM 6 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide D All Batch data load files will be processed between the hours of 5 00 PM and 6 45 PM The information will be validated and loaded into the FACTS website database If an error is encountered it will be written in an output log file and placed on the error screen of the web application E Essential information is passed through as a second batch loading process to FLAIR If errors are encountered the errors will be captured in the same output log file described in the earlier paragraph F Valid data loaded under the batch process will be in FLAIR within 24 hours from the time the web system processes the batch file Loading processes are scheduled to run on regular working days G All errors encountered during the batch process will be posted by 5 AM the next business day Contract Batch Import File Format Tables Main Contract Information Record Data Element Type S
8. Around the Lowest Achieving Schools jother 1111 AN 6 26 2013 2 40 00 PM 5 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide B Access the FACTS web application dashboard select the Upload Contract Information option to upload the agency contract data and follow the on screen instructions C The Agency will receive a confirmation that the file was transmitted successfully or a notification of errors If an error is encountered in saving the Agency Batch data load investigate and resubmit the file prior to 5 PM D All Batch data load files will be processed between the hours of 5 00 PM and 6 45 PM The information will be validated and loaded into the FACTS website database If an error is encountered it will be written in an output log file and placed on the error screen of the web application E Essential information is passed through as second batch loading processes to FLAIR If errors are encountered these errors will be captured in the same output log file described in the earlier paragraph F Valid data loaded under the batch process
9. chen Hood Exhaust Sys Rhode Bldg Cost Reimbursement 11 MAIN ADD 480000 Vending Machine Placement Services 12 DLBL N A Vending Machine Placement Services Other 13 MAIN ADD 480000 Building Renovation DOE Project Number 24027010 DOE Prd 14 DLBL N A Remodeling of the O A Center and Maintenance and building of the Library Annex Dayton Cost Reimbursement 15 MAIN ADD 480000 Race To The Top 16 DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 351 Other 17 MAIN ADD 480000 Race To The Top 18 DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 351 Other an sanmi an Heed bo Pl Sheet Sheet2 Sheet3 Ready Num Lock 90000 6 26 2013 2 40 00 PM 4 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Some of the data entered in the spreadsheet are FACTS codes Refer to FACTS Code Validation Tables Loading Steps A Once the spreadsheet data is verified save the file in the format and with the prescribed file name Batch_OLO number_date code e g Batch_830000_2012_03_ 31 so the FACTS web application can process In order to save the Excel file in the required format some Windows settings may need to be changed 1 Access the Control Panel 2 Double click the Regional and Language Options icon 3 When the
10. d used must be in the spreadsheet even if it contains blanks B Book1 Microsoft Excel mR E ue y Home Insert Page Layout Formulas Data Review View 3x H ni e M A r W LE From Access 2 B connections 3 y 4K Clear ziz Data Validation 7 E Fro s s ne A Properties S Reapply Q fla Consolidate L From Other Existing Remen OET Z Sort Filter y Text to Remove E Group Ungroup Subtotal Sources Connections Ally gt Edit Links Al 2 Advanced Columns Duplicates EP wnair Analysis z z Get External Data Connections Sort amp Filter Data Tools Outline E do crgo itot Al va f B c D E F MAIN JADD 480000 Race To The Top 2 DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 35 Other 3 MAIN ADD 480000 Race To The Top 4 DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 351 Other 5 MAIN ADD 480000 Race To The Top 6 DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 351 Other 7 MAIN ADD 480000 Race To The Top 8 DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 35 Other 9 MAIN ADD 480000 Replacement Kitchen Hood Exhaust Sys Rhode Bldg 10 DLBL N A Replacement Kit
11. e FACTS Conditionally Required if Contract Code Validation Tables Required Involves State or Federal for code details Financial Aid Y This should be a valid FLAIR Recipient Type code Provide for Text 1 Y Yes Yes Administrative N No 6 26 2013 2 40 00 PM 9 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Data Element Type Size Allowed values incase Required Comments Name Detail of code values Cost Administrative Text 6 Conditionally Required if Provide for Cost Percentage 00 00 Required Administrative Cost y Provide for Text 1 Y Yes Yes Periodic Increase N No Periodic Increase Text 6 Conditionally Required if Provide for Percentage 00 00 Required Periodic Increase Y Business Case Text 1 Y Yes Yes Study Done N No Business Case Date Conditionally Required if Business Date YYYY MM DD Required Case Study Done Y Legal Challenges Text 1 Y Yes Yes to Procurement N No Legal Challenge Text 2000 Conditionally Required if Legal Description Required Challenges to Procurement Y Was the Text 1 Y Yes Yes Contracted N No Functions Previously Done by the State Was the Text 1 Y Yes Yes Contracted
12. ent Kitchen Hood Exhaust Sys Rhode Bldg cost Reimbursement 111111111111111111 HIT MAIN MAIN ADD 480000 Vending Machine Placement Services Services A 1 30 2004 11 30 2013 Sole source None Specified No N AIN N A N N A DLBL DLBL N A Vending Machine Placement Services other VIVIA I ILLA Ia aran iaa 14004 MAIN MAIN ADD 480000 Building Renovation DOE Project Number 24027010 DOE Project Number 24027000 Services A 10 19 2004 9 9 9999 Exemption Y No N AIN Y NIN A DLBL DLBL N A Remodeling of the O A Center and Maintenance and building of the Library Annex Daytona Beach Blind Services Campus Cost Reimbursement 111111 Tit A AN pea MAIN ADD 480000 Race To The Top services A 9 1 2010 6 30 2014 entitlement vin n n AlImplementation has not egun N O DLBL DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 350 000 000 based on the Title I formula In order to receive an award each participating LEA must have an approved Final Scope of work detailing their activities and deliverables across 13 projects aligned to the memorandum of Understanding mou they hae in order to participate The mou and projects are aligned to the four assurance areas of the Race to the Top program as identified by the U S Department of Education Standards amp Assessments Using Data to Improve Instruction Great Teachers and Leaders and Turning
13. il in case of code values Contract Record Text 4 BUGT Yes Always pass this value for Type Contract Budget Information Agency Text 8 Conditionally Required if the Contract s Amendment Required Budgetary Amount is for a Reference Contract Change Amendment Leave it blank if the Budgetary Amount is for the Contract Contract s Numeric 13 2 Yes This can be zero for task Budgetary order type contracts Amount Contract s Text 2 RE Recurring Yes Budgetary NR Non Amount Type Recurring Contract s Text 29 Conditionally Required if the Contract s Budgetary Required Budgetary Amount is greater Amount Account than zero Code This must be a valid FLAIR account code This will be validated Contract s Date Conditionally Required if the Contract s Budgetary YYYY MM DD Required Budgetary Amount is greater Amount Fiscal than zero Year Effective Date OCA Text 60 No 6 26 2013 2 40 00 PM 13 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Contract s Vendor Information Record Data Element Type Size Allowed values in Required Comments Name Detail case of code values Contract Record Text 4 VNDR Yes Always pass this value for Type Contract Vendor Information Contract s Vendor Text 21 Yes This must be a valid FLAIR code Id on FLAIR s vendor o
14. il case of code values Contract Record Text 4 CFDA Yes Always pass this value for Type Contract CFDA Information Contract s CFDA Text 6 Yes This must be a valid FLAIR CFDA Code code This will be validated Error Log File Information Import Uploaded files will be processed nightly The results will be returned by an error log available either through the FTP or FACTS View Upload History dashboard functions Records that did not contain an error will not be placed into the file Records that resulted in an error will be placed into the file in their entirety with the exception of Contract Manager Information which will be blanked out Error logs will use the following naming convention FilenameRecieved_YYYYMMDD_HHMMSS Log txt The resulting error record will be formatted as Error Error Description Delimited record received 6 26 2013 2 40 00 PM 16 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS User Guide Contract Batch Import File Layout Format In cases where the Main record results in an error children records for that Main record will not be processed and will be put into the error log file with the error description that their Main contract record had errors FACTS Code Validation Tables Reference the FACTS Validation Tables for details Revision Control
15. ize Allowed values incase Required Comments Name Detail of code values Contract Record Text 4 MAIN Yes Always pass this value Type for Main Contract Information Action Text 4 ADD When Adding a Yes new contract UPD When Updating an existing contract NONE When Updating Adding an existing contract s children FLAIR Agency Text 6 Yes Identifier OLO FLAIR Contract Text 5 Yes Identifier Contract s Short Text 10 Yes Title Contract s Long Text 60 Yes Title Agency Assigned Text 50 Yes Contract Identifier 6 26 2013 2 40 00 PM 7 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Data Element Type Size Allowed values in case Required Comments Name Detail of code values Contract s Type Text 2 Please see the validation Yes tables for Contract Reporting System for code details Contract s Status Text 1 A Active Yes C Closed D Deleted E Extended R Renewed T Terminated Original Contract Numeric 13 2 Yes Amount Contract s Date of Date Yes Execution YYYY MM DD Contract s Date Yes Beginning Date YYYY MM DD Contract s Original Date No Ending Date YYYY MM DD Agency Service Text 5 No Area Agency Contract Text 31 Yes Manager s Name Age
16. mit data if this option is selected for the agency References Agencies should utilize the following additional documents to support FACTS processes 1 Department of Financial Services FACTS Code Validation Tables 2 Department of Financial Services FACTS User Manual 6 26 2013 2 40 00 PM 3 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide User Interface Batch FACTS expects the batch data in one delimited flat file The column delimiter is a one pipe and the new line row delimiter is a carriage return When using Microsoft Excel to create the batch file the data must be entered in the spreadsheet as follows for each contract Row 1 MAIN Contract Row 2 CTCH Contract Change Amendment if applicable Row3 BUGT Budget Info if applicable Row 4 VNDR Vendor Info if applicable Row 5 DLBL Deliverable Info if applicable Row 6 CSFA CSFA Info if applicable Row 7 CFDA CFDA Info if applicable Refer to the Contract Batch Import File Format tables below for field column data requirements for each row Each time record type of MAIN is encountered FACTS records one contract and its associated children records row CTCH BUGT VNDR DLBL CSFA and CFDA There does not have to be all the different children records rows for each MAIN however all the fields columns for each children recor
17. ncy Contract Text 10 Yes Manager s Phone 85034132230 Number Agency Contract Text 50 Yes Manager s e mail Address Authorized Text 1 Y Yes Yes Advance Payment N No Contract s Text 2 Please see the FACTS Yes 6 26 2013 2 40 00 PM 8 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Data Element Type Size Allowed values in case Required Comments Name Detail of code values Method of Code Validation Tables Procurement for code details State Term Text 50 Please see the FACTS Conditionally Required if Contract s Contract Identifier Code Validation Tables Required Method of Procurement for code details equals A B or D Agency Reference Text 50 No Number Contract s Text 2000 Please see the FACTS Conditionally Required if the Exemption Code Validation Tables Required Contract s Method of Explanation for code details Procurement field is populated with a Non Competitive Procurement Exemption Code Contract s Text 60 Yes Textual information that Statutory represents statutory Authority authority for procuring or providing the commodity or service General Text 2000 Yes Description of the Contract Contract Involves Text 1 Y Yes Yes State or Federal N No Financial Aid Recipient Type Text 1 Please see th
18. r account description file This will be validated Contract s Deliverable Information Record Data Element Type Size Allowed values Required Comments Name Detail in case of code values Contract Record Text 4 DLBL Yes Always pass this value for Type Contract Deliverable Information Contract s Text 6 Please see the Conditionally Data based on Commodity Commodity Service FACTS Code Required Contractual Services codes Type Validation Tables for code details that are active on FLAIR Title file It is required except when the Non Price Justification Contract Wide Consequences The value in this case will be 999999 This must be a valid FLAIR code This will be validated 6 26 2013 2 40 00 PM 14 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Contract s Major Text 2000 Conditionally Textual information that Deliverable Required represents the description for the deliverables It is required except when the Non Price Justification Contract Wide Consequences The value in this case will be Entire Contract Contract s Method Text 2 Please see the Conditionally It is required except when the of Payment FACTS
19. ree Changes Amendments and there is an update in the second previously submitted Change record then only the updated Change record needs to be provided For any updates the Agency Amendment Reference must exist in FACTS for the contract Agency Amendment Reference must be unique for a contract s FLAIR Contract ID Data Element Type Allowed values in Required Comments Name Detail case of code values Contract Record Text 4 CTCH Yes Always pass this value for Type Contract Change Information Action Text 3 ADD Adding a Yes new Contract Change UPD Updating an existing Contract Change Contract Change Text 1 A Amendment Yes Type E Extension R Renewal Amendment Numeric 13 2 Yes Amount Agency Text 8 Yes Amendment Reference Amendment Date Yes Effective Date YYYY MM DD Change Date Date Yes Executed YYYY MM DD New Ending Date Date Conditionally Required if Contract Change YYYY MM DD Required Type equals E or R Change Text 60 Yes Description 6 26 2013 2 40 00 PM 12 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format Contract s Budget Information Record User Guide Data Element Type Size Allowed values Required Comments Name Deta
20. sceesceceeecaeceaecaecaecaeeeeesseeeeeeseeeseaeeeaeesaeeeaaesaaeeaeseaeeeaeeeaeees 16 Contract s CFDA Information RecOrdO ccooocnoccconocanononononcnonnnnnnnonononenrnnnn nano nn nan nn rn ecak iaaiiai SE 16 Error Log File ATOM td ideada 16 FACTS Code Validation Tables voioiniii a 17 REVISION Control A ieee ues Gudea ee beeeee cde iee 17 6 26 2013 2 40 00 PM 2 of 18 Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Batch Import File Layout Format User Guide Introduction An agency can consider using one of the two following options to upload data into the Florida Accountability Contract Tracking System FACTS The first option also referred to as the User Interface Batch process is for agencies that are familiar with Microsoft Excel and have a large number of contract records to load Agencies must have the ability to save the Microsoft Excel worksheet into a file format easily processed by the FACTS web application Once the Agency user has verified and updated the file for required data the Excel spreadsheet with contract data is saved in the format and with the prescribed file name that the FACTS web application can process The user then logs into the FACTS website and can select the upload option to upload the data This requires that the Agency user have a SFTP user name and password provided by FACTS Info MyFloridaCFO com The second option also referred to as the Agency Ba
21. tch Transmission process is used when the agency has a high volume of contract records hundreds or more and is looking for a technical FACTS web application loading solution The agency will generate a Batch file in the format and with the prescribed file name that the FACTS web application can process at the Agency and transmit it through a sFTP to the FACTS web application This requires the agency to request a sFTP account through FACTS Info MyFloridaCFO com Agency Assumptions Agencies should adhere to the following assumptions 1 The Agency has identified their Agency s Point of Contact POC and Technical Point of Contact TPOC 2 The Agency has obtained user ID and password to log into the FACTS web application for Direct Data Entry 3 The Agency has a Microsoft Excel version that allows users to import and export text file instructions Minimum requirement is Microsoft Operating System Windows XP contact Agency technical staff if using earlier versions of Microsoft Operating System and software 4 The Agency has secure File Transfer Protocol sFTP software to retrieve and transmit data files required for Agency Batch Transmission only Contact agency technical staff technical staff if using earlier versions of Microsoft Operating System and software or if not familiar with sFTP software 5 The Agency has requested a secure File Transfer Protocol sFTP account through FACTS Info MyFloridaCFO com to retrieve and trans
22. um of Understanding mou they signed in order to participate MOU and projects are aligned to the four assurance areas of the Race to the Top program as identified by the U S Department of Education Standards amp Assessments Using Data to Improve Instruction Great Teachers and Leaders and Turning Around the Lowest Achieving schools other 17 IYD EII rara gra raJa MAIN MAIN ADD 480000 Race To The Top services A 19 1 2010 6 30 2014 entitlement l h DLBL DLBL Other Florida s participating local education agencies LEAs receive an award of their of 350 000 000 based on the Title I formula In order to receive an award each participating LEA must have an approved Final of work detailing their i activities and deliverables acros mou and projects are aligned to Education Standards ASsessmen s 13 projects aligned to the Memorandum of Understanding mou th igned in order to participate the four assurance areas of the Race to the Top program as identifi yy the U S Department of ts Using Data to Improve Instruction Great Teachers and Leaders d Turning Around the Lowest Achieving Schools other 1 III IITIN MAIN MAIN ADD 480000 Race To The Top Services A 9 1 2010 6 30 2014 Entitlement Y DLBL DLBL Other Florida s participating local education agencies LEAs receive an award of their of 350 000 000 based on the Title I formula In order to receive an award each participating LEA
23. will be in FLAIR within 24 hours from the time the web system process the batch file Loading processes are scheduled to run on regular working days G All errors encountered during the batch process will be posted by 5 AM the next business day and be accesed using the FACTS web application dashboard option View Upload History Agency Batch Transmission FACTS expects the batch data in one delimited flat file The column delimiter is a one pipe and the new line row delimiter is a carriage return e This file contains the Main contract information record One to One data relationship data not repeated for a contract and then all the children records One to Many relationship data may be repeated for a contract just after the Main record e The contract Change record if any follows the Main record The other children records can be in any order after the Main but must be grouped together Each Main record indicates another contract e When updating adding any of the Vendor Budget Deliverable CSFA CFDA children records provide the entire appropriate children record set for the contract Loading Steps A Configure the agencies local system to export data according to the format in the Contract Batch Import File Format Tables FACTS File Format for Agencies document Remember to save the file with the proper format and naming convention Batch_OLO number_date code e g Batch_
Download Pdf Manuals
Related Search