PeopleSoft 9
Asset Management

Table Name PI_RESULTS

Table Description
PI_RESULTS
Columns
Name Datatype Is PK Is FK
PI_ID char(10) Yes Yes
PI_LINE_NUM int Yes No
ASSET_ID char(12) Yes No
MATCH_STATUS char(1) No No
REVIEW_SW char(1) No No
PI_ERROR_SW char(1) No No
MESSAGE_SET_NBR int No No
MESSAGE_NBR int No No
HAND_HELD_OPERATOR char(30) No No
Index
Name Type Unique Member
PS_PI_RESULTS PK Yes
PS0PI_RESULTS IE1 No
PS1PI_RESULTS IE2 No
PS2PI_RESULTS IE3 No
Member(s) of "PS_PI_RESULTS" Index
PI_ID
PI_LINE_NUM
ASSET_ID
Member(s) of "PS0PI_RESULTS" Index
MATCH_STATUS
PI_ID
PI_LINE_NUM
ASSET_ID
Member(s) of "PS1PI_RESULTS" Index
REVIEW_SW
PI_ID
PI_LINE_NUM
ASSET_ID
Member(s) of "PS2PI_RESULTS" Index
PI_ERROR_SW
PI_ID
PI_LINE_NUM
ASSET_ID

Published December 16, 2006