R_FINAL_RESULTS(SQL Table) | 
Index Back | 
|---|---|
Tmp Tbl-NDT ResultsThis 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 | Character(11) | VARCHAR2(11) NOT NULL | Test ID | |
| 2 | PASSED | Character(1) | VARCHAR2(1) NOT NULL | 
Passed Test
 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  |