EXT_PARM_FRA

(SQL Table)
Index Back

Leg&Reg Report param - FRA

This 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