FPM_CA_MVT2_LNG

(SQL Table)
 Index Back

Level 2 Transfers - Table

Show BHA/AHM transfers

  • Related Language Record for FPM_CA_MVTS2

  • 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_TYP2 Character(3) VARCHAR2(3) NOT NULL The values show the changes applying to BH to impact BHA
    BLI=Indexical Locking ins
    BLS=n CAE Locked in
    GRV=Locking ins
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description