RETRODED_DEDS (SQL Table)	Index Back
Retro Deduction Ded Table This is the table of deductions that have been extracted and calculated for the Retro Deductions process. Warning! For technical reasons, this record's schema contains an alternate key of EMPL_RCD. This is not logically or functionally accurate. Throughout all of Base Benefits, when in the context of benefit enrollment, EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records (and by extension, benefit deductions) are logically keyed by BENEFIT_RCD_NBR, so here EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to this record be against BENEFIT_RCD_NBR. Thus a typical driving join for benefit participation is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_BEN_PROG_PARTIC.EMPL_RCD, and a typical join for benefit enrollment is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_HEALTH_BENEFIT.EMPL_RCD. The security and search views used in Base Benefits perform this "mapping" internally.

RETRODED_DEDS

(SQL Table)

Retro Deduction Ded Table

This is the table of deductions that have been extracted and calculated for the Retro Deductions process. Warning! For technical reasons, this record's schema contains an alternate key of EMPL_RCD. This is not logically or functionally accurate. Throughout all of Base Benefits, when in the context of benefit enrollment, EMPL_RCD must be interpreted as an alias for BENEFIT_RCD_NBR. All benefit enrollment-related records (and by extension, benefit deductions) are logically keyed by BENEFIT_RCD_NBR, so here EMPL_RCD actually contains the value of the appropriate BENEFIT_RCD_NBR. It is CRITICAL that all joins, comparisons, and updates to this record be against BENEFIT_RCD_NBR. Thus a typical driving join for benefit participation is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_BEN_PROG_PARTIC.EMPL_RCD, and a typical join for benefit enrollment is PS_PER_ORG_ASGN.BENEFIT_RCD_NBR = PS_HEALTH_BENEFIT.EMPL_RCD. The security and search views used in Base Benefits perform this "mapping" internally.

Parent record: RETRODED_RQST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RETRODED_SEQ_NO Character(8) VARCHAR2(8) NOT NULL Retro Ded Sequence Number

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

3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

4 PAY_END_DT Date(10) DATE Pay Period End Date

5 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
Y/N Table Edit
Default Value: N

6 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #

7 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #

8 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.

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.
Prompt Table: RETRODEDPGM_DEF

10 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: RETRODEDPGM_DEF

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

12 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: RETRODEDPGM_DEF

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

14 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

15 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: RETRODEDPGM_DEF

16 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code
Prompt Table: RETRODEDPGM_DEF

17 RETRODED_EFFDT Date(10) DATE Retro Ded Effective Date

18 DEDUCT_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Deducted Amount

19 NEW_DEDUCT_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL New Deducted Amount

20 DEDUCT_AMT_OVRD Signed Number(12,2) DECIMAL(10,2) NOT NULL Deducted Amount Override

21 RETRODED_DED_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Retro Deduction Amount

22 RETRODED_DED_TYPE Character(1) VARCHAR2(1) NOT NULL Retro Deduction Type
A=Arrears
N=No Difference
R=Refund

23 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

24 EXCEPTION_FLAG Character(1) VARCHAR2(1) NOT NULL Exception - Chg in Pay Period
Y/N Table Edit
Default Value: N

25 OK_TO_PROCESS Character(1) VARCHAR2(1) NOT NULL OK To Process
Y/N Table Edit
Default Value: N

26 JOB_PAY Character(1) VARCHAR2(1) NOT NULL Job Pay
Y/N Table Edit
Default Value: N

27 RETRO_SEPCHK Number(1,0) SMALLINT NOT NULL Retro Pay Separate Check No.

28 TERM_EMPL_PRCS Character(1) VARCHAR2(1) NOT NULL Terminated Employees Processed
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RETRODED_SEQ_NO	Character(8)	VARCHAR2(8) NOT NULL	Retro Ded Sequence Number
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
4	PAY_END_DT	Date(10)	DATE	Pay Period End Date
5	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N
6	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
7	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
8	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
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. Prompt Table: RETRODEDPGM_DEF
10	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: RETRODEDPGM_DEF
11	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: RETRODEDPGM_DEF
12	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: RETRODEDPGM_DEF
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
14	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
15	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules. Prompt Table: RETRODEDPGM_DEF
16	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code Prompt Table: RETRODEDPGM_DEF
17	RETRODED_EFFDT	Date(10)	DATE	Retro Ded Effective Date
18	DEDUCT_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deducted Amount
19	NEW_DEDUCT_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	New Deducted Amount
20	DEDUCT_AMT_OVRD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Deducted Amount Override
21	RETRODED_DED_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Retro Deduction Amount
22	RETRODED_DED_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Retro Deduction Type A=Arrears N=No Difference R=Refund
23	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
24	EXCEPTION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception - Chg in Pay Period Y/N Table Edit Default Value: N
25	OK_TO_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	OK To Process Y/N Table Edit Default Value: N
26	JOB_PAY	Character(1)	VARCHAR2(1) NOT NULL	Job Pay Y/N Table Edit Default Value: N
27	RETRO_SEPCHK	Number(1,0)	SMALLINT NOT NULL	Retro Pay Separate Check No.
28	TERM_EMPL_PRCS	Character(1)	VARCHAR2(1) NOT NULL	Terminated Employees Processed Y/N Table Edit Default Value: N