What is the specific theme of the code that shows the organization’s main priorities?

/in /by
  • Ethics in Public Service Paper

Please read and answer the 3 fact patterns listed below. Each answer must be at least one (1) page for a total of 3 pages.  (typed, double spaced),

Fact Patterns

  • Carlos Chance, is a former United States Postal Service (USPS) manager. His son, Julio, who is also a former worker at the post office, was shot when a disgruntled employee, who was attempting to shoot Carlos, fired shots through the rear door, hitting Julio.  Carlos was not injured, but Julio will never walk again and has medical bills of $7 million dollars.  The postal service has not made any payments to help Julio with his medical bills. There is a rule at the office which states that the outer doors in the rear must remain closed, but many smokers prop the door open so that they can go and smoke and return through the door.  If the door had been shut, the gunman would not have been able to gain access and shoot Julio.   The smokers complain that there is not a specific place for them to smoke.  When several smokers were disciplined for leaving the door open, Betty, a smoker, said that at the time when the door was open, the smokers were not outside smoking, but were engaged in a protest to get a designated smoking area. Please assume that postal employees are public servants.

Also, while Carlos was employed by the postal service, he established a truck leasing company called Golden Pacific Logistics (GPL) to pay for the medical bills that were piling up because of Julio’s injury. From 2005 to 2009, the Carlos submitted a bid for GPL to be awarded truck leasing contracts with the postal service in the same unit that he managed. During this time, GPL billed the postal service for expenses that were never incurred for trucks, mileage, servicing, and maintenance costs. In his position with the USPS, the Carlos authorized the payments to GPL. GPL billed and received approximately $6.4 million from the post office; $4.4 million of this amount was the result of fraudulent billing.

Answer the following questions:

  • Using the Go/No Go decision model, should the smokers have engaged in a protest by leaving the door open?  Make sure to discuss whether a public servant can engage in conscientious dissent as a citizen.
  • Please analyze this question using the ethical theories It is clear from the facts that Carlos has broken the law.  Has Carlos also engaged in unethical activity by setting up a company to get contracts from the postal service? Does it matter that Carlos was attempting to pay for Julio’s medical bills?  What about the fact that the postal service has a duty to protect its employees?
  1. Timothy Carson, was the former human resources director of the Federal Emergency Management Agency (FEMA). He was responsible for the oversight, training, and administration of FEMA’s employees. In 2007, he had discussions with the Gallup Organization about hiring the firm to provide consulting services to FEMA on a human resources project. He subsequently began talking to Gallup about future employment at the firm. In August 2008, FEMA awarded the contract to Gallup without any input from Carson.  However, Carson supervised the contract, which was worth $6 million over a five-year period. In December 2008 and January 2009, the Carson requested and received additional funding for the contract. While supervising the contract, Carson met and fell in love with Ms. Bailey, the head of Human Resources at Gallup. As the head of Human Resources, she was responsible for hiring employees.  In an e-mail to Ms. Bailey on February 12, 2009, the Carson stated, “I got another 500k put on the contract. Cool huh?”

In January 2009, Carson interviewed for a job with Gallup, and in February 2009 he received a job offer from the firm. After he accepted the job with Gallup, and while he was still working at FEMA, he continued to oversee and work on the human resources project being performed by Gallup.  While supervising the project, Carson discovered that Bill, another FEMA employee had leaked information to another person at Gallup.  Had the information not been leaked, Gallup probably would not have gotten the contract.

Carson retired from FEMA on February 27, 2009. On his termination public financial disclosure report he indicated that he did not have any agreements or arrangements for future employment. He did not list his future employment with Gallup. On February 27, 2009, he asked Gallup, through Ms. Bailey, to provide him with an offer letter dated after the date that he left FEMA so that it would appear that he had received the offer of employment after he had resigned from FEMA. Gallup provided the letter and it was signed by Ms. Bailey. Subsequently, Ms. Bailey’s boss raised concerns about the hiring of Carson and then Gallup withdrew the offer of employment.  Carson filed a civil suit against Gallup alleging that they could not withdraw the offer of employment. Carson also leaked to FEMA that the contract with Gallup was obtained by fraud, and FEMA canceled the contract.

It is against organizational rules for an employee to leave a governmental agency and immediately work for a company that does business with FEMA.  Employees must wait a year before they can take a position with a firm that has a contract.  Also, FEMA has protections in place for employees or others who expose fraud and they cannot be fired.  If the fraud is proven, a reward of $100,000 can be paid out.  Lastly, all contractual information is confidential.

  • Is Carson a whistle blower? Please discuss Carson’s motives for leaking the information to FEMA and whether he is under an obligation to keep any information confidential.
  • Has Carson violated his ethical duty to FEMA? If he has, would it be fair for him to be rewarded with the $100,000?
  1. Using the Code of Conduct that you found, answer the following questions (1 page).
  2. a) Provide the name of the code of conduct and the group of individuals to which it applies
  3. b) What is the specific theme of the code that shows the organization’s main priorities?
  4. c) List three of the values of the organization found in the code.
  5. d) Is there a mix of codes of ethics and codes of conduct?  If so, list one of each.
  6. e) Does the code have individual procedures and for handling ethical problems?  List 2 procedures.

f). Does the code convey a tone of respect for group members and confidence? Provide a statement from the code that shows respect and confidence for the group to which the code applies.

  1. g) If the code is violated, are there specific provisions for leaving or remaining in the group?  List 2 of them.

After reviewing the Logic Model Development Guide from the readings, create a logic model for a new program you would like to fund to address this impact on the health delivery system. Discuss how the program can be applied to reduce the impact on the health delivery system.

/in /by

Instructions

There are many forces that impact health delivery systems. Choose one aspect that influences how health delivery systems are challenged, and describe the issue. Examples include, but are not limited to, access to care, quality health care improvement, lack of coordinated care, continuity of care (medical home), etc.

After reviewing the Logic Model Development Guide from the readings, create a logic model for a new program you would like to fund to address this impact on the health delivery system. Discuss how the program can be applied to reduce the impact on the health delivery system.

Requirements

The paper and included logic model should be at least 975 words in length.
Include a list of references in APA format, including the information used from the modules.

Evaluate the information technology and tools needed in each step of the decision-making process.

/in /by

Read the following case study regarding an adverse trend in a health care setting.

An elderly patient has been admitted to the medical/surgical unit from the local nursing care facility. The new lab results in her electronic health record (EHR) indicate that she has methicillin-resistant Staphylococcus aureus (MRSA) in her urine. She is placed on contact precautions per the hospital guidelines.

The health care provider arrives to examine her new patient and inquires about the need for contact precautions. The nurse explains the lab results reveal the patient has MRSA in her urine. The health care provider states that she reviewed the patient’s lab results in the emergency room and the urine results were normal. The unit coordinator reveals to the staff nurse and nurse manager that this is the third incident this month of lab results being uploaded to the wrong patient’s EHR when admitted from the emergency department.

Write a 1,050 to 1,400-word paper based on the case study in which you:

Analyze the adverse trend, including how it affects patient care.

Evaluate the data that needs to be collected, reviewed, and applied in the decision-making process to address the adverse trend.

Evaluate the information system methods that will be used to collect the data needed in the decision-making process, including the source(s) of the data.

Evaluate the information technology and tools needed in each step of the decision-making process.

Evaluate any regulatory, legal, ethical, political, sociocultural, and financial issues related to the data and information technologies that will be used in the decision-making process.

Analyze at least two strategies used to advocate and access social justice in health care design and delivery.

How could a refresh of materialised view be done? Discuss the advantages and disadvantages of your chosen method of refresh over the other techniques.

/in /by

PART ONE, Entity Relationship diagram PART ONE, All DDL commands, test data [use SELECT * FROM…] per table
PART TWO, All query SQL syntax [and SQL*PLUS syntax] and results- evidence of the statements running in the Oracle DBMS. [Use SPOOL command to demonstrate]
PART THREE, All SQL Syntax and results pertaining to the view, triggers – evidence of the statements running in the Oracle DBMS [Use SPOOL command to demonstrate]
PART THREE, 150 word answer to part 3 (c)

PART ONE

Use a simple Entity Relationship Diagram (ERD) to show the Hampton Medical Practice database design.  The diagram should use the type of labels and notation taught in Computing Modules in your undergraduate course.  You may use a simple drawing package or word processor software or Oracle Modeller, or a hand drawn diagram or another suitable tool.  Appropriate relational database rules for cardinality and suitable constraints should be included.  INCLUDE ALL YOUR ASSUMPTIONS.

PART TWO

Basing your answer on your ERD in part one and using appropriate attribute types to create these tables using Oracle’s SQL*Plus. Your answer must include all primary keys, foreign keys and any additional constraints that are applicable.

Answer the following queries in Oralce SQL ONLY. If your implementation does not match your design, this will be penalised in the marking process. [WARNING : Do NOT auto-generate your SQL DDL/code- marks will be deducted if you fail to follow this instruction].

Complete the following:

  1. Create the tables in the Oracle DBMS using SQL create table statements. For all data relating to names or addresses set up uppercase constraints in your tables (e.g. patient surname, address of the practice).
  1. Enter representative test data into the tables. Enter the first record in the patient table using your own name. Ensure you have at least 12-15 rows of data to yield at least a few rows of data per query, as appropriate.  Take care with data, specific datasets are required to satisfy the query-based
  2. c) Produce answers to the following queries in SQL:
  1. Create a query that will display the total number of doctors (gps) and of that total the number who were hired in 1994, 1996, 1998, and 2000. Give appropriate column headings. [hint: you will need to use the Oracle DECODE function and remember to format the output].
  2. Give a list of patients seen from a given G.P. practice showing the

practice name, practice address, patient number, surname, initials, and G.P. number surname and initials. The list should be ordered first on G.P. surname and initials and then patient surname and initials.

  1. List the name and address of the patients who have been diagnosed as having “Asthma”. Each patient should occur only once in the result even though they may have been given that diagnosis a number of times (e.g. through a recurring illness).
  2. List the names and addresses of all GPs who work in the same city (i.e. you choose the city for example ’BIRMINGHAM’). Show the results of a number of different cities.
  3. Find out how many patients are seen by certain GP (i.e. you choose which GP)
  4. Use the MINUS construct as you have covered in the module, to find practices which do not employ a GP (include the city where they are located).
  5. Repeat the previous query (query 6) using the NOT EXISTS construct.

8      Write a query to display gps who have one or more colleagues in their practice with later hiredates but higher salaries.

PART THREE

  1. Develop a view that shows details of all patients on record and their details of diagnosis.  Display the contents of the view.
  2. Carry out separate updates on each individual column within the view.   Carry out INSERTS of new rows into the view .Deletes of rows from the view.  Ensure that patients based in Wolverhampton cannot book a routine appointment on a Sunday

Create triggers that enforce the following business rules:

  1. Ensure that appointments cannot be made for a Sunday.
  1. If a patient makes a greater than FOUR appointments in one month (patient_id, patient_name, practice_name) must be placed in an audit table.

Hint: You will need to construct an audit table with the appropriate columns of correct datatype.

  1. Ensure that patient appointments cannot be deleted if the date of the appointment is not later than the current date.

An essential part of this question is that having successfully compiled the triggers, you must construct a set of SQL statements and use them to test out the workings of your triggers.

For instance, if you have created an UPDATE trigger you will need to execute at least two UPDATE statements on the table on which the trigger is based – one that fires the trigger (and probably generates any error message from the trigger), and one that does not. In your testing, you must test all of your triggers, show their code and the output that they generate.

d.) Write upto 150 words to answer  “ How would you use a materialised view that can be used to enhance performance and undergo query re-write?”  Include the following in your answer:-

  • Use an external source of reference from your reading
  • Use an example to show how ‘Query Rewrite’  can be confirmed
  • How updates on materialised view’s base tables can affect query rewrite
  • How could a refresh of materialised view be done? Discuss the advantages and disadvantages of your chosen method of refresh over the other techniques.