Public Sector Case Lead Management
This ERD (see the following figure) illustrates how an investigative lead is related to incident and case. It shows how a party, such as a person, organization, or group, becomes involved in the investigative lead, and the positions of team members assigned to work on it. This ERD also shows evidence/supporting documentation as the trigger of the investigative lead. The physical object used, location of the investigative lead, as well as the related activity, disease, and service request are shown. This ERD covers the features of applications received from users and their supporting documents as well as their visibility to various organizations.
New features in 8.1 include:
-
Submitted applications are reviewed on the Siebel side and information uploaded from the applications into Siebel objects such as case and contacts.
-
Applications received from users/citizens for benefits, visa, immigration, and so forth are taken into account. The supporting documents for a given application, as well as any scanned images of the application, are stored in file systems. The visibility of an application to various organizations is also managed.
-
Data from the application form, as filled out by the citizen or employee, is transferred to the Siebel application so that the agency has a historical record of the data as submitted at that point in time. Employees will then upload the application into the system. During the upload process, relevant data from the form(s) is imported into the appropriate Siebel contact, household and case records.
The following table lists the entities in this ERD and their corresponding tables.
| Entity | Table |
|---|---|
|
INVESTIGATIVE CASE LEAD |
S_CASE_LEAD |
|
PARTY |
S_PARTY |
|
PERSON |
S_CONTACT, S_USER, S_CONTACT_PSX |
|
ORGANIZATION/GROUP |
S_ORG_EXT, S_ORG_GRP_PSX |
|
POSITION |
S_POSTN |
|
ADDRESS |
S_ADDR_PER |
|
SERVICE REQUEST |
S_SRV_REQ |
|
ACTIVITY |
S_EVT_ACT |
|
CASE |
S_CASE, S_CASE_PSX |
|
PHYSICAL OBJECT |
S_ASSET |
|
DISEASE |
S_DISEASE |
|
EVIDENCE/SUPPORTING DOCUMENT |
S_EVIDENCE |
|
INCIDENT |
S_INCIDENT |
|
PERSON DESCRIPTION |
S_SUBJECT |
|
APPLICATION |
S_PS_APPL |
|
APPLICATION ATTACHMENT |
S_PS_APPL_ATT |
|
APPLICATION/BUSINESS UNIT VISIBILITY |
S_PS_APPL_BU |