Contract/Disbursement Agreement Batch Import File Format User
Contents
1. Effective Date YYYY MM DD Data Element Type Size Allowed values Required Comments Name Detail in case of code values Record Type Text 4 CTCH Yes Always pass this value for Contract Grant Disbursement Agreement Change Information Action Text 3 ADD Adding a Yes new Contract Grant Disbursement Agreement Change UPD Updating an existing Contract Grant Disbursement Agreement 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 10 16 2013 1 37 00 PM 13 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Change Date Date Yes Executed YYYY MM DD New Ending Date Date Conditionally Required if Contract YYYY MM DD Required Change Type equals E or R Change Text 60 Yes Description 10 16 2013 1 37 00 PM 14 of 20 Budget Information Record Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Record Type Text 4 BUGT Yes Always pas2. Florida Department of Financial Services Florida Accountability Contract Tracking System FACTS Contract Grant Disbursement Agreement Batch Import File Format User Guide October 2013 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Table of Contents o A O NN 3 Agency ASSUMPTIONS iii ii 3 A RR NS 3 User Interface Bat A A tadas 4 Agency Batch aN Eaa Eo a E EAE E E A da E 6 Contract Batch Import File Format Tables ccoconocooconnnncnonononannnnnnnnnononononnnnnnnnonnnnnnnnnnnnnnnnnnnnn nn nn nnnnnnnnnnne nn nnnnnnnnnns 7 Main Contract Information RECO ceecceesseceeseceeeeeceeeeeesaeeeeaeeceeeeecsaeeeeaaeceeaeeseaeeesaaeeseaaeceeaeeenaeeessaeeeeaaeseanees 7 Contract Change Amendment Information Record ssccccssecesssecssseeesececseecesseecsseeecsaececseeceseceaeeeesaeeeeseeens 13 Contract s Budget Information Record occccccnonononoonnononnnanonennnnnnncnnnnnnnonnnnnnnnnnonnnnonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnanoss 15 Contract s Vendor Information RecOrO ccooocccnnnccconcccnonnnononnnnnnnononenononnnnnnnnnnnn cnn nnn ran nn anno nn nnnn rre nn aran nn anna nn ara iaaa 16 Contract s Deliverable Information Record oooocccnncccnoncnononcnonanonononononcnnnnanannn non nnnrnn ona nan nn nan n rra nn aran anannn nn nnncnnnns 16 Contract s CSFA Information Record oooocnoccconoccnononononcnonencnnnanonononcnnnnnnnnnnnnnn n
3. receive an award have an approved F Understanding mou Top program Teachers and the entitlement l encies LEAs receive an award of their share each participating LEA must have an approved Final scope Memorandum of Understanding mou they si the Race to the Top program as identified Instruction Great Teachers and Leaders and Turning Around the other A 8 11 2003 mbursement 11111111 30 2004 11 30 201 3 of the Library Annex entitlement of thei Y N N N A Implementation has not local education agencies LEAs receive an award of their share of 350 000 000 based on the In order to receive an award each participating LEA must have an approved Final scope of work detailing their Memorandum of Understanding mou they signed in order to participate areas of the Race to the Top program as identified Improve Instruction Great Teachers and Leaders and Turning Around the 6 30 2014 y the U S Department of hd of 350 000 000 based on the e of Work detailing their dps in order to participate y the U S Department of Turning Around the eir inal th entifi ers of 350 000 000 based on the of work detailing their igned in order to p rticipate y the U S Department of Turning Around the inal they YIN of 350 000 000 based on the of work detailing their me in order to particip
4. Name Detail in case of code values Record Type Text 4 DLBL Yes Always pass this value for Deliverable Information Commodity Service Text 6 Please see the Conditionally Data based Commodity Type validation tables Required Contractual Services Catalog for Contract that is active on FLAIR Title Reporting System file for code details It is required except when the Non Price Justification Contract Wide Consequences The value in this case will be 99999 This should be a valid FLAIR code This will be validated 10 16 2013 1 37 00 PM 16 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Major Deliverable Text 1000 Conditionally Textual information that 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 Method of Text 2 Please see FACTS Conditionally It is required except when the Payment Code Validation Required Non Price Justification Tables for code Contract Wide details Consequences The value in this case will be BK Major Deliverable Numeric 13 2 Yes May be zero Price Non Price Text 150 Please see FACTS Conditionally Only req
5. Standards t Lowest Achieving schoo l Education MAIN DLBL MAIN ADD DLBL Title I formu MOU and projects are Education MAIN MAIN specified DLBL DLBL MAIN MAIN Specified DLBL DLBL MAIN MAIN 24027000 DLBL DLBL N A Reimbursement MAIN MAIN ADD begun IN 0 DLBL DLBL Title I formu ADD N A ADD N A ADD Standards Lowest Achieving Schools other l other Florida s partic other Florida s partici ke c activities and deliverables across j i t t Standards Lowest Achieving schools other Replacement Kitchen A Y Project cancelled Replacement Kitchen Hood Exhaust vending Machine Placement services No N AIN N No N AIN N Services A Assessments s other 480000 a In order to re a amp igned to Assessments 480000 Race To TI In order to re aligned to amp ASsessmen s other Race To TI 480000 a In order to re a igned to ASsessmen 5 480000 480000 ALININ A vendin 2800007 Remodeli 11111 480000 V AN a Race To The Top other Florida s participating ceive activities and deliverables across 13 the four is Topl ating ive 13 e four assurance e Top pating elve 13 he four assurance Machine Placement Services other Building Renovation DOE Project Number 24027010 DOE Project Num
6. Natani Separated the Appendix in the separate SCRS Validation Tables Document 11 21 2011 Vivek Natani Combined two files in one file 12 01 2011 Vivek Natani Revised based on Bill DuBose feedback 12 02 2011 Vivek Natani Revised the Budget and Budget Change Information based on Bill s feedback 12 13 2011 Vivek Natani Revised to incorporate the Change Requests after the last two policy group meetings 12 28 2011 Robert Foster Updated general comment and error information 2 16 2012 Vivek Natani Updated the conditional rules for Deliverable record 2 22 2012 Vivek Natani Corrected the data element Authorized Advance Payment as required 3 21 2012 Vivek Natani Added Do not publish this contract on the FACTS website and Deliverable Number data elements 6 4 2013 Vivek Natani Updated Contract Manager s Phone No and Email fields to optional 9 10 2013 10 16 2013 1 37 00 PM 20 of 20
7. of the Vendor Budget Deliverable CSFA CFDA children records provide the entire appropriate children record set for the contract grant agreement preceded by a Main record containing at a minimum Agency ID FLAIR Id and Action Loading Steps A Configure the agencies local system to export data according to the format in the Contract Grand Disbursement Agreement 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_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 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 10 16 2013 1 37 00 PM 6 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide E Essential information is passed through as a second batch loading process to FLAIR If err
8. 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 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 grant disbursement agreement 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 grant disbursementagreement just after the Main record e The contract grant disbursement agreement 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 grant disbursement agreement e When updating adding any
9. the system but it is still kept in the file format to ensure data element s positions are not affected Any value if provided will be ignored 10 16 2013 1 37 00 PM 10 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Provide for Text 1 Y Yes Yes Periodic Increase N No Periodic Increase Text 6 Conditionally Required if Provide Percentage Required for Periodic Increase Y Business Case Text 1 Y Yes Yes Study Done N No Business Case Date YYYY Conditionally Required if Date MM DD Required Business 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 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 10 16 2013 1 37 00 PM 11 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format Us
10. 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 amp 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 nani ann a 20000 4 4 mM Sheetl Sheet2 Sheet3 43 4 Ready Num Lock 10 16 2013 1 37 00 PM 4 of 20 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 2 3 4 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Some of the data entered in the spreadsheet are FACTS codes Refer to FACTS Code Validation Tables Access the Control Panel Double click the Regional and Language Options icon When the Regional and Language Options dialog bo
11. Procurement to equal A Bor D Agency Reference Text 50 No Number Contract s Text 2000 Conditionally Please see FACTS Exemption Required Code Validation Explanation Tables for code details Note Required if the Contract s Method of Procurement field is populated with a Non Competitive Procurement Exemption Code E Exception Exemption Code status 10 16 2013 1 37 00 PM 9 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Contract s Text 60 Yes Textual information Statutory that represents Authority statutory authority for the grant disbursement agreement or procuring or providing the commodity or service General Text 2000 Yes Description of the Contract Contract Involves Text 1 Y Yes Yes If Contract s Type State or Federal N No GD must be Y Financial Aid Recipient Type Text 1 Please see the Conditionally Required if validation tables Required Contract Involves for Contract State or Federal Reporting System Financial Aid Y for code details Please see FACTS Code Validation Tables for code details Provide for Text 1 Y Yes Yes Administrative N No Cost Administrative Text 6 No This field is removed Cost Percentage from
12. ate yy the U S Department of 9 9 9999 Exempt 1111111 IEA EIA Drag ra sole source 1 None None Daytona Beach Blind services Campus Cost IYIN IN N A Implementation has not other Florida s participating local education agencies LEAs receive an award of their share of 350 000 000 based on the In order to receive an award each participating LEA must have an approved Final Scope of work detailing their Memorandum of Understanding mou they te in order to participate igned to the four assurance areas of the Race to the Top program as identified by the U S Department of Data to Improve Instruction Great Teachers and Leaders and Turning Around the The 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 10 16 2013 1 37 00 PM 5 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide 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
13. ber 10 19 2004 9 9 9999 JY no N A N IY NIN A of the O amp A Center and Maintenance and building veing Data to TTUTTEV TEEPE services A 9 1 local education a an award projects aligned assurance are Data to Improve 11111 11111 Services A 9 1 2010 local education agenc an award projects II 2010 enc the u of t mite lI the aligned to of t areas Data Improve III 114111 iserviceslAl 9 1 2010 local education ag an award using to the projects of aligned to areas Improve 1111 t Sys usin il to Data III Hood Exhaus N A sys Rhode B Exemption Race To The Top Services A 9 1 2010 activities and deliverables across 13 projects aligned to the mou and projects are a Education Standards amp ASsessments ret 1 Lowest Achieving Schools other LIMIT DITA EE dg Services A 1 jes LEAS each participating LEA must Memorandum of he Race to Instruction Great ies LEAs each participating LEA must Memorandum of he Race to Instruction Gre 6 30 2014 Rhode Bldg Cost Rei AN 6 30 2014 6 30 2014 6 30 2014 Entitlement Entitlement receive an award of th have an approved F understanding mou Top program as id Teachers and Lead the Entitlement
14. c non nn ran n nana nn nnnn rre nn aran nnann nn nanenenns 18 Contract s CFDA Information Recordi senideei iiaii eiai aar aieea eiea iiien ia ai aai i aae 18 Error Filesintonmatio miss seces esie EA A A AA A A ae eaen 18 FACTS Code Validation Table Sisinnio a a a a a i aa 19 Revision Control A AAA 20 10 16 2013 1 37 00 PM 2 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File 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 Batch Transmission process is used when the agency has a high volume of contract record
15. er Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Capital Text 1000 Conditionally Required if Did the Improvements Required Vendor Make Description Capital Improvements on State Property ayn Value of Capital Numeric 13 2 Conditionally Required if Did the Improvements Required Vendor Make Capital Improvements on State Property uy Value of Numeric 13 2 Conditionally Required if Did the Unamortized Required Vendor Make Capital Capital Improvements Improvements on State Property uyn Do not publish Text 1 Y Yes No The system will this contract on N No default the value to the FACTS website N if not provided 10 16 2013 1 37 00 PM 12 of 20 Contract Grant Disbursement Change Amendment Information Record Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Provide only the Change records that need to be added or updated For example if a contract grant disbursement agreement has three 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
16. es Agency Assigned Text 50 Yes Contract Identifier Contract s Type Text 2 Please see FACTS Yes For Grant Code Validation Disbursement Tables for code Agreement this details value will always be GD Contract s Status Text 1 A Active Yes C Closed D Deleted E Extended T Terminated R Renewed Original Contract Numeric 13 2 Yes Amount Contract s Date of Date Yes This field cannot be Execution YYYY MM DD updated after the contract is finished published to web 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 Agency Contract Text 10 No Manager s Phone 85034132230 Number 10 16 2013 1 37 00 PM 8 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Agency Contract Text 50 No Manager s e mail address Authorized Text 1 Y Yes Yes Advance Payment N No Contract s Text 2 Please see FACTS Yes Method of Code Validation Procurement Tables for code details State Term Text 50 Conditionally Please see FACTS Contract Identifier Required Code Validation Tables for code details Note Required if Contract s Method of
17. ilize 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 10 16 2013 1 37 00 PM 3 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File 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 Grant Disbursement Agreement Row 2 CTCH Contract Grant Disbursement Agreement 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 Grant Disburesment Agreement 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 grant disbursement agreement record 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 record used m
18. ill 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 10 16 2013 1 37 00 PM 18 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide 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 10 16 2013 1 37 00 PM 19 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Revision Control Name Action Date Vivek Natani Initial Draft 10 26 2011 Vivek Natani Revised based on Bill DuBose feedback 11 7 2011 Vivek Natani Revised implemented Changes for Agency Source Number and Method of Procurement 11 16 2011 Vivek
19. ors 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 Grant Disbursement Agreement Batch Import File Format Tables Main Contract Grant Disbursement Agreement Information Record Data Element Type Size Allowed values Required Comments Name Detail in case of code values Record Type Text 4 MAIN Yes Always pass this value for Main Information Action Text 4 ADD When Yes Adding a new contract grant disbursement agreement UPD When Updating an existing contract grant disbursement agreement NONE When Updating Adding an existing contract grant disbursement agreement s children FLAIR Agency Text 6 Yes Identifier OLO FLAIR Text 5 Yes Contract Grant Disbursemtn Agreement Identifier FLAIR ID 10 16 2013 1 37 00 PM 7 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Data Element Type Size Allowed values Required Comments Name Detail in case of code values Short Title Text 10 Yes Long Title Text 60 Y
20. s 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 transmit data if this option is selected for the agency References Agencies should ut
21. s this value for Budget Information Agency Text 8 Conditionally Required if the Budgetary Amendment Required Amount is for a Reference Contract Grandisbursement Agreement Change Leave it blank if the Budgetary Amount is for the Contract Grant Disbursement Agreement Budgetary Numeric 13 2 Yes This can be zero for task Amount order type contracts Budgetary Text 2 RE Recurring Yes Amount Type NR Non Recurring Budgetary Text 29 Conditionally Required if the Budgetary Amount Account Required Amount is greater than zero Code This should be a valid FLAIR account code This will be validated Budgetary Date Conditionally Required if the Budgetary Amount Fiscal YYYY Required Amount is greater than zero Year Effective MM DD Date OCA Text 60 No 10 16 2013 1 37 00 PM 15 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide Vendor Recipient Information Record Data Element Type Size Allowed values in Required Comments Name Detail case of code values Record Type Text 4 VNDR Yes Always pass this value for Vendor Recipient Information Vendor Id Text 21 Yes This should be a valid FLAIR code on FLAIR s Statewide Vendor File FLAIR A R CustomerFile orFLAIR Account Description Ffile This will be validated Deliverable Information Record Data Element Type Size Allowed values Required Comments
22. uired if the Major Justification Code Validation Required Deliverable Price is zero Tables for code details Performance Text 1000 Conditionally Not Required if the Non Price Metrics Required Justification Contract Wide Consequences Financial Text 1000 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 10 16 2013 1 37 00 PM 17 of 20 Department of Financial Services FACTS Contract Grant Disbursement Batch File Format User Guide CSFA Information Record Data Element Type Size Allowed values in Required Comments Name Detail case of code values Record Type Text 4 CSFA Yes Always pass this value for CSFA Information CSFA Code Text 6 Please see FACTS Yes This should be a valid FLAIR CSFA Code Validation code This will be validated Tables for code details Contract s CFDA Information Record Data Element Type Size Allowed values in Required Comments Name Detail case of code values Contract Record Text 4 CFDA Yes Always pass this value for CFDA Type Information CFDA Code Text 6 Please see FACTS Yes This should be a valid FLAIR CFDA Code Validation code This will be validated Tables for code details Error File Information Import Uploaded files w
23. ust be in the spreadsheet even if it contains blanks x y Book1 Microsoft Excel PH 1d is 7 Home Insert Page Layout Formulas Data Review View 7 A e Mo a ju 7 O a o Al a A ri El E From Access 5 E a Connections AJ id K Clear Eg Data Validation 7 A ar US Z A sas Sat E UES eg 9 From Web A Properties E Reapply fl consolidate Refresh 3 Z Sort Filter Textto Remove 5 Edit Links A Columns Duplicates Data Tools Group Ungroup Subtotal 2 From Text E Y Advanced E What If Analysis Sort amp Filter Outline Connections A ip d2 3 sl a foo Sos Al va E B c D E F mardaoo 480000 Race To The Top 2 DLBL Other Florida s participating local education agencies LEAs receive an award of their share of 351 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 351 Other 9 MAIN ADD 480000 Replacement Kitchen Hood Exhaust Sys Rhode Bldg 10 DLBL N A Replacement Kitchen Hood
24. x appears click Customize 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 N un pe Note After saving the data file in the prescribed text format you may want to change the List separator setting back to the comma When the next dialog box appears click OK Back at the Excel sheet click Save As Other Formats 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 When the next dialog box appears click Yes The saved file will look like this when opened with Microsoft Notepad P Bacth_480000_20120110 Notepad File Edit Format View Help AIN MAIN egun N O DLBL DLBL Title I formula ADD 480000 other Florida s participating Race To The Top Services A 9 1 2010 activities and deliverables across 13 projects aligned to the MOU and projects are aligned to the four assurance Standards amp Lowest Achieving schoo Education MAIN MAIN DLBL DLBL Title I formu ADD mou and projects are Education MAIN DLBL MAIN DLBL ADD h i Title I formula c activities and deliverables acros mou and projects are t
Download Pdf Manuals
Related Search