EMPLIDPrompt Table: PERSON
BNE_OE_CTX_VW(SQL View) |
Index Back |
|---|---|
Active Open Enrollment Eventreturn the active open enrollment events( EVENT_CLASS='EO' and EVENT_STATUS='O' |
| SELECT EMPLID , GVT_OS_BEGIN_DT , GVT_OS_END_DT ,' ' FROM PS_BAS_PARTIC EVENT , PS_BAS_SCHED SCHED , PS_BAS_OE_DEFN OE WHERE EVENT.SCHED_ID=SCHED.SCHED_ID AND SCHED.OE_DEFN_ID=OE.OE_DEFN_ID AND EVENT.EVENT_CLASS='OE' AND EVENT.EVENT_STATUS='O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | FROM_DT | Date(10) | DATE | From Date |
| 3 | TO_DT | Date(10) | DATE | To Date |
| 4 | DESCR120 | Character(120) | VARCHAR2(120) NOT NULL | This is used to store Female Description of Civil Service Ranks. |