BAS_ELIG_DBGFLD (SQL Table)	Index Back
Eligibility Debugging BAS_ELIG_DBG and it's children, BAS_ELIG_DBGFLD and BAS_ELIG_DBGVAL, hold the results of eligiiblity tests peformed by the Ben Admin batch process. BAS_ELIG_DBGFLD holds the overall result of each field comparison, while BAS_ELIG_DBGVAL holds the individual results for each job evaluated.

BAS_ELIG_DBGFLD

(SQL Table)

Eligibility Debugging

BAS_ELIG_DBG and it's children, BAS_ELIG_DBGFLD and BAS_ELIG_DBGVAL, hold the results of eligiiblity tests peformed by the Ben Admin batch process. BAS_ELIG_DBGFLD holds the overall result of each field comparison, while BAS_ELIG_DBGVAL holds the individual results for each job evaluated.

Parent record: BAS_ELIG_DBG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

3 ELIG_RULES_ID Character(4) VARCHAR2(4) NOT NULL Eligibility Rules ID

4 RULE_OR_GEOG Character(1) VARCHAR2(1) NOT NULL Rule or Geographic Eligibility
G=Geographic Location Table
R=Eligibility Rule

5 OPTION_TYPE Character(1) VARCHAR2(1) NOT NULL Option Type
D=General Deduction
G=General Credit
O=Option
P=Program
W=Waive Option

6 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

7 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

8 ELIG_FIELD Character(4) VARCHAR2(4) NOT NULL Field Compared

9 ELIG_LINK_TYPE Character(4) VARCHAR2(4) NOT NULL Benefits Administration: Defines the relationship (And/Or) between the Eligibility Field, and the "Linked" Eligibility Field.
AND=And
NONE=None
OR=Or
Default Value: NONE

10 ELIG_LINK_FIELD Character(4) VARCHAR2(4) NOT NULL Linked Eligibility Field

11 GRP_MTHD Character(1) VARCHAR2(1) NOT NULL Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs

12 EVAL_MTHD Character(1) VARCHAR2(1) NOT NULL Evaluation Method
1=One or More in Group
2=All in Group
3=Sum

13 EVAL_ACTV Character(1) VARCHAR2(1) NOT NULL Consider Active Jobs Only
Y/N Table Edit

14 ELIG_FLG_TEST Character(2) VARCHAR2(2) NOT NULL Eligible or Ineligible
E=Eligible
EO=Eligible - Override
I=Ineligible
IO=Ineligible - Override
IS=Included in Sum
NE=Not Evaluated
NL=Not in List

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
3	ELIG_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Eligibility Rules ID
4	RULE_OR_GEOG	Character(1)	VARCHAR2(1) NOT NULL	Rule or Geographic Eligibility G=Geographic Location Table R=Eligibility Rule
5	OPTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Option Type D=General Deduction G=General Credit O=Option P=Program W=Waive Option
6	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
7	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
8	ELIG_FIELD	Character(4)	VARCHAR2(4) NOT NULL	Field Compared
9	ELIG_LINK_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Benefits Administration: Defines the relationship (And/Or) between the Eligibility Field, and the "Linked" Eligibility Field. AND=And NONE=None OR=Or Default Value: NONE
10	ELIG_LINK_FIELD	Character(4)	VARCHAR2(4) NOT NULL	Linked Eligibility Field
11	GRP_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Group Method 1=Primary Job in Benefit Record 2=Flagged Jobs in Benefit Record 3=All Flagged Jobs
12	EVAL_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Evaluation Method 1=One or More in Group 2=All in Group 3=Sum
13	EVAL_ACTV	Character(1)	VARCHAR2(1) NOT NULL	Consider Active Jobs Only Y/N Table Edit
14	ELIG_FLG_TEST	Character(2)	VARCHAR2(2) NOT NULL	Eligible or Ineligible E=Eligible EO=Eligible - Override I=Ineligible IO=Ineligible - Override IS=Included in Sum NE=Not Evaluated NL=Not in List