PeopleSoft 9
Asset Management

Table Name ASSET

Table Description
ASSET
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes No
ASSET_TYPE char(3) No Yes
ASSET_SUBTYPE char(15) No Yes
PARENT_ID char(12) No Yes
COMPONENT_OF_ID char(12) No No
ASSET_ASSIGNED_TO char(12) No No
TAGGABLE_SW char(1) No No
TAG_NUMBER char(12) No No
DESCR char(30) No No
DESCRSHORT char(10) No No
ASSET_STATUS char(1) No No
FINANCIAL_ASSET_SW char(1) No No
REPLACE_SW char(1) No No
REPLACE_ASSET_ID char(12) No No
CONVERSION_ID char(15) No No
NEW_ASSET_SW char(1) No No
AVAIL_SW char(1) No No
AVAIL_CONTACT char(30) No No
AVAIL_PHONE char(12) No No
ACQUISITION_CD char(1) No No
ACQUISITION_DT PSDATE No No
FINANCING_CD char(5) No Yes
REPLACEMENT_COST decimal(26,3) No No
REPLACE_COST_DT PSDATE No No
LEASE_ASSET_ID char(12) No No
PROFILE_ID char(10) No Yes
ASSET_CLASS char(10) No Yes
CAP_NUM char(15) No Yes
CAP_SEQUENCE smallint No Yes
MFG_ID char(50) No No
MANUFACTURER char(30) No Yes
MODEL char(30) No No
PROD_VERSION char(10) No No
SERIAL_ID char(20) No No
PRODUCTION_DT PSDATE No No
PLANT char(30) No No
MANUFACTUR_CONTACT char(30) No No
BUSINESS_UNIT_JV char(5) No No
INDEX_NAME char(20) No Yes
INDEX_DETAIL_NAME char(35) No Yes
LAST_INDEX_VALUE decimal(26,3) No No
COMPOSITE_SW char(1) No No
COMPOSITE_ID char(12) No No
FERC_CD char(10) No Yes
GROUP_ASSET_FLAG char(1) No No
CURRENCY_CD char(3) No Yes
RD_PLANT_ASSET char(1) No No
RD_START_DT PSDATE No No
RD_USE_NBV char(1) No No
IP_ADDRESS char(15) No No
IP_ALIAS char(35) No No
COLLATERAL_ASSET char(2) No No
CLUSTERED_ASSET char(1) No No
LIFE smallint No No
LAST_REVIEW_DT PSDATE No No
AM_AST_UD_CHAR1 char(10) No No
AM_AST_UD_CHAR2 char(10) No No
AM_AST_UD_DATE1 PSDATE No No
AM_AST_UD_NUM1 decimal(18,3) No No
AM_AST_UD_NUM2 decimal(18,3) No No
LAST_CALC_RPL_COST decimal(26,3) No No
HAZARDOUS_SW char(1) No No
SS_STATUS char(1) No No
VIN char(18) No No
ASSET_RESOURCE_SW char(1) No No
ALLOW_OVERBOOK_SW char(1) No No
CHARGE_BACK_SW char(1) No No
SCHEDULABLE_SW char(1) No No
EPL_TMPL_ID char(15) No No
REPAIRABLE_FLG char(1) No No
REPAIR_STATUS char(1) No No
BUSINESS_UNIT_WO char(5) No No
SHOP_ID char(10) No No
UNOWNED_FLG char(1) No No
WO_LOCATION_FLG char(1) No No
OFFLINE_FLG char(1) No No
ASSET_CRITICALITY CHAR(2) No Yes
CREW_ID CHAR(10) No No
AVAIL_FOR_USE char(1) No No
IT_UD_CHAR1 char(50) No No
IT_UD_CHAR2 char(50) No No
IT_UD_DATE1 PSDATE No No
IN_SERVICE_DT PSDATE No No
REGION_CD char(10) No No
SKU char(50) No No
CRM_IPROD_ID char(20) No No
CRM_IPROD_SETID char(5) No No
CRM_IPROD_STATUS char(3) No No
CRM_DEPT_SETID char(5) No No
DESCR_LONG CHAR(254) No No
LINEAR_ASSET_SW CHAR(1) No No
NBR_OF_CPU SMALLINT No No
Index
Name Type Unique Member
PS_ASSET PK Yes
PS0ASSET IE1 No
PSAASSET IE2 No
PSBASSET IE3 No
PSCASSET IE4 No
PSDASSET IE5 No
Member(s) of "PS_ASSET" Index
BUSINESS_UNIT
ASSET_ID
Member(s) of "PS0ASSET" Index
TAG_NUMBER
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSAASSET" Index
ASSET_ID
Member(s) of "PSBASSET" Index
COMPONENT_OF_ID
Member(s) of "PSCASSET" Index
ASSET_TYPE
SERIAL_ID
ASSET_STATUS
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSDASSET" Index
PARENT_ID
BUSINESS_UNIT
ASSET_ID

Published December 16, 2006