RETRODED_SUM_VW(SQL View) |
Index Back |
|---|---|
Retroded Summary ViewThis is a view of RETRODED_RQST and RETRODED_DEDS that shows the total retroactive deduction calculations for all employees processed in Retro Deds.. |
| SELECT DISTINCT b.emplid ,b.EMPL_RCD ,a.mass_retro_rqst_id ,b.retroded_seq_no ,b.retroded_effdt ,a.retroded_rqst_type ,a.retroded_pgm_id ,b.retroded_prcs_flag ,b.plan_type ,B.COMPANY ,b.benefit_plan ,b.dedcd ,b.ded_class ,a.duplicate_flag ,SUM(b.retroded_ded_amt) FROM ps_retroded_rqst a ,PS_RETRODED_DEDS b WHERE a.retroded_seq_no = b.retroded_seq_no AND b.ok_to_process = 'Y' GROUP BY b.emplid ,b.EMPL_RCD ,a.mass_retro_rqst_id ,b.retroded_seq_no ,b.retroded_effdt ,a.retroded_rqst_type ,a.retroded_pgm_id ,b.retroded_prcs_flag ,b.plan_type ,B.COMPANY ,b.benefit_plan ,b.dedcd ,b.ded_class ,a.duplicate_flag |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL | Mass Retro Request ID |
| 4 | RETRODED_SEQ_NO | Character(8) | VARCHAR2(8) NOT NULL | Retro Ded Sequence Number |
| 5 | RETRODED_EFFDT | Date(10) | DATE | Retro Ded Effective Date |
| 6 | RETRODED_RQST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Retro Ded Request Type
A=Benefits Administration B=Benefit Deduction G=General Deduction J=Job Change M=Mass Request P=Benefit Program Change |
| 7 | RETRODED_PGM_ID | Character(3) | VARCHAR2(3) NOT NULL | Retro Ded Program ID |
| 8 | RETRODED_PRCS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Retro Ded Process Flag
C=Calculated I=Invalidated N=Not Processed P=Loaded to Paysheet R=Rejected X=Extracted |
| 9 | 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. |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 11 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 12 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 13 | 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 |
| 14 | DUPLICATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Flag
Y/N Table Edit Default Value: N |
| 15 | RETRODED_DED_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Retro Deduction Amount |