Inbound Contract Spreadsheet Upload (CTI002)
- 29 Jul 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Inbound Contract Spreadsheet Upload (CTI002)
- Updated on 29 Jul 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
Agencies can upload Contracts in Florida PALM using this spreadsheet upload interface. The spreadsheet upload file will be available for the Agencies exempt from Florida Accountability and Contract Tracking System (FACTS). As part of this interface, users will populate the spreadsheet with Contract details and upload it on the run control page. The process will then load the Contract details into the Florida PALM system. The same process will load the delivered Contract ChartField (CHARTFIELD1_TBL) record.
Click below to view the interface file layout and sample data file.
Business Process Model
This interface can be found in the following business process:
Interface Selection Criteria
The interface data selection criteria includes the following:
Data Field | Data Field Details |
|---|---|
Run Control ID | Required |
File Layout
The layout of the interface is listed below.
| Data Field | Record Type | Data Field Description |
|---|---|---|
Record Code | Contract Header | Indicates Contract Header information. This field is the row identifier and should be added at the start of each header row. |
Business Unit | Contract Header | Business unit. Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Contracts. |
Contract ID | Contract Header | Contract ID used to identify Contract managed by agencies excluded from FACTS. |
Contract Type | Contract Header | The type of Contract. |
Contract Status | Contract Header | The status of Contract. |
ChartField Status | Contract Header | ChartField Status. |
Short Title | Contract Header | A short title for the Contract. |
Long Title | Contract Header | A long title for the Contract. |
Contract Amount | Contract Header | Amount for the Contract. |
Contractor ID | Contract Header | State Assigned Contractor ID used to identify Contract managed by Agencies. |
Record Code | Grant ALN Line | Indicates Assistance Listing (ALN) information. This field is the row identifier and should be added at the start of each ALN row. |
ALN | Grants ALN Line | Assistance Listing Number for Contract. |
ALN Primary Flag | Grants ALN Line | Primary Flag for ALN. |
Record Code | Grant CSFA Line | Indicates Catalog for State Financial Assistance (CSFA) information. This field is the row identifier and should be added at the start of each CSFA row. |
CSFA | Grants CSFA Line | Catalog for State Financial Assistance for Contract. |
CSFA Primary Flag | Grants CSFA Line | Primary Flag for CSFA. |
Version History
Date | Revision Description |
|---|---|
12/01/2023 | Original Version |
| 06/27/2024 | DDID #702 - Update related to Contractor ID(Supplier Id) and Contractor Type(Vendor Type). |
Was this article helpful?
