PeopleSoft 9
Asset Management

Table Name ASSET_INSPCTION

Table Description
ASSET_INSPCTION
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
INSPECTION_ID char(10) Yes No
AGENCY_ID char(20) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
BUSINESS_UNIT_AM char(5) No No
LOCATION_SETID char(5) No No
LOCATION char(10) No No
ISSUE_DATE PSDATE No No
EXPIRE_DATE PSDATE No No
CURRENCY_CD char(3) No No
INSPECTOR char(30) No No
INSPECT_COST decimal(26,3) No No
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_ASSET_INSPCTION PK Yes
Member(s) of "PS_ASSET_INSPCTION" Index
BUSINESS_UNIT
ASSET_ID
INSPECTION_ID
AGENCY_ID
EFFDT

Published December 16, 2006