GM_PRJ_ACT_FA

(SQL Table)
 Index Back

F&A Rate Type

  • 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

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: SP_PROJ_NONVW

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

    Prompt Table: PROJ_ACT_VW

    4 FA_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL FA_RATE_TYPE

    Prompt Table: GM_FA_RATE_TYPE

    5 FA_INST_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_INST_BASE_ID

    Prompt Table: GM_FA_BASE_DTL

    6 FA_SPNSR_BASE_ID Character(5) VARCHAR2(5) NOT NULL Sponsor Base

    Prompt Table: GM_FA_BASE_DTL

    7 FA_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_BASE_ID

    Prompt Table: GM_FA_BASE_DTL

    8 FA_ACT_RATE_STATUS Character(3) VARCHAR2(3) NOT NULL FA Rate Status
    CAN=Cancelled
    DON=Done
    PND=Pending
    PRG=In Progress
    RDY=Ready

    Default Value: RDY

    9 FA_RDY_ACTIVATE Character(1) VARCHAR2(1) NOT NULL Ready at Activation

    Y/N Table Edit

    Default Value: N

    10 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold

    Default Value: N