Entity Memship

Description of Entity Memship

This is a company paid membership where the membership fees can be linked to the payroll module. When the membership fee is set to be paid by the company, you will require a free-method pay element and the date to pay this through the payroll. When the payroll is processed, the pay element will be inserted accordingly with the membership amount as the pay element amount.


List of all Dependencies of the Entity Memship

Name

Code

Class Name

Relation_376318

Relation_376318

Reference

Relation_376332

Relation_376332

Reference


List of Attributes of the Entity Memship

Name

Code

Organisation Code

OrganisationCode

PersonalSysId

PersonalSysId

MemSysId

MemSysId

Membership ID

MemId

Enrollment Date

MemEnrollDate

Expiry Date

MemExpiryDate

Membership Fee

MemFee

Payroll Date

PayrollDate

PayrollEmployeeSysId

PayrollEmployeeSysId

Pay Element ID

PayrollPayElement

Year

PayrollYear

Period

PayrollPeriod

Sub Period

PayrollSubPeriod

Processed On

PayrollProcessDate

Remarks

Remarks


Entity Attribute Organisation Code of the Entity Memship

Card of Attribute Organisation Code of the Entity Memship

Name

Organisation Code

Code

OrganisationCode

Data Type

char(20)

Mandatory

No


Description of Attribute Organisation Code of the Entity Memship

Shows the organisation code. This code is the same as the reference number. It is also the primary key for the Organisation table.


Entity Attribute PersonalSysId of the Entity Memship

Card of Attribute PersonalSysId of the Entity Memship

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity Memship

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.


Entity Attribute MemSysId of the Entity Memship

Card of Attribute MemSysId of the Entity Memship

Name

MemSysId

Code

MemSysId

Data Type

integer

Mandatory

Yes


Description of Attribute MemSysId of the Entity Memship

A system generated identity. It is blind to the user. This also acts as a primary key for the Memship table.


Entity Attribute Membership ID of the Entity Memship

Card of Attribute Membership ID of the Entity Memship

Name

Membership ID

Code

MemId

Data Type

char(20)

Mandatory

No


Description of Attribute Membership ID of the Entity Memship

Shows the identity of the membership.


Entity Attribute Enrollment Date of the Entity Memship

Card of Attribute Enrollment Date of the Entity Memship

Name

Enrollment Date

Code

MemEnrollDate

Data Type

date

Mandatory

No


Description of Attribute Enrollment Date of the Entity Memship

Shows the enrolment date of the membership.
It is in the format: DD-MM-YYYY.


Entity Attribute Expiry Date of the Entity Memship

Card of Attribute Expiry Date of the Entity Memship

Name

Expiry Date

Code

MemExpiryDate

Data Type

date

Mandatory

No


Description of Attribute Expiry Date of the Entity Memship

Shows the expiry date of the membership.
It is in the format: DD-MM-YYYY.


Entity Attribute Membership Fee of the Entity Memship

Card of Attribute Membership Fee of the Entity Memship

Name

Membership Fee

Code

MemFee

Data Type

double

Mandatory

No


Description of Attribute Membership Fee of the Entity Memship

Shows the membership fee.


Entity Attribute Payroll Date of the Entity Memship

Card of Attribute Payroll Date of the Entity Memship

Name

Payroll Date

Code

PayrollDate

Data Type

date

Mandatory

No


Description of Attribute Payroll Date of the Entity Memship

Shows the date of the payroll.
It is in the format: DD-MM-YYYY.


Entity Attribute PayrollEmployeeSysId of the Entity Memship

Card of Attribute PayrollEmployeeSysId of the Entity Memship

Name

PayrollEmployeeSysId

Code

PayrollEmployeeSysId

Data Type

integer

Mandatory

No


Description of Attribute PayrollEmployeeSysId of the Entity Memship

A system generated identity. It is blind to the user.


Entity Attribute Pay Element ID of the Entity Memship

Card of Attribute Pay Element ID of the Entity Memship

Name

Pay Element ID

Code

PayrollPayElement

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Element ID of the Entity Memship

Shows the identity of the pay element.
Example:
INCO = Income Tax Deduction / Withheld
NOIL = Notice in Lieu Deductions
NATI = National Service Pay
COMC = Community Chest
etc


Entity Attribute Year of the Entity Memship

Card of Attribute Year of the Entity Memship

Name

Year

Code

PayrollYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity Memship

Shows the year for the payroll.
Example: 2013


Entity Attribute Period of the Entity Memship

Card of Attribute Period of the Entity Memship

Name

Period

Code

PayrollPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity Memship

Shows the period of the payroll.
Example: January = "1" / February = "2" / March = "3" etc


Entity Attribute Sub Period of the Entity Memship

Card of Attribute Sub Period of the Entity Memship

Name

Sub Period

Code

PayrollSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity Memship

Shows the sub period for the payroll.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)


Entity Attribute Processed On of the Entity Memship

Card of Attribute Processed On of the Entity Memship

Name

Processed On

Code

PayrollProcessDate

Data Type

date

Mandatory

No


Description of Attribute Processed On of the Entity Memship

Shows when the payment was processed.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Remarks of the Entity Memship

Card of Attribute Remarks of the Entity Memship

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity Memship

Store remarks.