OPR_DEF_TEO2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	POSTING_MODE	Character(1)	VARCHAR2(1) NOT NULL	Posting Mode C=Now on Client L=Process Later S=Now on Server
4	SERVER_NAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
7	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
8	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
9	PARENT_NODE	Character(20)	VARCHAR2(20) NOT NULL	Parent Tree Node
10	ANALYSIS_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Analysis Group
11	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
12	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
13	OPEN_TRANS_ID	Number(10,0)	DECIMAL(10) NOT NULL	Open Transaction ID
14	OP_TRNS_ID_INCR_SW	Character(1)	VARCHAR2(1) NOT NULL	Increment Depr Request ID Flag N=Do Not Increment Depr Req ID Y=Increment Depr Request ID
15	RATE_OPTION	Character(3)	VARCHAR2(3) NOT NULL	Rate Option ABI=Activity Bill Rate ACO=Activity Cost Rate AML=Mark Up/Down Labor AMN=Mark Up/Down Non-labor AMT=Quantity Rate CRB=Custom Bill Rate CRC=Custom Cost Rate EBI=Employee Bill Rate ECO=Employee Cost Rate FIX=Fixed Amount JBI=Job Code Bill Rate JCO=Job Code Cost Rate MUP=Markup Rate NON=Bill at Cost RBI=Project Role Bill Rate RCO=Project Role Cost Rate TBI=MM Tools Usage Bill Rate TCO=MM Tools Usage Cost Rate WBI=Work Order Labor Bill Rate WCO=Work Order Labor Cost Rate
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	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.
18	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
19	TRANS_DT	Date(10)	DATE	Transaction Date
20	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
21	FROM_DATE	Date(10)	DATE	From Date
22	THRU_DATE	Date(10)	DATE	Through Date
23	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
24	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
25	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
26	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
27	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
28	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit
29	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
30	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
31	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
32	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
33	INTEGRATION_TMPL	Character(15)	VARCHAR2(15) NOT NULL	Integration
34	DOCUMENT_DRIVE	Character(5)	VARCHAR2(5) NOT NULL	Document Drive
35	DOCUMENT_PATH	Character(80)	VARCHAR2(80) NOT NULL	Application Path
36	DOCUMENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Document Path and Name
37	MILESTONE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Milestone Type
38	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member
39	FLEX_SETID	Character(5)	VARCHAR2(5) NOT NULL	Flexible Formula Setid
40	FLEX_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Flexible Analysis Template
41	PC_EDIT_PRJ_OPT	Character(4)	VARCHAR2(4) NOT NULL	Edit Project List Option BYBU=By Business Unit BYTR=By Project Tree
42	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
43	FLEX_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID