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 | 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 |