| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ELIG_RULES_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Eligibility Rules ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
MIN_STD_HRS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Minimum Standard Hours
|
| 7 |
MAX_STD_HRS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Maximum Standard Hours
Default Value: 99
|
| 8 |
COMBINE_MULT_HRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Combine Hours for Multi Jobs
Y/N Table Edit
Default Value: N
|
| 9 |
MIN_SERVICE_MM |
Number(3,0) |
SMALLINT NOT NULL |
Minimum Service Months
|
| 10 |
MAX_SERVICE_MM |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Service Months
Default Value: 999
|
| 11 |
SERVICE_AS_OF_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
This rule tells the system what reference date to use when determining length of Service as a criteria for a rate calculation.
C=Check Date
L=Last Year On
P=Pay End Date
T=This Year On
Default Value: C
|
| 12 |
SERVICE_AS_OF_MM |
Number(2,0) |
SMALLINT NOT NULL |
Service As Of Month
|
| 13 |
SERVICE_AS_OF_DD |
Number(2,0) |
SMALLINT NOT NULL |
Service As Of Day
|
| 14 |
MIN_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Monimum age used for Benefits process.
|
| 15 |
MAX_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Max age used for Benefits process
Default Value: 99
|
| 16 |
AGE_AS_OF_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
This rule tells the system what reference date to use when determining the Age needed for a rate calculation.
C=Check Date
E=Initial Coverage Date
L=Last Year On
N=Next/Check Date
P=Pay End Date
T=This Year On
Default Value: C
|
| 17 |
AGE_AS_OF_MM |
Number(2,0) |
SMALLINT NOT NULL |
Age As Of Month
|
| 18 |
AGE_AS_OF_DD |
Number(2,0) |
SMALLINT NOT NULL |
Age As Of Day
|
| 19 |
MIN_FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
Minimum FTE
|
| 20 |
MAX_FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
Maximum FTE
Default Value: 9.999999
|
| 21 |
BAS_HOME_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Base Eligibility On
B=Both
E=Either
H=Home
L=Location
Default Value: H
|
| 22 |
ELIG_FLG_BNSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 23 |
ELIG_FLG_CNFIG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 24 |
ELIG_FLG_CNFIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 25 |
ELIG_FLG_CNFIG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 26 |
ELIG_FLG_CNFIG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 27 |
ELIG_FLG_CNFIG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 28 |
ELIG_FLG_CNFIG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 29 |
ELIG_FLG_CNFIG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 30 |
ELIG_FLG_CNFIG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 31 |
ELIG_FLG_CNFIG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 32 |
ELIG_FLG_EECLAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 33 |
ELIG_FLG_EETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 34 |
ELIG_FLG_FLPART |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 35 |
ELIG_FLG_FLSA |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 36 |
ELIG_FLG_GRADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 37 |
ELIG_FLG_LOCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 38 |
ELIG_FLG_OFFICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 39 |
ELIG_FLG_PYGRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 40 |
ELIG_FLG_REGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 41 |
ELIG_FLG_REGTMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 42 |
ELIG_FLG_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 43 |
ELIG_FLG_UNION |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 44 |
ELIG_FLG_MEDICARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 45 |
ELIG_USE_ACAELG |
Character(1) |
VARCHAR2(1) NOT NULL |
The value is set to 'Y' if there is a row in BAS_ELIG_ACAELG.
Y/N Table Edit
Default Value: Y
|
| 46 |
ELIG_USE_BNSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Benefits Status
Y/N Table Edit
Default Value: Y
|
| 47 |
ELIG_USE_CNFIG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 1
Y/N Table Edit
Default Value: Y
|
| 48 |
ELIG_USE_CNFIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 2
Y/N Table Edit
Default Value: Y
|
| 49 |
ELIG_USE_CNFIG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 3
Y/N Table Edit
Default Value: Y
|
| 50 |
ELIG_USE_CNFIG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 4
Y/N Table Edit
Default Value: Y
|
| 51 |
ELIG_USE_CNFIG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 5
Y/N Table Edit
Default Value: Y
|
| 52 |
ELIG_USE_CNFIG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 6
Y/N Table Edit
Default Value: Y
|
| 53 |
ELIG_USE_CNFIG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 7
Y/N Table Edit
Default Value: Y
|
| 54 |
ELIG_USE_CNFIG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 8
Y/N Table Edit
Default Value: Y
|
| 55 |
ELIG_USE_CNFIG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Elig Config 9
Y/N Table Edit
Default Value: Y
|
| 56 |
ELIG_USE_EECLAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Employee Class
Y/N Table Edit
Default Value: Y
|
| 57 |
ELIG_USE_EETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Employee Type
Y/N Table Edit
Default Value: Y
|
| 58 |
ELIG_USE_FLPART |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Full/Part Time
Y/N Table Edit
Default Value: Y
|
| 59 |
ELIG_USE_FLSA |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use FLSA Status
Y/N Table Edit
Default Value: Y
|
| 60 |
ELIG_USE_GRADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Salary Plan/Grade
Y/N Table Edit
Default Value: Y
|
| 61 |
ELIG_USE_LOCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Location
Y/N Table Edit
Default Value: Y
|
| 62 |
ELIG_USE_OFFICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Officer Code
Y/N Table Edit
Default Value: Y
|
| 63 |
ELIG_USE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Emplid Override
Y/N Table Edit
Default Value: Y
|
| 64 |
ELIG_USE_PYGRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Company/Pay Group
Y/N Table Edit
Default Value: Y
|
| 65 |
ELIG_USE_REGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Reg Region
Y/N Table Edit
Default Value: Y
|
| 66 |
ELIG_USE_REGTMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Regular/Temporary
Y/N Table Edit
Default Value: Y
|
| 67 |
ELIG_USE_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use State
Y/N Table Edit
Default Value: Y
|
| 68 |
ELIG_USE_UNION |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Union Code
Y/N Table Edit
Default Value: Y
|
| 69 |
ELIG_USE_MEDICARE |
Character(1) |
VARCHAR2(1) NOT NULL |
The value is set to 'Y' if there is a row in BAS_ELIG_MEDICARE.
Y/N Table Edit
Default Value: Y
|
| 70 |
GRP_MTHD_BNSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 71 |
GRP_MTHD_CNFIG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 72 |
GRP_MTHD_CNFIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 73 |
GRP_MTHD_CNFIG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 74 |
GRP_MTHD_CNFIG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 75 |
GRP_MTHD_CNFIG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 76 |
GRP_MTHD_CNFIG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 77 |
GRP_MTHD_CNFIG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 78 |
GRP_MTHD_CNFIG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 79 |
GRP_MTHD_CNFIG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 80 |
GRP_MTHD_EECLAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 81 |
GRP_MTHD_EETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 82 |
GRP_MTHD_FLPART |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 83 |
GRP_MTHD_FLSA |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 84 |
GRP_MTHD_FTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 85 |
GRP_MTHD_GRADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 86 |
GRP_MTHD_HRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 87 |
GRP_MTHD_LOCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 88 |
GRP_MTHD_OFFICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 89 |
GRP_MTHD_PYGRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 90 |
GRP_MTHD_REGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 91 |
GRP_MTHD_REGTMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 92 |
GRP_MTHD_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 93 |
GRP_MTHD_SVC |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 94 |
GRP_MTHD_UNION |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 95 |
GRP_MTHD_MEDICARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 96 |
EVAL_MTHD_BNSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 97 |
EVAL_MTHD_CNFIG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 98 |
EVAL_MTHD_CNFIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 99 |
EVAL_MTHD_CNFIG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 100 |
EVAL_MTHD_CNFIG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 101 |
EVAL_MTHD_CNFIG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 102 |
EVAL_MTHD_CNFIG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 103 |
EVAL_MTHD_CNFIG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 104 |
EVAL_MTHD_CNFIG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 105 |
EVAL_MTHD_CNFIG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 106 |
EVAL_MTHD_EECLAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 107 |
EVAL_MTHD_EETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 108 |
EVAL_MTHD_FLPART |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 109 |
EVAL_MTHD_FLSA |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 110 |
EVAL_MTHD_FTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
3=Sum Across Jobs
Default Value: 1
|
| 111 |
EVAL_MTHD_GRADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 112 |
EVAL_MTHD_HRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
3=Sum Across Jobs
Default Value: 1
|
| 113 |
EVAL_MTHD_LOCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 114 |
EVAL_MTHD_OFFICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 115 |
EVAL_MTHD_PYGRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 116 |
EVAL_MTHD_REGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 117 |
EVAL_MTHD_REGTMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 118 |
EVAL_MTHD_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 119 |
EVAL_MTHD_SVC |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 120 |
EVAL_MTHD_UNION |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 121 |
EVAL_MTHD_MEDICARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One of More in Group
2=All in Group
Default Value: 1
|
| 122 |
EVAL_ACTV_BNSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 123 |
EVAL_ACTV_CNFIG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 124 |
EVAL_ACTV_CNFIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 125 |
EVAL_ACTV_CNFIG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 126 |
EVAL_ACTV_CNFIG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 127 |
EVAL_ACTV_CNFIG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 128 |
EVAL_ACTV_CNFIG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 129 |
EVAL_ACTV_CNFIG7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 130 |
EVAL_ACTV_CNFIG8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 131 |
EVAL_ACTV_CNFIG9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 132 |
EVAL_ACTV_EECLAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 133 |
EVAL_ACTV_EETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 134 |
EVAL_ACTV_FLPART |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 135 |
EVAL_ACTV_FLSA |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 136 |
EVAL_ACTV_FTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 137 |
EVAL_ACTV_GRADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 138 |
EVAL_ACTV_HRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 139 |
EVAL_ACTV_LOCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 140 |
EVAL_ACTV_OFFICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 141 |
EVAL_ACTV_PYGRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 142 |
EVAL_ACTV_REGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 143 |
EVAL_ACTV_REGTMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 144 |
EVAL_ACTV_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 145 |
EVAL_ACTV_SVC |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 146 |
EVAL_ACTV_UNION |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 147 |
EVAL_ACTV_MEDICARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Y/N Table Edit
Default Value: N
|
| 148 |
GVT_DATE_USE |
Character(4) |
VARCHAR2(4) NOT NULL |
Calc Service Using
HIR=Hire Date
SVC=Service Comp Date - Leave
Default Value: SVC
|
| 149 |
GVT_ELIG_FLG_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 150 |
GVT_ELIG_FLG_FEHB |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible
I=Ineligible
Default Value: E
|
| 151 |
GVT_ELIG_USE_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use Ret Status
E=Eligibile
I=Ineligible
Y/N Table Edit
Default Value: Y
|
| 152 |
GVT_ELIG_USE_FEHB |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules Use FEHB Elig
Y/N Table Edit
Default Value: Y
|
| 153 |
GVT_GRP_MTHD_FEHB |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 154 |
GVT_GRP_MTHD_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1
|
| 155 |
GVT_EVAL_MTHD_FEHB |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 156 |
GVT_EVAL_MTHD_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group
2=All in Group
Default Value: 1
|
| 157 |
GVT_EVAL_ACTV_FEHB |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Default Value: N
|
| 158 |
GVT_EVAL_ACTV_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Default Value: N
|