PROJ_RES_ORD

(SQL Table)
Index Back

Project Resources

Project Resources

  • Parent record: PROJ_ACTIVITY
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJ_ACTIVITY.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Default Value: PROJ_ACTIVITY.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Default Value: PROJ_ACTIVITY.ACTIVITY_ID

    Prompt Table: PROJ_ACT_SRCH

    4 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
    5 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID
    6 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Prompt Table: PROJ_AN_GRP_VW

    7 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

    Prompt Table: PROJ_RES_TYPE

    8 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: %EDITTABLE

    9 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

    Prompt Table: %EDITTABLE2

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PROJ_TEAM_VW

    12 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #
    13 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    14 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    15 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    17 PAY_END_DT Date(10) DATE Pay Period End Date
    18 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.
    19 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

    Default Value: %date

    20 TRANS_DT Date(10) DATE Transaction Date

    Default Value: %date

    21 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    22 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.
    23 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Default Value: PC_INT_TMPLGLVW.BUSINESS_UNIT_GL

    Prompt Table: PC_INT_TMPL_GL
    Set Control Field: BUSINESS_UNIT_GL

    24 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL

    Default Value: PC_INT_TMPLGLVW.BUSINESS_UNIT_GL

    Prompt Table: PC_INT_TMPL_GL

    25 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCT_BUGL_VW

    26 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Prompt Table: %EDIT_ALTACCT

    27 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW

    28 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPERUNT_BUGL_VW

    29 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODUCT_BUGL_VW

    30 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_BUGL_VW

    31 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASSCF_BUGL_VW

    32 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRAM_BUGL_VW

    33 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUD_REF_BUGL_VW

    34 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    35 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    36 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA02

    37 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CF1_BUGL_VW

    38 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CF2_BUGL_VW

    39 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CF3_BUGL_VW

    40 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_BUGL_VW

    41 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

    Prompt Table: BU_LGRP_DEF_VW

    42 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.

    Prompt Table: PC_GL_JRNL_VW

    43 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

    Default Value: %date

    44 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".
    45 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.
    46 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    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_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.
    50 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)
    51 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.
    52 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

    Default Value: I

    53 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
    A=Resource Approved
    U=Unapproved Resource

    Default Value: A

    54 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

    Prompt Table: SP_BU_AP_NONVW

    55 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: PROJ_VENDOR_VW

    56 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: PC_AP_VCHR_VW

    57 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
    58 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

    Prompt Table: JRNLGEN_APPL_ID

    59 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
    60 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
    61 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_PO

    Prompt Table: SP_BU_PM_NONVW

    62 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
    63 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
    64 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
    65 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
    66 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: PC_PO_HDR_VW

    67 DUE_DATE Date(10) DATE Delivery Due Date from PO
    68 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    69 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    70 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    71 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

    Default Value: 0

    72 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM

    Prompt Table: SP_BU_AM_NONVW

    73 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: PROJ_ASSET_VW

    74 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_PCAM_VW

    75 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
    76 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
    77 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
    78 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

    Prompt Table: PC_PROJ_GNT_VW

    79 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence
    80 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    81 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    82 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

    Prompt Table: SP_BU_BI_NONVW

    83 BILLING_DATE Date(10) DATE Billing Date
    84 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    85 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

    Default Value: I

    86 REV_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Revenue Distribution Status
    C=Created
    D=Distributed
    G=Generated
    I=Ignore
    N=Not Distributed
    87 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

    Prompt Table: SP_BUARED_NONVW

    88 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.

    Prompt Table: PROJ_CUST_VW

    89 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.

    Prompt Table: ITEM_OPEN_PC_VW

    90 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    91 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
    92 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
    93 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: SP_BUIN_NONVW

    94 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
    95 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
    96 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PROJ_ITEM_VW

    97 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

    Prompt Table: SP_BUPCOM_NONVW

    98 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
    99 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    100 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
    101 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
    102 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

    Default Value: V

    103 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
    104 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
    N=No
    Y=Yes
    105 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
    106 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
    107 BUDGET_OVER_ALLOW Character(1) VARCHAR2(1) NOT NULL Budget Overrun Allowed
    108 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
    109 BUDGET_DT Date(10) DATE Budget Date
    110 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit

    Prompt Table: SP_BU_BD_NONVW

    111 BD_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL BD Distribution Status
    D=Distributed
    I=Ignore
    N=None

    Default Value: N

    112 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
    113 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
    114 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
    115 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
    116 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
    117 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    118 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

    Prompt Table: PROJ_TRANS_TYPE

    119 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

    Prompt Table: PROJ_TRANS_CODE

    120 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    121 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.
    122 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

    Default Value: N

    123 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    124 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
    125 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

    Default Value: OPR_DEF_TBL_PC.CURRENCY_CD

    Prompt Table: FRGN_CURR_VW

    126 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.
    127 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    128 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.

    Default Value: %DATE

    129 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.

    Default Value: OPR_DEF_TBL_PC.RT_TYPE

    Prompt Table: RT_TYPE_TBL

    130 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    131 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    132 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount