FP_LEGALSTAT_CDPrompt Table: FPMLEGALSTA_TBL
EFFDTDefault Value: %date
FP_PT_PCT050=50
060=60
070=70
080=80
090=90
100=100
Default Value: 100
Default Value: 100
FPMFRACPYMT_TBL(SQL Table) |
Index Back |
|---|---|
Compensation Proration ratio |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_LEGALSTAT_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Civil Service Position Code
Prompt Table: FPMLEGALSTA_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | FP_PT_PCT |
Character(3) | VARCHAR2(3) NOT NULL |
Working Time Percentage
050=50 060=60 070=70 080=80 090=90 100=100 |
| 4 | FP_FRACPYMT_NOM1 | Number(3,0) | SMALLINT NOT NULL | Main Salary Numerator |
| 5 | FP_FRACPYMT_DEN1 | Number(3,0) | SMALLINT NOT NULL | Main Sal. Fraction Denominator |
| 6 | FP_FRACPYMT_NOM2 | Number(3,0) | SMALLINT NOT NULL | Scnd Salary Numerator |
| 7 | FP_FRACPYMT_DEN2 | Number(3,0) | SMALLINT NOT NULL |
Scnd Sal Fraction Denominator
Default Value: 100 |
| 8 | FP_FRACPYMT_NOM3 | Number(3,0) | SMALLINT NOT NULL | Allowance Fraction Numerator |
| 9 | FP_FRACPYMT_DEN3 | Number(3,0) | SMALLINT NOT NULL |
Allowance Fraction Denominator
Default Value: 100 |