PL_PI_REQ_VW (SQL View)	Index Back
PL Probinst Request View 10/18/02 EGS (CN#PL880-1): Added

PL_PI_REQ_VW

(SQL View)

PL Probinst Request View

10/18/02 EGS (CN#PL880-1): Added

SELECT PROBINST , BU_GROUP , PROBINST_STATUS , CURRENT_DTTM , START_DATE , END_DATE , BASE_CURRENCY , RT_TYPE FROM PS_PL_PROBINST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

2 BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL880-1.0): Added

3 PROBINST_STATUS Character(2) VARCHAR2(2) NOT NULL 05/13/02 EGS (CN#PL900-1): Added 10/30/02 NRA Added Status of 'Deleted'
10=Defined
20=Regenerated
30=Net Change
40=Loaded
50=Posted
60=Deleted

4 CURRENT_DTTM DateTime(26) TIMESTAMP 08/27/01 EGS (CN#PL900-1.0): Added

5 START_DATE Date(10) DATE Start Date for Gen Standing PO

6 END_DATE Date(10) DATE End Date

7 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

8 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	BU_GROUP	Character(6)	VARCHAR2(6) NOT NULL	08/16/01 EGS (CN#PL880-1.0): Added
3	PROBINST_STATUS	Character(2)	VARCHAR2(2) NOT NULL	05/13/02 EGS (CN#PL900-1): Added 10/30/02 NRA Added Status of 'Deleted' 10=Defined 20=Regenerated 30=Net Change 40=Loaded 50=Posted 60=Deleted
4	CURRENT_DTTM	DateTime(26)	TIMESTAMP	08/27/01 EGS (CN#PL900-1.0): Added
5	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
6	END_DATE	Date(10)	DATE	End Date
7	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
8	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.