FPM_CA_CTG_TBL(SQL Table) |
Index Back |
|---|---|
CAECCommitment Accounting Entity Category |
| # | 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 |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | FP_AVRG_INDEX | Number(6,0) | INTEGER NOT NULL | Highest and Lowest Index Avg |
| 6 | FP_STFBDG_LVL2 | Character(5) | VARCHAR2(5) NOT NULL | Chapter |
| 7 | FP_STFBDG_LVL21 | Character(2) | VARCHAR2(2) NOT NULL |
Title
31=Compensation and Bonus |
| 8 | FP_STFBDG_LVL22 | Character(2) | VARCHAR2(2) NOT NULL |
Part
41=Key Compensation 61=Key Compensation |
| 9 | FP_STFBDG_LVL3 | Character(2) | VARCHAR2(2) NOT NULL |
Article
00=Test Test 01=Minister and Secretaryof State 02=National Headquarters 10=Decentralized Services 91=Ministry (test) 92=National Headquarters 93=Decentralized Services 98=Special |
| 10 | FP_STFBDG_LVL4 | Character(2) | VARCHAR2(2) NOT NULL |
Paragraph
11=Incumbents 20=Contract Employees |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 13 | FP_ECONOMIC | Character(3) | VARCHAR2(3) NOT NULL |
Economy Code
112=112 113=113 |