PA_CLC_PEL_AY (SQL Table)	Index Back
Calc Results Plan Eligibility This is an employee table containing Calc Results for Plan Eligibility.

PA_CLC_PEL_AY

(SQL Table)

Calc Results Plan Eligibility

This is an employee table containing Calc Results for Plan Eligibility.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CALC_NAME Character(20) VARCHAR2(20) NOT NULL Calculation Name

2 CALC_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL Calc Seq Num

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

5 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name

6 START_DT Date(10) DATE Start Date

7 STOP_DT Date(10) DATE Stop Date

8 ELIG_STATUS_PA Character(1) VARCHAR2(1) NOT NULL Eligibility Status
N=Ineligible
P=Previously Eligible
Y=Eligible

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
2	CALC_SEQ_NUM	Number(9,0)	DECIMAL(9) NOT NULL	Calc Seq Num
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
5	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
6	START_DT	Date(10)	DATE	Start Date
7	STOP_DT	Date(10)	DATE	Stop Date
8	ELIG_STATUS_PA	Character(1)	VARCHAR2(1) NOT NULL	Eligibility Status N=Ineligible P=Previously Eligible Y=Eligible