PGM_PRJREQ_ANAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
6	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
7	SUMMARY_PRJ	Character(1)	VARCHAR2(1) NOT NULL	An indicator to determine whether project is summary or detail. N=Detail Project Y=Program
8	PARENT_PROGRAM_ID	Character(15)	VARCHAR2(15) NOT NULL	Parent Program ID
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	PC_PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The processing state of a project. A=Active I=Inactive P=Pending T=Template
11	BUDGET_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Projects Budget Amount
12	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
13	PC_COST_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total cost for a project.
14	START_DT	Date(10)	DATE	Start Date
15	END_DT	Date(10)	DATE	End Date
16	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
17	FOREIGN_AMOUNT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Foreign Amount 2
18	FOREIGN_CURRENCY_2	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency