| Name | Description | Type | Additional information |
|---|---|---|---|
| ILConnectIntakeAssignmentExtId |
CCCWIS Intake Assignment - ILConnect External Id |
string |
None. |
| ILConnectIntakeAssignmentGuid |
CCCWIS Intake Assignment - ILConnect Guid |
string |
None. |
| ILConnectIntakeAssignmentId |
CCCWIS Intake Assignment - ILConnect Id |
string |
None. |
| CategoryId |
CCCWIS Intake Assignment Category Id - to allocate for a 'TMP_' value. |
string |
None. |
| AssignmentId |
CCCWIS Intake Assignment Id - to allocate for a 'TMP_' value. |
string |
None. |
| CreatedByWorkerId |
CCCWIS Intake Assignment - Created By Worker Id |
string |
None. |
| CreatedByDesigneeId |
CCCWIS Intake Assignment - Created By Designee Id |
string |
None. |
| ParticipantId |
CCCWIS Intake Assignment - Participant Id - to allocate for a 'TMP_' value. |
string |
None. |
| IntakeParticipantId |
CCCWIS Intake Assignment - Intake Participant Id - to allocate for a 'TMP_' value. |
string |
None. |
| Id | integer |
None. |
|
| CreatedDateTime | date |
None. |
|
| UpdateDateTime | date |
None. |
|
| CategoryCode | integer |
None. |
|
| CategoryId | integer |
None. |
|
| ParticipantId | integer |
None. |
|
| OrganizationalEntityId | integer |
None. |
|
| OrganizationalRoleCode | integer |
None. |
|
| OrganizationalRoleName | string |
None. |
|
| OrganizationalEntityRsf | string |
None. |
|
| WorkerCreatedBy | integer |
None. |
|
| MailboxId | integer |
None. |
|
| MailboxName | string |
None. |
|
| ReassignedIndicator | boolean |
None. |
|
| VerbalIndicator | boolean |
None. |
|
| OnCallIndicator | boolean |
None. |
|
| AssignedIndicator | boolean |
None. |
|
| MergedIndicator | boolean |
None. |
|
| ResponseCode | integer |
None. |
|
| ResponseDescription | string |
None. |
|
| TypeCode | integer |
None. |
|
| AssignmentTypeDescription | string |
None. |
|
| RegionCode | integer |
None. |
|
| RegionDescription | string |
None. |
|
| VerbalCommunicationEmployeeId | integer |
None. |
|
| VerbalCommunicationEmployeeName | string |
None. |
|
| EnteredDateTime | date |
None. |
|
| EndedNarrativeId | integer |
None. |
|
| EndedNarrativeDescription | string |
None. |
|
| ReceivedDateTime | date |
None. |
|
| EndedDateTime | date |
None. |
|
| EndedWorkerLastName | string |
None. |
|
| EndedWorkerFirstName | string |
None. |
|
| SortEndedDateTime | date |
None. |
|
| AcknowledgedDateTime | date |
None. |
|
| VerbalAcceptedDateTime | date |
None. |
|
| OnCallPageDateTime | date |
None. |
|
| OnCallPageDescription | string |
None. |
|
| NarrativeId | integer |
None. |
|
| Narrative | string |
None. |
|
| UpdatedByWorkerId | integer |
None. |
|
| UpdatedByDesigneeId | integer |
None. |
|
| UpdatedDateTime | date |
None. |
|
| InvestigationSubjectId | integer |
None. |
|
| InvestigationCaseId | integer |
None. |
|
| InvestigationScrSequenceId | string |
None. |
|
| InvestigationReportDateTime | date |
None. |
|
| IntakeParticipantId | integer |
None. |
|
| LastName | string |
None. |
|
| FirstName | string |
None. |
|
| MiddleName | string |
None. |
|
| WorkerPrefixCode | integer |
None. |
|
| WorkerLastName | string |
None. |
|
| WorkerFirstName | string |
None. |
|
| WorkerMiddleName | string |
None. |
|
| WorkerSuffixName | string |
None. |
|
| CreatedWorkerLastName | string |
None. |
|
| CreatedWorkerFirstName | string |
None. |
|
| CreatedWorkerMiddleName | string |
None. |
|
| CreatedWorkerPrefixCode | integer |
None. |
|
| CreatedWorkerPrefixName | string |
None. |
|
| CreatedWorkerSuffix | string |
None. |
|
| WorkerSearchedStatus | boolean |
None. |
|
| StatusOpen | boolean |
None. |
|
| EventCreatedDateTime | date |
None. |