Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClaimID | int identity | 4 | null |
|
|
Claim identifier - Unique identifier for each claim |
||
| DateEntered | datetime | 16,3 | √ | null |
|
|
Claim entry date - Date when claim was entered into the system |
|
| DateService | datetime | 16,3 | √ | null |
|
|
Service date - Date when the service was provided |
|
| DateCycle | datetime | 16,3 | √ | null |
|
|
Billing cycle date - Date of billing cycle for the claim |
|
| DateUpdate | datetime | 16,3 | √ | null |
|
|
Claim update date - Date when claim was last updated |
|
| AmountCharged | money | 21,4 | √ | null |
|
|
Amount charged - Amount charged for the service |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to Agency table for the healthcare provider |
|
| InvoiceID | varchar | 30 | √ | null |
|
|
Invoice reference - Invoice identifier for billing |
|
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the patient receiving service |
|
| ClaimTypeID | int | 4 | √ | null |
|
|
Claim type reference - Links to ClaimType table for type of claim |
|
| SiteID | int | 4 | √ | null |
|
|
Site reference - Links to AgencySite table for service location |
|
| ICN | varchar | 50 | √ | null |
|
|
Internal control number - Internal control number for claim tracking |
|
| LineNumber | varchar | 3 | √ | null |
|
|
Line number - Line number on the claim form |
|
| Enteredby | int | 4 | √ | null |
|
|
Entered by user - UserID of the person who entered the claim |
|
| StatusID | int | 4 | √ | null |
|
|
Status reference - Links to StatusType table for claim status |
|
| AmountPaid | money | 21,4 | √ | null |
|
|
Amount paid - Amount paid by insurance or payer |
|
| DatePaid | datetime | 16,3 | √ | null |
|
|
Payment date - Date when payment was received |
|
| DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when claim was billed |
|
| ActionID | int | 4 | √ | null |
|
|
Action reference - Links to ClaimAction table for claim action |
|
| ProcedureID | int | 4 | √ | null |
|
|
Procedure reference - Links to ProcCode table for procedure performed |
|
| ModifierID | int | 4 | √ | null |
|
|
Modifier reference - Links to Modifier table for procedure modifier |
|
| ServiceTypeID | int | 4 | √ | null |
|
|
Service type reference - Links to ServiceType table for type of service |
|
| ClearingHouseErrorID | int | 4 | √ | null |
|
|
Clearing house error reference - Links to ClearingHouseError table for processing errors |
|
| RuleError | varchar | 10 | √ | null |
|
|
Rule error - Business rule error code |
|
| Comments | varchar | 500 | √ | null |
|
|
Claim comments - Comments and notes about the claim |
|
| UpdateBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the claim |
|
| ClaimBy | int | 4 | √ | null |
|
|
Claimed by user - UserID of the service provider who performed the service |
|
| DateAction | datetime | 16,3 | √ | null |
|
|
Action date - Date when claim action was taken |
|
| TransType | int | 4 | √ | null |
|
|
Transaction type - Type of transaction for the claim |
|
| PriorAuth | varchar | 50 | √ | null |
|
|
Prior authorization - Prior authorization number |
|
| RemittIDNumber | int | 4 | √ | null |
|
|
Remittance ID - Remittance advice identifier |
|
| CheckNumber | int | 4 | √ | null |
|
|
Check number - Payment check number |
|
| RA_ID | int | 4 | √ | null |
|
|
Remittance advice ID - Links to remittance advice record |
|
| VoidID | int | 4 | √ | null |
|
|
Void reference - Links to VoidReason table if claim is voided |
|
| source | varchar | 2 | √ | null |
|
|
Claim source - Source of claim data entry |
|
| Dateoriginalbilled | smalldatetime | 16 | √ | null |
|
|
Original billing date - Date when claim was originally billed |
|
| TransmitType | int | 4 | √ | null |
|
|
Transmission type - Type of claim transmission (electronic, paper, etc.) |
|
| ppdID | int | 4 | √ | null |
|
|
PPD reference - Links to PPD data for claim processing |
|
| Borough | int | 4 | √ | null |
|
|
Borough - Borough or administrative region for the claim |
|
| ActivePayroll | int | 4 | √ | null |
|
|
Active payroll - Indicates if claim is part of active payroll |
|
| AmountAdjusted | money | 21,4 | √ | null |
|
|
Amount adjusted - Amount adjusted on the claim |
|
| AmountVoid | money | 21,4 | √ | null |
|
|
Amount voided - Amount voided on the claim |
|
| DateAdjusted | datetime | 16,3 | √ | null |
|
|
Adjustment date - Date when claim was adjusted |
|
| DateVoid | datetime | 16,3 | √ | null |
|
|
Void date - Date when claim was voided |
|
| fkAdmitID | int | 4 | √ | null |
|
|
Case reference - Links to PatientAdministration table for the case |
|
| PaySourceID | varchar | 30 | √ | null |
|
|
Payment source - Payment source identifier |
|
| AttCode | varchar | 10 | √ | null |
|
|
Attendance code - Attendance code for the service |
|
| fkAuthID | int | 4 | √ | null |
|
|
Authorization reference - Links to Authorization table for service authorization |
|
| OnHold | int | 4 | √ | null |
|
|
On hold flag - Indicates if claim is on hold |
|
| OrigAmountCharged | money | 21,4 | √ | null |
|
|
Original amount charged - Original amount charged before adjustments |
|
| Outstanding | money | 21,4 | √ | null |
|
|
Outstanding amount - Outstanding amount on the claim |
|
| Minutes | int | 4 | √ | null |
|
|
Service minutes - Duration of service in minutes |
|
| importID | int | 4 | √ | null |
|
|
Import reference - Reference ID for data import tracking |
|
| fkCPID | int | 4 | √ | null |
|
|
Claim type program reference - Links to claim type program configuration |
|
| StartTime | varchar | 20 | √ | null |
|
|
Service start time - Start time of the service |
|
| EndTime | varchar | 20 | √ | null |
|
|
Service end time - End time of the service |
|
| BillingUnit | decimal | 6,2 | √ | null |
|
|
Billing units - Number of billing units for the service |
|
| deptID | int | 4 | √ | null |
|
|
Department reference - Department identifier for the service |
|
| ImportDate | varchar | 30 | √ | null |
|
|
Import date - Date when claim data was imported |
|
| OrigBillingUnit | decimal | 7,2 | √ | null |
|
|
Original billing units - Original billing units before adjustments |
|
| CPTCode | varchar | 50 | √ | null |
|
|
CPT code - Current Procedural Terminology code for the service |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Claim last update date - Timestamp of the most recent claim update |
|
| IsFormCompleted | bit | 1 | √ | null |
|
|
Form completed flag - Indicates if required forms are completed |
|
| FkWaiversId | int | 4 | √ | null |
|
|
Waivers reference - Links to waivers associated with the claim |
|
| ClaimTypeName | varchar | 100 | √ | null |
|
|
Claim type name - Name of the claim type |
|
| ModifierName | varchar | 50 | √ | null |
|
|
Modifier name - Name of the procedure modifier |
|
| StatusCode | varchar | 50 | √ | null |
|
|
Status code - Status code for the claim |
|
| ActionStatus | varchar | 50 | √ | null |
|
|
Action status - Status of the claim action |
|
| ActionNotes | varchar | 5000 | √ | null |
|
|
Action notes - Notes about the claim action |
|
| ModifierDes | varchar | 100 | √ | null |
|
|
Modifier description - Description of the procedure modifier |
|
| ProcCode | varchar | 30 | √ | null |
|
|
Procedure code - Procedure code for the service |
|
| ProcName | varchar | 100 | √ | null |
|
|
Procedure name - Name of the procedure performed |
|
| ServiceType | varchar | 10 | √ | null |
|
|
Service type - Type of service provided |
|
| ServiceDesc | varchar | 100 | √ | null |
|
|
Service description - Description of the service provided |
|
| servicetypedesc | varchar | 100 | √ | null |
|
|
Service type description - Description of the service type |
|
| isOnhold | varchar | 3 | null |
|
|
Is on hold - Indicates if claim is currently on hold |
||
| code | varchar | 10 | √ | null |
|
|
Code - General code for the claim |
|
| provider | varchar | 102 | null |
|
|
Provider - Name of the service provider |
||
| providerFName | varchar | 50 | √ | null |
|
|
Provider first name - First name of the service provider |
|
| providerLName | varchar | 50 | √ | null |
|
|
Provider last name - Last name of the service provider |
|
| userTitle | varchar | 50 | null |
|
|
User title - Title of the user who provided the service |
||
| ruledescription | varchar | 100 | √ | null |
|
|
Rule description - Description of business rule |
|
| RuleErrorDesc | varchar | 100 | √ | null |
|
|
Rule error description - Description of business rule error |
Relationships
Close relationships within degrees of separation
