GPUS_BENRPT_TMP(SQL Table) |
Index Back |
|---|---|
Benefit Reports Temp TableTemporary table populated by the AE program GPUS_BEN_AE and used by the GP US specific benefit reports |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 4 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 5 | DED_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit |
| 6 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 7 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
| 8 | GPUS_YTD_DED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Year to Date Deduction |
| 9 | GPUS_QTD_DED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Quarter to Date Deduction |
| 10 | GPUS_MTD_DED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Month to Date Deduction |