Entity PayPeriodRecord

Description of Entity PayPeriodRecord

This Table is associated with an object that automatically totals all sub pay records of that period into this record. One Period only has one record. The YTD, Import module will write into this record instead of creating sub period record.

Each payment within the pay period is placed in a sub-period. The pay period is 1 payroll cycle.
For pay periods set as 1 calendar month:
- A monthly payment group is set as a single sub period pay group.
- A weekly payment group is set as a four sub-periods pay group.


List of all Dependencies of the Entity PayPeriodRecord

Name

Code

Class Name

Relation_135639

Relation_135639

Reference

Relation_1849448

Relation_1849448

Reference

Relation_65375

Relation_65375

Reference


List of Attributes of the Entity PayPeriodRecord

Name

Code

EmployeeSysId

EmployeeSysId

PayPeriodSGSPGenId

PayPeriodSGSPGenId

Year

PayRecYear

Period

PayRecPeriod

Section ID

PaySectionId

Cost Center ID

PayCostCenterId

Category

PayCategoryId

Department

PayDepartmentId

Branch

PayBranchId

Position

PayPositionId

Pay Group

PayPayGroupId

Working Calendar

PayWorkCalendarId

Leave Group ID

PayLeaveGroupId

Salary Grade ID

PaySalaryGradeId

Classification

PayClassification

WorkTime Calendar ID

PayWTCalendarId

PayEmpCode1Id

PayEmpCode1Id

PayEmpCode2Id

PayEmpCode2Id

PayEmpCode3Id

PayEmpCode3Id

PayEmpCode4Id

PayEmpCode4Id

PayEmpCode5Id

PayEmpCode5Id


Entity Attribute EmployeeSysId of the Entity PayPeriodRecord

Card of Attribute EmployeeSysId of the Entity PayPeriodRecord

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity PayPeriodRecord

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.


Entity Attribute PayPeriodSGSPGenId of the Entity PayPeriodRecord

Card of Attribute PayPeriodSGSPGenId of the Entity PayPeriodRecord

Name

PayPeriodSGSPGenId

Code

PayPeriodSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute PayPeriodSGSPGenId of the Entity PayPeriodRecord

Shows the generating identity of the pay record for that period. This is the primary key for the PayPeriodRecord table.
Example: A1 / A66 / A110


Entity Attribute Year of the Entity PayPeriodRecord

Card of Attribute Year of the Entity PayPeriodRecord

Name

Year

Code

PayRecYear

Data Type

integer

Mandatory

Yes


Description of Attribute Year of the Entity PayPeriodRecord

Shows the year for the pay record.
Example: 2012


Entity Attribute Period of the Entity PayPeriodRecord

Card of Attribute Period of the Entity PayPeriodRecord

Name

Period

Code

PayRecPeriod

Data Type

integer

Mandatory

Yes


Description of Attribute Period of the Entity PayPeriodRecord

Shows the period for the pay record.
Example: January = "1", February = "2", March = "3" etc.


Entity Attribute Section ID of the Entity PayPeriodRecord

Card of Attribute Section ID of the Entity PayPeriodRecord

Name

Section ID

Code

PaySectionId

Data Type

char(20)

Mandatory

No


Description of Attribute Section ID of the Entity PayPeriodRecord

Shows the employee's section identity for the pay record for that period/year.


Entity Attribute Cost Center ID of the Entity PayPeriodRecord

Card of Attribute Cost Center ID of the Entity PayPeriodRecord

Name

Cost Center ID

Code

PayCostCenterId

Data Type

char(20)

Mandatory

No


Description of Attribute Cost Center ID of the Entity PayPeriodRecord

Shows the employee's cost centre identity for the pay record for that period/year.


Entity Attribute Category of the Entity PayPeriodRecord

Card of Attribute Category of the Entity PayPeriodRecord

Name

Category

Code

PayCategoryId

Data Type

char(20)

Mandatory

No


Description of Attribute Category of the Entity PayPeriodRecord

Shows the employee's category identity for the pay record for that period/year.


Entity Attribute Department of the Entity PayPeriodRecord

Card of Attribute Department of the Entity PayPeriodRecord

Name

Department

Code

PayDepartmentId

Data Type

char(20)

Mandatory

No


Description of Attribute Department of the Entity PayPeriodRecord

Shows the employee's department identity for the pay record for that period/year.
Example: Sales / Finance / HR


Entity Attribute Branch of the Entity PayPeriodRecord

Card of Attribute Branch of the Entity PayPeriodRecord

Name

Branch

Code

PayBranchId

Data Type

char(20)

Mandatory

No


Description of Attribute Branch of the Entity PayPeriodRecord

Shows the employee's branch identity for the pay record for that period/year.


Entity Attribute Position of the Entity PayPeriodRecord

Card of Attribute Position of the Entity PayPeriodRecord

Name

Position

Code

PayPositionId

Data Type

char(20)

Mandatory

No


Description of Attribute Position of the Entity PayPeriodRecord

Shows the employee's position identity for the pay record for that period/year.
Example: Clerk / Manager / Executive


Entity Attribute Pay Group of the Entity PayPeriodRecord

Card of Attribute Pay Group of the Entity PayPeriodRecord

Name

Pay Group

Code

PayPayGroupId

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Group of the Entity PayPeriodRecord

Shows the employee's pay group identity for the pay record for that period/year.
Example: 1 Payment Group / Project


Entity Attribute Working Calendar of the Entity PayPeriodRecord

Card of Attribute Working Calendar of the Entity PayPeriodRecord

Name

Working Calendar

Code

PayWorkCalendarId

Data Type

char(20)

Mandatory

No


Description of Attribute Working Calendar of the Entity PayPeriodRecord

Shows the employee's work calendar identity for the pay record for that period/year.
Example: 5 Days Week Cal


Entity Attribute Leave Group ID of the Entity PayPeriodRecord

Card of Attribute Leave Group ID of the Entity PayPeriodRecord

Name

Leave Group ID

Code

PayLeaveGroupId

Data Type

char(20)

Mandatory

No


Description of Attribute Leave Group ID of the Entity PayPeriodRecord

Shows the employee's leave group identity for the pay record for that period/year.
Example: Absent / Annual / No pay etc.


Entity Attribute Salary Grade ID of the Entity PayPeriodRecord

Card of Attribute Salary Grade ID of the Entity PayPeriodRecord

Name

Salary Grade ID

Code

PaySalaryGradeId

Data Type

char(20)

Mandatory

No


Description of Attribute Salary Grade ID of the Entity PayPeriodRecord

Shows the employee's salary grade identity for the pay record for that period/year.


Entity Attribute Classification of the Entity PayPeriodRecord

Card of Attribute Classification of the Entity PayPeriodRecord

Name

Classification

Code

PayClassification

Data Type

char(20)

Mandatory

No


Description of Attribute Classification of the Entity PayPeriodRecord

Shows the employee's categorization of what the employee does in the company for the payroll.
Example: Contract / Part-time / Project / Permanent


Entity Attribute WorkTime Calendar ID of the Entity PayPeriodRecord

Card of Attribute WorkTime Calendar ID of the Entity PayPeriodRecord

Name

WorkTime Calendar ID

Code

PayWTCalendarId

Data Type

char(20)

Mandatory

No


Description of Attribute WorkTime Calendar ID of the Entity PayPeriodRecord

Shows the work time calendar identity for the pay record.


Entity Attribute PayEmpCode1Id of the Entity PayPeriodRecord

Card of Attribute PayEmpCode1Id of the Entity PayPeriodRecord

Name

PayEmpCode1Id

Code

PayEmpCode1Id

Data Type

char(20)

Mandatory

No


Description of Attribute PayEmpCode1Id of the Entity PayPeriodRecord

Shows the code for the employee’s identity for the pay record.


Entity Attribute PayEmpCode2Id of the Entity PayPeriodRecord

Card of Attribute PayEmpCode2Id of the Entity PayPeriodRecord

Name

PayEmpCode2Id

Code

PayEmpCode2Id

Data Type

char(20)

Mandatory

No


Description of Attribute PayEmpCode2Id of the Entity PayPeriodRecord

Shows the code for the employee’s identity for the pay record.


Entity Attribute PayEmpCode3Id of the Entity PayPeriodRecord

Card of Attribute PayEmpCode3Id of the Entity PayPeriodRecord

Name

PayEmpCode3Id

Code

PayEmpCode3Id

Data Type

char(20)

Mandatory

No


Description of Attribute PayEmpCode3Id of the Entity PayPeriodRecord

Shows the code for the employee’s identity for the pay record.


Entity Attribute PayEmpCode4Id of the Entity PayPeriodRecord

Card of Attribute PayEmpCode4Id of the Entity PayPeriodRecord

Name

PayEmpCode4Id

Code

PayEmpCode4Id

Data Type

char(20)

Mandatory

No


Description of Attribute PayEmpCode4Id of the Entity PayPeriodRecord

Shows the code for the employee’s identity for the pay record.


Entity Attribute PayEmpCode5Id of the Entity PayPeriodRecord

Card of Attribute PayEmpCode5Id of the Entity PayPeriodRecord

Name

PayEmpCode5Id

Code

PayEmpCode5Id

Data Type

char(20)

Mandatory

No


Description of Attribute PayEmpCode5Id of the Entity PayPeriodRecord

Shows the code for the employee’s identity for the pay record.