PI_SCAN_CNT_VW (SQL View)	Index Back
PI Scan Count View

PI_SCAN_CNT_VW

(SQL View)

PI Scan Count View

Select PI_ID, count(*) from PS_PI_SCAN group by pi_id

# 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 TOTAL_SCAN Number(8,0) INTEGER NOT NULL Total Assets Scanned

#	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	TOTAL_SCAN	Number(8,0)	INTEGER NOT NULL	Total Assets Scanned