FPM_CA_LOCKS(SQL Table) |
Index Back |
|---|---|
Locking in between CAEC - TablThis table contains information related to the CAE Category locked to create additional headcount in other CAEC |
| # | 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 |
| 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_LOCK_CATG_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Category Supporting Locking in
Prompt Table: FPM_CA_CTG_TBL |
| 8 | FP_LOCK_CATG_ORD |
Number(3,0) | SMALLINT NOT NULL | Category Supporting Lock Order |
| 9 | FP_FIRST_UTIL_DT | Date(10) | DATE | Date of First Use |
| 10 | FP_APPL_DT | Date(10) | DATE |
Application Date
Default Value: FPM_CA_LOCKS.EFFDT |
| 11 | FP_END_DT | Date(10) | DATE | Position Actual End Date |
| 12 | FP_PROLONG_TAG | Character(1) | VARCHAR2(1) NOT NULL |
Locking ins Renewal
Y/N Table Edit Default Value: N |