SETIDPrompt Table: SETID_TBL
FP_CA_CATG_IDPrompt Table: FPM_CA_CTG_TBL
EFFDTEFFSEQEM=Labor
LG=Housing
S1=Sector 1
S2=Sector 2
SL=Solidarity
TO=Tourism
TR=Transportation
A=Adjourned
E=To Be Stamped
V=Stamped
FPM_CA_HDCT_VW1(SQL View) |
Index Back |
|---|---|
Counters / categories ViewCAE by CAEC counters. BH, BHA, AHM counters with carry overs + moves + "living" counters (allocated, locked in, de-allocated) |
| SELECT A.SETID , A.FP_CA_CATG_ID , A.EFFDT , A.EFFSEQ , A.FP_STFBDG_LVL1 , A.FP_FINANC_LAW_ID , A.FP_FL_STATUS , A.FP_LOCK_OVFL_HDCNT , A.FP_BUDG_HDCNT , A.FP_ALLWD_HDCNT , A.FP_MNDGD_HDCNT , A.FP_CARRYOVER_1 , A.FP_CARRYOVER_2 , A.FP_TRS1_SUM , A.FP_TRS2_SUM , A.FP_FROZ_HDCNT , A.FP_MASS_FRZ_HDCNT , A.FP_USED_HDCNT , A.FP_BK_UNST_HDCNT , A.FP_BK_STMP_HDCNT , A.FP_DSCH_UNST_HDCNT , A.FP_DSCH_STMP_HDCNT , A.FP_POT_DSCH_HDCNT , A.FP_LOCKED_HDCNT , A.FP_LOCK_RQS , A.FP_LCKD_DSCH_RQS , A.FP_COMM_PHYSIC , A.LAST_UPDATE_DATE FROM PS_FPM_CA_HDCT A WHERE FP_LOCK_OVFL_HDCNT > 0 AND (FP_ALLWD_HDCNT + FP_CARRYOVER_2 + FP_TRS2_SUM + FP_LOCK_OVFL_HDCNT - FP_LOCKED_HDCNT - (FP_USED_HDCNT + FP_FROZ_HDCNT + FP_MASS_FRZ_HDCNT + FP_BK_UNST_HDCNT + FP_BK_STMP_HDCNT))>0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | FP_CA_CATG_ID |
Character(6) | VARCHAR2(6) NOT NULL |
CAE Category
Prompt Table: FPM_CA_CTG_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | 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 |
| 6 | FP_FINANC_LAW_ID | Character(12) | VARCHAR2(12) NOT NULL | Finance Act |
| 7 | FP_FL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Finance Act Status
A=Adjourned E=To Be Stamped V=Stamped |
| 8 | FP_LOCK_OVFL_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Overstaff Authorized |
| 9 | FP_BUDG_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Budgetized Headcount |
| 10 | FP_ALLWD_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Budget Headcount Authorized |
| 11 | FP_MNDGD_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Authorized Headcount Managmt |
| 12 | FP_CARRYOVER_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Moves BH/BHA Carry Over |
| 13 | FP_CARRYOVER_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Mvts Lev 2 Carryover |
| 14 | FP_TRS1_SUM | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Moves between BH and BHA |
| 15 | FP_TRS2_SUM | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Moves between BHA and AHM |
| 16 | FP_FROZ_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Transactional Freeze |
| 17 | FP_MASS_FRZ_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Mass Freeze |
| 18 | FP_USED_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Allocated CAE |
| 19 | FP_BK_UNST_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | CAE Booked not Stamped |
| 20 | FP_BK_STMP_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | CAE Booked and Stamped |
| 21 | FP_DSCH_UNST_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | CAE Deallocated not Stamped |
| 22 | FP_DSCH_STMP_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | CAE Deallocated and Stamped |
| 23 | FP_POT_DSCH_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | CAE to be Deallocated |
| 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 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |