SVC_STEP_PCT (SQL Table)	Index Back
Svc Stp-Ded Class % / Interval Defines the matching percentage for each step interval by dedcuction class.

SVC_STEP_PCT

(SQL Table)

Svc Stp-Ded Class % / Interval

Defines the matching percentage for each step interval by dedcuction class.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SVC_STEP_TBL_ID Character(6) VARCHAR2(6) NOT NULL Service Step Table ID
Prompt Table: SVC_STEP_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 SERVICE_INTERVALS Number(5,0) INTEGER NOT NULL Service Intervals
Prompt Table: SVC_STEP_COVG

4 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
Default Value: B

5 PCT_EMPL_CONTRBUTN Number(7,3) DECIMAL(6,3) NOT NULL Percent of Employee Contributn

6 PCT_EMPL_INVESTMNT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Employee Investment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SVC_STEP_TBL_ID	Character(6)	VARCHAR2(6) NOT NULL	Service Step Table ID Prompt Table: SVC_STEP_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	SERVICE_INTERVALS	Number(5,0)	INTEGER NOT NULL	Service Intervals Prompt Table: SVC_STEP_COVG
4	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 Default Value: B
5	PCT_EMPL_CONTRBUTN	Number(7,3)	DECIMAL(6,3) NOT NULL	Percent of Employee Contributn
6	PCT_EMPL_INVESTMNT	Number(7,3)	DECIMAL(6,3) NOT NULL	Percent of Employee Investment