PROJ_RES_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
6	RESOURCE_ID_FROM	Character(40)	VARCHAR2(40) NOT NULL	Original Transaction ID
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
8	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
9	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
10	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
11	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
12	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
13	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
14	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
15	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
16	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
17	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
18	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
19	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
20	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
21	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
22	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
23	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
24	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
25	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
26	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
27	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
28	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
29	BUS_UNIT_GL_FROM	Character(5)	VARCHAR2(5) NOT NULL	From Business Unit GL
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
32	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
33	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
34	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
35	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
36	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
37	RES_USER1	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 1
38	RES_USER2	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 2
39	RES_USER3	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 3
40	RES_USER4	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 4
41	RES_USER5	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 5
42	TRANS_DT	Date(10)	DATE	Transaction Date
43	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
44	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
45	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
46	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
47	OPEN_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Open Item Status C=Closed Item N=Not an Open Item Account O=Open Item
48	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
49	JRNL_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the stage of processing of a journal entry. 0=OK - No Errors 1=Uncorrected Error(s)
50	JOURNAL_LINE_DATE	Date(10)	DATE	Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.
51	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
52	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.
53	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.
54	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
55	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
56	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
57	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
58	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
59	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
60	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type
61	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code
62	RESOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Resource Approved U=Unapproved Resource
63	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
64	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
65	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
66	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
67	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
68	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
69	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
70	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
71	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
72	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
73	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
74	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
75	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
76	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
77	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
78	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
79	PO_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PO Distribution Status 0=Non-PO 1=Active 2=In-process 3=Error 4=Processed 5=Modified
80	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
81	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
82	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
83	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
84	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
85	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
86	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
87	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
88	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
89	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
90	AM_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AM Distribution Status D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed
91	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
92	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
93	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
94	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
95	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
96	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
97	MSTONE_SEQ	Number(3,0)	SMALLINT NOT NULL	Milestone Sequence
98	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
99	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
100	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence
101	BI_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Distribution Status D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet
102	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
103	BILLING_DATE	Date(10)	DATE	Billing Date
104	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
105	REV_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Revenue Distribution Status C=Created D=Distributed G=Generated I=Ignore N=Not Distributed
106	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
107	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
108	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
109	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
110	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
111	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
112	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
113	SCHED_LINE_NO	Number(7,2)	DECIMAL(6,2) NOT NULL	Sched Line NO
114	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
115	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
116	PAY_END_DT	Date(10)	DATE	Pay Period End Date
117	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
118	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
119	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
120	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
121	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
122	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
123	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
124	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
125	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
126	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
127	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
128	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
129	BUDGET_OVER_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Budget Overrun Allowed
130	BUDGET_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	-> SL - 15-AUG-2002 MISC_CRITERIA label has been added <- B=Bypass E=Error N=Not Chk'd V=Valid W=Warning
131	BUDGET_DT	Date(10)	DATE	Budget Date
132	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
133	BD_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	BD Distribution Status D=Distributed I=Ignore N=None
134	BUSINESS_UNIT_BD	Character(5)	VARCHAR2(5) NOT NULL	Budgeting Business Unit
135	FA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	F&A Status
136	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
137	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
138	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
139	VCHR_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Number
140	PM_REVIEWED	Character(1)	VARCHAR2(1) NOT NULL	Reviewed A=All N=Not Reviewed Y=Reviewed Default Value: N
141	PRICED_RATE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Rate used by Pricing engine to calculate amount on transactions for billing. Rate is quantity related.
142	ACTIVITY_ID_DETAIL	Character(15)	VARCHAR2(15) NOT NULL	This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.
143	CST_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cost Distribution Status C=Created D=Distributed G=Generated I=Ignore N=Not Distributed
144	TXN_LMT_TRANS_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction Limit Identifer
145	EVENT_NUM	Number(3,0)	SMALLINT NOT NULL	Event Number
146	CA_FEE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cost Plus Fee Status for Governement Contracts 1=Fee Generated 2=Bil Actual Fee 3=Bil Additional Award Fee 4=Rev Actual Fee 5=Rev Additional Award Fee
147	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Prompt Table: SP_BU_WM_NONVW
148	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: %EDIT_WO_ID
149	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number Prompt Table: %EDIT_WO_TASK
150	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material
151	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No. Prompt Table: %EDIT_RES_LINE
152	COMPRESS_ID	Number(10,0)	DECIMAL(10) NOT NULL	A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)
153	AMOUNT_IN_EXCESS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether the amount is in excess.
154	RECLAIMED_FROM_OL	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether the amount was reclaimed from over the limit.
155	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
156	FND_DIST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Funds Distribution Status 1=No Matching Sequence 2=Insufficient Threshold Amount 3=Insufficient Distribute Amount A=Active B=Funds Burden C=Complete D=Distributed G=Generated H=Related BAJ Row I=Ignore N=Not Disitrbuted
157	SEQ_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Transaction ID
158	DIST_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Distribution Transaction ID
159	ADJ_LINE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Adjustment Line Type ACR=Adjustment Credit Line ADJ=Adjustment ARB=Adjustment Rebill Line REG=Regular bill line (not adjust)
160	FEEDER_SUM_ID	Number(16,0)	DECIMAL(16) NOT NULL	Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions.
161	PRICE_SUM_ID	Number(16,0)	DECIMAL(16) NOT NULL	Price Summarization ID relates the summed Project Transactions row in PC_PRICE_SUM to its corresponding detail transactions in PROJ_RESOURCE.
162	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
163	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
164	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.