FPM_CA_MVTS1(SQL Table) |
Index Back |
---|---|
Level 1 Moves TableShows moves between BH and BHA |
# | 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_TRANS_TYP1 | Character(3) | VARCHAR2(3) NOT NULL |
Type of Move
GRV=Locking in SFB=Budget Overstaffing TFX=External Transfer |
8 | FP_TRANS_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Type of Move
+=Plus -=Minus Default Value: + |
9 | FP_TRANS_HDCNT | Signed Number(10,2) | DECIMAL(8,2) NOT NULL |
Move
Default Value: 0 |
10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |