TransactionCategories


Description

Transaction category classification defining categories for financial transactions and billing operations within the healthcare system. This table organizes transaction types into logical categories, supporting transaction management, financial reporting, and accounting processes for healthcare billing and revenue cycle management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null

Primary key - Unique identifier for each transaction category
CategoryName nvarchar 500 √ null

Category name - Name of the transaction category
CategoryDescription varchar 1000 √ null

Category description - Detailed description of the transaction category
DeletedDate datetime 16,3 √ null

Deletion date - Date when the category was soft-deleted
CreatedBy int 4 √ null

Created by user - UserID of the person who created the category
CreatedDate datetime 16,3 √ null

Creation date - Date and time when the category was created
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated the category
UpdatedDate datetime 16,3 √ null

Update date - Date and time when the category was last updated

Indexes

Constraint Name Type Sort Column(s)
PK_TransactionCategories Primary key Asc ID

Relationships

Close relationships within degrees of separation