Case Study: You are working with one of Annkissam\'s clients. You are helping th
ID: 3844381 • Letter: C
Question
Case Study: You are working with one of Annkissam's clients. You are helping the client design what data they should collect when they enroll a new "consumer" in their program. They tell you the following points: If we don't have the consumer's first name and last name when we bill for the services we provided to the consumer, we won't get paid. Our process is to meet with each consumer and do an "intake" on them. For the intake, we collect the following data: Consumer's SSN Consumer's diagnosis Consumer's first name Consumer's last name Does the consumer have a representative? Before we can provide service to the Consumer, we have to get an EIN for them. After we get an EIN for them, we send them a Welcome Packet. After they get the Welcome Packet, they call us with any questions. We answer those questions over the phone. It would be nice to know what different questions people ask us so we could use those to make our Welcome Packet better and to train our staff. Once the Consumer has the Welcome Packet, we can start providing services to them. We can bill for the services as soon as we provide them. Billing for the services is important so that we're bringing in revenue to cover our costs. If your client told you this, what questions might you have for the client? Please list them below: What fields would you include in their database? List them below and put an asterisk next to any fields that would be required in order to save information on the person.Explanation / Answer
NOTE:- In case EIN here stands for the Employer Identification Number provided by the IRS, please ignore all questions regarding the EIN below.
Questions to ask the client:-
1. How is the data being handled currently?
2. Does old data need to be migrated?
3. How will the consumers' data be collected? Will it be through the company's website, through email, snail mail or personal interaction of the consumer with a company representative?
4.What are the required timelines for generating an EIN once a consumer's data has been recieved? How long does it currently take?
5. What is the format of the EIN(Numeric or Alpha-numeric)? Is it generated randomly or sequentially?
6. What are the timelines for sending out the Welcome Packet once the EIN has been generated?
7. Is there already an existing collection of questions asked by consumers?
8. How often is the Welcome Packet updated?
9. Is the Welcome Packet sent by snail mail as a hard copy or through email or both?
10. How do you keep track of whether or not the Welcome Packet has been recieved by the consumer? Can you start providing services when the Welcome Packet is sent out rather than when it has been recieved by the consumer?
11. What are the Regulatory requirements for storing and accessing the data?
12. What internal controls are required to handle:- a) Financial info and transactons
b) The consumers' medical data
13. Do you need to be able to audit any changes made to the data?
14. What are the different levels of access that you want your employees to have? How many such groups of 'access-level' will there be?
15. Do you want to be able to make changes to saved data?
16. Do you want the database structure to be flexible? (Not recommended)
17. How much growth in consumer numbers are you expecting? This is required to find the potential size of the database.
18. What are the different payment methods available to the consumer?
Database :-
Table Name : Consumer_Data - contains the consumer's basic data
Table : Consumer_Contact_Details - contains the consumer's contact details
Table : Consumer_Rep_Contact_Details - contains contact details of the consumer's representative
Table :Reciept Details
-contains Reciept details.
Svc_codes lists all the services availed by the consumer for one reciept. The program should parse through this list to read each code and retreive the service name and price for each service from the Services table.
Table Name : Services - contains list of all avilable services along with their prices.
Table Name: FAQ- contains questions asked by consumers.
Table Name : Consumer_Data - contains the consumer's basic data
Field Name Data Type SSN* Varchar First Name* Varchar2 Last Name* Varchar2 EIN Varchar Representative Name Varchar2 Diagnosis Varchar2 Welcome Packet Sent DateTable : Consumer_Contact_Details - contains the consumer's contact details
Field Name Data Type SSN* Varchar House No. Varchar Street Varchar2 Landmark Varchar2 City Varchar2 State Varchar2 ZIP Varchar Email ID Varchar2 Phone1 Varchar2 Phone2 Varchar2Table : Consumer_Rep_Contact_Details - contains contact details of the consumer's representative
Field Name Data Type SSN* Varchar Name* Varchar2 House No Varchar Street Varchar2 Landmark Varchar2 City Varchar2 State Varchar2 ZIP Varchar Email ID Varchar2 Phone1 Varchar Phone2 VarcharTable :Reciept Details
-contains Reciept details.
Field Name Data Type Reciept No* Varchar2 SSN* Varchar Svc_codes* Varchar2 Svc-Date DateTime Bill Amt Currency Bill Paid Date DateTimeSvc_codes lists all the services availed by the consumer for one reciept. The program should parse through this list to read each code and retreive the service name and price for each service from the Services table.
Table Name : Services - contains list of all avilable services along with their prices.
Field Name Data Type Svc_code Varchar Svc_Category Varchar2 Svc_Name Varchar2 Price CurrencyTable Name: FAQ- contains questions asked by consumers.
Field Name Data Type QNo* Number Question Category Varchar2 Question Varchar2 Answer Varchar2 Included in WelcomePack Boolean