Payroll and Benefit Management Models and Their Fields

PayrollStatus

• Represents the status of a payroll.

• Available statuses:

  • PENDING_APPROVAL

  • APPROVE_FOR_PAYMENT

  • REJECTED

  • RECONCILED

BenefitConsumptionStatus

• Represents the status of benefit consumption.

• Available statuses:

  • ACCEPTED

  • CREATED

  • APPROVE_FOR_PAYMENT

  • REJECTED

  • DUPLICATE

  • RECONCILED

PaymentPoint

• name: Name of the payment point.

• location: Foreign key to Location.

• ppm: Foreign key to User.

Payroll

• name: Name of the payroll.

• payment_plan: Foreign key to PaymentPlan.

• payment_cycle: Foreign key to PaymentCycle.

• payment_point: Foreign key to PaymentPoint.

• status: Status of the payroll (uses PayrollStatus choices).

• payment_method: Method of payment.

PayrollBill

• payroll: Foreign key to Payroll.

• bill: Foreign key to Bill.

PaymentAdaptorHistory

• payroll: Foreign key to Payroll.

• total_amount: Total amount as a string.

• bills_ids: JSON field for bill IDs.

BenefitConsumption

• individual: Foreign key to Individual.

• photo: Text field for photo.

• code: Code for benefit consumption.

• date_due: Due date.

• receipt: Receipt number.

• amount: Amount (decimal).

• type: Type of benefit.

• status: Status of benefit consumption (uses BenefitConsumptionStatus choices).

BenefitAttachment

• benefit: Foreign key to BenefitConsumption.

• bill: Foreign key to Bill.

PayrollBenefitConsumption

• payroll: Foreign key to Payroll.

• benefit: Foreign key to BenefitConsumption.

CsvReconciliationUpload

• payroll: Foreign key to Payroll.

• status: Status of the reconciliation upload (uses CsvReconciliationUpload.Status choices).

• error: JSON field for errors.

• file_name: Name of the file.

PayrollMutation

• payroll: Foreign key to Payroll.

• mutation: Foreign key to MutationLog.