PeopleSoft 9
Asset Management

Table Name ASSET_MAINT

Table Description
ASSET_MAINT
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
MAINT_DTTM PSDATETIME Yes No
MAINT_TYPE char(10) Yes No
MAINT_STATUS char(1) No No
RESPONSIBILITY char(30) No No
VENDOR_ID char(10) No No
CONTRACT_NUM char(25) No No
EST_DOWN_HOURS DECIMAL(8,2) No No
DOWN_HOURS DECIMAL(8,2) No No
EST_LABOR_HOURS DECIMAL(8,2) No No
EST_LABOR_COST decimal(26,3) No No
EST_MATERIALS_COST decimal(26,3) No No
EST_OTHER_COST decimal(26,3) No No
LABOR_COST decimal(26,3) No No
LABOR_HOURS DECIMAL(8,2) No No
MATERIALS_COST decimal(26,3) No No
OTHER_COST decimal(26,3) No No
INSPECTION_SW char(1) No No
WARRANTY_SW char(1) No No
PROBLEM_ID char(15) No No
OFFSITE_SW char(1) No No
READY_DTTM PSDATETIME No No
PICKUP_DT PSDATE No No
PICKUP_CONTACT char(30) No No
PO_ID char(10) No No
REFERENCE char(30) No No
VOUCHER_ID char(8) No No
INVOICE_DT PSDATE No No
INVOICE_ID char(30) No No
CURRENCY_CD char(3) No No
BUSINESS_UNIT_WO char(5) No No
WO_ID char(10) No No
WO_TASK_ID int No No
REPAIR_CODE char(8) No No
LOCATION char(10) No No
AREA_ID CHAR(10) No No
CUSTODIAN char(30) No No
EMPLID char(11) No No
DEPTID char(10) No No
TOOLS_COST DECIMAL(26,3) No No
EST_TOOLS_COST DECIMAL(26,3) No No
PURCH_COST DECIMAL(26,3) No No
EST_PURCH_COST DECIMAL(26,3) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_ASSET_MAINT PK Yes
Member(s) of "PS_ASSET_MAINT" Index
BUSINESS_UNIT
ASSET_ID
MAINT_DTTM
MAINT_TYPE

Published December 16, 2006