PeopleSoft 9
Asset Management

Table Name AM_AST_COMP_HIS

Table Description
AM_AST_COMP_HIS
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
DTTM_STAMP PSDATETIME Yes No
BUSINESS_UNIT_1 char(5) No No
COMPONENT_OF_ID char(12) No No
BEGIN_DT PSDATE No No
END_DT PSDATE No No
DTTM_STAMP_PREV PSDATETIME No No
AM_HGRID_ACTION CHAR(1) No No
AMI_REASON CHAR(3) No No
AM_COMP_SOURCE CHAR(1) No No
OPRID CHAR(30) No No
COMPONENT_PREV CHAR(12) No No
COMP_MOVE_COMMENT CHAR(254) No No
Index
Name Type Unique Member
PS_AM_AST_COMP_HIS PK Yes
PS0AM_AST_COMP_HIS IE1 No
Member(s) of "PS_AM_AST_COMP_HIS" Index
BUSINESS_UNIT
ASSET_ID
DTTM_STAMP
Member(s) of "PS0AM_AST_COMP_HIS" Index
COMPONENT_OF_ID
BUSINESS_UNIT
ASSET_ID
DTTM_STAMP

Published December 16, 2006