FPM_CA_MVTS1

(SQL Table)
 Index Back

Level 1 Moves Table

Shows moves between BH and BHA

  • Related Language Record: FPM_CA_MVT1_LNG

  • Parent record: FPM_CA_HDCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FP_STFBDG_LVL1 Character(2) VARCHAR2(2) NOT NULL Section
    EM=Labor
    LG=Housing
    S1=Sector 1
    S2=Sector 2
    SL=Solidarity
    TO=Tourism
    TR=Transportation
    2 FP_FINANC_LAW_ID Character(12) VARCHAR2(12) NOT NULL Finance Act
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    6 FP_CA_CATG_ID Character(6) VARCHAR2(6) NOT NULL CAE Category

    Prompt Table: FPM_CA_CTG_TBL

    7 FP_TRANS_TYP1 Character(3) VARCHAR2(3) NOT NULL Type of Move
    GRV=Locking in
    SFB=Budget Overstaffing
    TFX=External Transfer
    8 FP_TRANS_SIGN Character(1) VARCHAR2(1) NOT NULL Type of Move
    +=Plus
    -=Minus

    Default Value: +

    9 FP_TRANS_HDCNT Signed Number(10,2) DECIMAL(8,2) NOT NULL Move

    Default Value: 0

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description