DED_ARR_SUM_VW (SQL View)	Index Back
EE Deduction Arrears This record shows summary of employee deduction arrears balances accross benefit record numbers.

DED_ARR_SUM_VW

(SQL View)

EE Deduction Arrears

This record shows summary of employee deduction arrears balances accross benefit record numbers.

SELECT EMPLID , COMPANY , PLAN_TYPE , BENEFIT_PLAN , BENEFIT_RCD_NBR , DEDCD , DED_CLASS , SUM(ARREARS_BAL) FROM PS_DED_ARREARS GROUP BY EMPLID ,COMPANY ,PLAN_TYPE ,BENEFIT_PLAN ,BENEFIT_RCD_NBR ,DEDCD ,DED_CLASS

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

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 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

6 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Prompt Table: BEN_PROG_BENDED

7 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
Prompt Table: DEDUCTION_CLASS

8 ARREARS_BAL Signed Number(12,2) DECIMAL(10,2) NOT NULL Arrears Balance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
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	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
6	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: BEN_PROG_BENDED
7	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 Prompt Table: DEDUCTION_CLASS
8	ARREARS_BAL	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Arrears Balance