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 |