DEFINITION_NAMECLAUSE_KEYA=Later of (i.e. "And")
O=Earlier of (i.e. "OR")
Default Value: O
Prompt Table: PA_DURATION
Prompt Table: PA_DFN_SVC_VW
Prompt Table: PA_CUSTOM
PA_DFN_BEN_ELIG(SQL Table) |
Index Back |
|---|---|
Benefit EligiblityThis is a setup table containing Benefit Eligiblity parameters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEFINITION_NAME |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 2 | CLAUSE_KEY |
Character(10) | VARCHAR2(10) NOT NULL | Clause Name |
| 3 | ORDER_NUM | Number(3,0) | SMALLINT NOT NULL | Order of Clauses in Definition |
| 4 | CLAUSE_COMPARISON | Character(1) | VARCHAR2(1) NOT NULL |
Clause Comparison
A=Later of (i.e. "And") O=Earlier of (i.e. "OR") Default Value: O |
| 5 | AGE_MINIMUM | Number(3,0) | SMALLINT NOT NULL | Age Minimum |
| 6 | AGE_DEFINITION | Character(10) | VARCHAR2(10) NOT NULL |
Age Calculation Method
Prompt Table: PA_DURATION |
| 7 | SERVICE_MINIMUM | Number(3,0) | SMALLINT NOT NULL | Service Minimum Years |
| 8 | SERVICE_DEFINITION | Character(10) | VARCHAR2(10) NOT NULL |
Service Result Name
Prompt Table: PA_DFN_SVC_VW |
| 9 | POINTS_MINIMUM | Number(3,0) | SMALLINT NOT NULL | Minimum Points |
| 10 | DB_CUSTOM_STMT | Character(10) | VARCHAR2(10) NOT NULL |
Custom Statement
Prompt Table: PA_CUSTOM |