MORT_TABLE_NAMEEFFDTPA_MORT_RATE_VW(SQL View) |
Index Back |
|---|---|
View for Mortality RatesThis is a working view for Mortality Rates. |
| SELECT DISTINCT MORT_TABLE_NAME , EFFDT FROM PS_PA_MORT_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 NOT NULL | Effective Date |