GM_CALC2_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
4	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
5	SUB_PROP_NBR	Character(15)	VARCHAR2(15) NOT NULL	SUB_PROP_NBR
6	BUDGET_ID	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_ID
7	BUDGET_PERIOD_GM	Number(3,0)	SMALLINT NOT NULL	BUDGET_PERIOD_GM
8	BUDGET_LN	Number(6,0)	INTEGER NOT NULL	BUDGET_LN
9	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
10	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member
11	TEAM_MEMBER_IND	Character(1)	VARCHAR2(1) NOT NULL	Team Member Indicator E=Employee G=Generic Resource N=Not Applicable
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	GM_TEAM_MEMBER	Character(25)	VARCHAR2(25) NOT NULL	Team Member
14	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
15	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
16	BEGIN_DT	Date(10)	DATE	Begin Date
17	END_DT	Date(10)	DATE	End Date
18	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: RS_PROJROLE_VW
19	QTY_INTEGER	Number(11,0)	DECIMAL(11) NOT NULL	Quantity Rounded to 0 Decimals
20	NBR_OF_HOURS	Number(5,0)	INTEGER NOT NULL	Number of Hours
21	QTY_X_HOURS	Number(11,0)	DECIMAL(11) NOT NULL	Quantity * Hours
22	NBR_OF_DAYS	Number(5,0)	INTEGER NOT NULL	Number of Days
23	WEEKLY_WEEKS	Number(3,0)	SMALLINT NOT NULL	Weeks
24	QTY_X_WEEKS	Number(11,0)	DECIMAL(11) NOT NULL	Quantity * Weeks
25	STD_BILL_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Standard Bill Rate Default Value: 0
26	ADJUSTED_FLAG_BILL	Character(1)	VARCHAR2(1) NOT NULL	Adjusted Flag H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments Default Value: N
27	ADJUST_OPTION_BILL	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Option Bill Rate A=Flat Amount N=No Adjustment P=Percentage R=New Rate Default Value: N
28	ADJUSTMENT_BILLAMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Bill Amount
29	ADJUSTMENT_BILLPCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Adjustment Bill Percent
30	ADJUSTMENT_BILL_RT	Number(27,3)	DECIMAL(26,3) NOT NULL	Adjustment Bill Rate
31	ACTUAL_BILL_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Bill Rate
32	STD_COST_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Standard Cost Rate Default Value: 0
33	ADJUSTED_FLAG_COST	Character(1)	VARCHAR2(1) NOT NULL	Adjusted Flag H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments Default Value: N
34	ADJUST_OPTION_COST	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Option Cost Rate A=Flat Amount N=No Adjustment P=Percentage R=New Rate Default Value: N
35	ADJUSTMENT_COSTAMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Cost Amount
36	ADJUSTMENT_COSTPCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Adjustment Cost Percent
37	ADJUSTMENT_COST_RT	Number(27,3)	DECIMAL(26,3) NOT NULL	Adjustment Cost Rate
38	ACTUAL_COST_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Cost Rate
39	BILL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
40	COST_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount
41	PM_MARGIN_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
42	RS_RESRC_TEMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Resource Template ID Prompt Table: RS_RESRC_TMP_VW
43	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PC_RATE_EMPL
44	REVIEW	Character(1)	VARCHAR2(1) NOT NULL	Review
45	RES_RATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Resource Rate E=Employee ID J=Job Code R=Role Type Default Value: R
46	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Prompt Table: RS_REGION_VW
47	POOL_ID	Character(10)	VARCHAR2(10) NOT NULL	Pool ID field. Prompt Table: RS_RES_POOL
48	NOTE	Long Character(256)	VARCHAR2(256)	Note
49	OVERRIDE_AMT_EX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Replacement Amount for Expense
50	OVERRIDE_AMT_TM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Replacement Amount for Time
51	SCEN_ADJUST_AMT_EX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Scenario Adjustment Amount for Expense
52	SCEN_ADJUST_AMT_TM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Scenario Adjustment Amount for Time
53	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 Default Value: N
54	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 Default Value: N
55	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
56	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
57	ESTIMATED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount Expense
58	PROPOSED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Proposed Amount Expense
59	DELETE_ME	Character(1)	VARCHAR2(1) NOT NULL	Delete Record
60	TEAM_MEMBER_CLASS	Character(1)	VARCHAR2(1) NOT NULL	05/26/2004 - FS Translate Value "O" added. A=Asset L=Labor M=Material O=Other
61	BUDGET_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_CATEGORY
62	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
63	SUBCONTRACT_TYPES	Character(1)	VARCHAR2(1) NOT NULL	Subcontract Type C=Cost Reimbursable F=FP Fee N=Not Available O=Other P=Fixed Price
64	ASSET_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Asset or Item ID
65	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit