DEP_RULE_IDEFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
Default Value: 99
Y/N Table Edit
Default Value: Y
Default Value: 99
E=On the Event Date
M=On Month-Begin After Event Dt
Default Value: E
DEP_RULE_TBL(SQL Table) |
Index Back |
|---|---|
Dependent Rule TableDefines dependent age limits and other attributes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEP_RULE_ID |
Character(5) | VARCHAR2(5) NOT NULL | Dependent Rules ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DEPENDENT_MARRIAGE | Character(1) | VARCHAR2(1) NOT NULL |
Dependent Ineligible if Married Flag
Y/N Table Edit Default Value: N |
| 6 | DEP_AGE_LIMIT | Number(2,0) | SMALLINT NOT NULL |
Dependent Age Limit
Default Value: 99 |
| 7 | EXCL_DISABLED_AGE | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Disabled from Age Limit
Y/N Table Edit Default Value: Y |
| 8 | STUDENT_AGE_LIMIT | Number(2,0) | SMALLINT NOT NULL |
Student Age Limit
Default Value: 99 |
| 9 | OVERAGE_PD_BEG_CD | Character(1) | VARCHAR2(1) NOT NULL |
COBRA Overage Period Begins
E=On the Event Date M=On Month-Begin After Event Dt Default Value: E |