FPM_CA_HDCNT_VW(SQL View) |
Index Back |
---|---|
Counters / categories ViewCAE by CAEC counter table. 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_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_POT_DSCH_HDCNT , A.FP_LOCK_OVFL_HDCNT , A.FP_LOCKED_HDCNT , A.FP_LOCK_RQS , A.FP_LCKD_DSCH_RQS , A.FP_COMM_PHYSIC , A.FP_WARN1_HDCNT , A.FP_WARN2_HDCNT , A.FP_FREE_ENT1_HDCNT , A.FP_FREE_ENT2_HDCNT , A.LAST_UPDATE_DATE FROM PS_FPM_CA_HDCT A |
# | 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_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_POT_DSCH_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | CAE to be Deallocated |
21 | FP_LOCK_OVFL_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Overstaff Authorized |
22 | FP_LOCKED_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | CAE Locked in |
23 | FP_LOCK_RQS | Number(9,2) | DECIMAL(8,2) NOT NULL | Nbr of Locking ins Requested |
24 | FP_LCKD_DSCH_RQS | Number(9,2) | DECIMAL(8,2) NOT NULL | Nbr of CAE to Unlock |
25 | FP_COMM_PHYSIC | Number(6,0) | INTEGER NOT NULL | Physical Headcount |
26 | FP_WARN1_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Booked Overdue not Stampd |
27 | FP_WARN2_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Dealloctd Overdue not Stampd |
28 | FP_FREE_ENT1_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Counter 1 Free of Use |
29 | FP_FREE_ENT2_HDCNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Counter 2 Free of Use |
30 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |