BAS_ELIG_OFFICR (SQL Table)	Index Back
BenAdmin Elig Officer code BAS_ELIG_OFFICR is one of the records that identify benefit program/option eligibility criteria. It is used to record what officer codes are eligible for a given benefit program and/or option. It is created online by the Eligibility panels under Benefits Administration tables. The information is used for processing Benefits Administration.

BAS_ELIG_OFFICR

(SQL Table)

BenAdmin Elig Officer code

BAS_ELIG_OFFICR is one of the records that identify benefit program/option eligibility criteria. It is used to record what officer codes are eligible for a given benefit program and/or option. It is created online by the Eligibility panels under Benefits Administration tables. The information is used for processing Benefits Administration.

Parent record: BAS_ELIG_RULES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ELIG_RULES_ID Character(4) VARCHAR2(4) NOT NULL Eligibility Rules ID
Prompt Table: BAS_ELIG_RULES

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ELIG_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Eligibility Rules ID Prompt Table: BAS_ELIG_RULES
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	OFFICER_CD	Character(1)	VARCHAR2(1) NOT NULL	Officer Code C=Chairman D=Director N=None O=Officer P=President S=Secretary T=Treasurer V=Vice President