PayrollCityPro


Description

Payroll city professional processing managing payroll calculations and processing for city-based professional services. This table handles complex payroll calculations including rates, hours, mileage, and various payroll types for professional staff providing services across different sites and programs, supporting comprehensive payroll management and reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Claimid int 4 null

Claim reference - Links to the service claim associated with this payroll entry
Rate float 8 null

Payroll rate - Hourly or unit rate for the service provided
UserID smallint 2 null

User reference - Links to the staff member receiving payment
DateCalculated datetime2 54 null

Calculation date - Date when the payroll calculation was performed
fkPIID smallint 2 null

Payroll invoice reference - Links to the payroll invoice record
statusid tinyint 1 null

Status identifier - Current status of the payroll entry, references iCS2.dbo.StatusType for centralized status management
ErrorCode nvarchar 100 null

Error code - Error code if there were issues with payroll processing
DateReceived datetime2 54 null

Received date - Date when the payroll data was received
Comments nvarchar 100 null

Payroll comments - Comments or notes about the payroll entry
EnteredBy smallint 2 null

Entered by user - UserID of the person who entered the payroll data
PayrollType tinyint 1 null

Payroll type - Type of payroll (Regular, Overtime, Mileage, etc.)
PayrollID int 4 null

Payroll identifier - Unique identifier for the payroll batch
NumHour nvarchar 100 null

Number of hours - Number of hours worked for this payroll entry
DateService nvarchar 100 null

Service date - Date when the service was provided
SiteID tinyint 1 null

Site reference - Links to the site where the service was provided
DateEntered datetime2 54 null

Entry date - Date when the payroll entry was created
UpdatedBy nvarchar 100 null

Updated by user - UserID of the person who last modified the payroll entry
DateUpdated nvarchar 100 null

Update date - Date when the payroll entry was last modified
fkCodeID nvarchar 100 null

Code reference - Links to the service or procedure code
fkConfigID nvarchar 100 null

Configuration reference - Links to the payroll configuration used
fkProgramID nvarchar 100 null

Program reference - Links to the program type for this payroll entry
Miles nvarchar 100 null

Mileage - Number of miles traveled for reimbursement
column23 nvarchar 100 null

Custom field 23 - Additional custom field for program-specific data
column24 nvarchar 100 null

Custom field 24 - Additional custom field for program-specific data
column25 nvarchar 100 null

Custom field 25 - Additional custom field for program-specific data
column26 nvarchar 2 √ null

Custom field 26 - Additional custom field for program-specific data

Relationships

Close relationships within degrees of separation