TIG International Home

PeopleSoft Plugin

Overview

The PeopleSoft product already has the ability to export asset data to a text file on the client PC. Additionally, the PeopleSoft product already possesses the ability to import resultant data from the client PC to the PeopleSoft host. Therefore, interfacing the ATT product to the PeopleSoft product is a very straightforward procedure as illustrated in the diagram.

A standard template for the PeopleSoft unmodified import and export file formats is supplied with the ATT software. It is simply a matter of selecting this template for use with the ATT Text Interface, and the system is operational.

If your PeopleSoft system has been modified to utilise additional fields during an asset stock take procedure, it is simply a matter of modifying the configuration of the ATT data formats to fully support the modification.

Diagram

The diagram below displays the components involved in the communication between PeopleSoft and the ATT software.

PeopleSoft Interface

Standard Data Formats

The data formats for the standard PeopleSoft export and import files are defined in the following two sections. These are defined for the PeopleSoft side of the interface in the program “Ampi1000.sqc”.


Export Format

The table below describes the file format that is used for the extract file. This data is extracted from the PeopleSoft system and saved in a text file on the client PC, ready for transferring to the hand held scanning device. This is the format supported by the supplied PeopleSoft Text interface template. It can be modified using the available techniques within the PeopleSoft system and the ATT Text Interface.

Field Length
tag_number 12
serial_id 20
asset_id 8
deptid 10
model 30
location 10
descr 30
emplid 11
manufacturer 30
Import Format

The table below describes the file format that is used for the import file. This data is imported into the PeopleSoft system from a text file on the client PC. It is then used in the preparation of discrepancy reports inside the PeopleSoft system and will eventually be propagated into the main Asset data. This is the format supported by the supplied PeopleSoft Text interface template. It can be modified using the available techniques within the PeopleSoft system and the ATT Text Interface.

Field Length
tag_number 12
serial_id 20
asset_id 8
match_status 1
review_sw 1
deptid 10
model 30
location 10
descry 30
custodian 30
emplid 11
hand_held_operator 30
manufacturer 30
(hdwr_softwr_sw) 1
(ip_address) 15
(ip_alias) 35
(software_version) 10
(it_asset_id) 10
(scan_business_unit) 5