PeopleSoft 9
Asset Management

Table Name MAINT_TYPE_TBL

Table Description
MAINT_TYPE_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
MAINT_TYPE char(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
DESCR char(30) 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
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
CURRENCY_CD char(3) No No
SERVICE_PROCEDURES TEXT No No
Index
Name Type Unique Member
PS_MAINT_TYPE_TBL PK Yes
Member(s) of "PS_MAINT_TYPE_TBL" Index
SETID
MAINT_TYPE
EFFDT

Published December 16, 2006