INTFC_PC_MPX_VW

(SQL View)
 Index Back

Interface MPX View


SELECT INTFC_ID ,INTFC_LINE_NUM ,BUSINESS_UNIT ,PROJECT_ID ,LOAD_STATUS ,DESCR ,PS_OWNER ,PROJECT_STATUS ,START_DT ,END_DT ,PROJECT_PRIORITY ,PERCENT_COMPLETE ,ACTIVITY_ID ,RESOURCE_ID ,RESOURCE_TYPE ,RESOURCE_QUANTITY ,RESOURCE_AMOUNT ,RESOURCE_CATEGORY ,RESOURCE_SUB_CAT ,UNIT_OF_MEASURE ,PC_DISTRIB_STATUS ,CURRENCY_CD FROM PS_INTFC_PC_MPX

  • Parent record: PROJ_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
    2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    5 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
    CON=Consolidated
    DON=Loaded
    ERR=Errored
    EXC=Excluded
    HLD=On Hold
    INP=In Process
    NEW=Pending
    PGI=PO Grp Incomplete
    REP=Replaced
    UNI=Unitized
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 PS_OWNER Character(2) VARCHAR2(2) NOT NULL PeopleSoft Owner
    AM=Asset Management
    AP=Accounts Payable
    AR=Accounts Receivable
    BD=Budgets
    BI=Billing
    CA=Contracts
    CM=Cost Management
    CS=Customer Service
    EN=Engineering
    EX=Expenses
    GL=General Ledger
    HR=Human Resources
    IN=Inventory
    MG=Manufacturing
    OM=Order Management
    PC=Project Costing
    PL=Planning
    PO=Purchasing
    PR=Production Control
    PT=PeopleTools
    TL=Time and Labor
    TR=Treasury
    8 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed
    9 START_DT Date(10) DATE Start Date
    10 END_DT Date(10) DATE End Date
    11 PROJECT_PRIORITY Number(3,0) SMALLINT NOT NULL Project Priority
    12 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
    13 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    14 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
    15 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
    16 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
    17 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
    18 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
    19 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
    20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    21 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
    22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL