Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Patient_PatientID | int | 4 | null |
|
|
Patient identifier - Unique identifier for each patient/client in the system |
||
| Patient_FirstName | varchar | 50 | √ | null |
|
|
Patient first name - Patient’s given name for identification and communication |
|
| Patient_MiddleName | varchar | 50 | √ | null |
|
|
Patient middle name - Patient’s middle name or initial for complete identification |
|
| Patient_LastName | varchar | 50 | √ | null |
|
|
Patient last name - Patient’s surname for identification and alphabetical sorting |
|
| Patient_Sex | varchar | 20 | √ | null |
|
|
Patient gender - Patient’s gender for demographic reporting and appropriate care matching |
|
| Patient_DateOfBirth | datetime | 16,3 | √ | null |
|
|
Patient birth date - Patient’s date of birth for age calculations and eligibility determination |
|
| Patient_Address | varchar | 50 | √ | null |
|
|
Patient primary address - Patient’s street address for service delivery and communication |
|
| Patient_City | varchar | 50 | √ | null |
|
|
Patient city - City of patient’s primary residence |
|
| Patient_State | varchar | 50 | √ | null |
|
|
Patient state - State/province of patient’s primary residence |
|
| Patient_ZipCode | varchar | 10 | √ | null |
|
|
Patient postal code - ZIP/postal code for patient’s address |
|
| Patient_Telephone | varchar | 30 | √ | null |
|
|
Patient phone number - Primary telephone number for patient contact |
|
| Patient_Ethnicity | varchar | 20 | √ | null |
|
|
Patient ethnicity - Patient’s ethnic background for demographic reporting and cultural considerations |
|
| Patient_InsuranceID | int | 4 | √ | null |
|
|
Patient insurance reference - Links to Insurance table for primary insurance coverage |
|
| Patient_DateEntered | datetime | 16,3 | √ | null |
|
|
Patient enrollment date - Date when patient was first entered into the system |
|
| Patient_DatePrescription | datetime | 16,3 | √ | null |
|
|
Patient prescription date - Date of medical prescription or referral for services |
|
| Patient_AgencyID | int | 4 | √ | null |
|
|
Patient agency reference - Links to Agency table for the healthcare provider serving this patient |
|
| Patient_ForestCareID | int | 4 | √ | null |
|
|
ForestCare identifier - External system identifier for ForestCare integration |
|
| Patient_Comments | varchar | 500 | √ | null |
|
|
Patient comments - General comments and notes about the patient |
|
| Patient_District | int | 4 | √ | null |
|
|
Patient district - School or administrative district for the patient |
|
| Patient_Borough | char | 20 | √ | null |
|
|
Patient borough - Borough or administrative region for the patient |
|
| Patient_RxDate | datetime | 16,3 | √ | null |
|
|
Prescription date - Date of medical prescription or referral |
|
| Patient_BillingType | int | 4 | √ | null |
|
|
Patient billing type - Type of billing arrangement for the patient |
|
| Patient_DateAnnualMedical | datetime | 16,3 | √ | null |
|
|
Annual medical date - Date of annual medical examination |
|
| Patient_DateAudiological | datetime | 16,3 | √ | null |
|
|
Audiological assessment date - Date of hearing/audiological evaluation |
|
| Patient_DateVisionTest | datetime | 16,3 | √ | null |
|
|
Vision test date - Date of vision screening or examination |
|
| Patient_DateSCConsent | datetime | 16,3 | √ | null |
|
|
Service coordination consent date - Date when service coordination consent was obtained |
|
| Patient_DateReleaseInfoConsent | datetime | 16,3 | √ | null |
|
|
Information release consent date - Date when consent to release information was obtained |
|
| Patient_DateEvalConsent | datetime | 16,3 | √ | null |
|
|
Evaluation consent date - Date when evaluation consent was obtained |
|
| Patient_DateFamilyInfoWorksheet | datetime | 16,3 | √ | null |
|
|
Family information worksheet date - Date when family information worksheet was completed |
|
| Patient_DateMedicalInfoWorksheet | datetime | 16,3 | √ | null |
|
|
Medical information worksheet date - Date when medical information worksheet was completed |
|
| Patient_Date45DayLimit | datetime | 16,3 | √ | null |
|
|
45-day timeline date - Date related to 45-day service timeline requirements |
|
| Patient_DateChildInfoChange | datetime | 16,3 | √ | null |
|
|
Child information change date - Date when child information was last changed |
|
| Patient_DateSurrogacyForm | datetime | 16,3 | √ | null |
|
|
Surrogacy form date - Date when surrogacy form was completed |
|
| Patient_DateClosureForm | datetime | 16,3 | √ | null |
|
|
Closure form date - Date when case closure form was completed |
|
| Patient_OtherInsurance | char | 5 | √ | null |
|
|
Other insurance flag - Indicates if patient has additional insurance coverage |
|
| Patient_MedicalID | varchar | 50 | √ | null |
|
|
Medical record ID - Medical record number or identifier |
|
| Patient_DateHIPAAPrivacyReceived | datetime | 16,3 | √ | null |
|
|
HIPAA privacy notice date - Date when HIPAA privacy notice was received |
|
| Patient_SignatureOnFile | varchar | 1 | √ | null |
|
|
Signature on file flag - Indicates if patient signature is on file |
|
| Patient_DateSigned | datetime | 16,3 | √ | null |
|
|
Signature date - Date when consent forms were signed |
|
| Patient_Age | int | 4 | √ | null |
|
|
Patient current age - Patient’s current age (calculated field) |
|
| Patient_MaritalStatus | varchar | 3 | √ | null |
|
|
Patient marital status - Patient’s marital status (for adult patients) |
|
| Patient_DateOfDeath | datetime | 16,3 | √ | null |
|
|
Patient death date - Date of death if applicable |
|
| Patient_EmploymentStatus | varchar | 3 | √ | null |
|
|
Patient employment status - Employment status (for adult patients) |
|
| Patient_CreatedBy | int | 4 | √ | null |
|
|
Patient record created by - UserID of the person who created this patient record |
|
| Patient_DateUpdated | datetime | 16,3 | √ | null |
|
|
Patient record last update date - Timestamp of the most recent patient record update |
|
| Patient_UpdatedBy | int | 4 | √ | null |
|
|
Patient record updated by - UserID of the person who last modified this patient record |
|
| Patient_Pregnancy | varchar | 1 | √ | null |
|
|
Patient pregnancy status - Pregnancy status indicator |
|
| Patient_SiteID | int | 4 | √ | null |
|
|
Patient site reference - Links to AgencySite table for primary service location |
|
| Patient_patientStatus | varchar | 30 | √ | null |
|
|
Patient status - Current status of the patient in the system |
|
| Patient_source | varchar | 2 | √ | null |
|
|
Patient data source - Source of patient data entry |
|
| Patient_Address2 | varchar | 50 | √ | null |
|
|
Patient address line 2 - Additional address information (apartment, suite, etc.) |
|
| Patient_InternalID | int | 4 | √ | null |
|
|
Patient internal ID - Internal system identifier |
|
| Patient_Email | varchar | 100 | √ | null |
|
|
Patient email address - Patient or guardian email for communication |
|
| Patient_ImportID | int | 4 | √ | null |
|
|
Patient import identifier - Reference ID for data migration and import tracking |
|
| Patient_ProfileImage | nvarchar | 1073741823 | √ | null |
|
|
Patient profile image - Patient profile photo or image |
|
| Patient_ListClassrooms | nvarchar | 1073741823 | √ | null |
|
|
Patient classroom list - List of classrooms associated with the patient |
|
| ClaimCustom_pkID | int | 4 | null |
|
|
Claim custom primary key - Unique identifier for each custom claim record |
||
| ClaimCustom_fkClaimID | int | 4 | null |
|
|
Claim custom claim reference - Links to Claim table for the associated claim |
||
| ClaimCustom_DateCreated | datetime | 16,3 | √ | null |
|
|
Claim custom creation date - Timestamp when the custom claim record was created |
|
| ClaimCustom_CreatedBy | int | 4 | √ | null |
|
|
Claim custom created by - UserID of the person who created this custom claim record |
|
| ClaimCustom_DateUpdated | datetime | 16,3 | √ | null |
|
|
Claim custom last update date - Timestamp of the most recent custom claim record update |
|
| ClaimCustom_UpdatedBy | int | 4 | √ | null |
|
|
Claim custom updated by - UserID of the person who last modified this custom claim record |
|
| ClaimCustom_DeletedDate | datetime | 16,3 | √ | null |
|
|
Claim custom deletion date - Soft delete timestamp for audit trail purposes |
|
| ClaimCustom_TestField | nvarchar | 510 | √ | null |
|
|
Claim test field - Test field for custom claim data |
|
| ClaimCustom_SessionParticipants | nvarchar | 510 | √ | null |
|
|
Session participants - Participants in the therapy/service session |
|
| ClaimCustom_UnableToParticipate | nvarchar | 510 | √ | null |
|
|
Unable to participate - Reasons why patient was unable to participate |
|
| ClaimCustom_SessionProgress | nvarchar | 1998 | √ | null |
|
|
Session progress - Progress made during the therapy/service session |
|
| ClaimCustom_ObjectivesAddressed | nvarchar | 1998 | √ | null |
|
|
Objectives addressed - Specific objectives addressed during the session |
|
| ClaimCustom_RoutineActivities | nvarchar | 510 | √ | null |
|
|
Routine activities - Routine activities performed during the session |
|
| ClaimCustom_StrategiesUsed | nvarchar | 510 | √ | null |
|
|
Strategies used - Therapeutic strategies used during the session |
|
| ClaimCustom_CoachCaregiver | nvarchar | 510 | √ | null |
|
|
Coach caregiver - Caregiver coaching activities performed |
|
| ClaimCustom_CaregiverCommunicate | nvarchar | 1998 | √ | null |
|
|
Caregiver communication - Communication with caregiver during session |
|
| ClaimCustom_CaregiverActivities | nvarchar | 1998 | √ | null |
|
|
Caregiver activities - Activities involving caregiver participation |
|
| ClaimCustom_Haircolor | nvarchar | 510 | √ | null |
|
|
Hair color - Hair color field (custom attribute) |
|
| ClaimCustom_Notes | nvarchar | 1073741823 | √ | null |
|
|
Claim custom notes - Additional notes and observations for the claim |
|
| ClaimCustom_specify | nvarchar | 1073741823 | √ | null |
|
|
Specify details - Additional specification details for custom fields |
|
| ClaimCustom_ParticipantOther | nvarchar | 1073741823 | √ | null |
|
|
Other participants - Other participants not listed in standard categories |
|
| ClaimCustom_Additionalinformationaboutthesession | nvarchar | 1073741823 | √ | null |
|
|
Additional session information - Additional information about the therapy/service session |
|
| ClaimCustom_RoutineActivitiesOther | nvarchar | 1073741823 | √ | null |
|
|
Other routine activities - Other routine activities not listed in standard categories |
|
| ClaimCustom_StrategiesOther | nvarchar | 1073741823 | √ | null |
|
|
Other strategies - Other therapeutic strategies not listed in standard categories |
|
| ClaimCustom_CoachingOther | nvarchar | 1073741823 | √ | null |
|
|
Other coaching - Other coaching activities not listed in standard categories |
|
| ClaimCustom_RelationshipToChild | nvarchar | 510 | √ | null |
|
|
Relationship to child - Relationship of participant to the child/patient |
|
| ClaimCustom_ProviderCredentials | nvarchar | 510 | √ | null |
|
|
Provider credentials - Credentials of the service provider |
|
| ClaimCustom_GeneralNotes | nvarchar | 1073741823 | √ | null |
|
|
General notes - General notes about the claim or service |
|
| ClaimCustom_InitialCPSEMeeting | nvarchar | 6000 | √ | null |
|
|
Initial CPSE meeting - Information about initial Committee on Preschool Special Education meeting |
|
| ClaimCustom_AdditionalNotes | nvarchar | 510 | √ | null |
|
|
Additional notes - Additional notes for the claim |
|
| ClaimCustom_Classifiedasapreschoolchildwithadisability | nvarchar | 6000 | √ | null |
|
|
Classified as preschool child with disability - Classification status for preschool children with disabilities |
|
| ClaimCustom_Eligibilityform | nvarchar | 6000 | √ | null |
|
|
Eligibility form - Eligibility form information |
|
| ClaimCustom_ChairpersonName | nvarchar | 510 | √ | null |
|
|
Chairperson name - Name of meeting chairperson |
|
| ClaimCustom_Services | nvarchar | 510 | √ | null |
|
|
Services - Services provided or discussed |
|
| ClaimCustom_CPSEStartDate | nvarchar | 510 | √ | null |
|
|
CPSE start date - Start date for Committee on Preschool Special Education services |
|
| ClaimCustom_ExtraNotes | nvarchar | 6000 | √ | null |
|
|
Extra notes - Extra notes field for additional information |
|
| ClaimCustom_ExtraNoteSpace | nvarchar | 6000 | √ | null |
|
|
Extra note space - Additional space for extra notes |
|
| ClaimCustom_District | nvarchar | 510 | √ | null |
|
|
District - School or administrative district information |
|
| Claim_ClaimID | int | 4 | null |
|
|
Claim identifier - Unique identifier for each claim |
||
| Claim_DateEntered | datetime | 16,3 | √ | null |
|
|
Claim entry date - Date when claim was entered into the system |
|
| Claim_DateService | datetime | 16,3 | √ | null |
|
|
Service date - Date when the service was provided |
|
| Claim_DateCycle | datetime | 16,3 | √ | null |
|
|
Billing cycle date - Date of billing cycle for the claim |
|
| Claim_DateUpdate | datetime | 16,3 | √ | null |
|
|
Claim update date - Date when claim was last updated |
|
| Claim_AmountCharged | money | 21,4 | √ | null |
|
|
Amount charged - Amount charged for the service |
|
| Claim_AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to Agency table for the healthcare provider |
|
| Claim_InvoiceID | varchar | 30 | √ | null |
|
|
Invoice reference - Invoice identifier for billing |
|
| Claim_PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the patient receiving service |
|
| Claim_ClaimTypeID | int | 4 | √ | null |
|
|
Claim type reference - Links to ClaimType table for type of claim |
|
| Claim_SiteID | int | 4 | √ | null |
|
|
Site reference - Links to AgencySite table for service location |
|
| Claim_ICN | varchar | 50 | √ | null |
|
|
Internal control number - Internal control number for claim tracking |
|
| Claim_LineNumber | varchar | 3 | √ | null |
|
|
Line number - Line number on the claim form |
|
| Claim_Enteredby | int | 4 | √ | null |
|
|
Entered by user - UserID of the person who entered the claim |
|
| Claim_StatusID | int | 4 | √ | null |
|
|
Status reference - Links to StatusType table for claim status |
|
| Claim_AmountPaid | money | 21,4 | √ | null |
|
|
Amount paid - Amount paid by insurance or payer |
|
| Claim_DatePaid | datetime | 16,3 | √ | null |
|
|
Payment date - Date when payment was received |
|
| Claim_DateBilled | datetime | 16,3 | √ | null |
|
|
Billing date - Date when claim was billed |
|
| Claim_ActionID | int | 4 | √ | null |
|
|
Action reference - Links to ClaimAction table for claim action |
|
| Claim_ProcedureID | int | 4 | √ | null |
|
|
Procedure reference - Links to ProcCode table for procedure performed |
|
| Claim_ModifierID | int | 4 | √ | null |
|
|
Modifier reference - Links to Modifier table for procedure modifier |
|
| Claim_ServiceTypeID | int | 4 | √ | null |
|
|
Service type reference - Links to ServiceType table for type of service |
|
| Claim_ClearingHouseErrorID | int | 4 | √ | null |
|
|
Clearing house error reference - Links to ClearingHouseError table for processing errors |
|
| Claim_RuleError | varchar | 10 | √ | null |
|
|
Rule error - Business rule error code |
|
| Claim_Comments | varchar | 500 | √ | null |
|
|
Claim comments - Comments and notes about the claim |
|
| Claim_UpdateBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the claim |
|
| Claim_ClaimBy | int | 4 | √ | null |
|
|
Claimed by user - UserID of the service provider who performed the service |
|
| Claim_DateAction | datetime | 16,3 | √ | null |
|
|
Action date - Date when claim action was taken |
|
| Claim_TransType | int | 4 | √ | null |
|
|
Transaction type - Type of transaction for the claim |
|
| Claim_PriorAuth | varchar | 50 | √ | null |
|
|
Prior authorization - Prior authorization number |
|
| Claim_RemittIDNumber | int | 4 | √ | null |
|
|
Remittance ID - Remittance advice identifier |
|
| Claim_CheckNumber | int | 4 | √ | null |
|
|
Check number - Payment check number |
|
| Claim_RA_ID | int | 4 | √ | null |
|
|
Remittance advice ID - Links to remittance advice record |
|
| Claim_VoidID | int | 4 | √ | null |
|
|
Void reference - Links to VoidReason table if claim is voided |
|
| Claim_source | varchar | 2 | √ | null |
|
|
Claim source - Source of claim data entry |
|
| Claim_Dateoriginalbilled | smalldatetime | 16 | √ | null |
|
|
Original billing date - Date when claim was originally billed |
|
| Claim_TransmitType | int | 4 | √ | null |
|
|
Transmission type - Type of claim transmission (electronic, paper, etc.) |
|
| Claim_ppdID | int | 4 | √ | null |
|
|
PPD reference - Links to PPD data for claim processing |
|
| Claim_Borough | int | 4 | √ | null |
|
|
Borough - Borough or administrative region for the claim |
|
| Claim_ActivePayroll | int | 4 | √ | null |
|
|
Active payroll - Indicates if claim is part of active payroll |
|
| Claim_AmountAdjusted | money | 21,4 | √ | null |
|
|
Amount adjusted - Amount adjusted on the claim |
|
| Claim_AmountVoid | money | 21,4 | √ | null |
|
|
Amount voided - Amount voided on the claim |
|
| Claim_DateAdjusted | datetime | 16,3 | √ | null |
|
|
Adjustment date - Date when claim was adjusted |
|
| Claim_DateVoid | datetime | 16,3 | √ | null |
|
|
Void date - Date when claim was voided |
|
| Claim_fkAdmitID | int | 4 | √ | null |
|
|
Case reference - Links to PatientAdministration table for the case |
|
| Claim_PaySourceID | varchar | 30 | √ | null |
|
|
Payment source - Payment source identifier |
|
| Claim_AttCode | varchar | 10 | √ | null |
|
|
Attendance code - Attendance code for the service |
|
| Claim_fkAuthID | int | 4 | √ | null |
|
|
Authorization reference - Links to Authorization table for service authorization |
|
| Claim_OnHold | int | 4 | √ | null |
|
|
On hold flag - Indicates if claim is on hold |
|
| Claim_OrigAmountCharged | money | 21,4 | √ | null |
|
|
Original amount charged - Original amount charged before adjustments |
|
| Claim_Outstanding | money | 21,4 | √ | null |
|
|
Outstanding amount - Outstanding amount on the claim |
|
| Claim_Minutes | int | 4 | √ | null |
|
|
Service minutes - Duration of service in minutes |
|
| Claim_importID | int | 4 | √ | null |
|
|
Import reference - Reference ID for data import tracking |
|
| Claim_fkCPID | int | 4 | √ | null |
|
|
Claim type program reference - Links to claim type program configuration |
|
| Claim_StartTime | varchar | 20 | √ | null |
|
|
Service start time - Start time of the service |
|
| Claim_EndTime | varchar | 20 | √ | null |
|
|
Service end time - End time of the service |
|
| Claim_BillingUnit | decimal | 6,2 | √ | null |
|
|
Billing units - Number of billing units for the service |
|
| Claim_deptID | int | 4 | √ | null |
|
|
Department reference - Department identifier for the service |
|
| Claim_ImportDate | varchar | 30 | √ | null |
|
|
Import date - Date when claim data was imported |
|
| Claim_OrigBillingUnit | decimal | 7,2 | √ | null |
|
|
Original billing units - Original billing units before adjustments |
|
| Claim_CPTCode | varchar | 50 | √ | null |
|
|
CPT code - Current Procedural Terminology code for the service |
|
| Claim_DateUpdated | datetime | 16,3 | √ | null |
|
|
Claim last update date - Timestamp of the most recent claim update |
|
| Claim_VW_ClaimID | int | 4 | null |
|
|
Claim view identifier - Unique identifier for each claim in the view |
||
| Claim_VW_DateEntered | datetime | 16,3 | √ | null |
|
|
Claim view entry date - Date when claim was entered into the system |
|
| Claim_VW_DateService | datetime | 16,3 | √ | null |
|
|
Claim view service date - Date when the service was provided |
|
| Claim_VW_DateCycle | datetime | 16,3 | √ | null |
|
|
Claim view billing cycle date - Date of billing cycle for the claim |
|
| Claim_VW_DateUpdate | datetime | 16,3 | √ | null |
|
|
Claim view update date - Date when claim was last updated |
|
| Claim_VW_AmountCharged | money | 21,4 | √ | null |
|
|
Claim view amount charged - Amount charged for the service |
|
| Claim_VW_AgencyID | int | 4 | √ | null |
|
|
Claim view agency reference - Links to Agency table for the healthcare provider |
|
| Claim_VW_InvoiceID | varchar | 30 | √ | null |
|
|
Claim view invoice reference - Invoice identifier for billing |
|
| Claim_VW_PatientID | int | 4 | √ | null |
|
|
Claim view patient reference - Links to Patient table for the patient receiving service |
|
| Claim_VW_ClaimTypeID | int | 4 | √ | null |
|
|
Claim view claim type reference - Links to ClaimType table for type of claim |
|
| Claim_VW_SiteID | int | 4 | √ | null |
|
|
Claim view site reference - Links to AgencySite table for service location |
|
| Claim_VW_ICN | varchar | 50 | √ | null |
|
|
Claim view internal control number - Internal control number for claim tracking |
|
| Claim_VW_LineNumber | varchar | 3 | √ | null |
|
|
Claim view line number - Line number on the claim form |
|
| Claim_VW_Enteredby | int | 4 | √ | null |
|
|
Claim view entered by user - UserID of the person who entered the claim |
|
| Claim_VW_StatusID | int | 4 | √ | null |
|
|
Claim view status reference - Links to StatusType table for claim status |
|
| Claim_VW_AmountPaid | money | 21,4 | √ | null |
|
|
Claim view amount paid - Amount paid by insurance or payer |
|
| Claim_VW_DatePaid | datetime | 16,3 | √ | null |
|
|
Claim view payment date - Date when payment was received |
|
| Claim_VW_DateBilled | datetime | 16,3 | √ | null |
|
|
Claim view billing date - Date when claim was billed |
|
| Claim_VW_ActionID | int | 4 | √ | null |
|
|
Claim view action reference - Links to ClaimAction table for claim action |
|
| Claim_VW_ProcedureID | int | 4 | √ | null |
|
|
Claim view procedure reference - Links to ProcCode table for procedure performed |
|
| Claim_VW_ModifierID | int | 4 | √ | null |
|
|
Claim view modifier reference - Links to Modifier table for procedure modifier |
|
| Claim_VW_ServiceTypeID | int | 4 | √ | null |
|
|
Claim view service type reference - Links to ServiceType table for type of service |
|
| Claim_VW_ClearingHouseErrorID | int | 4 | √ | null |
|
|
Claim view clearing house error reference - Links to ClearingHouseError table for processing errors |
|
| Claim_VW_RuleError | varchar | 10 | √ | null |
|
|
Claim view rule error - Business rule error code |
|
| Claim_VW_Comments | varchar | 500 | √ | null |
|
|
Claim view comments - Comments and notes about the claim |
|
| Claim_VW_UpdateBy | int | 4 | √ | null |
|
|
Claim view updated by user - UserID of the person who last updated the claim |
|
| Claim_VW_ClaimBy | int | 4 | √ | null |
|
|
Claim view claimed by user - UserID of the service provider who performed the service |
|
| Claim_VW_DateAction | datetime | 16,3 | √ | null |
|
|
Claim view action date - Date when claim action was taken |
|
| Claim_VW_TransType | int | 4 | √ | null |
|
|
Claim view transaction type - Type of transaction for the claim |
|
| Claim_VW_PriorAuth | varchar | 50 | √ | null |
|
|
Claim view prior authorization - Prior authorization number |
|
| Claim_VW_RemittIDNumber | int | 4 | √ | null |
|
|
Claim view remittance ID - Remittance advice identifier |
|
| Claim_VW_CheckNumber | int | 4 | √ | null |
|
|
Claim view check number - Payment check number |
|
| Claim_VW_RA_ID | int | 4 | √ | null |
|
|
Claim view remittance advice ID - Links to remittance advice record |
|
| Claim_VW_VoidID | int | 4 | √ | null |
|
|
Claim view void reference - Links to VoidReason table if claim is voided |
|
| Claim_VW_source | varchar | 2 | √ | null |
|
|
Claim view source - Source of claim data entry |
|
| Claim_VW_Dateoriginalbilled | smalldatetime | 16 | √ | null |
|
|
Claim view original billing date - Date when claim was originally billed |
|
| Claim_VW_TransmitType | int | 4 | √ | null |
|
|
Claim view transmission type - Type of claim transmission (electronic, paper, etc.) |
|
| Claim_VW_ppdID | int | 4 | √ | null |
|
|
Claim view PPD reference - Links to PPD data for claim processing |
|
| Claim_VW_Borough | int | 4 | √ | null |
|
|
Claim view borough - Borough or administrative region for the claim |
|
| Claim_VW_ActivePayroll | int | 4 | √ | null |
|
|
Claim view active payroll - Indicates if claim is part of active payroll |
|
| Claim_VW_AmountAdjusted | money | 21,4 | √ | null |
|
|
Claim view amount adjusted - Amount adjusted on the claim |
|
| Claim_VW_AmountVoid | money | 21,4 | √ | null |
|
|
Claim view amount voided - Amount voided on the claim |
|
| Claim_VW_DateAdjusted | datetime | 16,3 | √ | null |
|
|
Claim view adjustment date - Date when claim was adjusted |
|
| Claim_VW_DateVoid | datetime | 16,3 | √ | null |
|
|
Claim view void date - Date when claim was voided |
|
| Claim_VW_fkAdmitID | int | 4 | √ | null |
|
|
Claim view case reference - Links to PatientAdministration table for the case |
|
| Claim_VW_PaySourceID | varchar | 30 | √ | null |
|
|
Claim view payment source - Payment source identifier |
|
| Claim_VW_AttCode | varchar | 10 | √ | null |
|
|
Claim view attendance code - Attendance code for the service |
|
| Claim_VW_fkAuthID | int | 4 | √ | null |
|
|
Claim view authorization reference - Links to Authorization table for service authorization |
|
| Claim_VW_OnHold | int | 4 | √ | null |
|
|
Claim view on hold flag - Indicates if claim is on hold |
|
| Claim_VW_OrigAmountCharged | money | 21,4 | √ | null |
|
|
Claim view original amount charged - Original amount charged before adjustments |
|
| Claim_VW_Outstanding | money | 21,4 | √ | null |
|
|
Claim view outstanding amount - Outstanding amount on the claim |
|
| Claim_VW_Minutes | int | 4 | √ | null |
|
|
Claim view service minutes - Duration of service in minutes |
|
| Claim_VW_importID | int | 4 | √ | null |
|
|
Claim view import reference - Reference ID for data import tracking |
|
| Claim_VW_fkCPID | int | 4 | √ | null |
|
|
Claim view claim type program reference - Links to claim type program configuration |
|
| Claim_VW_StartTime | varchar | 20 | √ | null |
|
|
Claim view service start time - Start time of the service |
|
| Claim_VW_EndTime | varchar | 20 | √ | null |
|
|
Claim view service end time - End time of the service |
|
| Claim_VW_BillingUnit | decimal | 6,2 | √ | null |
|
|
Claim view billing units - Number of billing units for the service |
|
| Claim_VW_deptID | int | 4 | √ | null |
|
|
Claim view department reference - Department identifier for the service |
|
| Claim_VW_ImportDate | varchar | 30 | √ | null |
|
|
Claim view import date - Date when claim data was imported |
|
| Claim_VW_OrigBillingUnit | decimal | 7,2 | √ | null |
|
|
Claim view original billing units - Original billing units before adjustments |
|
| Claim_VW_CPTCode | varchar | 50 | √ | null |
|
|
Claim view CPT code - Current Procedural Terminology code for the service |
|
| Claim_VW_DateUpdated | datetime | 16,3 | √ | null |
|
|
Claim view last update date - Timestamp of the most recent claim update |
|
| Claim_VW_ClaimTypeName | varchar | 100 | √ | null |
|
|
Claim view claim type name - Name of the claim type |
|
| Claim_VW_ModifierName | varchar | 50 | √ | null |
|
|
Claim view modifier name - Name of the procedure modifier |
|
| Claim_VW_StatusCode | varchar | 50 | √ | null |
|
|
Claim view status code - Status code description for the claim |
|
| Claim_VW_ActionStatus | varchar | 50 | √ | null |
|
|
Claim view action status - Status description for claim action |
|
| Claim_VW_ActionNotes | varchar | 5000 | √ | null |
|
|
Claim view action notes - Notes about claim actions taken |
|
| Claim_VW_ModifierDes | varchar | 100 | √ | null |
|
|
Claim view modifier description - Description of the procedure modifier |
|
| Claim_VW_ProcCode | varchar | 30 | √ | null |
|
|
Claim view procedure code - Procedure code for the service |
|
| Claim_VW_ProcName | varchar | 30 | √ | null |
|
|
Claim view procedure name - Name of the procedure performed |
|
| Claim_VW_ServiceType | varchar | 10 | √ | null |
|
|
Claim view service type - Type of service provided |
|
| Claim_VW_servicetypedesc | varchar | 100 | √ | null |
|
|
Claim view service type description - Description of the service type |
|
| Claim_VW_isOnhold | varchar | 3 | null |
|
|
Claim view on hold indicator - Text indicator if claim is on hold |
||
| Claim_VW_hold | varchar | 3 | null |
|
|
Claim view hold status - Hold status indicator for the claim |
||
| Claim_VW_code | varchar | 10 | √ | null |
|
|
Claim view code - General code field for the claim |
|
| Claim_VW_visitcodedesc | varchar | 255 | √ | null |
|
|
Claim view visit code description - Description of the visit code |
|
| Claim_VW_VisitCode | varchar | 255 | √ | null |
|
|
Claim view visit code - Code identifying the type of visit |
|
| Claim_VW_ServiceDesc | varchar | 100 | √ | null |
|
|
Claim view service description - Description of the service provided |
|
| Claim_VW_provider | varchar | 102 | √ | null |
|
|
Claim view provider - Name of the service provider |
|
| Claim_VW_userTitle | varchar | 50 | null |
|
|
Claim view user title - Title of the user who entered the claim |
||
| Claim_VW_errorCode1 | int | 4 | √ | null |
|
|
Claim view error code 1 - First error code for claim processing |
|
| Claim_VW_errorCode2 | int | 4 | √ | null |
|
|
Claim view error code 2 - Second error code for claim processing |
|
| Claim_VW_errorCode3 | int | 4 | √ | null |
|
|
Claim view error code 3 - Third error code for claim processing |
|
| Claim_VW_errorCode4 | int | 4 | √ | null |
|
|
Claim view error code 4 - Fourth error code for claim processing |
|
| Claim_VW_CompanyName | varchar | 50 | √ | null |
|
|
Claim view company name - Name of the company or agency |
|
| Claim_VW_ClientID | varchar | 15 | √ | null |
|
|
Claim view client ID - Client identifier for the claim |
|
| Claim_VW_errorDesc1 | varchar | 100 | √ | null |
|
|
Claim view error description 1 - Description of the first error |
|
| Claim_VW_errorDesc2 | varchar | 100 | √ | null |
|
|
Claim view error description 2 - Description of the second error |
|
| Claim_VW_errorDesc3 | varchar | 100 | √ | null |
|
|
Claim view error description 3 - Description of the third error |
|
| Claim_VW_errorDesc4 | varchar | 100 | √ | null |
|
|
Claim view error description 4 - Description of the fourth error |
|
| Claim_VW_RuleErrorDesc | varchar | 100 | √ | null |
|
|
Claim view rule error description - Description of business rule errors |
|
| Claim_VW_voucher | varchar | 30 | √ | null |
|
|
Claim view voucher - Voucher number for the claim |
|
| Claim_VW_ReasonDesc | varchar | 50 | √ | null |
|
|
Claim view reason description - Description of reason codes |
|
| Claim_VW_VoidDesc | varchar | 500 | √ | null |
|
|
Claim view void description - Description of void reason |
|
| Claim_VW_currICN | char | 13 | √ | null |
|
|
Claim view current ICN - Current internal control number |
|
| Claim_VW_currLineNum | char | 5 | √ | null |
|
|
Claim view current line number - Current line number on claim |
|
| Claim_VW_NYEISID | varchar | 30 | √ | null |
|
|
Claim view NYEIS ID - New York Early Intervention System identifier |
|
| Claim_VW_NPI | varchar | 30 | √ | null |
|
|
Claim view NPI - National Provider Identifier |
|
| Claim_VW_ICDCodes | varchar | 100 | √ | null |
|
|
Claim view ICD codes - International Classification of Diseases codes |
|
| Claim_VW_CPTCode1 | varchar | 100 | √ | null |
|
|
Claim view CPT code 1 - First Current Procedural Terminology code |
|
| Claim_VW_CPTCode2 | varchar | 100 | √ | null |
|
|
Claim view CPT code 2 - Second Current Procedural Terminology code |
|
| Claim_VW_CPTCode3 | varchar | 100 | √ | null |
|
|
Claim view CPT code 3 - Third Current Procedural Terminology code |
|
| Claim_VW_CPTCode4 | varchar | 100 | √ | null |
|
|
Claim view CPT code 4 - Fourth Current Procedural Terminology code |
Relationships
Close relationships within degrees of separation
