FPM_CA_FINLAW

(SQL Table)
 Index Back

Finance Act

Finance Act Definition

  • Related Language Record: FPM_CA_FLAW_LNG

  • Parent Record Of FPM_CA_HDCT FPM_CA_HDCT_VW2 FPM_CA_HEAD_VW

    • # 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 FP_FL_STATUS Character(1) VARCHAR2(1) NOT NULL Finance Act Status
    A=Adjourned
    E=To Be Stamped
    V=Stamped
    6 FP_BUDG_YEAR Number(4,0) SMALLINT NOT NULL Budgeting
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    8 FP_INPUT_DATE Date(10) DATE NOT NULL Input Date

    Default Value: %date

    9 FP_FINANC_LAW_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Event
    D=Order
    I=Initial
    M=Internal Move
    R=Rectified

    Default Value: I