PeopleSoft 9
Asset Management

Table Name ASSET_CHECKOUT

Table Description
ASSET_CHECKOUT
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
CHECKOUT_ID char(12) Yes No
BUSINESS_UNIT_WO char(5) No No
WO_ID char(10) No No
WO_TASK_ID int No No
START_DT PSDATE No No
START_TM PSTIME No No
END_DT PSDATE No No
END_TM PSTIME No No
CUSTODIAN char(30) No No
CONTACT char(15) No No
SHOP_ID char(10) No No
LOCATION char(10) No No
DEPLOYED_BU char(5) No No
DEPLOYED_ASSET_ID char(12) No No
USAGE_AMOUNT decimal(12,4) No No
UNIT_OF_MEASURE char(3) No No
CHECKED_IN char(1) No No
Index
Name Type Unique Member
PS_ASSET_CHECKOUT PK Yes
PS0ASSET_CHECKOUT IE1 No
PS1ASSET_CHECKOUT IE2 No
PS2ASSET_CHECKOUT IE3 No
Member(s) of "PS_ASSET_CHECKOUT" Index
BUSINESS_UNIT
ASSET_ID
CHECKOUT_ID
Member(s) of "PS0ASSET_CHECKOUT" Index
BUSINESS_UNIT_WO
BUSINESS_UNIT
ASSET_ID
CHECKOUT_ID
Member(s) of "PS1ASSET_CHECKOUT" Index
WO_ID
BUSINESS_UNIT
ASSET_ID
CHECKOUT_ID
Member(s) of "PS2ASSET_CHECKOUT" Index
DEPLOYED_BU
BUSINESS_UNIT
ASSET_ID
CHECKOUT_ID

Published December 16, 2006