CS_PRCR_YRPD_VW (SQL View)	Index Back
Procurement History Item View Last Period Data.

CS_PRCR_YRPD_VW

(SQL View)

Procurement History Item View

Last Period Data.

SELECT DISTINCT A.REPORT_ENTITY , A.PRCR_YEAR ,A.PRCR_PERIOD FROM PS_PRCR_ITEM_HST A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID

2 PRCR_YEAR Number(4,0) SMALLINT NOT NULL Procurement Year

3 PRCR_PERIOD Number(3,0) SMALLINT NOT NULL Procurement Period

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
2	PRCR_YEAR	Number(4,0)	SMALLINT NOT NULL	Procurement Year
3	PRCR_PERIOD	Number(3,0)	SMALLINT NOT NULL	Procurement Period