PA_CLC_VAL_DT (SQL Table)	Index Back
Calc Resutls Date Fields This is an employee table containing the Calc Results which are date fields. This table contains results from multiple funtions run during the calculation.

PA_CLC_VAL_DT

(SQL Table)

Calc Resutls Date Fields

This is an employee table containing the Calc Results which are date fields. This table contains results from multiple funtions run during the calculation.

# 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 FLD_SEQ_NUM Number(3,0) SMALLINT NOT NULL Field Sequence Number

7 FLD_NAME Character(18) VARCHAR2(18) NOT NULL Field Name

8 FLD_VAL_DT_NOVRD Date(10) DATE Value - No Override

#	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	FLD_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Field Sequence Number
7	FLD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name
8	FLD_VAL_DT_NOVRD	Date(10)	DATE	Value - No Override