PI_SCAN_HIST_VW

(SQL View)
 Index Back

Scan History


SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.LAST_SCAN_DTTM , A.TAG_NUMBER , A.SERIAL_ID , A.PI_ID , A.SCAN_TYPE , A.HAND_HELD_OPERATOR , A.OVERWRITE_LOCATION , A.PI_OVERWRITE_LOC , A.OLD_LOCATION , A.LOCATION , A.AREA_ID , A.COMMENTS , B.NAME , %DatePart(A.LAST_SCAN_DTTM) FROM PS_PI_SCAN_HIST A , PS_PERSONAL_DATA B , PSOPRDEFN C WHERE A.HAND_HELD_OPERATOR = C.OPRID AND B.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 LAST_SCAN_DTTM DateTime(26) TIMESTAMP Asset Management - Last datetime the asset was scanned (QR Codes).
4 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
6 PI_ID Character(10) VARCHAR2(10) NOT NULL Physical Inventory ID
7 SCAN_TYPE Character(3) VARCHAR2(3) NOT NULL Scan Type
LS=Location Scan
MAN=Manual
NEW=New
REG=Regular
8 HAND_HELD_OPERATOR Character(30) VARCHAR2(30) NOT NULL Scanned By
9 OVERWRITE_LOCATION Character(10) VARCHAR2(10) NOT NULL Scan Location
10 PI_OVERWRITE_LOC Character(1) VARCHAR2(1) NOT NULL Force Asset Location Update
N=No
Y=Yes
11 OLD_LOCATION Character(10) VARCHAR2(10) NOT NULL Old Location
12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
13 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
14 COMMENTS Long Character CLOB Comments
15 NAME Character(50) VARCHAR2(50) NOT NULL Name
16 AM_PI_DATE Date(10) DATE Asset Date