Inbound Contract Spreadsheet Upload (CTI002)
  • 18 Jul 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Inbound Contract Spreadsheet Upload (CTI002)

  • Dark
    Light
  • PDF

Article summary

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/2024DDID #702 - Update related to Contractor ID(Supplier Id) and Contractor Type(Vendor Type).

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.