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
IVXPA
IVXPA

Version management

Difference between version and

At line 1 changed 2 lines
[{TableOfContents }]
!!!PENSION ACCOUNT INTERFACE FILE
!!!Alias: [IVXPA]
(INF_CV_PNACCOUNTS)
\\
At line 4 changed one line
The Pension Account Interface File screen is used to import pension accounts into the software data structures.
Pension Accounts
At line 6 changed one line
Pension Account Interface File data is maintained on the [INF_CV_PNACCOUNTS] table.
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[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)| |
At line 8 removed 19 lines
;[ID|ID]:This field identifies the pension account record within the data base.
;[Pension Plan|PENSION_PLAN_CODE]:This field identifies the pension plan associated with this account.
;[Entity|ENTITY_CODE]:The entity associated with the pension plan is displayed in this field.
;[PN Account|PENSION_OPTION_CODE]:The Pension Option field identifies the option the employee has selected upon official retirement. This field is only completed once the employee retires.
;[Person Code|PERSON_CODE]:This field identifies the person associated with this account.
;[PN Account|PENSION_ACCOUNT_CODE]:This field displays the pension account.
;[Enrolled On|ENROLLMENT_DATE]:This field displays the date the EE was enrolled in the pension plan.
;[Adj. Enrollment Date|ADJUSTED_ENROLLMENT_DATE]:This field displays the override date the employee was enrolled.
;[Vested On|VESTED_DATE]:This field displays the date on which the employee was vested within the plan.
;[Retired On|RETIREMENT_DATE]:This field displays the retirement date for this employee.
;[Start Date of Annuity|ANNUITY_START_DATE]:If the member is receiving a benefit, this indicates the date the payment started.
;[Deceased as of|DECEASED_DATE]:The date on which the member became deceased.
;[Service Connected Death|SERVICE_CONNECTED_DEATH]:This field indicates if the employee’s death was connected to their employment.
;[O/R Vest Percentage|OVERRIDE_VEST_PERCENTAGE]:This field displays the vesting factor (50%, 75%, etc.). This is an override field.
;[Change Reason|CHANGE_CODE]:This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date.
;[PN Account Status|PENSION_STATUS_CODE]:This field will display the status of the account.
;[Effective As Of|EFFECTIVE]/[Expires On|EXPIRY]:If the account is time sensitive, these fields will indicate the dates it is effective.
;[Pension Account Text Details|PENSION_ACCOUNT_TEXT_DETAILS]:This field allows you to enter in details about the pension account.
;[Pension Plan Details|PENSION_PLAN_DETAILS]:This field allows you to enter in details about the pension plan.
At line 32 added one line
[{If var='loginstatus' contains 'authenticated'
At line 30 changed 2 lines
![Notes|Edit:Internal.IVXPA]
[{InsertPage page='Internal.IVXPA' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IVXPA]
[{InsertPage page='Internal.IVXPA' default='Click to create a new discussion page'}]
At line 33 changed one line
}]
This page (revision-8) was last changed on 26-Nov-2021 10:22 by jmyersTop