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 |
|
|
Entry date - Date when claim was entered |
|
| DateService | datetime | 16,3 | √ | null |
|
|
Service date - Date when service was provided |
|
| DateCycle | datetime | 16,3 | √ | null |
|
|
Billing cycle - Billing cycle date |
|
| DateUpdate | datetime | 16,3 | √ | null |
|
|
Update date - Last modification date |
|
| AmountCharged | money | 21,4 | √ | null |
|
|
Charged amount - Amount charged for service |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Healthcare provider agency |
|
| InvoiceID | varchar | 30 | √ | null |
|
|
Invoice reference - Associated invoice |
|
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Patient receiving service |
|
| ClaimTypeID | int | 4 | √ | null |
|
|
Claim type - Type of claim |
|
| SiteID | int | 4 | √ | null |
|
|
Site reference - Service delivery location |
|
| ICN | varchar | 50 | √ | null |
|
|
Internal Control Number - Claim tracking number |
|
| LineNumber | varchar | 3 | √ | null |
|
|
Line number - Line item number |
|
| Enteredby | int | 4 | √ | null |
|
|
Entered by - User who entered claim |
|
| StatusID | int | 4 | √ | null |
|
|
Status - Current claim status |
|
| AmountPaid | money | 21,4 | √ | null |
|
|
Paid amount - Amount paid by payer |
|
| DatePaid | datetime | 16,3 | √ | null |
|
|
Payment date - Date payment received |
|
| DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date claim was billed |
|
| ActionID | int | 4 | √ | null |
|
|
Action reference - Action taken on claim |
|
| ProcedureID | int | 4 | √ | null |
|
|
Procedure reference - CPT/HCPCS code |
|
| ModifierID | int | 4 | √ | null |
|
|
Modifier reference - Billing modifier |
|
| ServiceTypeID | int | 4 | √ | null |
|
|
Service type - Category 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 |
|
|
Last update date - Timestamp of the most recent claim update |
|
| IsFormCompleted | bit | 1 | √ | null |
|
|
Form completed - Flag indicating if required forms are completed |
|
| FkWaiversId | int | 4 | √ | null |
|
|
Waiver reference - Links to waiver program if applicable |
|
| ClaimTypeName | varchar | 100 | √ | null |
|
|
Claim type name - Description of claim type |
|
| ModifierName | varchar | 50 | √ | null |
|
|
Modifier name - Modifier description |
|
| StatusCode | varchar | 50 | √ | null |
|
|
Status code - Status code description |
|
| ActionStatus | varchar | 50 | √ | null |
|
|
Action status - Status of action taken |
|
| ActionNotes | varchar | 5000 | √ | null |
|
|
Action notes - Notes about action |
|
| ModifierDes | varchar | 100 | √ | null |
|
|
Modifier description - Detailed modifier description |
|
| ProcCode | varchar | 30 | √ | null |
|
|
Procedure code - CPT/HCPCS procedure code |
|
| ProcName | varchar | 30 | √ | null |
|
|
Procedure name - Procedure description |
|
| ServiceType | varchar | 10 | √ | null |
|
|
Service type - Service category |
|
| servicetypedesc | varchar | 100 | √ | null |
|
|
Service description - Detailed service description |
|
| isOnhold | varchar | 3 | null |
|
|
On hold indicator - Text indicator if claim is on hold |
||
| hold | varchar | 3 | null |
|
|
Hold status - Hold status indicator for the claim |
||
| code | varchar | 10 | √ | null |
|
|
General code - General code field for the claim |
|
| visitcodedesc | varchar | 255 | √ | null |
|
|
Visit code description - Description of the visit code |
|
| VisitCode | varchar | 255 | √ | null |
|
|
Visit code - Code identifying the type of visit |
|
| ServiceDesc | varchar | 100 | √ | null |
|
|
Service description - Description of the service provided |
|
| provider | varchar | 102 | √ | null |
|
|
Provider name - Healthcare provider |
|
| userTitle | varchar | 50 | null |
|
|
Provider title - Provider’s professional title |
||
| errorCode1 | int | 4 | √ | null |
|
|
Error code 1 - First error code for claim processing |
|
| errorCode2 | int | 4 | √ | null |
|
|
Error code 2 - Second error code for claim processing |
|
| errorCode3 | int | 4 | √ | null |
|
|
Error code 3 - Third error code for claim processing |
|
| errorCode4 | int | 4 | √ | null |
|
|
Error code 4 - Fourth error code for claim processing |
|
| CompanyName | varchar | 50 | √ | null |
|
|
Company name - Agency company name |
|
| ClientID | varchar | 15 | √ | null |
|
|
Client ID - Patient identifier |
|
| errorDesc1 | varchar | 100 | √ | null |
|
|
Error description 1 - Description of the first error |
|
| errorDesc2 | varchar | 100 | √ | null |
|
|
Error description 2 - Description of the second error |
|
| errorDesc3 | varchar | 100 | √ | null |
|
|
Error description 3 - Description of the third error |
|
| errorDesc4 | varchar | 100 | √ | null |
|
|
Error description 4 - Description of the fourth error |
|
| RuleErrorDesc | varchar | 100 | √ | null |
|
|
Rule error description - Description of business rule errors |
|
| voucher | varchar | 30 | √ | null |
|
|
Voucher number - Payment voucher |
|
| ReasonDesc | varchar | 50 | √ | null |
|
|
Reason description - Description of reason codes |
|
| VoidDesc | varchar | 500 | √ | null |
|
|
Void description - Description of void reason |
|
| currICN | char | 13 | √ | null |
|
|
Current ICN - Current internal control number |
|
| currLineNum | char | 5 | √ | null |
|
|
Current line number - Current line number on claim |
|
| NYEISID | varchar | 30 | √ | null |
|
|
NYEIS ID - New York Early Intervention System ID |
|
| NPI | varchar | 30 | √ | null |
|
|
NPI number - National Provider Identifier |
|
| ICDCodes | varchar | 100 | √ | null |
|
|
ICD codes - Diagnosis codes |
|
| CPTCode1 | varchar | 100 | √ | null |
|
|
CPT code 1 - Primary procedure code |
|
| CPTCode2 | varchar | 100 | √ | null |
|
|
CPT code 2 - Secondary procedure code |
|
| CPTCode3 | varchar | 100 | √ | null |
|
|
CPT code 3 - Tertiary procedure code |
|
| CPTCode4 | varchar | 100 | √ | null |
|
|
CPT code 4 - Quaternary procedure code |
Relationships
Close relationships within degrees of separation
