• Basic Database Skills
Department ID
Department Name
Number of Employees
Head of Department
DEP0001
Product Development
42
EMP0010
DEP0002
HR
15
EMP0002
DEP0003
Finance
7
EMP0012
DEP0004
Database Management
7
EMP0045
DEPDEGID
Department ID
Designation
DD001
DEP0001
Product Lead
DD002
DEP0001
Product Architect
DD003
DEP0001
Business Analyst
DD004
DEP0002
HR Lead
DD005
DEP0002
HRIS Analyst
DD006
DEP0003
Financial Analyst
DD007
DEP0003
Sr. Financial Analyst
DD008
DEP0004
Database Engineer
DD009
DEP0004
Architect
Employee ID
Employee Name
Gender
Department-Designation ID
Client Name
EMP0001
Michael Keane
M
DD001
BYN Corp
EMP0002
Ian Wright
M
DD004
EMP0003
Kate Myers
F
DD003
BYN Corp
EMP0004
Danny Ings
M
DD003
BYN Corp
EMP0005
Alex Morgan
F
DD002
PG Inc.
EMP0006
Emily Stone
F
DD006
EMP0007
Xing Vu
M
DD003
PG Inc.
EMP0008
Michele Gallagar
F
DD001
PG Inc.
Here are the snapshots of the Employee, Department and a Department-Designation Association Table. Please answer the following questions
• In the employee table snapshot, which departments have no representation?
• Can you name the head of department for HR from the information represented in the tables above?
• Which designations are currently working on BYN Corporation?
• Below is an example of how a rule is written. Following is the text provided – text in blue are examples/instructions.
[Plans with no monthly premium, omit: In addition to paying the monthly plan premium,] many members are required to pay other Medicare premiums. As explained in Section 2 above, in order to be eligible for our plan, you must have both Medicare Part A and Medicare Part B. Some plan members (those who aren’t eligible for premium-free Part A) pay a premium for Medicare Part A. Most plan members pay a premium for Medicare Part B. You must continue paying your Medicare premiums to remain a member of the plan.
Example Rule:
If monthly premium = blank, then show
Many members are required to pay other Medicare premiums. As explained in Section 2 above, in order to be eligible for our plan, you must have both Medicare Part A and Medicare Part B. Some plan members (those who aren’t eligible for premium-free Part A) pay a premium for Medicare Part A. Most plan members pay a premium for Medicare Part B. You must continue paying your Medicare premiums to remain a member of the plan.
If monthly premium is not blank, then show
In addition to paying the monthly plan premium, many members are required to pay other Medicare premiums. As explained in Section 2 above, in order to be eligible for our plan, you must have both Medicare Part A and Medicare Part B. Some plan members (those who aren’t eligible for premium-free Part A) pay a premium for Medicare Part A. Most plan members pay a premium for Medicare Part B. You must continue paying your Medicare premiums to remain a member of the plan.
Question: Now, if similarly, the below was provided to you, what rule would you write?
In certain situations, changes are also allowed at other times of the year. For example, people with Medicaid, those who get “Extra Help” paying for their drugs, those who have or are leaving employer coverage, and those who move out of the service area may be allowed to make a change at other times of the year. For more information, see Chapter 10, Section 2.3 of the Evidence of Coverage.
If you enrolled in a Medicare Advantage plan for January 1, 2020, and don’t like your plan choice, you can switch to another Medicare health plan (either with or without Medicare prescription drug coverage) or switch to Original Medicare (either with or without Medicare prescription drug coverage) between January 1 and March 31, 2020. For more information, see Chapter 10, Section 2.2 of the Evidence of Coverage.
[If the plan is a PPO: replace the paragraph above with the following:
You can change your Medicare coverage at any time. You can change to any other Medicare health plan (either with or without Medicare prescription drug coverage) or switch to Original Medicare (either with or without a separate Medicare prescription drug plan) at any time.]
• Write user stories for the following features
Microsoft Excel has a Find Feature and a Replace feature. Write user stories for these features.
——————————————————————————————————————————————
• Based on the following code snippet and plan attributes, provide the output for Plan A, Plan B and Plan C.
Code Snippet
• {{IF:[Copay]=Not Covered && [Coinsurance]=Not Covered, show ‘Not covered’}}
• {{IF:[Copay]!=$0.00 && [Copay]!=Blank, show value from {{Copay}} copayment}}
• {{IIF:[Copay]!=$0.00 && [CopayFrequency]!=Blank, show {{Copay}} copayment/{{CopayFrequency}}}}
• {{IF:[CopayMax]=$0.00 OR [Copay]=$0.00, show No Charge}}
• {{IF:[[CopayMax]!=$0.00 && [CopayMax] contains ‘$’ && [Coinsurance] contains ‘%’ && [CopayMaxFrequency]=Blank, show {{CopayMax}} copayment then {{Coinsurance}} coinsurance]}}
Plan
Copay
CopayFrequency
CopayMax
CopayMaxFrequency
Coinsurance
Plan A
$10.00
Per Visit
$50.00
Per Visit
Not Covered
Plan B
$0.00
Not Applicable
$0.00
Not Applicable
Not Covered
Plan C
$50.00
$50.00
Per Session
10%
• What will the output for statements (a), (b), (c) and (d) based on the data provided in the screenshot.
• {{Business.BenefitReview.BenefitReviewGrid.Coinsurance@NetworkName=Out of Network&BenefitServiceCode=SER0014&BenefitCategory2=Emergency Room Facility}}
• {{Business.BenefitReview.BenefitReviewGrid.Copay@BenefitServiceCode=SER0001&NetworkName=In Network}}
• {{Business.BenefitReview.BenefitReviewGrid.FamilyOOPM@BenefitServiceCode=SER0004&BenefitCategory1=Outpatient Care}}
• {{Business.BenefitReview.BenefitReviewGrid.BenefitCategory1@NetworkName=In Network&CopayFrequency=Per Trip}}
• Attached after this sheet are 2 Word Documents. The task is to do a compare between the 2 documents and underline the differences between the data in the two files. First difference has been underlined as an example.
• Attached are this sheet are 3 excel sheets. The first sheet, named ServiceDictionary and the second tab named BGrid contains the Excel Grids which you would have to work with to enter the values in the third sheet named ‘Mapping Sheet’
• Fill the values for the following columns:
• Is the benefit covered?
• Do you require a prior approval?
• State the Cost Share Groupings for each of the benefits mentioned in the Mapping Sheet