Skip to Main Content
Return to Navigation

Defining Asset Attributes

To define asset attributes, use the following components:

To access these components, select select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management.

Several procedures and options are available for establishing the core tables for PeopleSoft Asset Management. As previously noted, many of these tables are optional or conditional. Some are required before you can enter assets into the system; these tables are noted as such.

This topic discusses how to:

Note: You can also set up attribute groups.

See PeopleSoft Maintenance Management Integration with PeopleSoft Asset Management.

Pages Used to Define Asset Attributes

Page Name

Definition Name

Navigation

Usage

Asset Class

ASSET_CLASS_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Financials, then select Asset Classes

Maintain asset classes. Asset classes are set up at the tableset level.

VAT Defaults Setup (value-added tax defaults setup)

VAT_DEFAULTS_DTL

Click the VAT Default link on the Asset Class definition page.

Specify VAT defaults setup.

Payment Schedules

LEASE_SCH_ID

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Financials, then select Payment Schedules, then select Payment Schedules

Add or modify payment schedules. When adding leased assets to your system, you must have at least one payment schedule defined.

FERC Code

FERC_CD_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Financials, then select FERC Code, then select FERC Code

Establish FERC (Federal Energy Regulatory Commission) codes for asset categories that are used in regulatory reporting.

Joint Venture Allocation

JV_BUS_ALLOC

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Financials, then select Joint Venture Allocation, then select Joint Venture Allocation

Define the percentage of asset ownership to allocate to each joint venture participant. Use this page to set up the Joint Venture Allocation table.

Maintenance Types

MAINT_TYPE_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Maintenance Types, then select Maintenance Types

Define maintenance types.

Units of Production

UOP_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Depreciation, then select Units of Production

Set up units of production definitions.

Load UOP and Index Tables

RUN_AMIF2000

select Asset Management, then select Send/Receive Information, then select Load Interface, then select Receive UOP and Index Tables

Load units of production and index tables.

Agencies

AGENCY_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Agencies, then select Agencies

Create agency codes. Keep track of the registration and licenses of an asset by using the information that is set up in Agency tables.

Area Definition

AM_AREA_TBL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Area Definition, then select Area Definition

Define an asset area within a location.

Asset Type Options

AM_TYPE_OPT

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Asset Type Options, then select Asset Type Options

Define physical asset types to be applied to individual assets. Oracle delivers ten asset types:Hardware, Software, Equipment, Property, Fleet, Machinery, Furniture, Facility, Intangible, Other.

Define Asset Subtype

AM_SUBTYPE

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Asset Subtype, then select Define Asset Subtype

Define asset subtypes as they relate to asset types. For example, if the asset type is Hardware, an asset subtype may be defined for a Laptop.

Define Asset Attribute

AM_UD_ATTR

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Define Asset Attribute, then select Define Asset Attribute

Define any asset physical attribute to be associated with an asset.

Define Property Subclass

AM_PROP_SUBCLASS

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Asset Property Subclass, then select Define Property Subclass

Define property asset subclasses as they relate to asset property classes: Site, Building, Floor, Area, Space.

Hazardous Codes

ASSET_FSC_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Hazardous Codes, then select Hazardous Codes

Define hazardous-asset codes. The PeopleSoft system is delivered with the Federal Supply Class (FSC) codes, which are U.S. federal codes that identify predominant and significant hazardous materials. You may add other classifications.

Location Definition

AM_LOCATION_TBL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions, then select Location Definition, then select Location Definition

Set up locations.

Detail

MAINT_CONTRACT_01

select Asset Management, then select Service and Maintenance, then select Maintenance Contract Terms, then select Detail

Define the detail terms for maintenance contracts by entering the effective, expiration, and contract dates, and the contract cost and supplier information.

Coverage

MAINT_CONTRACT_02

select Asset Management, then select Service and Maintenance, then select Maintenance Contract Terms, then select Coverage

Define the maintenance contract coverage, including contact information.

Insurance Types

INSURANCE_TYPE

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Insurance Types, then select Insurance Types

Enter different types of insurance, such as liability for automobiles or property.

Transaction Information

UOP_DEFN_WRK

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Depreciation, then select Units of Production, then select Transaction Information

Generate open transactions. Each time new detail is added to this table, you can generate open transactions for each asset associated with it.

Work Order Options for Components

AM_WOM_OPT_SUBTYPE

Click the Work Order Options for Components link on the Define Asset Subtype page.

Define Work Management work order options.

Meter Type Definition

AM_METER_TYPE1

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Meter Types, then select Meter Type Definition

Define meter types.

Meter Type Comments

AM_METER_TYPE2

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Meter Types, then select Meter Type Comments

Add comments that are relevant to meter type definition.

Standard Warranties

AM_STD_WRTY

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Standard Warranties

Define standard warranties.

Warranty Templates

AM_WRTY_TMPL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Warranty Templates

Set up templates for warranty types to apply to asset types.

Equipment Parts List

AM_PART_LIST_TMPL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Equipment Parts List

Define equipment parts lists to be associated with asset classes, groups, categories, types and subtypes, or other asset definitions.

Criticality Codes

AM_CRIT_LEVEL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Service and Repair, then select Criticality Codes, then select Criticality Codes

Establish levels of criticality.

Asset Classes Page

Use the Asset Class page (ASSET_CLASS_DEFN) to maintain asset classes.

Asset classes are set up at the tableset level.

Image: Asset Classes page

This example illustrates the fields and controls on the Asset Classes page. You can find definitions for the fields and controls later on this page.

Asset Classes page

To add a new asset class, select the setID and enter the name of the asset class. Complete the fields on the Asset Classes page as appropriate.

Use asset class to classify assets for reporting purposes. It can be used in combination with the category code to refine asset classification. For example, an executive desk is categorized as furniture and fixtures for the balance sheet. Within the broad category of furniture and fixtures, you can use an asset class code to specifically identify the asset as a desk.

For defining asset classes, Oracle provides the option to define value-added tax (VAT) processing defaults as well.

Defining Asset Class as VAT Driver

Asset class is also used as a VAT driver. Create classifications of assets based on the VAT treatment. For example, treatment of assets such as automobiles may be different from that of assets such as buildings or leases. In this way, the asset class can be used to determine the VAT treatment.

VAT defaults are also set up at the business unit level.

See VAT Defaults Setup Page.

Payment Schedules page

Use the Payment Schedules page (LEASE_SCH_ID) to add or modify payment schedules.

When adding leased assets to your system, you must have at least one payment schedule defined.

Image: Payment Schedule page

This example illustrates the fields and controls on the Payment Schedule page. You can find definitions for the fields and controls later on this page.

Payment Schedules page

When working with leased assets, you must define payment schedules to be assigned to the leased assets.

You must have at least one payment schedule defined when working with leased assets. PeopleSoft Asset Management delivers four payment schedules in the SHARE tableset.

See Understanding Leased Assets.

FERC Code Page

Use the FERC Code page (FERC_CD_DEFN) to establish FERC (Federal Energy Regulatory Commission) codes for asset categories that are used in regulatory reporting.

Image: FERC Code page

This example illustrates the fields and controls on the FERC Code page. You can find definitions for the fields and controls later on this page.

FERC Code page

Add or update FERC codes in accordance with the U.S. Federal Energy Regulatory Commission. FERC codes are used to associate assets with the FERC Uniform System of Accounts for utilities. They are used for regulatory reporting and do not affect any calculations.

Joint Venture Allocation Page

Use the Joint Venture Allocation page (JV_BUS_ALLOC) to define the percentage of asset ownership to allocate to each joint venture participant.

Use this page to set up the Joint Venture Allocation table.

Enter each participating business unit and its allocated percentage of equity in the shared assets. The sum of these percentages must equal 100 percent.

The joint venture allocation table affects only newly added assets. Changes made to the allocation table will not affect existing assets. To change ownership percentages of existing assets, you must run a mass change using the template that is supplied for this purpose. These joint venture mass change templates enable you to:

  1. Add a joint venture business unit.

  2. Remove a joint venture business unit.

  3. Change joint venture ownership allocations.

When you have changed the assets, change the allocation table to reflect the new equity percentages.

Note: The joint venture allocation as defined in the allocation table need not match the actual ownership percentages. For example, if two companies enter a joint venture on a 60/40 basis, one of them can sell the joint venture asset on a 70/30 basis—effectively giving one party a discount while the other pays a premium. In this case, you would first enter the asset at the joint venture business unit level, then change the cost apportionment by using mass change.

Maintenance Types Page

Use the Maintenance Types page (MAINT_TYPE_DEFN) to define maintenance types.

Image: Maintenance Types page

This example illustrates the fields and controls on the Maintenance Types page. You can find definitions for the fields and controls later on this page.

Maintenance Types page

Maintenance types identify the type of maintenance and maintenance procedures to follow for a particular asset. For example, you might establish a Tune Up maintenance code that specifies routine maintenance for an automobile.

See Understanding Asset Maintenance, Repair, Warranties, and Insurance.

Units of Production Page

Use the Units of Production page (UOP_DEFN) to set up units of production definitions.

When you depreciate assets by using the units of production method, you must set up units of production definitions. This table defines the maximum units that an asset can produce and how many units have been posted for each period.

Adding and Adjusting Units of Production Detail Page

Access the Transaction Information page.

Both dates are used in recalculating depreciation. The difference between the transaction date and the accounting date determines whether production detail for this transaction will be posted as accumulated production.

The difference between the transaction date and the accounting date determines whether any prior period production needs to be posted. For example, consider a machine that was acquired and placed in service on March 15, 2008 but did not get entered in PeopleSoft Asset Management until August 1, 2008. All general ledger periods prior to August are closed. In this case, PeopleSoft Asset Management automatically posts any accumulated production to the general ledger in August.

Unlike accumulated depreciation, accumulated production is posted exactly the same as any other production detail. Nothing distinguishes it as accumulated production.

Accumulated production for a new units of production ID should be posted on a date that is before any assets associated with the units of production ID are added.

Maintaining Indexes and Units of Production Tables

You will periodically update the information in your Index and Units of Production tables when you receive new information. You can load or update the Index and Units of Production tables automatically using the AMIF2000. This process takes data in a fixed length format ASCII file and loads it into the appropriate table.

Files to be loaded into the Index table should be in this format:

Field

Length

SETID

5

INDEX_NAME

20

EFFDT

8 (MM/DD/YY)

DESCR

30

INDEX_DETAIL_NAME

35

INDEX_AMOUNT

15

Files to be loaded into the Units of Production table should be in this format:

Field

Length

SETID

5

UOP_ID

10

DESCR

30

UOP_IN_SERVICE_DT

8 (MM/DD/YY)

UOP_MAX_UNITS

12

UNIT_OF_MEASURE

3

UOP_POSTING_DT

8 (MM/DD/YY)

UOP_UNITS

12

Defining Asset Physical Definitions

To define asset physical definitions, use the following components:

  • Agencies (AGENCY_DEFN)

  • Area Definition (AM_AREA_TBL)

  • Asset Type Options (AM_TYPE_OPT).

  • Asset Subtype (AM_SUBTYPE).

  • Asset Attribute (AM_UD_ATTR).

  • Asset Property Subclass (AM_PROP_SUBTYPE).

  • Hazardous Codes (ASSET_FSC_DEFN)

  • Asset Meter Types (AM_METER_TYPE)

  • Location Definition (AM_LOCATION)

To access these components, select select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Physical Definitions.

Agencies Page

Use the Agencies page (AGENCY_DEFN) to create agency codes.

Image: Agencies Page

This example illustrates the fields and controls on the Agencies Page. You can find definitions for the fields and controls later on this page.

Agencies page

Keep track of the registration and licenses of an asset by using the information that is set up in Agency tables. Only agency IDs that are set up here can be entered on the Asset License/Registration page.

Area Definition Page

Use the Area Definition page (AM_AREA_TBL) to define an asset area within a location.

Image: Area Definition Page

This example illustrates the fields and controls on the Area Definition Page. You can find definitions for the fields and controls later on this page.

Area Definition page

The Area Definition enables you to create a more granular level that further identifies the asset within a location. In PeopleSoft Asset Management, an asset can be physically located by region, location, and area.

Note: The system clears the area ID for an asset when you move that asset to a new location. You can then reassign new area IDs to the asset, as appropriate.

Asset Type Options Page

Use the Asset Type Options page (AM_TYPE_OPT) to define physical asset types to be applied to individual assets.

Oracle delivers ten asset types: Hardware, Software, Equipment, Property, Fleet, Machinery, Furniture, Facility, Intangible, Other.

You can assign the appropriate options that apply to each asset type for PeopleSoft Maintenance Management work orders and InterUnit Transfer Default values.

Image: Asset Type Options Page

This example illustrates the fields and controls on the Asset Type Options Page. You can find definitions for the fields and controls later on this page.

Asset Type Options page

Define Asset Subtype Page

Use the Define Asset Subtype page (AM_SUBTYPE) to define asset subtypes as they relate to asset types.

For example, if the asset type is Hardware, an asset subtype may be defined for a Laptop.

Image: Define Asset Subtype Page

This example illustrates the fields and controls on the Define Asset Subtype Page. You can find definitions for the fields and controls later on this page.

Define Asset Subtype page

Define Asset Attribute Page

Use the Define Asset Attribute page (AM_UD_ATTR) to define any asset physical attribute to be associated with an asset.

Image: Define Asset Attribute Page

This example illustrates the fields and controls on the Define Asset Attribute Page. You can find definitions for the fields and controls later on this page.

Define Asset Attribute page

Enter user-defined asset attributes to assign to assets. For example, you can create asset attributes to specify a quality, aspect, version, or other characteristic that can be applied to an asset. Asset attributes are optional.

Note: Asset attributes should not be confused with attribute groups. Asset attributes are used widely within PeopleSoft Asset Management to characterize assets regardless of the type of asset. Attribute groups are logical records that store the specific attributes that are of a particular interest for a certain type of asset. The attributes that are part of the attribute group are defined on the Fields Summary page within PeopleSoft Maintenance Management, Supplemental Data select (Set Up Financials/Supply Chain, then select Product Related, then select Maintenance Management, then select Supplemental Data, then select Define Record.)

Define Property Subclass Page

Use the Define Property Subclass page (AM_PROP_SUBCLASS) to define property asset subclasses as they relate to asset property classes: Site, Building, Floor, Area, Space.

Image: Define Property Subclass Page

This example illustrates the fields and controls on the Define Property Subclass Page. You can find definitions for the fields and controls later on this page.

Define Property Subclass page

Define property subclass codes to apply to property asset classes: Site, Building, Floor, Area, Space. For example, you can define the corporate sites and further enter property subclasses for the buildings located on the site.

Hazardous Codes Page

Use the Hazardous Codes page (ASSET_FSC_DEFN) to define hazardous-asset codes.

The PeopleSoft system is delivered with the Federal Supply Class (FSC) codes, which are U.S. federal codes that identify predominant and significant hazardous materials. You may add other classifications.

When you manage assets that can be classified as hazardous material, you must maintain the Hazardous Material codes table. U.S. Federal Supply Class codes are delivered with PeopleSoft Asset Management, and you can add codes to supplement the list. Hazardous assets can be reported using asset search functions, and storage locations can be managed with specific building, room, floor, and longitudinal and latitudinal information added to the location page that is associated with the asset.

Note: Hazardous material and waste is solid, liquid, or gaseous waste, or a combination of these wastes, that because of its quantity or concentration, or its physical, chemical, or infectious characteristics, may cause a significant increase in mortality or an increase in serious irreversible or incapacitating illness, or pose a substantial present or potential hazard to human health or the environment when improperly treated, stored, transported, disposed of, or otherwise managed (according to the United States Environmental Protection Agency).

Meter Type Definition Page

Use the Meter Type Definition page (AM_METER_TYPE1) to define meter types.

Image: Meter Type Definition page

This example illustrates the fields and controls on the Meter Type Definition page. You can find definitions for the fields and controls later on this page.

Meter Type Definition page

When you manage assets that use meters to track asset usage or that provide some other type of measurement associated with the asset, you need to define meter types.

Define meter types within setIDs.

Description

Meter Options

Setting Up Asset Warranties

This section provides an overview of warranties and discusses how to:

  • Set up standard warranties.

  • Set up warranty templates.

Understanding Warranties

For the system to automatically assign one or more warranties to each newly acquired asset, standard equipment warranties and equipment warranty defaults must be defined. Each asset that is added to the repository is available to have the appropriate warranties automatically attached to it. You can update a warranty for an asset at any time after the addition of the asset to the asset repository, including changing the terms of the warranty, renewing or voiding the warranty associated with the asset, or making other notable changes in coverages or terms.

A warranty is established as a standard warranty that is applied to a single asset. Or a generic warranty that can be applied to multiple assets can be defined as a warranty template. This is useful when the same terms of a general warranty apply to many assets, such as multiple computer workstations or truck tires for a fleet of trucks. It is also useful when you are applying multiple standard warranties to assets. For example, an asset may be delivered with a manufacturer's warranty and an additional extended warranty that is purchased separately and provides different coverages.

Standard Warranties Page

Use the Standard Warranties page (AM_STD_WRTY) to define standard warranties.

Image: Standard Warranties Page

This example illustrates the fields and controls on the Standard Warranties Page. You can find definitions for the fields and controls later on this page.

Standard Warranties page

Enter the standard warranty information for an asset type, category, class, or other asset definition. Use the standard warranty to associate it with specific asset IDs.

Warranty Templates Page

Use the Warranty Templates page (AM_WRTY_TMPL) to set up templates for warranty types to apply to asset types.

Image: Warranty Templates Page

This example illustrates the fields and controls on the Warranty Templates Page. You can find definitions for the fields and controls later on this page.

Warranty Templates page

Define warranty templates that can be applied to multiple assets at one time, such as assets defined by asset type, category, class or other asset definition.

Select all standard warranties that apply to the individual asset category, class, type, and so on.

Equipment Parts List Page

Use the Equipment Parts List page (AM_PART_LIST_TMPL) to define equipment parts lists to be associated with asset classes, groups, categories, types and subtypes, or other asset definitions.

Image: Equipment Parts List page

This example illustrates the fields and controls on the Equipment Parts List page. You can find definitions for the fields and controls later on this page.

Equipment Parts List page

Asset equipment parts lists (EPL) are maintained by setID. You can establish a parts list to correspond to asset classes, groups, categories, types, and subtypes, or to any asset definition. The EPL can then be associated with a specific asset ID.

Criticality Codes Page

Use the Criticality Codes page (AM_CRIT_LEVEL) to establish levels of criticality.

Image: Criticality Codes page

This example illustrates the fields and controls on the Criticality Codes page. You can find definitions for the fields and controls later on this page.

Criticality Codes page