GVT_ACCR_PLAN(SQL Table) |
Index Back |
|---|---|
Employee Accrual Election(s)This record is used to store information regarding the employee's choice of Accrual Plans. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW |
| 3 | GVT_ERN_ACCR_CLASS |
Character(6) | VARCHAR2(6) NOT NULL | Earnings Accrual Class |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | COVERAGE_ELECT | Character(1) | VARCHAR2(1) NOT NULL |
Coverage Election
E=Elect T=Terminate W=Waive Default Value: E |
| 6 | COVERAGE_ELECT_DT | Date(10) | DATE NOT NULL |
Coverage Elect Date
Default Value: %date |
| 7 | GVT_ALT_WORK_SCHED | Character(2) | VARCHAR2(2) NOT NULL |
Alternate Work Schedule
00=None 01=Flexitour 02=Gliding Schedule 03=Variable Day Schedule 04=Variable Week Schedule 05=FWS - Maxiflex 06=FWS - Other 07=CWS - 3 Day Work Week 08=CWS - 4 Day Work Week 09=CWS 5/4-9 Compressed Plan 10=Other Default Value: 00 |
| 8 | GVT_GFATH_CYOVER | Number(9,3) | DECIMAL(8,3) NOT NULL | Grandfathered Carryover |