BAS_ELIG_MED(SQL Table) |
Index Back |
---|---|
BenAdmin Elig MedicareBAS_ELIG_MEDICARE is one of the records that identify benefit program/option eligibility criteria. It is used to record what Medicares 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. |
# | 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 | MEDICARE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Medicare Indicator
A=Medicare A B=Medicare B D=Medicare D |