Social Security Management

The Social Security Management module caters to the needs of Public Sector Pension Fund Management entities. It provides key pension fund management functionality such as contribution and benefit management as well as  financial asset allocation, loan management and other fund management support processes such as risk management, actuary and legal services.

It is part of the FreeBalance GRP and as such is seamlessly integrated with typical functions such as the budgeting, commitment accounting, revenue and expenditure management as well as treasury and asset management.

Benefits Management

Support Entities And Functions

Benefit Assignment Amount Modification Voucher

Overview

 
This entity keeps records of the voucher created due to the amount modification of a benefit assigment.

A screenshot of the Benefit Assignment Amount Modification Voucher feature is available here<.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Benefit Assignment Amount Modification Voucher from within the menu through this navigation path: Social Security Management ► Benefits Management ► Support Entities And Functions ► Benefit Assignment Amount Modification Voucher

Visible Fields

The following table lists and describes all visible fields for the Benefit Assignment Amount Modification Voucher feature, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
IDUnique identification code for the entity, store value is automatically assigned by the system.
Benefit Assignment IdAllows users to select benefit assignment Id form lookup feature.
Workflow Status

Displays the current status within the configured workflow. The stages configured by default are:

  • created
  • approval requested
  • approved
  • rejected
  • canceled
AmountAllows users to add amount.  
LanguageLanguage used to enter remarks.
RemarksStores the remarks of the benefit assignment amount modification voucher. Users use this field to describe the remarks related to the benefit assignment amount modification voucher.
Attachments TabUsing this tab, users can upload attachment related to benefit assignment amount modification voucher.
 
Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Benefit Assignment Amount Modification Voucher feature.
 
Button ImageDescription
Set screen to Insert Mode.  Users can then create a new record through this button.
Set screen to Search Mode.  Users can enter filter criteria and search existing entries.  By default, when entering a feature, users are in Search Mode.
Once a record has been created or searched for, users can return to the results screen when necessary.
Lookup button allows users to browse and select existing items.  Once selected, all available information automatically populates the corresponding fields.
Add a new item to the attachment tab.  A screen appears allowing users to enter new information for a attachment tab.
Remove a record.  A screen appears to confirm the record is deleted.
When users are required to sort by a specific filtering criterion, the Select All button allows to highlight all the filter criteria.
When users are required to sort by a specific filtering criterion, the Unselect All button unselects all previously highlighted filter criteria.
Click to save the information inputted. The record is stored and a confirmation message is presented.

 

 

Benefit Assignment Change Status Voucher

Overview

 
This entity keeps records of the voucher created to activate or supend a beneficiary of a benefit payroll.

A screenshot of the Benefit Assignment Change Status Voucher feature is available here<.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Benefit Assignment Change Status Voucher from within the menu through this navigation path: Social Security Management ► Benefits Management ► Support Entities And Functions ► Benefit Assignment Change Status Vouche

Visible Fields

The following table lists and describes all visible fields for the Benefit Assignment Change Status Voucher feature, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
IDUnique identification code for the entity, store value is automatically assigned by the system.
Voucher Type

Displays the voucher type within the configured workflow. The stages configured by default are:

  • Activation
  • Suspension
Workflow Status

Displays the current status within the configured workflow. The stages configured by default are:

  • created
  • approval requested
  • approved
  • Canceled
Benefit Assignment IdAllows users to select benefit assignment Id form lookup feature.
Benefit Beneficiary IDAllows users to select benefit beneficiary Id form lookup feature.
Voucher DateVoucher date of benefit assignment change status voucher.
LanguageLanguage used to enter remarks.
RemarksStores the remarks of the benefit assignment change status voucher. Users use this field to describe the remarks related to the benefit assignment change status voucher.
Supporting DocumentsUsing this tab, users can upload supporting documents related to benefit assignment change status voucher.
 

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Benefit Assignment Change Status Voucher feature.
 
Button ImageDescription
Set screen to Insert Mode.  Users can then create a new record through this button.
Set screen to Search Mode.  Users can enter filter criteria and search existing entries.  By default, when entering a feature, users are in Search Mode.
Once a record has been created or searched for, users can return to the results screen when necessary.
Lookup button allows users to browse and select existing items.  Once selected, all available information automatically populates the corresponding fields.
Date Picker, allows users to select a calendar date.
Add a new item to the item tab.  A screen appears allowing users to enter new information for a item tab.
Remove a record.  A screen appears to confirm the record is deleted.
When users are required to sort by a specific filtering criterion, the Select All button allows to highlight all the filter criteria.
When users are required to sort by a specific filtering criterion, the Unselect All button unselects all previously highlighted filter criteria.
Click to save the information inputted. The record is stored and a confirmation message is presented.

 

 

Benefit Compliance Document

Overview

This feature allows users to store the configuration for the main process of benefit compliance document.

A screenshot of the Benefit Compliance Document feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Benefit Compliance Document from within the menu through this navigation path: Social Security Management ► Benefit Managment ► Support Entities And Functions ► Benefit Compliance Document.

 

Visible Fields

The following table lists and describes all visible fields for the Benefit Compliance Document feature, in their default order. Note that some fields depends on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldDescription
Benefit Request IDIt is a system-generated unique benefit request identifier.
Workflow Status

Displays the current status within the configurated workflow. The stages configured by default are:

  • created,
  • approval requested,
  • approved,
  • open,
  • closed
  • cancelled and
  •  rejected.

This field is modified through the Transition button after the benefit compliance document is created. The default status is created.

Fiscal YearStores the fiscal year which is affected by the benefit compliance document. Users can select other opened fiscal years.
Start DateIt allows users to select the start date of the benefit compliance document.
End DateIt allows users to select the end date of the benefit compliance document. The stored value must be greater than the Start Date and within the same fiscal year.
Is Apply Filters for Document

The default value of this checkbox is unmarked. When it is marked then it make visible to the follwing fields:

  • Gender
  • Beneficiary Initial Birth Date
  • Beneficiary Final Birth Date
  • First Letter of Last Name
GenderIt stores the beneficiary gender. Users define the gender through this drop-down list.
Beneficiary Initial Birth DateAllows users to select initial birth date through date picker.
Beneficiary Final Birth DateAllows users to select final birth date through date picker.
First Letter of Last NameAllows user to enter the first letter of the last name of the beneficiary.
Is Automatically Suspend Pension PaymentsThe default value of this checkbox is unchecked. It is used manage the execution of the process associated to automatically suspend.
LanguageIt stores the language. User defines the language through this drop-down list. English is set as the default value in this field.
DescriptionIt allows users to write short description related to benefit compliance document.
Attachments TabUsing this tab, users attach one or more files related to the benefit compliance document. File types allowed are specified in System Parameters.
Benefit Compliance Document Detail TabUsing this tab, users stores benefit compliance document detail related to the benefit compliance document.

 

Buttons

The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Benefit Compliance Document feature.

Button ImageDescription
The New button allows users to switch to insert mode. This action button allows users to create benefit compliance document.
The Search button allows users to switch to search mode.
Calendar date-pickers allow users to select on a visual calendar a specific date. Within benefit compliance document, it is used to select the start date and end date.
Once a record has been created or searched for, users can return to the results screen when necessary.
Present a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
The New button allows users to add details to the selected tab. It is used to add attachments and benefit compliance document detail.


 

Benefit Resolution

Overview

This entity keeps records of the resolutions. A resolution is related to 1 or more benefit requests, when a resolution is approved all related benefit requests are also automatically approved. in the same sense, when a resolution is rejected all related benefit requests are also automatically rejected.

A screenshot of the Benefit Resolution feature is available here.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Benefit Resolution from within the menu through this navigation path: Social Security Management ► Benefits Management ► Support Entities And Functions ► Benefit Resolution

Visible Fields

The following table lists and describes all visible fields for the Benefit Resolution feature, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldDescription
Benefit Resolution IDUnique identification code for the entity,store value is automatically assigned by the system.
Workflow Status

Displays the current status within the configured workflow. The stages configured by default are:

  • created,
  • approval requested,
  • approved,
  • rejected,
  • canceled.
Resolution NumberResolution number of the benefit resolution.
Resolution DateResolution date of the benefit resolution.
LanguageLanguage used to enter remarks.
RemarksStores the remarks of the benefit resolution. Users use this field to describe the remarks related to the benefit resolution.
Resolution Line Items TabUsing this tab, users store a collection of one or more benefit request.
Awarded Beneficiaries TabUsing this tab, users store awarded beneficiaries related to the benefit resolution. When benefit resolution gets approved a new record of benefit beneficiary created by the system.

 

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Benefit Resolution feature.
Button ImageDescription
Set screen to Insert Mode.  Users can then create a new record through this button.
Set screen to Search Mode.  Users can enter filter criteria and search existing entries.  By default, when entering a feature, users are in Search Mode.
Once a record has been created or searched for, users can return to the results screen when necessary.
Add a new item to the detail tab.  A screen appears allowing users to enter new information for a detail item.
Remove a record.  A screen appears to confirm the record is deleted.
When users are required to sort by a specific filtering criterion, the Select All button allows to highlight all the filter criteria.
When users are required to sort by a specific filtering criterion, the Unselect All button unselects all previously highlighted filter criteria.
Click to save the information inputted. The record is stored and a confirmation message is presented.

 

Benefit Resolution Awarded Beneficiary

Overview

This entity keeps records of the entitled, applicant and awarded beneficiaries in a benefit request included in a benefit resolution.

A screenshot of the Benefit Resolution Awarded Beneficiary tab is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Paramters and Rendering Control configuration.

Visible Fields

FieldsDescription
Sequence NumberUnique identifier number of the awarded beneficiary tab. automatically generated by the system.
Type of Personal ID

Contains the type of personal ID document.
The following are possible values:

  • Personal Identity Card,
  • Resident Card,
  • Passport,
  • Other,
  • Not Applicable.
Personal Id NumberPersonal ID number of the awarded beneficiary.
GenderGender of the awarded beneficiary.
Date of BirthDate of Birth of the awarded beneficiary.
Marital StatusMarital status of the awarded beneficiary.
Country of OriginCountry of origin of the awarded beneficiary.
Start DateRead-only field shows the date when the benefit starts. The system automatically assigns the value.
End DateRead-only field shows the date when the benefit ends. The system automatically assigns the value.
Calculated Allocation PercentageRead-only field shows the percentage of the total amount for the benefit to be received as payment.
Calculated AmountRead-only field shows the amount calculated for the benefit Type.
Corrected AmountRead-only field shows the corrected amount for the benefit Type.
Legal Representative IDRead-only field shows the id number of legal representative.
Legal Representative NameRead-only field shows the legal representative for the member causing the benefit.
Legal Representative PhoneRead-only field shows the phone number of legal representative.
Beneficiary Bank AccountRead-only field shows the beneficiary bank account.
VendorRead-only field shows the vendor code.
BenefitRead-only field shows the benefit id.

 

Benefit Termination Voucher

Overview

This entity keeps records of the a benefit assigments vouchers recorded to terminate a benefit assigment for a benefit payroll.

A screenshot of the Benefit Termination Voucher feature is available here<.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Benefit Termination Voucher from within the menu through this navigation path: Social Security Management ► Benefits Management ► Support Entities And Functions ► Benefit Termination Voucher

Visible Fields

The following table lists and describes all visible fields for the Benefit Termination Voucher feature, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
IDUnique identification code for the entity, store value is automatically assigned by the system.
Benefit Assignment IdAllows users to select benefit assignment Id form lookup feature.
Workflow Status

Displays the current status within the configured workflow. The stages configured by default are:

  • created
  • approval requested
  • approved
  • rejected
  • canceled
Expected Termination DateExpected termination date of benefit termination voucher.
LanguageLanguage used to enter remarks.
RemarksStores the remarks of the benefit termination voucher. Users use this field to describe the remarks related to the benefit termination voucher.
AttachmentsUsing this tab, users can upload attachment related to benefit termination voucher
 
Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Benefit Termination Voucher feature.
 
Button ImageDescription
Set screen to Insert Mode.  Users can then create a new record through this button.
Set screen to Search Mode.  Users can enter filter criteria and search existing entries.  By default, when entering a feature, users are in Search Mode.
Once a record has been created or searched for, users can return to the results screen when necessary.
Lookup button allows users to browse and select existing items.  Once selected, all available information automatically populates the corresponding fields.
Add a new item to the attachment tab.  A screen appears allowing users to enter new information for a attachment tab.
Remove a record.  A screen appears to confirm the record is deleted.
When users are required to sort by a specific filtering criterion, the Select All button allows to highlight all the filter criteria.
When users are required to sort by a specific filtering criterion, the Unselect All button unselects all previously highlighted filter criteria.
Click to save the information inputted. The record is stored and a confirmation message is presented.

 

 

Medical Consultant

Overview

This entity is a catalog that keeps records of the Pension Fund registered Medical Consultants.

Navigation

Social Security Management ► Benefits Management ► Support Entities and Functions ► Medical Consultant

Medical Consultant Screen Fields

FieldsDescription
Medical Consultant IdUnique identifier.  System generated.
ActiveTo indicate if a record is active and can be referenced. Default Value = True
Full NameMedical consultant name.
SpecialistThe medical consultant specialties.
Contact InformationMedical consultant's Contacts information.

 

Contact Information Tab

Overview

This entity allows the user to define the type of contact location types.
 
Contact Information Tab Screen Fields
FieldsDescription
Is MainWhether the contact added, is the main address, gets mentioned in this field.
Contact TypeWhether the contact added, is the main address, gets mentioned in this field.
Contact Location TypeWhether the contact mentioned home address, work address, gets mentioned.
Contact ValueThe contact is defined in this field.
LanguageLanguage used to define the contact.
DescriptionDescription regarding the contact is mentioned in this field.

Medical Specialty

Overview

This entity is a catalog that keeps records of the different Medical Specialties.
 

Navigation

Social Security Management ► Benefits Management ► Support Entities and Functions ► Medical Specialty

 

Medical Speciality Screen Fields

FieldsDescription
IdMedical Speciality ID. System generated.
ActiveTrue by default. Indicates if medical speciality can be used and referenced.
LanguageUsers can select the language users would like to use in the application.
DescriptionMedical Speciality Description.

 

Common Entities and Functions

Coverage Regime

Overview

This entity is a catalog that keeps records of the different coverage regimes used in Contributions and Benefits.

Navigation

Social Security Management ► Common Entities and Functions ► Coverage Regime

Coverage Regime Screen Fields and Tab

FieldsDescription
IdUnique identifier of each record. Automatically assigned by the system.
ActiveIndicates if the coverage regime can be used and referenced. Only Active=True can be used and referenced.
LanguageUsers can select the language users would like to use in the application.
DescriptionCoverage Regime Description. User defined.
Benefit TabList of benefits associated to a Coverage Regime. Records can be attached by using the lookup button.

 

Rejection Reason

Overview

This entity is a catalog that keeps records of the different reasons why a document in PFM (e.g. benefit request, Loan) is rejected.

Navigation

Social Security Management ► Common Entities and Functions ► Rejection Reason

Rejection Reason Screen Fields

FieldsDescription
IdRejection Reason ID. System generated.
ActiveTrue by default. Indicates if rejection reason can be used and referenced.
LanguageUsers can select the language users would like to use in the application.
DescriptionRejection reason Description.

 

Social Security Type of Beneficiary

Overview:

This entity is a catalog that keeps records of the different Member's Type of Beneficiaries.

Navigation:

Social Security Management ► Support Entities ► Social Security Type of Beneficiary

Social Security Type of Beneficiary screen fields:

 

FieldsDescription
IdUnique identifier. Automatically assigned by the system.
ActiveIf it true, the support entity can be used in other entity.
Set Max OccurrencesIndicates whether the maximum number of occurrences will be limited by type of beneficiary or not
LanguageLanguage used to enter Beneficiary name.
Type of Beneficiary Name
Contains the name of the type of beneficiary

 

Supporting Document Type

Overview

This entity is a catalog that keeps records of the different supporting document types that can be used in PFM.

Navigation

Social Security Management ► Common Entities and Functions ► Supporting Document Type

Supporting Document Type Screen Fields

FieldsDescription
IdUnique identifier. System generated.
ActiveTrue by default. Indicates if the Support Document Type can be used and referenced.
LanguageUsers can select the language users would like to use in the application.
DescriptionShort description for the type of supporting document.

 

Investment Management

Investment Indicator

Overview

This feature keeps information regarding the Indicators of the investment.

A screenshot of the Investment Indicator feature is available here. Image is shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Investment Indicator from within the menu through this navigation path: Social Security Management ► Investment Management ► Investment Indicator

Visible Fields

The following table lists and describes all visible fields for the Investment Indicator, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
IdStores the unique identifier for the Investment Indicator. This is a read only field as the value is automatically generated by the system, and is increased based on a sequence.
ActiveThe status of the Investment Indicator record.
LanguageUsers are allowed to select the language to register the description.
NameAllows users to add a name to the indicator.
DescriptionAllows users to add full description of the indicator.
Starting DateAllows users to select the starting date of the indicator from a date picker.
Ending DateAllows users to select the ending date of the indicator from a date picker.
Indicator TypeAllows users to select indicator type from the drop down list.
Workflow StatusIt is a closed domain and allows users to select transition from dropdown list.
Investement LevelsAllows users to add related investment level records through the lookup functionality.
Accounting ParametersAllows users to add related account parameters records through the lookup functionality.

 

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Investment Indicator.

Button ImageDescription
The New button allows users to switch to insert mode. This action button allows users to manually create Investment Indicator.
The Search button allows users to switch to search mode.
Find button presents a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
Once a record has been created or searched for, users can return to the results screen when necessary.
The Calendar button allows users to select a calendar date, used for starting and ending date.
The Lookup button allows users to browse and select existing items. Once selected, all available information automatically populates the corresponding fields.
The Remove button allows users to remove the selected tab.
The Select All button allows users to highlight all the filter criteria.
The Unselect All button allows users to unselects all previously highlighted filter criteria.
The Audit button allows users to view the audit history for the current record.
The Save button allows user to save the information inputted.

 

Support Entities And Functions

Accountability Parameter

Overview

This feature keeps information regarding the accountability parameter of the investment.

A screenshot of the Accountability Parameter feature is available here <. Image is shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Accountability Parameter  from within the menu through this navigation path: Social Security Management ► Investment Management ► Support Entities And Functions  Accountability Parameter

Visible Fields

The following table lists and describes all visible fields for the Accountability Parameter, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
IdStores the unique identifier for the Accountability Parameter. This is a read only field as the value is automatically generated by the system, and is increased based on a sequence.
Element TypeIt is a closed domain and allows users to select an element type from dropdown list.
Operation TypeIt is a closed domain and allows users to select an operation type from dropdown list.
Accountability AccountAllows users to select accountability account associated with the record.

 

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Accountability Parameter.

Button ImageDescription
The New button allows users to switch to insert mode. This action button allows users to manually create Accountability Parameter.
The Search button allows users to switch to search mode.
Find button presents a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
The Lookup button allows users to browse and select existing items. Once selected, all available information automatically populates the corresponding fields.
Once a record has been created or searched for, users can return to the results screen when necessary.
The Update button allows users to update all changes made to a record.
The Delete button allows users to remove the record. A window is displayed confirming the item is deleted.
The Save button allows user to save the information inputted.

 

Investment Level

Overview

This feature keeps information regarding the level of the Investment indicator.

A screenshot of the Investment Level feature is available here <. Image is shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Investment Level  from within the menu through this navigation path: Social Security Management ► Investment Management ► Support Entities And Functions ► Investment Level

Visible Fields

The following table lists and describes all visible fields for the Investment Level, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
IdStores the unique identifier for the Investment Level. This is a read only field as the value is automatically generated by the system, and is increased based on a sequence.
LevelAllows user to select color code that works as the visual indicator the Investment level.
Starting ValueAllows users to select a value and this value represents a percentage.
Ending ValueAllows users to select a value and this value represents a percentage.

 

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Investment Level.

Button ImageDescription
The New button allows users to switch to insert mode. This action button allows users to manually create Investment Level.
The Search button allows users to switch to search mode.
Find button presents a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
Once a record has been created or searched for, users can return to the results screen when necessary.
The Range button allows users to select range of values.
The Color Picker button allows users to select color code.
The Update button allows users to update all changes made to a record.
The Delete button allows users to remove the record. A window is displayed confirming the item is deleted.
The Save button allows user to save the information inputted.

 

Investment filter

Overview

This feature keeps information regarding the accountability parameter of the investment.

A screenshot of the Investment filter feature is available here<. Image is shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Investment filter  from within the menu through this navigation path: Social Security Management ► Investment Management ► Support Entities And Functions  Investment filter

Visible Fields

The following table lists and describes all visible fields for the Investment filter, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
IdStores the unique identifier for the Investment filter. This is a read only field as the value is automatically generated by the system, and is increased based on a sequence.
VariableIt is a closed domain and allows users to select variable from dropdown list.

 

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Investment filter.

Button ImageDescription
The New button allows users to switch to insert mode. This action button allows users to manually create Investment filter.
The Search button allows users to switch to search mode.
Find button presents a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
Once a record has been created or searched for, users can return to the results screen when necessary.
The Update button allows users to update all changes made to a record.
The Delete button allows users to remove the record. A window is displayed confirming the item is deleted.
The Audit button allows users to view the audit history for the current record.
The Save button allows user to save the information inputted.

 

Affiliation and Contribution Management

Contribution Assignment Change

Overview

This entity keeps records of the history of the movement for a Contribution Assignment.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Contribution Assignment Change

Contribution Assignment Change Screen Fields

FieldsDescription
IdSystem generated.
Contribution AssignmentLookup to select Members having assignments in Institutions.
Type of TransactionType of the transaction related to Registration, Cancellation, Salary_Adjustment
Effective DateDate of effectiveness.
Approval DateDate of approval.

 

Contribution Assignment Termination

Overview

This entity keeps records of the termination or a Contribution Assignment and its workflow. 

Navigation

Social Security Management ► Affiliation and Contribution Management ► Contribution Assignment Termination

Contribution Assignment Termination Screen Fields and Tab

FieldsDescription
Contribution Assignment TerminationUnique identifier of each record. Automatically assigned by the system.
Contribution AssignmentLookup to select Members having assignments in Institutions.
Cause of TerminationList of the termination realted cause such as Dimisal_Resignation, Decease, Disability, Leave_without_pay
Workflow StatusDisplays the current workflow status of the record. Depending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
Effective DateDate of the effectiveness of the termination.
LanguageUsers can select the language users would like to use in the application.
Additional NotesShort Description.
Support Documentation TabAllows to add any documents related to the process.

 

Support Documentation Tab

Overview

Allows to add any documents related to the process.

Support Documentation Tab Screen Fields

FieldsDescription
IdUnique identification code manually entered by users or automatically generated based on parameters.
Attachment ClassificationTo define the different Attachment Classification.
TitleName of Attachment.
DescriptionA detailed Description of the attachment.
AttachmentFile uploaded and attached to the Contribution Assignment Termination.
Date TimeSystem generated date and time the attachment was added.
DateDate of adding the attachment.
UserRead-only. ID of the user who attached the file.

 

Contribution Salary Transitition Operation

Overview

This entity refers to the transactions related to the salary transition process and its detail.  It holds the details of the salary transition and its transactionality, so when the register here is approved, the system will create a record on the salary transition entity.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Contribution Salary Transitition Operation

Contribution Salary Transitition Operation Screen Fields

FieldsDescription
ST Operation IDUnique identifier of each record. Automatically assigned by the system.
Member Assignment IDContribution assignment related to the salary transition.
Workflow StatusDisplays the current workflow status of the record. Depending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
Original SalaryThe original amount of the salary.
Type of ChangeThe different type of modifications to the current original salary. Closed domain, with values: Percentage, Fixed_Value, To_Fixed_Value.
ValueAll types changes imply a value greater than 0.
New Calculated AmountThe resultant value after the calculation, taking the type of change and the value.
Effective DateEffective application date of the change.
Support Documentation TabAllows to add any documents such as “Payslip” related to the process.

 

Support Document Tab

Overview

Allows to add any documents such as “Payslip” related to the process.

Support Document Tab Screen Fields

FieldsDescription
IdUnique identification code manually entered by users or automatically generated based on parameters.
Attachment ClassificationTo define the different Attachment Classification.
TitleName of Attachment.
DescriptionA detailed Description of the attachment.
AttachmentFile uploaded and attached to the Contribution Salary Transitition Operation.
Date TimeSystem generated date and time the attachment was added.
DateDate of adding the attachment.
UserRead-only. ID of the user who attached the file.

 

 

Institution Legal Representative

Overview

This entity is a catalog that keeps records of the Legal Representatives.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Institution Legal Representative

Institution Legal Representative Screen Fields

FieldsDescription
Application IdUnique identifier.  System generated.
First NameFirst Name of the Member.
Middle NameMiddle Name of the Member.
Last NameLast Name of the Member.
Type of Personal IdContains the type of personal ID document.
Personal Id NumberContains the personal ID Number.
Start DateStart Date as Legal Representative.
End DateEnd Date as Legal Representative.
Personal Tax NumberContains the TAX number of the Legal Representative
Designation Document NumberNumber of the document of designation as Legal Representative.
Status (Is Active)Only one Institution Legal Representative must be active, per Member Institution, at time.

 

Attachment Tab

Overview

This entity keeps records of the attachment.

Attachment Tab Screen Fields

FieldsDescription
IdIdentification code of the attachment.
Attachment ClassificationClassification of the Attachment.
TitleTitle of the attachment.
DescriptionDescription of the File attached.
AttachmentFile to be attached from this field.
Date TimeTime and Date of file attachment.
UserUsers by whom the field is attached.

 

Contact Tab

Overview

This entity allows the user to define the type of contact location types.

Contact Tab Screen Fields

FieldsDescription
Is MainWhether the contact added, is the main address, gets mentioned in this field.
Contact TypeWhether the contact added, is the main address, gets mentioned in this field.
Contact Location TypeWhether the contact mentioned home address, work address, gets mentioned.
Contact ValueThe contact is defined in this field.
LanguageLanguage used to define the contact.
DescriptionDescription regarding the contact is mentioned in this field.

 

Member

Overview

This entity keeps records of the Members registered in PMF Module.

 

Navigation

Social Security Management  ► Affiliation and Contribution Management ► Member

 

Member screen Fields

Field

Description

Application Id

Unique identifier. Automatically assigned by the system.

Workflow Status

Depending on the workflow configuration setting, the basic stages are: Created, Approval Requested, Approved, Void, Closed, Cancelled, Acknowledged. Default value is created.

Type of Personal Id

Contains the type of personal ID document

Personal Id Number

Contains the personal ID Number

First Name

First Name of the Member

Middle Name

Middle Name of the Member

Last Name

Last Name of the Member

Place of Birth

Contains the place of birth

Date of Birth

Date of Birth of the member

Age to Date

Read Only. Display the age to date of the member including Years, Months and Days.

Date of Death

Date of death of the member

Origin

Drop down selection. Two possible values Data Import and Manual.

Country of Origin

Country of origin of the member.

Gender

Gener of the member

Marital Status

Marital Status of the member

Profession or Occupation or Economic Activity

Profession, Occupation or Economic Activity of the member

Is Politically Exposed Person

Indicates if the member is a pollitically exposed person.

Personal Tax Number

Contains the TAX number of the Member

Type of Participant

Contains the type of participant. At the moment of the Affiliation of the memer this value is assigned as "New".

Is Updated Biometric Data and Photography

Indicates if the member has updated biometric data and photography

Legacy Member Id

Member ID in Legacy System

Member Status

Read Only. This status is only changed by business logic processes.

 

 

 

Address tab screen Fields

Overview

This entity allow to the user to define the type of address.

 

Address tab screen Fields

Field

Description

Is Main

Whether the contact added, is the main address, gets mentioned in this field.

Country

Drop down to pick country

Address TypeWhether the Address added, is the main address, gets mentioned in this field.
AddressAddress of the location.
Zip Code

Zip code of the location.

 

Attachment Tab

Overview

This entity keeps records of the attachment

 

Attachment tab screen Fields

Field

Description

Id

Identification code of the attachment.

Attachment Classification

Classification of the Attachment.

Title

Title of the attachment.

Description

Description of the File attached.

AttachmentFile to be attached from this field.
Date Time

Time and Date of file attachment.

User

Users by whom the field is attached.

Contacts Tab

Overview

This entity allow to the user to define the type of contact location types.

 

Contact tab screen Fields

Field

Description

Is Main

Whether the contact added, is the main address, gets mentioned in this field.

Contact Type

Whether the contact added, is the main address, gets mentioned in this field.

Contact Location TypeWhether the contact mentioned home address, work address, gets mentioned.
Contact ValueThe contact is defined in this field.
LanguageLanguage used to define the contact.
DescriptionDescription regarding the contact is mentioned in this field.

 

Member Financial Information Tab

Overview

This entity keeps records of the Member's Financial Information.

 

Member Financial Information tab screen Fields

Field

Description

Type of Record

Contains if the record is for an Asset or is for a Revenue.

Type of Asset

For an Asset record, indicates if the asset is Real State, a vehicle or other asset.

Estimated ValueContains the estimated value of the Asset.
Type of PossessionIndicates the type of possession that the Member has over the asset.
Type of RevenueContains the type of revenue.
Estimated Annual Amount

Contains the estimated annual amount of the revenue.

StatusRead Only. This status is only changed by business logic processes.
LanguageUsers can select the language users would like to use in the application.
DescriptionThis attribute contains the description of the type of record, either asset type or revenue type.

 

Member Potential Beneficiary Tab

Overview

This entity keeps records of the Member's Potential Beneficiaries.

 

Contact tab screen Fields

Field

Description

Inclusion Date

System date when the record is created

Type of Personal ID

Contains the type of personal ID document

First NameFirst Name of the Member
Last Names

Last Name of the Member

GenderGender of the potential beneficiary
Date of birthDate of Birth of the member
Type of Beneficiary

Contains the type of beneficiary.

Is Currently StudyingIndicates if the potential beneficiary is currently studying at the moment of the record
Is Legally DisableIndicates if the potential beneficiary is legally disabled at the moment of the record.
Is Economically DependentIndicates if the potential beneficiary is economically dependent of the member.
Is MinorIndicates if the potential beneficiary is a minor.
Voluntary Benefit Percentage set by MemberContains the voluntary benefit percentage set by Member
StatusRead Only. Status of the record.
Inactivation Date

Read Only. Date when the record is inactivated.

 

Member Reference Tab

Overview

This entity keeps records of the Member's reference(s).

 

Member Reference tab screen Fields

Field

Description

Type of Reference

Contains the type of reference.

Name

Name of the reference

AddressDetails of the Address of the Member's reference
ContactPhone number of the Member's reference
StatusStatus of the Member Reference.

 

Other Employment History

Overview

This entity keeps records of the Member's Other Public Sector Employment(s).

 

Other Employment History tab screen Fields

Field

Description

Sequence

Sequence number of the Employment History.

Employer Name

Name of the public employer.

Start Date

Start date of the employment.

End DateEnd date of the employment.
StatusIndicates the status of the employment. Possible values are Active, To be Inactivated, To be Activated, Inactive.
LanguageLanguage used to describe the position and the employer activity.
PositionName of the employment position.
Employer ActivityDescription of the employer Activity.

 

 

Member Information Update Request

Overview

This entity keeps the record of requests to update the member's information in stages subsequent to its activation.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Member Information Update Request

Member Information Update Request Screen Fields and Tab

FieldsDescription
Application IdUnique identifier of each record. Automatically assigned by the system.
Workflow StatusDisplays the current workflow status of the record. Depending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
Type of UpdateType of update that is requested. Possible values: General Information, Potential Beneficiaries.
Member IDLookup functionality. User can select Member which is in status Active, Suspense, and Retired.
Created DateDatetime when the "Member Information Update Request" is created.
Approved DateDatetime when the "Member Information Update Request" is approved.
Attachement TabAllows to add any documents related to the process.

 

Attachment tab

Overview

Allows to add any documents related to the process.

Attachment Tab Screen Fields

FieldsDescription
IdUnique identification code manually entered by users or automatically generated based on parameters.
Attachment ClassificationTo define the different Attachment Classification.
TitleName of Attachment.
DescriptionA detailed Description of the attachment.
AttachmentFile uploaded and attached to the Member Information Update Request.
Date TimeSystem generated date and time the attachment was added.
DateDate of adding the attachment.
UserRead-only. ID of the user who attached the file.

 

Member Institution

Overview

This entity is a catalog that keeps records of the Member Institutions. It is subjected to audit trail and rendering control

Navigation

Social Security Management ► Affiliation and Contribution Management ► Member Institutions

Member Institution Screen Fields

FieldsDescription
Application IdUnique identifier.  System generated.
Workflow StatusDepending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
Legal Institution IdInstitution ID in legacy system.
Decree of CreationContains the decree creating the Institution.
Institutional Tax NumberContains the TAX number of the Institution.
Official Journal NumberContains the number of the official journal in which the creation decree was published.
Official Journal Publication DateContains the date of publication in the official newspaper.
Pay CodeIt will be the catalog to be used to set up the subjects to be considered for the calculation of a payroll either collections or benefits.
Pay PeriodIt will be used to set up the periods that a pay code applies.
Member Institution TypeIndicates whether the entity is centralized or decentralized.
Start DateDate the institution is incorporated as a member of the pension fund.
End DateDate the institution ends its relationship with the pension fund.
CustomerContains the list of active customers.
OriginThe origin serves to differentiate if a record has been manually entered from the system or if it has been automatically entered from a data import process.
LanguageUsers can select the language users would like to use in the application.
NameContains the name.
Institution Short NameContains the short name of the Institution.
Institution Status (Is Active)This status is only changed by business logic processes.
ContactsContact information
Addresses 
AttachmentsUser must be able to attach 0 or many documents. 
Institution Legal Representatives
Contains information regarding the legal representative of the institution.
Member Institution Name HistoriesThis collection contains history of the names that the institution can have throughout its participation within the pension fund.

 

Address Tab

Overview

This entity allows the user to define the type of addresses.

Addresses Tab Screen Fields

FieldsDescription
Is MainWhether the contact added, is the main address, gets mentioned in this field.
CountryDropdown to pick country
Address TypeWhether the Address added, is the main address, gets mentioned in this field.
AddressAddress of the location.
Zip CodeZip code of the location.

 

Attachment Tab

Overview

This entity keeps records of the attachment.

Attachment Tab Screen Fields

FieldsDescription
IdIdentification code of the attachment.
Attachment ClassificationClassification of the Attachment.
TitleTitle of the attachment.
DescriptionDescription of the File attached.
AttachmentFile to be attached from this field.
Date TimeTime and Date of file attachment.
UserUsers by whom the field is attached.

 

Contact Tab

Overview

This entity allows users to define the type of contact location types.

Contact Tab Screen Fields

FieldsDescription
Is MainWhether the contact added, is the main address, gets mentioned in this field.
Contact TypeWhether the contact added, is the main address, gets mentioned in this field.
Contact Location TypeWhether the contact mentioned home address, work address, gets mentioned.
Contact ValueThe contact is defined in this field.
LanguageLanguage used to define the contact.
DescriptionDescription regarding the contact is mentioned in this field.

 

Member Institution Name History

Overview

This functionality allows the user to record when the Institution changes its name. The user has also the possibilty to attach any document(s) generated as part of this process.

 

Navigation

Social Security Management  ► Affiliation and Contribution Management ► Member Institution Name History

 

Member Institution Name History screen Fields

Field

Description

Application Id

Unique identifier. Automatically assigned by the system.

Workflow Status

Depending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.

Start Date

Contains the type of personal ID document

Member Institution

A catalog that keeps records of the Member Institutions.

Language

Users can select the language users would like to use in the application.

Old Name

Corresponds to the "Institution Name" that is populated from lookup functionality.

Old Short Name

Corresponds to the "Institution Short Name" that is populated from lookup functionality.

New Name

Contains the name of the New Institution.

New Short Name

Contains the name of the new short name institution.

Status (Is Active)

Only one Member Institution Name History must be active, per Member Institution, at time.

 

Attachment Tab

Overview

This entity keeps records of the attachment

 

Attachment tab screen Fields

Field

Description

Id

Identification code of the attachment.

Attachment Classification

Classification of the Attachment.

Title

Title of the attachment.

Description

Description of the File attached.

AttachmentFile to be attached from this field.
Date Time

Time and Date of file attachment.

User

Users by whom the field is attached.

 

Member Institution Termination

Overview

A catalog that keeps records of termination for Institutions that stop participating as members of the Pension Fund.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Member Institution Termination

Member Institution Termination Screen Fields

FieldsDescription
IDUnique identifier. Automatically assigned by the system.
ActiveRead Only. This status is only changed by business logic processes.
Workflow StatusDepending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
Institution IDThe system will populate Institution ID and Institution Name.
End DateDate the institution ends its relationship with the pension fund. Display as Date Picker.

 

Attachment Tab

Overview

Allows to add any documents related to the process.

Attachment Tab Screen Fields

FieldsDescription
IdIdentification code of the attachment.
Attachment ClassificationClassification of the Attachment.
TitleTitle of the attachment.
DescriptionDescription of the File attached.
AttachmentFile to be attached from this field.
Date TimeTime and Date of file attachment.
UserUsers by whom the field is attached.

 

Open Contributions Period

Overview

Through Displays Open Contributions Period users are able to indicate the Period to Open,

Navigation

Social Security Management ► Affiliation and Contribution Management ► Open Contributions Period

Open Contributions Period Screen Fields

FieldsDescription
Fiscal YearAllows users to select fiscal year from drop down list.
PeriodAllows users to select Pay Period from drop down list. Periods shown are related to the Fiscal Year previously selected, have pay code related to Constirbutions and do not already have a payroll associated to them (are not already opened).

 

Payment Item Per Period

Overview

This entity keeps records of the details of each Payroll calculated for the Institutions.

Following types or records can be found here:

  1. "Not Processed" also known as "Estimated" Payroll which is a forecast of the collection payroll.
  2. "Confirmed" also known as "Calculated" payroll which is the draft for Accounts Receivables.
  3. "Finalized" also known as "Approved" this is the final stage of a payroll. Once this stage is reached no updates can be done to it.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Payment Item Per Period

Payment Item Per Period Screen Fields

FieldsDescription
Application IdUnique identifier of each record. Automatically assigned by the system.
Workflow StatusDisplays the current workflow status of the record. Depending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
StatusStatus of the record in a Payroll.
OriginIndicates the origin of the Payment Item Per Period.
Contribution AssignmentAllows user to select contribution assignment from look up functionality.
Member InstitutionAllows user to select Member Institution from look up functionality.
Payment ItemAllows user to select Payment Item from look up functionality.
Pay CodeAllows user to select pay code from drop down list.
Pay PeriodAllows user to select pay period from drop down list.
Start DateStart date of the Contribution Assignment.
End DateEnd date of the Contribution Assignment.
Number of DaysNumber of worked days.
Number of Pay PeriodsNumber of Pay Periods.
RateDefines the Rate of the contribution.
Calculated AmountCalculated Amount of the contribution assignment.
Corrected AmountCorrected Amount of the contribution assignment.
Coding BlockIf the record is created manually user must indicate the coding block.
Fiscal YearDropdown to select Arrear Fiscal Year.
Arrear Pay PeriodDropdown to select Arrear Pay Period.

 

Period end Process

Overview

This feature display the tree of Institutions that have reached the status of "Finalized"

A screenshot of the Period end Process  feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Paramters and Rendering Control configuration. 

Users access Period end Process from within the menu through this navigation path: Social Security Management ► Affiliation and Contribution Management  ► Period end Process.

Visible Fields

The following table lists and describes all visible fields for the Period end Process, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldsDescription
Fiscal YearUsers are allowed to select fiscal year from dropdown list. The current fiscal year is set as default value.
PeriodUsers are allowed to select fiscal period from dropdown list.

 

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Period end Process  feature.

Button ImageDescription
Present a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
Proceed button allows users to execute the Period end Process .

 

Reject Collections Payroll

Overview

This feature allows users to reject collection payroll. Sometimes after the comparison and validation of payrolls, users realize that the collection payroll is not ok due to some missing updates from the assignments like the dismissal of employees, new hiring, new loans, etc. The collection payroll needs to delete and rollback the status to projected for the record in pay period institution

This feature allows users to reject it by providing the fiscal year and fiscal period details. Once these two fields get values the system shows the tree of institutions that fits into the filter criteria. Afterwards users need to execute the process to reject the collection payroll.

A screenshot of the Reject Collections Payroll feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Paramters and Rendering Control configuration. 

Users access Reject Collections Payroll from within the menu through this navigation path: Social Security Management ► Affiliation and Contribution Management  ► Reject Collections Payroll.

 

Visible Fields

The following table lists and describes all visible fields for the Reject Collections Payroll feature, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldDescription
Fiscal YearIt lists and allows users to select the fiscal year from the list. The current fiscal year is set as default value.
Fiscal PeriodIt lists and allows users to select the fiscal period from the list. 
InstitutionsIt shows the tree of institution and allows users to select one or more institution to reject.

 

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the reject collections payroll feature.

Button ImageDescription
Present a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
The Select All button allows to highlight all the filter criteria. Using this feature users can select all institutions at one click.
The Unselect All button unselects all previously highlighted filter criteria. Using this feature users can unselect all institutions at one click.
Remove a record.  A screen appears to confirm the record is deleted.
Proceed button allows users to execute the reject collections payroll.

 

Reports

Billing Notice Report

Overview

This report is considered the report of accounts receivable in PFM. It provides different filter option to generate a specific report.

A screenshot of the Billing Notice Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to installed revision, System Parameters and Rendering Control configuration.

Users access Billing Notice Report from within the menu through this navigation path: Social Security Management ► Affiliation and Contribution Management Reports  Billing Notice Report.

 

Filters

The following table lists and describes all filter fields for the Billing Notice Report in their default order. Note that some fields depends on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldDescription
CommentAllows users to add a custom comment to the generated report.

 

Visible Fields

The following table lists and describes all visible fields for the Billing Notice Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration. A sample of the Billing Notice Report is available here.

FieldDescription
Institution NameShows the institution name.
Institution IdIt shows the institution ID.
PeriodThe contribution pay period name.
ID NumberThe member identification number.
Member Full NameMember full name, as first name, middle name and last name format.
Gross SalaryThe total salary amount of members.
Item NamePayment item name to be printed as the name of the column.
AmountTotal calculated amount.
TotalSum for each coding block amount.

 

Buttons

The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Billing Notice Report feature.

Button ImageDescription
This button allows users to generate the report as PDF format.
This button allows users to generate the report as MS Excel format.
This button allows users to generate the report in the excel format.
This button allows users to generate the report in ODS format.
This button allows users to generate the report in RTF format.
This button allows the users to generate the report in MS Word format.
This button allows users to generate the report in ODT format.

 

Collections Payroll Report

Overview

This report generates a report of the collection payroll in PFM. It provides different filter option to generate a specific report.

A screenshot of the Collections Payroll Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to installed revision, System Parameters and Rendering Control configuration.

Users access Collections Payroll Report from within the menu through this navigation path: Social Security Management ► Affiliation and Contribution Management Reports  Collections Payroll Report.

 

Filters

The following table lists and describes all filter fields for the Collections Payroll Report in their default order. Note that some fields depends on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldDescription
CommentAllows users to add a custom comment to the generated report.

 

Visible Fields

The following table lists and describes all visible fields for the Collections Payroll Reportin their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration. A sample of the Collections Payroll Report is available here.

FieldDescription
Institution NameShows the institution name.
Institution IdIt shows the institution ID.
PeriodThe contribution pay period name.
ID NumberThe member identification number.
Member Full NameMember full name, as first name, middle name and last name format.
Gross SalaryThe total salary amount of members.
Item NamePayment item name to be printed as the name of the column.
AmountTotal calculated amount.
TotalSum for each coding block amount.

 

Buttons

The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Collections Payroll Report feature.

Button ImageDescription
This button allows users to generate the report as PDF format.
This button allows users to generate the report as MS Excel format.
This button allows users to generate the report in the excel format.
This button allows users to generate the report in ODS format.
This button allows users to generate the report in RTF format.
This button allows the users to generate the report in MS Word format.
This button allows users to generate the report in ODT format.

 

Member Death

Overview

This functionality allows the user to record the date when a Member has passed away. The user has also the possibility to attach any document(s) generated as part of this process.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Member Death

Member Death Screen Fields and Tab

FieldsDescription
Application IDUnique identifier of each record. Automatically assigned by the system.
ActiveTo indicate if the record can be used and reference. True by default.
Workflow StatusDisplays the current workflow status of the record.
Member IDThe ID of the Member. The system populates Member ID and Member Name from the Member entity. Can be selected through lookup function only if the status of the Member is set to “Suspense”.
Date of DeathDate the member has passed away.
Attachment tabAllows to add any documents such as “Death Certificate” related to the process.

 

Attachment Tab

Overview

Allows to add any documents such as “Death Certificate” related to the process.

Attachment Tab Screen Fields

FieldsDescription
IdUnique identification code manually entered by users or automatically generated based on parameters.
Attachments ClassificationTo define the different Attachment Classification.
LanguageLanguage used to enter the Attachment information.
TitleName of Attachment.
DescriptionA detailed Description of the attachment.
AttachmentFile uploaded and attached to the Death Member.
Date TimeSystem generated date and time the attachment was added.
DateDate of adding the attachment.
UserRead-only. ID of the user who attached the file.
LanguageLanguage of the Attachment.

 

Support Entities And Functions

Automatic Payment Item

Overview

This feature is used to keep records of the payments items that are automatically set at the moment of creation of a member assignment records. It is the association between the payment item and member assignment.

A screenshot of the Automatic Payment Item feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Automatic Payment Item from within the menu through this navigation path: Social Security Management ► Affiliation and Contribution Management ► Support Entities And Functions ► Automatic Payment Item.

 

Visible Fields

The following table lists and describes all visible fields for the Automatic Payment Item feature, in their default order. Note that some fields depends on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldDescription
Payment Item IDIt is a system-generated unique identifier for payment item.
Contribution AssignmentIt refers to contribution assignment. The system allows users to select the contribution assignment for the payment item using the lookup feature or users can enter manually.
Member IDThe system automatically populates the related member ID from the Member. Users are not allowed to make any changes.
Payment ItemIt is associated with the Payment Item. It allows users to select the payment item using the lookup feature or can enter manually.
Coding BlockWhen users select the payment item the system automatically populates the coding block.
TypeWhen users select the payment item the system automatically populates the type fields information. 
Start Date It allows users to select the start date of the automatic payment item.
End DateIt allows users to select the end date of the automatic payment item.
FrequencyIt stores the frequency of the payment. Users define the frequency of the payment through this drop-down list
Amount per FrequencyThe amount related to the frequency. Users define the value related to the frequency. The default value is set as zero.
RateUsers define the rate of the payment. The default value set as zero.
Maximum Per PayUsers define maximum per pay amount. The default value is set as zero.
Maximum Per YearUsers define the maximum per year amount. The default value is set as zero.

 

Buttons

The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Automatic Payment Item feature.

Button ImageDescription
The New button allows users to switch to insert mode. This action button allows users to create automatic payment item.
The Search button allows users to switch to search mode.
Calendar date-pickers allow users to select on a visual calendar a specific date. Within Automatic Payment Item, it is used to select the paymen start date and payment end date.
Once a record has been created or searched for, users can return to the results screen when necessary.
Present a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.

 

Contributions Pay Code

Overview

This entity will be the catalog to be used to set up the subjects to be considered for the calculation of a payroll either collections or benefits.

Navigation

Social Security Management ► Affiliation and Contribution Management ► Support Entities And Functions ► Contributions Pay Code

Contributions Pay Code Screen Fields and Tab

FieldsDescription
Application IDDisplays the ID / Code of the Contributions Pay Code record. It is a system generated field.
Number of Pay Periods per YearTo define Number of Pay Periods per Year.
Number of work days in PeriodTo define Number of work days in Period.
Number of work days in the yearTo define Number of work days in the year.
Average day of working days in yearTo define Average day of working days in year.
Average day of working days in monthTo define Average day of working days in month.
Number of calendar days in yearTo define Number of calendar days in year.
Average calendar days in monthTo define Average calendar days in month.
ActiveTo indicate if the pay code is active and can be used in calculations of payrolls. True by default.
Is Used for Contributions PayrollThis attribute indicates that this pay code will be used for Contribution Payroll Calculation. Only one active record can be True. False By default.
LanguageRequired language can be selected to register the description.
DescriptionA description of the Contributions Pay Code are to be defined in this field.
Pay Period tabThis entity will be used to set up the periods that a pay code applies.
 

 

Pay Periods Tab

Overview

This entity allows the user to set up the periods that a pay code applies. This is the catalog entity that must be configured to handle the Pay Periods.

Pay Periods Tab Screen Fields

FieldsDescription
SequenceThis is manually entered by the user. This is to decide the order of pay periods will be calculated. This is not necessarily a unique number. Many of the records can have 1 and many can have 2
Fiscal YearFiscal year the pay period belongs to.
StatusTo indicate if the period is Open or Closed. When the Deadline for Payroll is reached, system will execute the Payroll calculation Process and, in that process, system will change de value for this field. If this field = "Closed" no transactions can be recorded for this Pay Period. Only one record can be = "Open" in a Fiscal Year at a time per Pay Code. Default value = "Not Processed".
Rate Date for Estimated PayrollDate estimated to generate the estimated payroll. User defined.
Date for Collections PayrollDate estimated to generate the collection payroll. User defined.
Deadline for PayrollLast day the payroll most be paid. User defined.
From DateStart date of the period. User defined.
To DateEnd date of the Period. User defined.
LanguageRequired language can be selected to register the description.
Period NameUser defined name of the period.
Pay Period Institution tabList of Institutions to be processed in the collection Payroll.
 

 

Pay Period Institution Tab

Overview

This entity allows the users to set up the Institutions to be included in a collection payroll in a pay period.

Pay Period Institution Tab Screen Fields

FieldsDescription
SequenceSystem generated sequence number.
Member InstitutioInstitution included in the list for the collection payroll.
StatusThis indicates the status of a payroll for a specific Member Institution. Default value = "Projected".
Receipt NumberWhen Status = "Finalized" system assign the value using as reference Billing Receipt Number parameter. This parameter has the INITIAL billing receipt number and then when the pay period institution is being created, system will retrieve the max billing receipt number adding 1. If the max is zero, then system will set what is defined on the system parameter as the Initial Billing Receipt Number
 

 

Payment Item

Overview

This entity is a catalog that keeps records of the payment items such as: Member Contributions, Employer Share, loans, etc.

Navigation

Social Security Management  Affiliation and Contribution Management  Support Entities And Functions  Payment Item

Payment Item Screen Fields

FieldsDescription
Payment Item IDSystem generated.
ActiveTo indicate if Payment Item can be used and reference. True by default
Is Based on SalaryTo indicate if the item included in a collection payroll is based on salary. False by default
TypeTo classify the type of Payment Item
FrequencyTo indicate the frequency the Payment Item applies.
RateRate. User defined.
Based onTo indicate the basis of the payment item during a collection payroll calculation.
SequenceThis is manually entered by the user.  This will decide the order these payment items will be calculated.  This is not a unique number, Many of the records can have 1 and many can have 2.
Used for ArrearsThis flag indicates if the payment item is an arrear. False by default
Coding BlockA Payment Item can have only 1 coding block associated to it where COA Group entity has budget execution = true.
Inactive DateWhen a date is entered the Payment Item will no longer be available from that date on. Default value is Null
Language 
NamePayment Item Name
DescriptionPayment Item Description
Effective DatesCollection of effective date

 

Payment Item Effective Date

Overview

This entity is to list the effective dates for a Payment Item.

Payment Item Effective Date Screen Fields

FieldsDescription
Correlative NumberIndex number. 
Effective DateThis date decides when this payment item is effective.
Is CurrentOnly 1 record can be = True at a time per Payment Item ID.
RateDefault value is 100.
Maximum AmountMaximum amount allowed to the payment item associated on an effective date.
Minimum AmountMinimum amount allowed to the payment item associated on an effective date.