PA_CLC_DATES (SQL Table)	Index Back
Calc Output Dates This is an employee table containing Calc Output for Dates.

PA_CLC_DATES

(SQL Table)

Calc Output Dates

This is an employee table containing Calc Output for Dates.

# 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
Default Value: PA_CALCULATION.CALC_SEQ_NUM

3 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: PA_PLAN_ORDER

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

5 BEN_CMCMNT_AGE Number(5,2) DECIMAL(4,2) NOT NULL Benefit Commencement Age/YY.MM

6 BEN_CMAGE_DEC Number(10,6) DECIMAL(9,6) NOT NULL Benefit Comencement Age

7 LUMP_SUM_AGE Number(5,2) DECIMAL(4,2) NOT NULL Lump Sum Age(YY.MM)

8 LUMP_AGE_DEC Number(10,6) DECIMAL(9,6) NOT NULL Lump Sum Age

9 BEN_CMDT_DATE Date(10) DATE Benefit Commencement Date

10 LUMP_SUM_DT Date(10) DATE Lump Sum Date

#	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 Default Value: PA_CALCULATION.CALC_SEQ_NUM
3	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: PA_PLAN_ORDER
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	BEN_CMCMNT_AGE	Number(5,2)	DECIMAL(4,2) NOT NULL	Benefit Commencement Age/YY.MM
6	BEN_CMAGE_DEC	Number(10,6)	DECIMAL(9,6) NOT NULL	Benefit Comencement Age
7	LUMP_SUM_AGE	Number(5,2)	DECIMAL(4,2) NOT NULL	Lump Sum Age(YY.MM)
8	LUMP_AGE_DEC	Number(10,6)	DECIMAL(9,6) NOT NULL	Lump Sum Age
9	BEN_CMDT_DATE	Date(10)	DATE	Benefit Commencement Date
10	LUMP_SUM_DT	Date(10)	DATE	Lump Sum Date