Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
WorkersComp
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| WorkersCompSID | INTEGER | ? | MANDATORY | System generated unique identifier. Uses the Ailment sequence. |
| PlanID | INTEGER | ? | OPTIONAL | FK |
| PolicyNumber | CHARACTER(20) | OPTIONAL | FK | |
| CompanyID | INTEGER | ? | OPTIONAL | FK |
| DisabilityType | CHARACTER(1) | OPTIONAL | User entered. Type of disability. Field is supported by the lookup types:[DisabilityType]. Values are defined in the LookupCode table for the above lookup types. | |
| DisabilityBeginDate | DATE | OPTIONAL | User entered date disability began. | |
| ResumeModifiedWorkDate | DATE | OPTIONAL | User entered date patient may resume modified work. | |
| Occupation | CHARACTER(20) | OPTIONAL | User entered occupation of patient. | |
| InjuryLocationAddress | CHARACTER(20) | OPTIONAL | User entered address of injury location. | |
| DisabilityEndDate | DATE | OPTIONAL | User entered date disability ended. | |
| LastWorkDate | DATE | OPTIONAL | User entered date patient last worked. | |
| ResumedWorkDate | DATE | OPTIONAL | User entered date patient resumed work. | |
| ResumeUsualWorkDate | DATE | OPTIONAL | User entered date patient may resume usual work. | |
| InjuryLocationCity | CHARACTER(25) | OPTIONAL | User entered city of injury location. | |
| InjuryLocationCounty | CHARACTER(20) | OPTIONAL | User entered county of injury location. | |
| InjuryLocationState | CHARACTER(2) | OPTIONAL | User entered state of injury location. | |
| InjuryLocationZip | CHARACTER(10) | OPTIONAL | User entered zip of injury location. | |
| NatureOfBusiness | CHARACTER(40) | OPTIONAL | User entered nature of patient's business. | |
| PhysicalTherapyReq | CHARACTER(1) | OPTIONAL | User entered flag to indicate if physical therapy is required. Possible values are (Y)es or (N)o. Values are validated by the lookup type Confirmation. | |
| FurtherTreatmentReq | CHARACTER(1) | OPTIONAL | User entered flag to indicate if further treatment is required. Possible values are (Y)es or (N)o. Values are validated by the lookup type Confirmation. | |
| CanPerformUsualWork | CHARACTER(1) | OPTIONAL | User entered flag to indicate the patient can perform usual work. Valid values are (Y)es (N)o. | |
| ImpedingConditionPresent | CHARACTER(1) | OPTIONAL | User entered flag to indicate an impeding condition is present. Valid values are (Y)es (N)o. | |
| ConditionExpl | CHARACTER(60) | OPTIONAL | User entered explanation. | |
| FindingsConsistent | CHARACTER(1) | OPTIONAL | User entered flag to indicate the doctors findings are consistent. Valid values are (Y)es (N)o. | |
| FindingsExpl | CHARACTER(60) | OPTIONAL | User entered explanation. | |
| FirstPrintDate | DATE | OPTIONAL | Date workers comp first filed. | |
| LastPrintDate | DATE | OPTIONAL | Date workers comp last filed. | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| WorkersCompType | CHARACTER(1) | Workers_Comp | MANDATORY | Identifies type of worker compensation source. Possible values: (F)irst Injury Report (W)orkers Compensation Default: "W" |
| FiledDate | DATE | OPTIONAL | Date that the work injury report was filed. | |
| PracticeID | INTEGER | ? | OPTIONAL | FK |
| StaffID | INTEGER | ? | OPTIONAL | FK |
| PrevPatientFlag | CHARACTER(1) | OPTIONAL | Indicates if the patient has been previously been a patient for the practice. Possible values: (Y)es, (N)o | |
| ReportDefSetupSID | INTEGER | 0 | OPTIONAL | System generated unique id using the 'GeneralSystem' sequence. |
| LetterSID | INTEGER | ? | OPTIONAL | FK - From LetterDefinition. Indicates which first injury letter format was used. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Staff | WorkersComp.PracticeID = Staff.PracticeID and WorkersComp.StaffID = Staff.StaffID |
NONE if WorkersComp exists |
| Policy | WorkersComp.PlanID = Policy.PlanID and WorkersComp.PolicyNumber = Policy.PolicyNumber |
RESTRICT if WorkersComp exists |
| Company | WorkersComp.CompanyID = Company.CompanyID | RESTRICT if WorkersComp exists |
| Child Table | Join Phrase | When deleting WorkersComp record... |
|---|---|---|
| WorkersCompDiagnosis | WorkersCompDiagnosis.WorkersCompSID = WorkersComp.WorkersCompSID | CASCADE if WorkersCompDiagnosis exists |
| WorkersCompProcedure | WorkersCompProcedure.WorkersCompSID = WorkersComp.WorkersCompSID | CASCADE if WorkersCompProcedure exists |
| Ailment | Ailment.WorkersCompSID = WorkersComp.WorkersCompSID | NONE if Ailment exists |