PA_PEN_VAL_MTX (SQL Table)	Index Back
Actuarial Valuation Matrix This is a setup table containing the file type for each valuation category.

PA_PEN_VAL_MTX

(SQL Table)

Actuarial Valuation Matrix

This is a setup table containing the file type for each valuation category.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_VAL_CODE Character(1) VARCHAR2(1) NOT NULL Prior Year Val Code
A=Active
B=Both (Inactive and Active)
D=Done (no liability remaining)
I=Inactive
N=No Record Exist

2 CY_VAL_CODE Character(1) VARCHAR2(1) NOT NULL Current Year Val Code
A=Active
B=Both (Inactive and Active)
D=Done (no liability remaining)
I=Inactive
N=No Record Exist

3 ACTIVE_EXTRACT Character(1) VARCHAR2(1) NOT NULL Active Valuation Extract
Y/N Table Edit

4 INACTIVE_EXTRACT Character(1) VARCHAR2(1) NOT NULL Inactive Valuation Extract
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_VAL_CODE	Character(1)	VARCHAR2(1) NOT NULL	Prior Year Val Code A=Active B=Both (Inactive and Active) D=Done (no liability remaining) I=Inactive N=No Record Exist
2	CY_VAL_CODE	Character(1)	VARCHAR2(1) NOT NULL	Current Year Val Code A=Active B=Both (Inactive and Active) D=Done (no liability remaining) I=Inactive N=No Record Exist
3	ACTIVE_EXTRACT	Character(1)	VARCHAR2(1) NOT NULL	Active Valuation Extract Y/N Table Edit
4	INACTIVE_EXTRACT	Character(1)	VARCHAR2(1) NOT NULL	Inactive Valuation Extract Y/N Table Edit