!!!Alias: BOEE (P2K_BE_OPEN_ENROLLMENT_EES) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD: [ERD-BE60] \\ !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[EEM_ID]|Number(10)|[ID]|Y|link to [P2K_HR_EMPLOYMENTS] |[BOE_ID]|Number(10)|[ID]|Y|link to [P2K_BE_OPEN_ENROLLMENTS] |[ELECTION_STAGE]|Varchar2(2)|[X_BE_OE_ELECTION_STAGE]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[BEV_ID]|Number(10)|[ID]| |link to [P2K_BE_EVENTS] |[EMPLOYEE_SIGN_OFF]|Varchar2(1)|[TOGGLE]| | New in 40800 !![Derived Fields|DERIVED FIELDS] ||Column Name |[DRV_APPROVAL_BAR] |[DRV_TOTAL_DECLINED] |[DRV_TOTAL_PLANS] |[DRV_TOTAL_TO_BE_DECIDED] |[DRV_VIEW_MONTH] |[DRV_VIEW_PERIOD] |[DRV_VIEW_YEAR] |[DRV_PLAN_ELECTION_SET_CODE] User Fields: Allowed\\ Audit Logging: Allowed\\ [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.P2K_BE_OPEN_ENROLLMENT_EES] [{InsertPage page='Internal.P2K_BE_OPEN_ENROLLMENT_EES' default='Click to create a new discussion page'}] }]