UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 3/29/2005.

UOD_PROJ_RES_VW

Project Resources: Individual expense transactions associated with each project. "Analysis Type" is an essential field when querying this view and interpretting the various costs that are returned.
ACTIVITY_ID Activity ID Example: 1
KEY Type: character Format: Upper Length: 15 Decimals: 0
Activity is the unit of work in PS Projects that Provides a further breakdown of projects, usually into specific tasks. Resources are assigned directly to Activities within a Project.
 
BUSINESS_UNIT Business Unit Example: UOD01
KEY Type: character Format: Upper Length: 5 Decimals: 0
Business Unit
 
CHARTFIELD1 Purpose Example: BUAD312111
KEY Type: character Format: Upper Length: 10 Decimals: 0
Expansion chartfield 1
 
PROJECT_ID Project Example: BUAD31211105000
KEY Type: character Format: Upper Length: 15 Decimals: 0
Chartfield which identifies contract and grant activities and facilities projects (eg. ARTC37211199000). Adds designators to a "Purpose" (eg. ARTC372111) indicating fiscal year, building, or other coded details.
 
RESOURCE_ID Resource ID Example: 10413356
KEY Type: character Format: Upper Length: 40 Decimals: 0
Resource ID
 
ACCOUNT Account Example: 195000
Type: character Format: Upper Length: 10 Decimals: 0
Identifies the nature of a transaction.
 
ACCOUNTING_DT Accounting Date Example: 11/30/2004
Type: date Format: Upper Length: 10 Decimals: 0
The accounting entry construction date for a given transaction (a generic field that crosses multiple
 
ACCOUNTING_PERIOD Accounting Period Example: 5
Type: number Format: Upper Length: 3 Decimals: 0
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 define
 
AFFILIATE Affiliate Example:
Type: character Format: Upper Length: 5 Decimals: 0
Chartfield used to map transactions between business units when using a single interunit account.
 
AFFILIATE_INTRA1 Fund Affiliate Example:
Type: character Format: Upper Length: 10 Decimals: 0
IntraUnit Affiliate1
ALTACCT Alternate Account Example:
Type: character Format: Upper Length: 10 Decimals: 0
Alternate Account
 
AM_DISTRIB_STATUS AM Distribution Status Example: N
Type: character Format: Upper Length: 1 Decimals: 0
AM Distribution Status
 
ANALYSIS_TYPE Resource Analysis Type Example: SFA
Type: character Format: Upper Length: 3 Decimals: 0
A three-character identifier that enables you to label the different types of costs in Projects. For example, you may want to track budgeted costs(BUD), Committed costs (COM), and actual costs (ACT)
 
APPL_JRNL_ID Journal Template Example: ACCRUAL
Type: character Format: Upper Length: 10 Decimals: 0
Journal Template
 
ASSET_ID Asset Identification Example:
Type: character Format: Upper Length: 12 Decimals: 0
Asset Identification
 
BD_DISTRIB_STATUS BD Distribution Status Example: I
Type: character Format: Upper Length: 1 Decimals: 0
BD Distribution Status
 
BI_DISTRIB_STATUS Billing Distribution Status Example: P
Type: character Format: Upper Length: 1 Decimals: 0
Billing Distribution Status
BILLING_DATE Billing Date Example:
Type: date Format: Upper Length: 10 Decimals: 0
Billing Date
 
BOOK Asset Book Name Example:
Type: character Format: Upper Length: 10 Decimals: 0
Asset Book Name
 
BUDGET_DT Budget Date Example: 11/30/2004
Type: date Format: Upper Length: 10 Decimals: 0
Budget Date
 
BUDGET_HDR_STATUS Budget Checking Header Status Example: V
Type: character Format: Upper Length: 1 Decimals: 0
Budget Checking Header Status
 
BUDGET_LINE_STATUS Budget Checking Line Status Example: V
Type: character Format: Upper Length: 1 Decimals: 0
Budget Checking Line Status
 
BUDGET_OVER_ALLOW Budget Overrun Allowed Example:
Type: character Format: Upper Length: 1 Decimals: 0
Budget Overrun Allowed
 
BUDGET_REF Budget Reference Example: 2003
Type: character Format: Upper Length: 8 Decimals: 0
Budget Reference
 
BUS_UNIT_GL_FROM From Business Unit GL Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
From Business Unit GL
 
BUSINESS_UNIT_AM Asset Management Business Unit Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Business Unit (Always = UOD01)
 
BUSINESS_UNIT_AP AP Business Unit Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
AP Business Unit
 
BUSINESS_UNIT_AR AR Business Unit Example:
Type: character Format: Upper Length: 5 Decimals: 0
AR Business Unit
 
BUSINESS_UNIT_BD Budgeting Business Unit Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Budgeting Business Unit
 
BUSINESS_UNIT_BI Billing Business Unit Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
Business Unit (Always = UOD01)
 
BUSINESS_UNIT_GL General Ledger Unit Example: UOD01
Type: character Format: Upper Length: 5 Decimals: 0
General Ledger Unit
 
BUSINESS_UNIT_IN Inventory Unit Example:
Type: character Format: Upper Length: 5 Decimals: 0
Inventory Unit
 
BUSINESS_UNIT_OM Order Management Business Unit Example:
Type: character Format: Upper Length: 5 Decimals: 0
Order Management Business Unit
 
BUSINESS_UNIT_PO PO Business Unit Example:
Type: character Format: Upper Length: 5 Decimals: 0
PO Business Unit
 
CHARTFIELD2 Source Example: 3300000000
Type: character Format: Upper Length: 10 Decimals: 0
Expansion Chartfield 2
 
CHARTFIELD3 UD Chartfield Example: 0000000501
Type: character Format: Upper Length: 10 Decimals: 0
Expansion Chartfield 3
 
CLASS_FLD Class Field Example: 301
Type: character Format: Upper Length: 5 Decimals: 0
Class Field
 
COMPANY Company Example:
Type: character Format: Upper Length: 3 Decimals: 0
Company
 
CONTRACT_LINE_NUM Contract Line Num Example: 1
Type: number Format: Upper Length: 3 Decimals: 0
Specific line number of contract
 
CONTRACT_NUM Contract Example: SES-0422772
Type: character Format: Upper Length: 25 Decimals: 0
Unique identifier of a single contract. Same as "reference award number". Assigned at the point that the contract is awarded.
 
CONTRACT_PPD_SEQ Prepaid Add Sequence Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Prepaid Add Sequence
 
COST_TYPE Cost Type Example:
Type: character Format: Upper Length: 1 Decimals: 0
Cost Type
 
CUR_EFFDT Currency Effective Date Example: 11/30/2004
Type: date Format: Upper Length: 10 Decimals: 0
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
 
CURRENCY_CD Currency Code Example: USD
Type: character Format: Upper Length: 3 Decimals: 0
Currency Code
 
CUST_ID Customer ID Example: 0400
Type: character Format: Upper Length: 15 Decimals: 0
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 bil
DEMAND_LINE_NO Demand Line No Example: 0
Type: number Format: Upper Length: 4 Decimals: 0
Demand Line No
 
DEPTID Department Example: 02710
Type: character Format: Upper Length: 10 Decimals: 0
Indicates who is responsible for or affected by the transaction.
 
DESCR Description Example: SEMI MONTHLY BENEFITS CHARGE
Type: character Format: Mixed Length: 30 Decimals: 0
Description
 
DISTRIB_LINE_NUM Distribution Line Number Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Distribution Line Number
 
DST_ACCT_TYPE Accounting Entry Type Example: DST
Type: character Format: Upper Length: 4 Decimals: 0
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
 
DST_SEQ_NUM Distribution Sequence Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Distribution Sequence
 
DTTM_STAMP Date/Time Stamp Example: 12/08/2004 10:36:48PM
Type: date-time Format: Seconds Length: 26 Decimals: 0
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.
 
DUE_DATE Delivery Due Date from PO Example:
Type: date Format: Upper Length: 10 Decimals: 0
Delivery Due Date from PO
 
EMPL_RCD Empl Rcd Nbr Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Empl Rcd Nbr
 
EMPLID EmplID Example:
Type: character Format: Upper Length: 11 Decimals: 0
Employee ID
 
EX_DOC_ID Expenses Document ID Example:
Type: character Format: Upper Length: 10 Decimals: 0
Documentation ID
 
EX_DOC_TYPE Expenses Document Type Example:
Type: character Format: Upper Length: 1 Decimals: 0
Identifies Expenses Document Type
 
FA_STATUS F&A Status Example: D
Type: character Format: Upper Length: 1 Decimals: 0
F&A Status
 
FISCAL_YEAR Fiscal Year Example: 2005
Type: number Format: Upper Length: 4 Decimals: 0
Fiscal Year
FOREIGN_AMOUNT Foreign Amount Example: 20.4
Type: signed number Format: Upper Length: 28 Decimals: 3
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.
 
FOREIGN_CURRENCY Foreign Currency Code Example: USD
Type: character Format: Upper Length: 3 Decimals: 0
Foreign Currency Code
 
FUND_CODE Fund Code Example: OPBAL
Type: character Format: Upper Length: 5 Decimals: 0
Fund Code
 
GL_DISTRIB_STATUS Distribution Status Example: D
Type: character Format: Upper Length: 1 Decimals: 0
Distribution Status
 
INCENTIVE_ID Investment Incentive ID Example:
Type: character Format: Upper Length: 10 Decimals: 0
Investment Incentive ID
 
INV_ITEM_ID Item ID Example:
Type: character Format: Upper Length: 18 Decimals: 0
Item ID
 
INVOICE Invoice Example:
Type: character Format: Upper Length: 22 Decimals: 0
Invoice
ITEM Item ID Example:
Type: character Format: Upper Length: 30 Decimals: 0
Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
 
ITEM_LINE Item Line Example: 0
Type: number Format: Upper Length: 6 Decimals: 0
Item Line
 
ITEM_SEQ_NUM Item Sequence Number Example: 0
Type: number Format: Upper Length: 2 Decimals: 0
Item Sequence Number
 
JOBCODE Job Code Example:
Type: character Format: Upper Length: 6 Decimals: 0
Job Code
 
JOURNAL_DATE Journal Date Example: 11/30/2004
Type: date Format: Upper Length: 10 Decimals: 0
Specifies the date the journal was created.
 
JOURNAL_ID Journal ID Example: BENF000029
Type: character Format: Upper Length: 10 Decimals: 0
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.
 
JOURNAL_LINE GL Journal Line Number Example: 25
Type: number Format: Upper Length: 9 Decimals: 0
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
JOURNAL_LINE_DATE Journal Line Date Example: 11/30/2004
Type: date Format: Upper Length: 10 Decimals: 0
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.
 
JRNL_LINE_STATUS Journal Line Status Example: 0
Type: character Format: Length: 1 Decimals: 0
A flag that indicates the stage of processing of a journal entry.
 
JRNL_LN_REF Journal Line Reference Example: 57320
Type: character Format: Upper Length: 10 Decimals: 0
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
 
KK_AMOUNT_TYPE Commitment Control Amount Type Example:
Type: character Format: Upper Length: 1 Decimals: 0
Commitment Control Amount Type
 
KK_TRAN_OVER_DTTM Override Date Example: 08/12/2004 7:01:28PM
Type: date-time Format: Seconds Length: 26 Decimals: 0
Commitment Control source transaction override datetime
 
KK_TRAN_OVER_FLAG Override Transaction Example:
Type: character Format: Upper Length: 1 Decimals: 0
Commitment Control source transaction override flag
 
KK_TRAN_OVER_OPRID Override User ID Example: cecook
Type: character Format: Mixed Length: 30 Decimals: 0
Commitment Control source transaction override operator
 
LEDGER Ledger Example: CANG_BUD
Type: character Format: Upper Length: 10 Decimals: 0
Ledger
 
LEDGER_GROUP Ledger Group Example: ACTUALS
Type: character Format: Upper Length: 10 Decimals: 0
Ledger Group
 
LINE_DESCR Journal Line Description Example: SEMI MONTHLY BENEFITS CHARGE
Type: character Format: Mixed Length: 30 Decimals: 0
Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
 
LINE_NBR Line Number Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Line Number
 
MSTONE_SEQ Milestone Sequence Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Milestone Sequence
 
OPEN_ITEM_STATUS Open Item Status Example:
Type: character Format: Upper Length: 1 Decimals: 0
Open Item Status
 
OPERATING_UNIT Operating Unit Example:
Type: character Format: Upper Length: 8 Decimals: 0
Operating Unit
 
OPRID User ID Example: GA_SCHED
Type: character Format: Mixed Length: 30 Decimals: 0
A user's ID
 
ORDER_INT_LINE_NO Order Line Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Order Line
 
ORDER_NO Order No Example:
Type: character Format: Upper Length: 10 Decimals: 0
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
 
PAY_END_DT Pay Period End Date Example:
Type: date Format: Upper Length: 10 Decimals: 0
Pay Period End Date
 
PC_DISTRIB_STATUS PC Distribution Status Example: D
Type: character Format: Upper Length: 1 Decimals: 0
PC Distribution Status
 
PO_DISTRIB_STATUS PO Distribution Status Example: 0
Type: character Format: Upper Length: 1 Decimals: 0
PO Distribution Status
 
PO_ID Purchase Order Example:
Type: character Format: Upper Length: 10 Decimals: 0
Purchase Order
 
PROCESS_INSTANCE Process Instance Example: 139276
Type: number Format: Upper Length: 10 Decimals: 0
Process Instance
 
PRODUCT Product Example:
Type: character Format: Upper Length: 6 Decimals: 0
Product - Captures additional information useful for profitability and cash flow analysis by product sold.
 
PROFILE_ID Asset Profile ID Example:
Type: character Format: Upper Length: 10 Decimals: 0
Asset Profile ID
 
PROGRAM_CODE Program Code Example: RSCH1
Type: character Format: Upper Length: 5 Decimals: 0
Program Code
 
PROJ_TRANS_CODE Project Transaction Code Example:
Type: character Format: Upper Length: 5 Decimals: 0
Project Transaction Code
 
PROJ_TRANS_TYPE Project Transaction Type Example: VCH
Type: character Format: Upper Length: 3 Decimals: 0
Project Transaction Type
 
PYMNT_CNT Payments Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Payments
RATE_DIV Rate Divisor Example: 1
Type: number Format: Upper Length: 16 Decimals: 8
Rate Divisor
 
RATE_MULT Rate Multiplier Example: 1
Type: signed number Format: Upper Length: 17 Decimals: 8
Rate Multiplier
 
REQ_DISTRIB_NBR Requisition Distrib Number Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Requisition Distrib Number
 
REQ_ID Requisition ID Example:
Type: character Format: Upper Length: 10 Decimals: 0
Requisition ID
 
REQ_LINE_NBR Requisition Line Number Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Requisition Line Number
 
REQ_SCHED_NBR Requisition Schedule Number Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Requisition Schedule Number
 
RES_USER1 Resource User 1 Example:
Type: character Format: Upper Length: 10 Decimals: 0
Resource User 1
 
RES_USER2 Resource User 2 Example:
Type: character Format: Upper Length: 10 Decimals: 0
Resource User 2
 
RES_USER3 Resource User 3 Example:
Type: character Format: Upper Length: 10 Decimals: 0
Resource User 3
 
RES_USER4 Resource User 4 Example:
Type: character Format: Upper Length: 10 Decimals: 0
Resource User 4
 
RES_USER5 Resource User 5 Example:
Type: character Format: Upper Length: 10 Decimals: 0
Resource User 5
 
RESOURCE_AMOUNT Resource Amount Example: 20.4
Type: signed number Format: Upper Length: 28 Decimals: 3
Resource Amount
 
RESOURCE_CATEGORY Resource Category Example:
Type: character Format: Upper Length: 5 Decimals: 0
Resource Category
 
RESOURCE_ID_FROM Original Resource ID Example: GUOD01BENF0000292004-11-30025
Type: character Format: Upper Length: 40 Decimals: 0
Original Resource ID
 
RESOURCE_QUANTITY Resource Quantity Example: 0
Type: signed number Format: Upper Length: 16 Decimals: 2
Resource Quantity
 
RESOURCE_STATUS Resource Status Example:
Type: character Format: Upper Length: 1 Decimals: 0
Resource Status
 
RESOURCE_SUB_CAT Resource SubCategory Example:
Type: character Format: Upper Length: 5 Decimals: 0
Resource SubCategory
 
RESOURCE_TYPE Resource Type Example:
Type: character Format: Upper Length: 5 Decimals: 0
Resource Type
 
REV_DISTRIB_STATUS Revenue Distribution Status Example: I
Type: character Format: Upper Length: 1 Decimals: 0
Revenue Distribution Status
 
RT_TYPE Rate Type Example: CRRNT
Type: character Format: Upper Length: 5 Decimals: 0
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
 
SCHED_LINE_NO Sched Line No Example: 0
Type: number Format: Upper Length: 7 Decimals: 2
Sched Line No
SCHED_NBR Schedule Number Example: 0
Type: number Format: Upper Length: 3 Decimals: 0
Schedule Number
 
SEQ_NBR Sequence Number Example: 0
Type: number Format: Upper Length: 15 Decimals: 0
Sequence Number
 
STATISTICS_CODE Statistics Code Example:
Type: character Format: Upper Length: 3 Decimals: 0
Statistics Code
 
SYSTEM_SOURCE System Source Example: BGM
Type: character Format: Upper Length: 3 Decimals: 0
Identifies the application or source system that generated a journal entry.
 
TIME_RPTG_CD Time Reporting Code Example:
Type: character Format: Upper Length: 5 Decimals: 0
Time Reporting Code
 
TRANS_DT Transaction Date Example: 12/8/2004
Type: date Format: Upper Length: 10 Decimals: 0
Transaction Date
 
UNIT_OF_MEASURE Unit of Measure Example: EA
Type: character Format: Upper Length: 3 Decimals: 0
Used on an approval rule set.
UNPOST_SEQ UnPost Sequence Example: 0
Type: number Format: Upper Length: 2 Decimals: 0
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".
 
VENDOR_ID Vendor ID Example: E43596
Type: character Format: Upper Length: 10 Decimals: 0
Vendor Identifier
 
VOUCHER_ID Voucher ID Example: B0404386
Type: character Format: Upper Length: 8 Decimals: 0
Voucher ID
 
VOUCHER_LINE_NUM Voucher Line Number Example: 0
Type: number Format: Upper Length: 5 Decimals: 0
Voucher Line Number