EXT_PARM_CD_FRADefault Value: 01
EFFDTDefault Value: %DATE
EXT_PARM_FRA(SQL Table) |
Index Back |
|---|---|
Leg&Reg Report param - FRAThis table tracks various global parameters required for legs and regs reporting in France. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_PARM_CD_FRA |
Character(2) | VARCHAR2(2) NOT NULL |
External Variables
Default Value: 01 |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %DATE |
| 3 | SMIC_CD_FRA | Number(8,2) | DECIMAL(7,2) NOT NULL | Minimum Salary |
| 4 | MINIMUM_AMOUNT_FRA | Number(8,2) | DECIMAL(7,2) NOT NULL | Minimum Salary Guaranteed |
| 5 | RETAIL_PR_INDX_FRA | Number(8,2) | DECIMAL(7,2) NOT NULL | Retail Price Index |
| 6 | SSN_LIMIT1_FRA | Number(8,2) | DECIMAL(7,2) NOT NULL | Social Security Ceiling A |
| 7 | SSN_LIMIT2_FRA | Number(8,2) | DECIMAL(7,2) NOT NULL | Social Security Ceiling B |
| 8 | SSN_LIMIT3_FRA | Number(9,2) | DECIMAL(8,2) NOT NULL | Social Security Ceiling C |
| 9 | DISAB_RPT_RATE_FRA | Number(6,2) | DECIMAL(5,2) NOT NULL | Disability Report Rate |