FPM_CA_MVT1_LNG

(SQL Table)
Index Back

Level 1 Moves - Table

Show BH/BHA moves

  • Related Language Record for FPM_CA_MVTS1
  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description