| Name | Description | Type | Additional information |
|---|---|---|---|
| Id | integer |
None. |
|
| EmployeeId | string |
String length: inclusive between 0 and 12 |
|
| CorporationCode | string |
String length: inclusive between 0 and 20 |
|
| CaseNo | integer |
None. |
|
| Sequence | integer |
None. |
|
| FirstName | string |
String length: inclusive between 0 and 50 |
|
| LastName | string |
String length: inclusive between 0 and 50 |
|
| CorporationName | string |
String length: inclusive between 0 and 60 |
|
| ServiceType | string |
String length: inclusive between 0 and 50 |
|
| Scheduled | boolean |
None. |
|
| ScheduleDate | date |
None. |
|
| ScheduleStartTime | time interval |
None. |
|
| ScheduleEndTime | time interval |
None. |
|
| ChiefComplain | string |
String length: inclusive between 0 and 1000 |
|
| OpenDate | date |
None. |
|
| CloseDate | date |
None. |
|
| CompanyEmployeeId | string |
String length: inclusive between 0 and 20 |
|
| ClinicalPathwayStatusId | integer |
None. |
|
| CPWTimeZoneName | string |
String length: inclusive between 0 and 150 |
|
| Name | string |
String length: inclusive between 0 and 100 |
|
| WorkLocationName | string |
String length: inclusive between 0 and 200 |
|
| InteractionType | integer |
None. |
|
| CaseStatus | string |
String length: inclusive between 0 and 100 |
|
| ClinicalPathwayStatus | string |
String length: inclusive between 0 and 100 |
|
| WorkStatus | string |
String length: inclusive between 0 and 100 |
|
| string |
String length: inclusive between 0 and 150 |
||
| WorkStatusId | integer |
None. |
|
| DateOfExposure | date |
None. |
|
| DateOfSymptomsBegan | date |
None. |
|
| WorkStatusStartDate | date |
None. |
|
| WorkStatusEndDate | date |
None. |
|
| EvaluationDate | date |
None. |
|
| EvaluationTime | time interval |
None. |
|
| QuarantineStartDate | date |
None. |
|
| QuarantineEndDate | date |
None. |
|
| RTWDate | date |
None. |
|
| RTWTimeZoneName | string |
String length: inclusive between 0 and 150 |
|
| RTWTimeZoneAbbreviation | string |
String length: inclusive between 0 and 10 |
|
| ClinicalPathwayTypeName | string |
String length: inclusive between 0 and 100 |
|
| NotificationSent | date |
None. |
|
| ScheduledString | string |
String length: inclusive between 0 and 8000 |
|
| CaseCreatedByFirstName | string |
String length: inclusive between 0 and 50 |
|
| CaseCreatedByLastName | string |
String length: inclusive between 0 and 50 |
|
| CPWCreatedByFirstName | string |
String length: inclusive between 0 and 50 |
|
| CPWCreatedByLastName | string |
String length: inclusive between 0 and 50 |
|
| CPWClosedByFirstName | string |
String length: inclusive between 0 and 50 |
|
| CPWClosedByLastName | string |
String length: inclusive between 0 and 50 |
|
| LOB | string |
String length: inclusive between 0 and 4000 |
|
| FormatedEvaluationDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedQuarantineStartDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedQuarantineEndDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedRTWDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedScheduleDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedDateOfExposure | string |
String length: inclusive between 0 and 50 |
|
| FormatedDateOfSymptomsBegan | string |
String length: inclusive between 0 and 50 |
|
| FormatedOpenDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedCloseDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedWorkStatusStartDate | string |
String length: inclusive between 0 and 50 |
|
| FormatedWorkStatusEndDate | string |
String length: inclusive between 0 and 50 |
|
| HomePhone | string |
String length: inclusive between 0 and 20 |
|
| CellPhone | string |
String length: inclusive between 0 and 100 |
|
| WorkPhone | string |
String length: inclusive between 0 and 20 |
|
| Assessment | string |
String length: inclusive between 0 and 8000 |
|
| AdministrativeClosureName | string |
String length: inclusive between 0 and 100 |
|
| WorkLocationNameTimeofCase | string |
None. |