FPM_CA_HDCT(SQL Table) |
Index Back |
|---|---|
Budget Lines ReplicationThis table contains information related to the CAE Category in the Finance Law |
| # | 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_FL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Finance Act Status
A=Adjourned E=To Be Stamped V=Stamped Default Value: FPM_CA_FINLAW.FP_FL_STATUS |
| 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_MASS_FRZ_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Mass Freeze |
| 17 | FP_USED_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Allocated CAE |
| 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 |