R_FINAL_RESULTS

(SQL Table)
Index Back

Tmp Tbl-NDT Results

This record is created as a result of the Non-discrimination testing, and shows the results of this testing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
2 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test
N=No
Y=Yes

Default Value: N

3 SLOB Character(1) VARCHAR2(1) NOT NULL Separate Line of Business

Default Value: N

4 CAFETERIA_PLAN Character(1) VARCHAR2(1) NOT NULL Cafeteria Plan

Default Value: N

5 NHCE_LOOKUP_PCT Number(3,0) SMALLINT NOT NULL NHCE LookUp Concentration Pct

Default Value: 0

6 FIFTY5_CALC_PCT Number(6,2) DECIMAL(5,2) NOT NULL 55% Calculated Result

Default Value: 0

7 ELIG_NHCE_COUNT Number(6,0) INTEGER NOT NULL Eligible NHCE Count

Default Value: 0

8 ELIG_HCE_COUNT Number(6,0) INTEGER NOT NULL Eligible HCE Count

Default Value: 0

9 CALC_HARBOR_PCT Number(6,2) DECIMAL(5,2) NOT NULL Calculated Harbor Percent

Default Value: 0

10 SAFE_HARBOR_PCT Number(8,4) DECIMAL(7,4) NOT NULL Safe Harbor Percentage

Default Value: 0

11 UNSAFE_HARBOR_PCT Number(8,4) DECIMAL(7,4) NOT NULL Unsafe Harbor Percentage

Default Value: 0

12 TTL_BENEFIT_PAID Number(10,2) DECIMAL(9,2) NOT NULL Total Benefits Paid

Default Value: 0

13 PCT_BENEFIT_PAID Number(10,2) DECIMAL(9,2) NOT NULL Pecent of Benefits Paid

Default Value: 0

14 MIN_EMPLOYEE_COUNT Number(5,0) INTEGER NOT NULL Minimum Employee Count

Default Value: 0