FPM_CA_HDCT_VW2

(SQL View)
 Index Back

CAE Counter Table

CAE by CAEC counters. BH, BHA, AHM counters with carry overs + moves + "living" counters (allocated, locked in, de-allocated)

SELECT FP_STFBDG_LVL1 , FP_FINANC_LAW_ID , EFFDT , EFFSEQ , SETID , FP_CA_CATG_ID , FP_FL_STATUS , FP_BUDG_HDCNT , FP_ALLWD_HDCNT , FP_MNDGD_HDCNT , FP_CARRYOVER_1 , FP_CARRYOVER_2 , FP_TRS1_SUM , FP_TRS2_SUM , FP_FROZ_HDCNT , FP_USED_HDCNT , FP_MASS_FRZ_HDCNT , FP_BK_UNST_HDCNT , FP_BK_STMP_HDCNT , FP_DSCH_UNST_HDCNT , FP_DSCH_STMP_HDCNT , FP_POT_DSCH_HDCNT , FP_LOCK_OVFL_HDCNT , FP_LOCKED_HDCNT , FP_LOCK_RQS , FP_LCKD_DSCH_RQS , FP_COMM_PHYSIC , FP_WARN1_HDCNT , FP_WARN2_HDCNT , FP_FREE_ENT1_HDCNT , FP_FREE_ENT2_HDCNT , LAST_UPDATE_DATE FROM PS_FPM_CA_HDCT

  • Parent record: FPM_CA_FINLAW

    • # 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_LOCK_CATG_ID Character(6) VARCHAR2(6) NOT NULL Category Supporting Locking in
    7 FP_FL_STATUS Character(1) VARCHAR2(1) NOT NULL Finance Act Status
    A=Adjourned
    E=To Be Stamped
    V=Stamped
    8 FP_BUDG_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Budgetized Headcount
    9 FP_ALLWD_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Budget Headcount Authorized
    10 FP_MNDGD_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Authorized Headcount Managmt
    11 FP_CARRYOVER_1 Signed Number(10,2) DECIMAL(8,2) NOT NULL Moves BH/BHA Carry Over
    12 FP_CARRYOVER_2 Signed Number(10,2) DECIMAL(8,2) NOT NULL Total Mvts Lev 2 Carryover
    13 FP_TRS1_SUM Signed Number(10,2) DECIMAL(8,2) NOT NULL Moves between BH and BHA
    14 FP_TRS2_SUM Signed Number(10,2) DECIMAL(8,2) NOT NULL Moves between BHA and AHM
    15 FP_FROZ_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Transactional Freeze
    16 FP_USED_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Allocated CAE
    17 FP_MASS_FRZ_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Mass Freeze
    18 FP_BK_UNST_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL CAE Booked not Stamped
    19 FP_BK_STMP_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL CAE Booked and Stamped
    20 FP_DSCH_UNST_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL CAE Deallocated not Stamped
    21 FP_DSCH_STMP_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL CAE Deallocated and Stamped
    22 FP_POT_DSCH_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL CAE to be Deallocated
    23 FP_LOCK_OVFL_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Overstaff Authorized
    24 FP_LOCKED_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL CAE Locked in
    25 FP_LOCK_RQS Number(9,2) DECIMAL(8,2) NOT NULL Nbr of Locking ins Requested
    26 FP_LCKD_DSCH_RQS Number(9,2) DECIMAL(8,2) NOT NULL Nbr of CAE to Unlock
    27 FP_COMM_PHYSIC Number(6,0) INTEGER NOT NULL Physical Headcount
    28 FP_WARN1_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Booked Overdue not Stampd
    29 FP_WARN2_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Dealloctd Overdue not Stampd
    30 FP_FREE_ENT1_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Counter 1 Free of Use
    31 FP_FREE_ENT2_HDCNT Number(9,2) DECIMAL(8,2) NOT NULL Counter 2 Free of Use
    32 LAST_UPDATE_DATE Date(10) DATE Date of last update