ELIG_RULES_IDPrompt Table: BAS_ELIG_RULES
EFFDTDefault Value: %date
BEN_STATUSA=Active
D=Deceased
L=Leave of Absence
P=Leave With Benefits
Q=Retired With Benefits
R=Retired
S=Suspended
T=Terminated
U=Terminated With Benefits
BAS_ELIG_BNSTAT(SQL Table) |
Index Back |
|---|---|
BenAdmin Elig Ben_StatusBAS_ELIG_BNSTAT is one of the records that identify benefit program/option eligibility criteria. It is used to record what employee's status is 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 | BEN_STATUS |
Character(4) | VARCHAR2(4) NOT NULL |
Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
A=Active D=Deceased L=Leave of Absence P=Leave With Benefits Q=Retired With Benefits R=Retired S=Suspended T=Terminated U=Terminated With Benefits |