PI_EXTRACT_CNT (SQL View)	Index Back
PI Extract Count View

PI_EXTRACT_CNT

(SQL View)

PI Extract Count View

Select PI_ID, count(*) from PS_PI_EXTRACT 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_EXTRACT Number(8,0) INTEGER NOT NULL Extract Total

#	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_EXTRACT	Number(8,0)	INTEGER NOT NULL	Extract Total