- 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Inbound Contract Spreadsheet Upload (CTI002)
- Updated on 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
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 |
---|---|---|
Business Unit | Custom 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 | Custom Contract Header | Contract ID used to identify Contract managed by agencies excluded from FACTS. |
Contract Type | Custom Contract Header | The type of Contract |
Contract Status | Custom Contract Header | The status of Contract |
ChartField Status | Custom Contract Header | ChartField Status |
Short Title | Custom Contract Header | A short title for the Contract |
Long Title | Custom Contract Header | A long title for the Contract |
Contract Amount | Custom Contract Header | Amount for the Contract |
Contractor ID | Custom Contract Header | State Assigned Contractor ID used to identify Contract managed by Agencies. |
ALN | Custom Grants ALN/CSFA | Assistance Listing Number for Contract |
ALN Primary Flag | Custom Grants ALN/CSFA | Primary Flag for ALN |
CSFA | Custom Grants ALN/CSFA | Catalog for State Financial Assistance for Contract |
CSFA Primary Flag | Custom Grants ALN/CSFA | Primary Flag for CSFA |
Version History
Date | Revision Description |
---|---|
12/01/2023 | Original Version |