Inbound Asset Physical Inventory Scanner File Load (AMI010)
  • 13 Aug 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Inbound Asset Physical Inventory Scanner File Load (AMI010)

  • Dark
    Light
  • PDF

Article summary

Interface Description

The Florida PALM Physical Inventory process extracts the Asset data into a sequential file from the database. This file is generated and saved for the agency to perform its physical inventory. The physical inventory results are then loaded into Florida PALM. The physical inventory results are reviewed and verified to generate results that compare the inventoried data to asset data within Florida PALM. Based on the Inventory result, assets are added, retired, transferred, updated, etc. in Florida PALM.

Click below to view the interface file layout and sample data file.

Business Process Model

This interface can be found in the following business processes:

Selection Criteria

The interface data selection criteria includes the following:

Data Field

Data Field Details

Physical Inventory ID

A search list of the available Physical Inventory IDs for selection.

Format

A dropdown of the available file formats.

Import File Name

A free text field where the user specifies the file path and name where the inventory results file will be placed.

Delete Data Before Load Scan

Check Box, which allows for deletion of previously loaded data.

File Layout

Field names and descriptions from the interface layout are provided below. 

Data Field Name
Record Type
Data Field Description
Tag NumberDetailThe agency unique tag number that is assigned to this asset.               
Serial IDDetailSerial number of asset being recorded in Florida PALM.
Asset IDDetailFlorida PALM generated Asset ID.
Match Status       DetailIdentifies the Physical Inventory Match Status
Review SW DetailIndicates if Manual Review of Asset Record is Required.
DeptidDetailBU Organization that manages and safeguards the asset. Organization ChartField allows agencies to  manage and report asset according to agency's operational/hierarchical structure.
ModelDetailModel of the Asset
LocationDetailThe current  location of this asset (usually BU main location or primary safe-keeping address).  Value entered must be a valid Florida PALM location code. 
DescriptionDetailLong description of the asset (30-character).
CustodianDetailIndividual Authorized to Manage and Safeguard the Asset 
Employee IDDetailThe Employee ID of the custodian responsible for     this asset.
Hand Held OperatorDetailIdentifies the Hand Held Operator
ManufacturerDetailIdentifies the Manufacturer of the asset.
Hardware Software SWDetailIndicates if the asset is a computer equipment
IP Address     DetailIndicates the Internet Protocol Address   
IP Alias       DetailIndicates the Internet  Address Alias 
Software Version  DetailThis field is used for processing purpose and may not have target record
IT Asset IDDetailIdentifies the IT Asset ID
Scan Business UnitDetailUsed to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for AM.
 
 Assets are recorded and  updated in this Business Unit.
Area IDDetailAgency administered field that identifies a more specific area within the location.
Custodian Department IDDetail Agency Department to which the  asset custodian reports.      
Last Scanned DatetimeDetailDate and time the asset was inventoried

Version History

Date

Revision Description

03/12/2024

Original Version

08/13/2024Updated to reflect 7/24 Versions History: Added Last Scanned Datetime field

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.