RUN_PSA_CALC_AE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
7	SCENARIO_ID	Character(4)	VARCHAR2(4) NOT NULL	A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
8	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
9	END_DATE	Date(10)	DATE	End Date
10	NBR_OF_HOURS	Number(5,0)	INTEGER NOT NULL	Number of Hours
11	WEEKLY_WEEKS	Number(3,0)	SMALLINT NOT NULL	Weeks
12	SCEN_ADJUST_OPT_TM	Character(1)	VARCHAR2(1) NOT NULL	Overall Scenario adjustment option for Time. A=Flat Amount N=No Adjustment P=Percentage R=Replacement Amount
13	SCEN_ADJUST_AMT_TM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Scenario Adjustment Amount for Time
14	SCEN_ADJUST_PCT_TM	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Scenario Adjustment % for Time 06/09/2004 PR_FS_B005 Added Label - LABOR_ADJUST
15	OVERRIDE_AMT_TM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Replacement Amount for Time
16	SCEN_ADJUST_OPT_EX	Character(1)	VARCHAR2(1) NOT NULL	Overall Scenario adjustment option for Expense. A=Flat Amount N=No Adjustment P=Percentage R=Replacement Amount
17	SCEN_ADJUST_AMT_EX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Scenario Adjustment Amount for Expense
18	SCEN_ADJUST_PCT_EX	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Scenario Adjustment % for Expense 06/09/2004 PR_FS_B005 Added Label NON_LABOR_ADJUST
19	OVERRIDE_AMT_EX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Replacement Amount for Expense