PY_REDUCE_ERN (SQL Table)	Index Back
Earnings Reduced Earnings Reduced under ACT H.R. 6201

PY_REDUCE_ERN

(SQL Table)

Earnings Reduced

Earnings Reduced under ACT H.R. 6201

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_EARN_CATEGORY Character(5) VARCHAR2(5) NOT NULL Earnings Category to group varies sick leave earnings codes. The purpose of this field is developed for COVID-19 sick leaves.

2 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
Prompt Table: EARNINGS_TBL

3 PY_LIMIT_DAILY Number(11,2) DECIMAL(10,2) NOT NULL Daily Limit Amount

4 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
E=Exempt
H=ER FICA Exmpt
J=EE FICA Exmpt
K=EE/ER FICA Exmpt
M=Medicare only
N=Subject

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_EARN_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Earnings Category to group varies sick leave earnings codes. The purpose of this field is developed for COVID-19 sick leaves.
2	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_TBL
3	PY_LIMIT_DAILY	Number(11,2)	DECIMAL(10,2) NOT NULL	Daily Limit Amount
4	FICA_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	FICA Status-Employee E=Exempt H=ER FICA Exmpt J=EE FICA Exmpt K=EE/ER FICA Exmpt M=Medicare only N=Subject