PI_SCAN_DTAG_VW

(SQL View)
 Index Back

PI Scan Duplicate Tags


SELECT A.PI_ID , A.TAG_NUMBER , A.PI_LINE_NUM , A.BUSINESS_UNIT , A.ASSET_ID , A.MATCH_STATUS , A.LOCATION , A.AREA_ID , A.SCAN_TYPE , A.HAND_HELD_OPERATOR , P1.NAME , %DatePart(A.LAST_SCAN_DTTM) FROM PS_PI_SCAN A , %Table(PERSONAL_DATA) P1 , %Table(PSOPRDEFN) P2 WHERE A.HAND_HELD_OPERATOR = P2.OPRID AND P1.EMPLID = P2.EMPLID AND 1 <> ( SELECT COUNT(*) FROM PS_PI_SCAN B WHERE A.PI_ID = B.PI_ID AND A.TAG_NUMBER = B.TAG_NUMBER )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PI_ID Character(10) VARCHAR2(10) NOT NULL Physical Inventory ID

Prompt Table: PI_CNTL

2 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
3 PI_LINE_NUM Number(8,0) INTEGER NOT NULL PI Line Number
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 MATCH_STATUS Character(1) VARCHAR2(1) NOT NULL PI Match Status
0=None
1=Special Depr
2=Accelerated Depr
3=Initial Depr
A=All (I,O,U)
D=Discard
I=Inventory
O=Over
R=Retire
U=Under
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
9 SCAN_TYPE Character(3) VARCHAR2(3) NOT NULL Scan Type
LS=Location Scan
MAN=Manual
NEW=New
REG=Regular
10 HAND_HELD_OPERATOR Character(30) VARCHAR2(30) NOT NULL Scanned By
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 LAST_SCAN_DTTM DateTime(26) TIMESTAMP Asset Management - Last datetime the asset was scanned (QR Codes).