PA_MORT_RATES (SQL Table)	Index Back
Mortality Rates This is a setup table containing mortality rates.

PA_MORT_RATES

(SQL Table)

Mortality Rates

This is a setup table containing mortality rates.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MORT_TABLE_NAME Character(10) VARCHAR2(10) NOT NULL Mortality Table Name

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 MORT_AGE Number(3,0) SMALLINT NOT NULL Mortality Lookup Age

4 MORT_RATE Number(8,6) DECIMAL(7,6) NOT NULL Mortality Rate

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MORT_TABLE_NAME	Character(10)	VARCHAR2(10) NOT NULL	Mortality Table Name
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	MORT_AGE	Number(3,0)	SMALLINT NOT NULL	Mortality Lookup Age
4	MORT_RATE	Number(8,6)	DECIMAL(7,6) NOT NULL	Mortality Rate