Entity DMBRecord

Description of Entity DMBRecord

This entity is for the Philippines Payroll.


List of all Dependencies of the Entity DMBRecord

Name

Code

Class Name

Relationship_747

Relationship_747

Reference

Relationship_748

Relationship_748

Reference

Relationship_751

Relationship_751

Reference


List of Attributes of the Entity DMBRecord

Name

Code

EmployeeSysId

EmployeeSysId

DMBRecSGSPGenId

DMBRecSGSPGenId

Year

PayRecYear

Period

PayRecPeriod

Sub Period

PayRecSubPeriod

Pay Rec ID

PayRecID

DMB Amount

DMBAmount


Entity Attribute EmployeeSysId of the Entity DMBRecord

Card of Attribute EmployeeSysId of the Entity DMBRecord

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

No


Description of Attribute EmployeeSysId of the Entity DMBRecord

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


Entity Attribute DMBRecSGSPGenId of the Entity DMBRecord

Card of Attribute DMBRecSGSPGenId of the Entity DMBRecord

Name

DMBRecSGSPGenId

Code

DMBRecSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute DMBRecSGSPGenId of the Entity DMBRecord

Shows the generating identity of the Department of Budget and Management (DBM) record.
Example: A1 / A66 / A110


Entity Attribute Year of the Entity DMBRecord

Card of Attribute Year of the Entity DMBRecord

Name

Year

Code

PayRecYear

Data Type

integer

Mandatory

No


Description of Attribute Year of the Entity DMBRecord

Shows the year for the pay record.
Example: 2012


Entity Attribute Period of the Entity DMBRecord

Card of Attribute Period of the Entity DMBRecord

Name

Period

Code

PayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute Period of the Entity DMBRecord

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


Entity Attribute Sub Period of the Entity DMBRecord

Card of Attribute Sub Period of the Entity DMBRecord

Name

Sub Period

Code

PayRecSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute Sub Period of the Entity DMBRecord

Holds the sub period for the pay record.

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 Pay Rec ID of the Entity DMBRecord

Card of Attribute Pay Rec ID of the Entity DMBRecord

Name

Pay Rec ID

Code

PayRecID

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Rec ID of the Entity DMBRecord

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet


Entity Attribute DMB Amount of the Entity DMBRecord

Card of Attribute DMB Amount of the Entity DMBRecord

Name

DMB Amount

Code

DMBAmount

Data Type

double

Mandatory

No


Description of Attribute DMB Amount of the Entity DMBRecord

Shows the amount for the DMB record.