NameDescriptionTypeAdditional information
IntakeId

integer

None.

InvestigationId

integer

None.

FacilityId

integer

None.

CaseEpisodeId

integer

None.

FamilyGroupId

integer

None.

IntakeEvaluationId

integer

None.

InvestigationSorSequenceId

integer

None.

CreatedByWorkerId

integer

None.

CreatedByDesigneeId

integer

None.

CreatedDate

date

None.

InterpreterNeeded

boolean

None.

SupervisorApproved

boolean

None.

Completed

boolean

None.

StatementRead

boolean

None.

SummarySent

boolean

None.

DcfsEmployeeInvolved

boolean

None.

DcfsWardInvolved

boolean

None.

ChildUnderFiveInvolved

boolean

None.

FacilityInvolved

boolean

None.

IsConfidential

boolean

None.

QualifiedForDifferentialResponse

boolean

None.

IsMediumHighProfile

boolean

None.

ChicagoPoliceSent

boolean

None.

ReportTypeCode

i.e. Intake Event INTK_SOR_IOR_RI_CODE

integer

None.

ReportTypeSequenceCode

integer

None.

SubTypeCode

integer

None.

TypeCode

integer

None.

LanguageCode

integer

None.

StatusCode

integer

None.

ResponseCode

integer

None.

IncidentDate

date

None.

ReporterLastName

string

None.

ReporterFirstName

string

None.

NarrativeId

integer

None.

Narrative

string

None.

UpdatedByWorkerId

integer

None.

UpdatedByDesigneeId

integer

None.

UpdatedDate

date

None.

PrimaryAddressCategoryId

integer

None.

PrimaryAddressCategoryCode

integer

None.

PrimaryAddressTypeCode

integer

None.

PrimaryAddressSubSequence

integer

None.

InvestigationSequenceNumber

integer

None.

InvestigationCaseId

integer

None.

InvestigationStatusCode

integer

None.

InvestigationRelatedInformationId

integer

None.

InvestigationReporterFirstName

string

None.

InvestigationReporterLastName

string

None.

InvestigationReportDate

date

None.

DifferentialResponseCaseId

integer

None.

DifferentialResponseCaseFirstName

string

None.

DifferentialResponseCaseLastName

string

None.

OverrideDate

date

None.

AssignmentEventCreated

date

None.

IsCriticalEvent

boolean

None.

Addresses

Collection of ExtendedAddress

None.

Approvals

Collection of Approval

None.

IntakeResponseIndicators

Collection of IntakeResponseIndicator

None.

Reasons

Collection of IntakeReason

None.

Assignments

Collection of Assignment

None.

ProtectiveCustodies

Collection of ProtectiveCustody

None.

Participants

Collection of IntakeParticipant

None.

Contacts

Collection of ExtendedContact

None.

Deceased

Collection of Deceased

None.

CaseResources

Collection of IntakeCaseResource

None.

FacilityInformation

IntakeFacility

None.

IntakeAllegations

Collection of IntakeAllegation

None.

Relationships

Collection of Relationship

None.

ChangeLogs

Collection of ChangeLog

None.

IntakeContactDetails

Collection of IntakeContactDetail

None.

IntakeNoReportTaken

IntakeEventNoReportTaken

None.

IntakeElementHistories

Collection of IntakeElementHistory

None.

LookupLists

IntakeLookupLists

None.

SessionInfo

SessionInfo

None.