PayrollBatch


Description

Payroll batch processing managing payroll batch creation, processing, and status tracking for healthcare provider compensation. This table coordinates payroll batch operations including batch dates, total invoice counts, batch amounts, processing status, and check dates, supporting systematic payroll processing, batch management, and financial reconciliation for healthcare staff compensation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PBID int identity 4 √ null
PayrollInvoice.fkPBID FK__PayrollIn__fkPBI__1EA62536 C

Primary key - Unique identifier for each payroll batch
DateBatch datetime 16,3 √ null

Batch date - Date when the payroll batch was created or processed
TotalInvoice int 4 √ null

Total invoices - Number of invoices included in this payroll batch
AmountBatch money 21,4 √ null

Batch amount - Total monetary amount for the entire payroll batch
BatchBy int 4 √ null

Batch creator - Links to AccessUser table for the user who created this batch
Status int 4 √ null

Batch status - Current processing status of the payroll batch (e.g., 1=Open, 2=Processed, 3=Closed)
DateCheck smalldatetime 16 √ null

Check date - Date when checks were issued or payments were processed for this batch

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollBatch__1705036E Primary key Asc PBID

Relationships

Close relationships within degrees of separation