Table: Patients
| Field | Size |
| PatientRef | INT (IDENTITY) |
| FacilityRef | INT |
| PatientId | VARCHAR(20) |
| MedicalRecordNumber | VARCHAR(20) |
| AdmitDate | DATE |
| DischargeDate | DATE |
| LastName | VARCHAR(20) |
| FirstName | VARCHAR(15) |
| MiddleInitial | VARCHAR(1) |
| Address1 | VARCHAR(40) |
| Address2 | VARCHAR(40) |
| City | VARCHAR(20) |
| State | VARCHAR(2) |
| Zip | VARCHAR(10) |
| Country | VARCHAR(30) |
| DateOfBirth | DATE |
| Sex | VARCHAR(1) |
| SocialSecurityNumber | VARCHAR(11) |
| Height | REAL |
| Weight | REAL |
| Caregiver | VARCHAR(15) |
| CaregiverRelationship | VARCHAR(8) |
| EmergencyContact | VARCHAR(40) |
| ReferredBy | VARCHAR(15) |
| EnteredByRef | INT |
| PatientType | VARCHAR(25) |
| TherapyType | VARCHAR(25) |
| HomeHealthAgencyRef | INT |
| PrimaryDoctorRef | INT |
| SecondaryDoctorRef | INT |
| TertiaryDoctorRef | INT |
| PrimaryPayerRef | INT |
| SecondaryPayerRef | INT |
| TertiaryPayerRef | INT |
| Notes | TEXT |
| Note | VARCHAR(100) |
| REF_NR | INT |
| CodeStatus | VARCHAR(5) |
| LineType | VARCHAR(20) |
| BSA | REAL |
| MaritalStatus | VARCHAR(1) |
| EmploymentStatus | VARCHAR(1) |
| ConditionEmployment | BIT |
| ConditionAutoAccident | BIT |
| ConditionAccidentState | VARCHAR(2) |
| ConditionOtherAccident | BIT |
| PatientLocation | TINYINT |
| EmployerId | VARCHAR(15) |
| Smoker | TINYINT |
| HomePhone | VARCHAR(20) |
| WorkPhone | VARCHAR(20) |
| CellPhone | VARCHAR(20) |
| OtherPhone | VARCHAR(20) |
| EmergencyPhone | VARCHAR(20) |
| EmergencyOtherPhone | VARCHAR(20) |
| BranchRef | INT |
| LiaisonRef | INT |