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

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
11 26-Nov-2021 10:22 2 KB rforbes to previous
10 26-Nov-2021 10:22 2 KB JMyers to previous | to last
9 26-Nov-2021 10:22 2 KB JMyers to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 6 KB JMyers to previous | to last
5 26-Nov-2021 10:22 5 KB JMyers to previous | to last
4 26-Nov-2021 10:22 5 KB JMyers to previous | to last
3 26-Nov-2021 10:22 4 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 1 changed one line
!!!PENSION RECIPIENTS INTERFACE FILE
!!!Alias: IVXPR
(INF_CV_PNRECIPIENTS)
\\
At line 3 changed one line
The Pension Recipients Interface File screen is used to import pension recipients into the software data structures.
Pension Recipients
At line 5 changed one line
Pension Recipients Interface File data is maintained on the [INF_CV_PNRECIPIENTS] 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_ACCOUNT_CODE]|Varchar2(16)|Y|
|[PERSON_CODE_OWNER]|Varchar2(16)|Y|
|[PERSON_CODE_RECPT]|Varchar2(16)| |
|[RECIPIENT_CATEGORY]|Varchar2(30)|Y|
|[DECEASED_DATE]|Date()| |
|[INCLUDE_COLA]|Varchar2(4)| |
|[FIRST_NAME]|Varchar2(50)| |
|[LAST_NAME]|Varchar2(50)| |
|[RELATION]|Varchar2(30)| |
|[EMPLOYER]|Varchar2(50)| |
|[EFFECTIVE]|Date()| |
|[EXPIRY]|Date()| |
|[RECIPIENT_STATUS]|Varchar2(30)| |
|[PAYMENT_SEQUENCE]|Number(10)| |
|[PAYMENT_AMOUNT]|Number(14)| |
|[PAYMENT_PERCENT]|Number(18)| |
|[CHANGE_CODE]|Varchar2(16)| |
At line 7 changed 19 lines
;[ID|ID]:This field identifies the pension recipients record within the data base.
;[Pension Plan|PENSION_PLAN_CODE]:This field displays the pension plan associated with this account.
;[Entity|ENTITY_CODE]:The entity associated with the pension recipient
;[PN Account|PENSION_ACCOUNT_CODE]:This field displays the pension account.
;[Owner (EE#)|PERSON_CODE_OWNER]:
;[Recipient (EE#)|PERSON_CODE_RECPT]:
;[Category|RECIPIENT_CATEGORY]:This field displays the type of relation the contact is to the member.
;[Deceased as of|DECEASED_DATE]:The date on which the member became deceased
;[Include COLA|INCLUDE_COLA]:This field indicates if the recipient should receive a cost of living expense.
;[First Name|FIRST_NAME]:This is the first name of the person associated with this account.
;[Last Name|LAST_NAME]:This is the last name of the person associated with this account.
;[Relation|RELATION]:If the person receiving the payment is not the employee, the relationship between that person and the employee is displayed in this field.
;[Employer|EMPLOYER]:The employer associated with the payment will be displayed in this field.
;[Effective As Of|EFFECTIVE]/[Expires On|EXPIRY]:If the pension recipient is eligible for a limited time period, that time frame will be defined in these fields.
;[Status|RECIPIENT_STATUS]:The status of the recipient will be displayed in this field.
;[Payment Seq #|PAYMENT_SEQUENCE]:This field indicates the sequence of payment to the recipient.
;[Payment Amount|PAYMENT_AMOUNT]:The payment amount is displayed in this field.
;[Payment %|PAYMENT_PERCENT]:This field identifies a percentage paid to the recipient.
;[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.
[{If var='loginstatus' contains 'authenticated'
At line 28 changed 2 lines
![Notes|Edit:Internal.IVXPR]
[{InsertPage page='Internal.IVXPR' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IVXPR]
[{InsertPage page='Internal.IVXPR' default='Click to create a new discussion page'}]
At line 37 added one line
}]