PI_SCAN_VW

(SQL View)
Index Back

AM Mobile Physical Inventory

View of Physical Inventory Scanned Data. Add fields to this view when adding new fields to PI_SCAN.

%SelectAll(PI_SCAN)

# 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 PI_LINE_NUM Number(8,0) INTEGER NOT NULL PI Line Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 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
6 REVIEW_SW Character(1) VARCHAR2(1) NOT NULL Manual Review Required

Y/N Table Edit

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

11 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: AM_MODEL_VW

12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

13 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

14 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
15 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

16 CUSTODIAN_DEPTID Character(10) VARCHAR2(10) NOT NULL Asset Custodian Deptid

Prompt Table: DEPT_TBL

17 HAND_HELD_OPERATOR Character(30) VARCHAR2(30) NOT NULL Scanned By
18 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

Prompt Table: PI_MANUF_NKVW

19 IP_ADDRESS Character(39) VARCHAR2(39) NOT NULL Internet Protocol Address
20 IP_ALIAS Character(35) VARCHAR2(35) NOT NULL Internet Address Alias/UNC
21 IT_ASSET_ID Character(10) VARCHAR2(10) NOT NULL IT Discovery Tool Asset ID
22 SCAN_TYPE Character(3) VARCHAR2(3) NOT NULL Scan Type
LS=Location Scan
MAN=Manual
NEW=New
REG=Regular

Default Value: REG

23 LAST_SCAN_DTTM DateTime(26) TIMESTAMP Asset Management - Last datetime the asset was scanned (QR Codes).
24 PI_OVERWRITE_LOC Character(1) VARCHAR2(1) NOT NULL Force Asset Location Update
N=No
Y=Yes
25 SCAN_BY_OPTION Character(1) VARCHAR2(1) NOT NULL Scan By
S=Serial ID
T=Tag Number
26 COMMENTS Long Character CLOB Comment