PayrollInvoice


Description

Payroll invoice management handling payroll invoice generation, processing, and tracking for healthcare staff compensation. This table manages individual payroll invoices including voucher information, invoice dates, claim totals, amounts, processing status, and batch associations, supporting systematic payroll invoice processing, payment tracking, and financial reconciliation for healthcare provider compensation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PIID int identity 4 √ null
ClaimServiceRate.fkPIID FK__claimserv__fkPII__1F9A496F C

Primary key - Unique identifier for each payroll invoice
fkUserID int 4 √ null
AccessUser.UserID FK__PayrollIn__fkUse__1DB200FD R

Employee reference - Links to AccessUser table for the healthcare provider or staff member
VoucherID int 4 √ null

Voucher identifier - Voucher number or reference for the payroll invoice
DateInvoice datetime 16,3 √ null

Invoice date - Date when the payroll invoice was generated
TotalClaim int 4 √ null

Total claims - Number of claims included in this payroll invoice
AmountInvoice money 21,4 √ null

Invoice amount - Total monetary amount for this payroll invoice
InvoiceBy int 4 √ null

Invoice creator - Links to AccessUser table for the user who generated this invoice
Status int 4 √ null

Invoice status - Current processing status of the payroll invoice (e.g., 1=Draft, 2=Processed, 3=Paid)
fkPBID int 4 √ null
PayrollBatch.PBID FK__PayrollIn__fkPBI__1EA62536 C

Payroll batch reference - Links to PayrollBatch table for the associated payroll batch
DatePost datetime 16,3 √ null

Post date - Date when the payroll invoice was posted to the accounting system

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollInvoice__1CBDDCC4 Primary key Asc PIID

Relationships

Close relationships within degrees of separation