PC_RPO_AET

(SQL Table)
 Index Back

Proj_Resource Rptg Tbl State

Proj_Resource Reporting Table State Record 7/10/00 Added RPTG_INTERVAL, CALENDAR_ID_20, CALENDAR_ID for summarization by date option. 7/17/00 Added SECURITY_TYPE for determine class or operator level security.

  • Parent record: PROJ_RESOURCE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists
    3 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
    4 BUPRJACT_OPTN Character(1) VARCHAR2(1) NOT NULL BU/Proj/Act Option
    A=Business Unit/Project/Activity
    B=Business Unit
    E=All
    P=Business Unit/Project
    5 DATE_RANGE_OPTN Character(1) VARCHAR2(1) NOT NULL Date Option
    A=Accounting Date
    E=All
    T=Transaction Date
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJ_ACTIVITY.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: PROJ_ACTIVITY.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

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

    Default Value: PROJ_ACTIVITY.ACTIVITY_ID

    Prompt Table: PROJ_ACT_SRCH

    9 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
    10 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID
    11 FROM_DATE Date(10) DATE From Date
    12 THRU_DATE Date(10) DATE Through Date
    13 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
    14 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    15 ANALYSIS_TYPE_MAP Character(3) VARCHAR2(3) NOT NULL Analysis Type Map
    16 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
    17 KEY_NUM_9 Number(8,0) INTEGER NOT NULL Key Number 9
    18 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

    19 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

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

    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 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCT_BUGL_VW

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

    Prompt Table: %EDIT_ALTACCT

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

    Prompt Table: DEPTID_BUGL_VW

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

    Prompt Table: OPERUNT_BUGL_VW

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

    Prompt Table: PRODUCT_BUGL_VW

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

    Prompt Table: FUND_BUGL_VW

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

    Prompt Table: CLASSCF_BUGL_VW

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

    Prompt Table: PROGRAM_BUGL_VW

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

    Prompt Table: BUD_REF_BUGL_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CF1_BUGL_VW

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

    Prompt Table: CF2_BUGL_VW

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

    Prompt Table: CF3_BUGL_VW

    38 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

    39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    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 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Prompt Table: PROJ_AN_GRP_VW

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

    Prompt Table: PROJ_RES_TYPE

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

    Prompt Table: %EDITTABLE

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

    Prompt Table: %EDITTABLE2

    46 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
    47 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
    48 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
    49 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
    50 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
    51 TRANS_DT Date(10) DATE Transaction Date

    Default Value: %date

    52 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

    Default Value: %date

    53 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    54 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.
    55 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

    Default Value: OPR_DEF_TBL_PC.CURRENCY_CD

    Prompt Table: FRGN_CURR_VW

    56 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code
    57 CUR_EFFDT_OPTN Character(1) VARCHAR2(1) NOT NULL Currency Effective Date Option
    A=Accounting Date
    T=Transaction Date
    V=Value
    58 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

    59 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.
    60 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    61 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    62 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

    63 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

    64 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

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

    Prompt Table: PROJ_TRANS_TYPE

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

    Prompt Table: PROJ_TRANS_CODE

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

    Default Value: A

    68 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    69 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.
    70 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

    71 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PROJ_TEAM_VW

    72 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    73 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    74 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    75 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

    Prompt Table: SP_BU_AP_NONVW

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

    Prompt Table: PROJ_VENDOR_VW

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

    Prompt Table: PC_AP_VCHR_VW

    78 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

    79 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
    80 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: PC_PO_HDR_VW

    81 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
    82 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

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

    Prompt Table: PROJ_ASSET_VW

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

    Prompt Table: PROFILE_PCAM_VW

    85 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
    86 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
    87 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

    Prompt Table: PC_PROJ_GNT_VW

    88 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    89 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

    Prompt Table: SP_BU_BI_NONVW

    90 BILLING_DATE Date(10) DATE Billing Date
    91 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    92 REV_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Revenue Distribution Status
    C=Created
    D=Distributed
    G=Generated
    I=Ignore
    N=Not Distributed
    93 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

    Prompt Table: SP_BUARED_NONVW

    94 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

    95 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

    96 SELECT_PARM1 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 1
    97 AE_SW1 Character(1) VARCHAR2(1) NOT NULL AE Switch
    98 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: SP_BUIN_NONVW

    99 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PROJ_ITEM_VW

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

    Prompt Table: SP_BUPCOM_NONVW

    101 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
    102 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
    103 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
    104 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

    105 BUDGET_DT Date(10) DATE Budget Date
    106 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    107 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit

    Prompt Table: SP_BU_BD_NONVW

    108 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
    109 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    110 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
    111 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    112 RPOGRP Character(30) VARCHAR2(30) NOT NULL Summarization Option
    113 DO_SECTION Character(10) VARCHAR2(10) NOT NULL Do AE Section
    114 EDIT_VALUE Character(30) VARCHAR2(30) NOT NULL 8/7/00 - Modified Long and Short Name from Edit Value to Selection Value. This is more meaningful as this field is used to select a particular value for a field from PROJ_RESOURCE.
    115 GROUP_BY_TEXT Character(254) VARCHAR2(254) NOT NULL Group by text
    116 GROUP_BY_LONG Long Character(4000) CLOB GROUP_BY_LONG
    117 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    118 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    119 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    120 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    121 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed
    122 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment
    123 BUTREEPRJACT_OPTN Character(1) VARCHAR2(1) NOT NULL BU/Tree/Prj/Act Optn
    A=Business Unit/Project/Activity
    B=Business Unit
    E=All
    P=Business Unit/Project
    T=Tree Node
    124 ZERO Number(1,0) SMALLINT NOT NULL ZERO
    125 RPTG_INTERVAL Character(3) VARCHAR2(3) NOT NULL Reporting Interval is used to determine the how reporting data should be summed: daily, monthly, quarterly, yearly, or inception to date.
    DAY=Daily Summation
    ITD=Inception to Date
    MTH=Monthly Summation
    QTR=Quarterly Summation
    YR=Yearly Summation
    126 CALENDAR_ID_20 Character(20) VARCHAR2(20) NOT NULL Calendar Id
    127 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    128 SECURITY_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Security
    C=Permission List Level Security
    N=No Security
    O=User ID Level Security