PI_RESULTS_SRCH

(SQL View)
 Index Back

PI Results View

PI Results view for hardware

SELECT PI_ID , PI_LINE_NUM , ASSET_ID , MATCH_STATUS , REVIEW_SW , PI_ERROR_SW , PI_ERROR_DEPT_SW , MESSAGE_SET_NBR , MESSAGE_NBR , MESSAGE_NBR02 , HAND_HELD_OPERATOR FROM PS_PI_RESULTS

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

Y/N Table Edit

7 PI_ERROR_DEPT_SW Character(1) VARCHAR2(1) NOT NULL PI Department Transfer Error
N=No Error In Multi CF
Y=Error In Multi CF

Y/N Table Edit

8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
10 MESSAGE_NBR02 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
11 HAND_HELD_OPERATOR Character(30) VARCHAR2(30) NOT NULL Scanned By