PeopleSoft 9
Asset Management

Table Name PI_ASSET_HIST

Table Description
PI_ASSET_HIST
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
PI_ID char(10) Yes Yes
INVENTORY_DT PSDATE No No
PERFORMED_BY char(30) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_PI_ASSET_HIST PK Yes
Member(s) of "PS_PI_ASSET_HIST" Index
BUSINESS_UNIT
ASSET_ID
PI_ID

Published December 16, 2006