OE_DEFN_IDPrompt Table: BAS_EVT_CLASS
Prompt Table: BAS_OE_TMPL_VW
Prompt Table: PTGP_IMG_PVW
Prompt Table: PTBR_IMG_PVW
BAS_OE_DEFN(SQL Table) |
Index Back |
|---|---|
BAS OE DefnBAS_OE_DEFN is a record that allows you to establish an ID for a set of benefit programs and plan types to include during Open Enrollment Benefits Administration processing. The record defines the effective date, description, period begin date, and period end date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OE_DEFN_ID |
Character(4) | VARCHAR2(4) NOT NULL | Open Enrollment Definition ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | PERIOD_BEGIN_DT | Date(10) | DATE NOT NULL | Period Begin Date |
| 5 | PERIOD_END_DT | Date(10) | DATE NOT NULL | Period End Date |
| 6 | GVT_OS_BEGIN_DT | Date(10) | DATE | Enrollment Begin Date |
| 7 | GVT_OS_END_DT | Date(10) | DATE | Enrollment End Date |
| 8 | EVENT_CLASS | Character(3) | VARCHAR2(3) NOT NULL |
Event Classification
Prompt Table: BAS_EVT_CLASS |
| 9 | AGC_TEMPLATE_ID | Character(7) | VARCHAR2(7) NOT NULL |
Activity Guide Composer Template Id
Prompt Table: BAS_OE_TMPL_VW |
| 10 | BAS_TILE_IMAGE | Character(30) | VARCHAR2(30) NOT NULL |
Tile Image
Prompt Table: PTGP_IMG_PVW |
| 11 | BAS_TEMPLATE_IMG | Character(30) | VARCHAR2(30) NOT NULL |
Template Image
Prompt Table: PTBR_IMG_PVW |