BAS_ELIG_DBGVAL (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_DBGVAL

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

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

10 BENEFIT_RCD_JOB Number(3,0) SMALLINT NOT NULL Benefit Record Number

11 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

12 PRIMARY_JOB_IND Character(1) VARCHAR2(1) NOT NULL Primary Job used by applications other than HR
N=Stop Primary
Y=Start Primary
Y/N Table Edit

13 PRIMARY_FLAG1 Character(1) VARCHAR2(1) NOT NULL Include Job for Eligibility
Y/N Table Edit

14 ELIG_VALUE Character(20) VARCHAR2(20) NOT NULL Field Value

15 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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
10	BENEFIT_RCD_JOB	Number(3,0)	SMALLINT NOT NULL	Benefit Record Number
11	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
12	PRIMARY_JOB_IND	Character(1)	VARCHAR2(1) NOT NULL	Primary Job used by applications other than HR N=Stop Primary Y=Start Primary Y/N Table Edit
13	PRIMARY_FLAG1	Character(1)	VARCHAR2(1) NOT NULL	Include Job for Eligibility Y/N Table Edit
14	ELIG_VALUE	Character(20)	VARCHAR2(20) NOT NULL	Field Value
15	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