FP_STFBDG_LVL1EM=Labor
LG=Housing
S1=Sector 1
S2=Sector 2
SL=Solidarity
TO=Tourism
TR=Transportation
FP_FINANC_LAW_IDEFFDTDefault Value: %date
EFFSEQSETIDPrompt Table: SETID_TBL
FP_LOCK_CATG_IDA=Adjourned
E=To Be Stamped
V=Stamped
FPM_CA_HDCT_VW2(SQL View) |
Index Back |
|---|---|
CAE Counter TableCAE 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 |
| # | 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 Stamped |
| 29 | FP_WARN2_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Dealloctd Overdue not Stamped |
| 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 |