PC_SUM_TPL_HDR

(SQL Table)
Index Back

Summarization Template Header

Summarization template identifies the fields that will be used in the "group by" for summing project transactions.

  • Parent Record Of PC_SUM_TPL_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Feeder integration product code
    3RD=Third Party Loader
    APPO=Payables / Purchasing
    EX=Expenses
    GL=General Ledger
    GRFA=Grants Retroactive F&A
    PRC=Pricing Engine
    RPT1=Project Reporting Tables
    TL=Time and Labor
    USR1=User 1
    USR2=User 2
    USR3=User 3
    USR4=User 4
    USR5=User 5
    VP=Variance Pricing
    2 PROCESSING_SEQ Number(5,0) INTEGER NOT NULL Processing Sequence
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

    Y/N Table Edit

    Default Value: N

    6 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    7 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    8 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    9 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    10 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause