PeopleSoft 9
Asset Management

Table Name PI_SCAN

Table Description
PI_SCAN
Columns
Name Datatype Is PK Is FK
PI_ID char(10) Yes Yes
PI_LINE_NUM int Yes No
TAG_NUMBER char(12) No No
ASSET_ID char(12) No No
MATCH_STATUS char(1) No No
REVIEW_SW char(1) No No
DEPTID char(10) No No
SERIAL_ID char(20) No No
MODEL char(30) No No
LOCATION char(10) No No
CUSTODIAN char(30) No No
EMPLID char(11) No No
DESCR char(30) No No
HAND_HELD_OPERATOR char(30) No No
MANUFACTURER char(30) No No
IP_ADDRESS char(15) No No
IP_ALIAS char(35) No No
IT_ASSET_ID char(10) No No
BUSINESS_UNIT char(5) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_PI_SCAN PK Yes
PS0PI_SCAN IE1 No
PS1PI_SCAN IE2 No
PS2PI_SCAN IE3 No
PS3PI_SCAN IE4 No
Member(s) of "PS_PI_SCAN" Index
PI_ID
PI_LINE_NUM
Member(s) of "PS0PI_SCAN" Index
TAG_NUMBER
PI_ID
PI_LINE_NUM
Member(s) of "PS1PI_SCAN" Index
ASSET_ID
PI_ID
PI_LINE_NUM
Member(s) of "PS2PI_SCAN" Index
MATCH_STATUS
PI_ID
PI_LINE_NUM
Member(s) of "PS3PI_SCAN" Index
REVIEW_SW
PI_ID
PI_LINE_NUM

Published December 16, 2006