This page (revision-8) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
8 26-Nov-2021 10:22 2 KB jmyers to previous
7 26-Nov-2021 10:22 2 KB jmyers to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 3 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 9 changed 19 lines
|[PENSION_PLAN_CODE]|Varchar2(16)|Y|
|[ENTITY_CODE]|Varchar2(16)|Y|
|[PENSION_OPTION_CODE]|Varchar2(16)| |
|[PERSON_CODE]|Varchar2(16)|Y|
|[PENSION_ACCOUNT_CODE]|Varchar2(16)|Y|
|[ENROLLMENT_DATE]|Date()|Y|
|[ADJUSTED_ENROLLMENT_DATE]|Date()| |
|[VESTED_DATE]|Date()| |
|[RETIREMENT_DATE]|Date()| |
|[ANNUITY_START_DATE]|Date()| |
|[DECEASED_DATE]|Date()| |
|[SERVICE_CONNECTED_DEATH]|Varchar2(4)| |
|[OVERRIDE_VEST_PERCENTAGE]|Number(18)| |
|[CHANGE_CODE]|Varchar2(16)| |
|[PENSION_STATUS_CODE]|Varchar2(16)| |
|[EFFECTIVE]|Date()| |
|[EXPIRY]|Date()| |
|[PENSION_ACCOUNT_TEXT_DETAILS]|Varchar2(4000)| |
|[PENSION_PLAN_DETAILS]|Varchar2(16)| |
;[Pension Plan|PENSION_PLAN_CODE]:
;[Entity|ENTITY_CODE]:
;[PN Account|PENSION_OPTION_CODE]:
;[Person Code|PERSON_CODE]:
;[PN Account|PENSION_ACCOUNT_CODE]:
;[Enrolled On|ENROLLMENT_DATE]:
;[Adj. Enrollment Date|ADJUSTED_ENROLLMENT_DATE]:
;[Vested On|VESTED_DATE]:
;[Retired On|RETIREMENT_DATE]:
;[Start Date of Annuity|ANNUITY_START_DATE]:
;[Deceased as of|DECEASED_DATE]:
;[Service Connected Death|SERVICE_CONNECTED_DEATH]:
;[O/R Vest Percentage|OVERRIDE_VEST_PERCENTAGE]:
;[Change Reason|CHANGE_CODE]:
;[PN Account Status|PENSION_STATUS_CODE]:
;[Effective As Of|EFFECTIVE]:
;[Expires On|EXPIRY]:
;[Pension Account Text Details|PENSION_ACCOUNT_TEXT_DETAILS]:
;[Pension Plan Details|PENSION_PLAN_DETAILS]: