AttCodeInClaimType


Description

Attendance codes in claim types defining which attendance codes are valid for specific claim types and their billing configurations. This table manages the relationship between attendance tracking codes and billing claim types, controlling billability, payment rules, and verification requirements for different service delivery scenarios.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkCode varchar 15 √ null

Attendance code reference - Links to the attendance code (varchar identifier)
fkCPID int 4 √ null

Claim type reference - Links to the claim type this attendance code applies to
Billable int 4 √ null

Billable flag - Indicates if this attendance code is billable for this claim type (0=No, 1=Yes)
DisplayOrder int 4 √ null

Display order - Order in which this code appears in user interfaces
OnHold int 4 √ null

On hold flag - Indicates if billing should be placed on hold for this code
Paytherapist int 4 √ null

Pay therapist flag - Indicates if therapist should be paid for this attendance code
internalCode int 4 √ null

Internal code flag - Indicates if this is an internal-only code not for external billing
scanorder int 4 √ null

Scan order - Order for document scanning and processing workflows
VerifyTo int 4 √ null

Verification requirement - Indicates what level of verification is required
AllowDup int 4 √ null

Allow duplicates flag - Controls whether duplicate entries are allowed
DupStatuses varchar 200 √ null

Duplicate statuses - Comma-separated list of statuses where duplicates are allowed
AllowFutureDate int 4 √ null

Allow future date flag - Controls whether future dates are allowed for this code

Indexes

Constraint Name Type Sort Column(s)
IX_Code Performance Asc fkCode
IX_CPID Performance Asc fkCPID

Relationships

Close relationships within degrees of separation