Which Sql Query Must Have Must Have A Group By Clause

The GROUP BY clause groups together rows in a table with non-distinct values for the expression in the GROUP BY clause. For multiple rows in the source table with non-distinct values for expression, theGROUP BY clause produces a single combined row. GROUP BY is commonly used when aggregate functions are present in the SELECT list, or to eliminate redundancy in the output. There's an additional way to run aggregation over a table.

If a query contains table columns only inside aggregate functions, the GROUP BY clause can be omitted, and aggregation by an empty set of keys is assumed. Knowing how to use a SQLGROUP BY statement whenever you have aggregate functions is essential. In most cases, when you need an aggregate function, you must add aGROUP BY clause in your query too. The first must contain a distinct first name of the employee and the second – the number of times this name is encountered in our database. GROUP BY enables you to use aggregate functions on groups of data returned from a query. FILTER is a modifier used on an aggregate function to limit the values used in an aggregation.

All the columns in the select statement that aren't aggregated should be specified in a GROUP BY clause in the query. Once the rows are divided into groups, the aggregate functions are applied in order to return just one value per group. It is better to identify each summary row by including the GROUP BY clause in the query resulst. All columns other than those listed in the GROUP BY clause must have an aggregate function applied to them.

The GROUP BY clause is often used in SQL statements which retrieve numerical data. It is commonly used with SQL functions like COUNT, SUM, AVG, MAX and MIN and is used mainly to aggregate data. Data aggregation allows values from multiple rows to be grouped together to form a single row. The first table shows the marks scored by two students in a number of different subjects. The second table shows the average marks of each student.

Group By Clause Generally, these functions are aggregate functions such as min(),max(),avg(), count(), and sum() to combine into single or multiple columns. It uses the split-apply-combine strategy for data analysis. The GROUP BY clause groups identical output values in the named columns. Every value expression in the output column that includes a table column must be named in it unless it is an argument to aggregate functions. GROUP BY is used to apply aggregate functions to groups of rows defined by having identical values in specified columns.

ROLLUP is an extension of the GROUP BY clause that creates a group for each of the column expressions. Additionally, it "rolls up" those results in subtotals followed by a grand total. Under the hood, the ROLLUP function moves from right to left decreasing the number of column expressions that it creates groups and aggregations on. Since the column order affects the ROLLUP output, it can also affect the number of rows returned in the result set. The Group by clause is often used to arrange identical duplicate data into groups with a select statement to group the result-set by one or more columns.

This clause works with the select specific list of items, and we can use HAVING, and ORDER BY clauses. Group by clause always works with an aggregate function like MAX, MIN, SUM, AVG, COUNT. The above query includes the GROUP BY DeptId clause, so you can include only DeptId in the SELECT clause. You need to use aggregate functions to include other columns in the SELECT clause, so COUNT is included because we want to count the number of employees in the same DeptId. The GROUP BY clause defines groups of output rows to which aggregate functions can be applied.

The ORDER BY clause specifies a column or expression as the sort criterion for the result set. If an ORDER BY clause is not present, the order of the results of a query is not defined. Column aliases from a FROM clause or SELECT list are allowed. If a query contains aliases in the SELECT clause, those aliases override names in the corresponding FROM clause. It is not permissible to include column names in a SELECT clause that are not referenced in the GROUP BY clause. The only column names that can be displayed, along with aggregate functions, must be listed in the GROUP BY clause.

Since ENAME is not included in the GROUP BYclause, an error message results. The HAVING clause in a SELECT specifies a condition to apply within a group or aggregate. In other words, HAVING filters rows after the aggregation of the GROUP BY clause has been applied.

Since HAVING is evaluated after GROUP BY, it can only reference expressions constructed from grouping keys, aggregate expressions, and constants. (These are the same rules that apply to expressions in the SELECT clause of a GROUP BY query.) A HAVING clause must come after any GROUP BY clause and before any ORDER BY clause. Results from a HAVING clause represent groupings or aggregations of original rows, whereas results from a WHERE clause are individual original rows.

You must use the aggregate functions such as COUNT(), MAX(), MIN(), SUM(), AVG(), etc., in the SELECT query. The result of the GROUP BY clause returns a single row for each value of the GROUP BY column. Otherwise, each column referenced in the SELECT list outside an aggregate function must be a grouping column and be referenced in this clause. All rows output from the query that have all grouping column values equal, constitute a group. All the expressions in the SELECT, HAVING, and ORDER BY clauses must be calculated based on key expressions or on aggregate functions over non-key expressions . In other words, each column selected from the table must be used either in a key expression or inside an aggregate function, but not both.

Use theSQL GROUP BYClause is to consolidate like values into a single row. The group by returns a single row from one or more within the query having the same column values. Its main purpose is this work alongside functions, such as SUM or COUNT, and provide a means to summarize values. The GROUP BY clause is a SQL command that is used to group rows that have the same values.

Optionally it is used in conjunction with aggregate functions to produce summary reports from the database. If you don't use GROUP BY, either all or none of the output columns in the SELECT clause must use aggregate functions. If all of them use aggregate functions, all rows satisfying the WHERE clause or all rows produced by the FROM clause are treated as a single group for deriving the aggregates.

The aggregate functions do not include rows that have null values in the columns involved in the calculations; that is, nulls are not handled as if they were zero. If the WITH TOTALS modifier is specified, another row will be calculated. This row will have key columns containing default values , and columns of aggregate functions with the values calculated across all the rows (the "total" values). In conclusion, we didn't say that the SQLGROUP BY clause is one of the most powerful tools out there for no reason. It is preferred over the SELECT DISTINCT statement because it can be combined with aggregate functions. You can also use it with SQLORDER BY. However, you must make sure that you keep the right order when writing it.

Which SQL Query Must Have Must Have A Group By Clause But this technique is constantly being applied in queries, as it clarifies the analysis undertaken. If you are interested in learning about what else you can combine with the GROUP BY statement, you can learn all about the HAVING clause. Aggregate functions are functions that take a set of rows as input and return a single value.

In SQL we have five aggregate functions which are also called multirow functions as follows. The GROUP BY clause is part of the SQL SELECT statement. Optionally it is used in conjunction with aggregate functions to produce the resulting group of rows from the database. While the first query is not needed, I've used it to show what it will return. I did that because this is what the second query counts. In some cases, MySQL is able to do much better than that and avoid creation of temporary tables by using index access.

Here, you can add the aggregate functions before the column names, and also a HAVING clause at the end of the statement to mention a condition. Having Clause is basically like the aggregate function with the GROUP BY clause. The HAVING clause is used instead of WHERE with aggregate functions. While the GROUP BY Clause groups rows that have the same values into summary rows.

The having clause is used with the where clause in order to find rows with certain conditions. The having clause is always used after the group By clause. Adding a HAVING clause after your GROUP BY clause requires that you include any special conditions in both clauses. If the SELECT statement contains an expression, then it follows suit that the GROUP BY and HAVING clauses must contain matching expressions. It is similar in nature to the "GROUP BY with an EXCEPTION" sample from above. In the next sample code block, we are now referencing the "Sales.SalesOrderHeader" table to return the total from the "TotalDue" column, but only for a particular year.

The SUM() function returns the total value of all non-null values in a specified column. Since this is a mathematical process, it cannot be used on string values such as the CHAR, VARCHAR, and NVARCHAR data types. When used with a GROUP BY clause, the SUM() function will return the total for each category in the specified table. The SELECT statement used in the GROUP BY clause can only be used contain column names, aggregate functions, constants and expressions.

The USING clause requires a column list of one or more columns which occur in both input tables. It performs an equality comparison on that column, and the rows meet the join condition if the equality comparison returns TRUE. HAVING and WHERE are often confused by beginners, but they serve different purposes.

WHERE is taken into account at an earlier stage of a query execution, filtering the rows read from the tables. If a query contains GROUP BY, rows from the tables are grouped and aggregated. After the aggregating operation, HAVING is applied, filtering out the rows that don't match the specified conditions. Therefore, WHERE applies to data read from tables, and HAVING should only apply to aggregated data, which isn't known in the initial stage of a query. HAVING Clause is used as a conditional statement with GROUP BY Clause in SQL. WHERE Clause cannot be combined with aggregate results so Having clause is used which returns rows where aggregate function results matched with given conditions only.

The GROUP BY clause divides the rows returned from the SELECTstatement into groups. For each group, you can apply an aggregate function e.g.,SUM() to calculate the sum of items or COUNT()to get the number of items in the groups. The only aggregate functions used in the select list are MIN() and MAX(), and all of them refer to the same column. The column must be in the index and must immediately follow the columns in the GROUP BY. In this query, all rows in the EMPLOYEE table that have the same department codes are grouped together.

The aggregate function AVG is calculated for the salary column in each group. The department code and the average departmental salary are displayed for each department. This statement is used to group records having the same values. The GROUP BY statement is often used with the aggregate functions to group the results by one or more columns. However, you can use the GROUP BY clause with CUBE, GROUPING SETS, and ROLLUP to return summary values for each group.

Like most things in SQL/T-SQL, you can always pull your data from multiple tables. Performing this task while including a GROUP BY clause is no different than any other SELECT statement with a GROUP BY clause. The fact that you're pulling the data from two or more tables has no bearing on how this works. In the sample below, we will be working in the AdventureWorks2014 once again as we join the "Person.Address" table with the "Person.BusinessEntityAddress" table. I have also restricted the sample code to return only the top 10 results for clarity sake in the result set. IIt is important to note that using a GROUP BY clause is ineffective if there are no duplicates in the column you are grouping by.

A better example would be to group by the "Title" column of that table. The SELECT clause below will return the six unique title types as well as a count of how many times each one is found in the table within the "Title" column. The HAVING keyword works exactly like the WHERE keyword, but uses aggregate functions instead of database fields to filter. The GROUP BY statement is often used with aggregate functions to group the result-set by one or more columns. SELECT AS STRUCT can be used in a scalar or array subquery to produce a single STRUCT type grouping multiple values together.

Scalar and array subqueries are normally not allowed to return multiple columns, but can return a single column with STRUCT type. Query statements scan one or more tables or expressions and return the computed result rows. This topic describes the syntax for SQL queries in BigQuery.

We'll call columns/expressions that are in SELECT without being in an aggregate function, nor in GROUP BY,barecolumns. In other words, if our results include a column that we're not grouping by and we're also not performing any kind of aggregation or calculation on it, that's a bare column. In addition to producing all the rows of a GROUP BY ROLLUP, GROUP BY CUBE adds all the "cross-tabulations" rows. Sub-total rows are rows that further aggregate whose values are derived by computing the same aggregate functions that were used to produce the grouped rows. Data Grouping and Data Aggregation are the important concepts of SQL. Groupby can be used without having clause with the select statement.

JOINS are SQL statements used to combine rows from two or more tables, based on a related column between those tables. We can use the SQL GROUP BY statement to group the result set based on a column/ columns. Note – There is a restriction regarding the use of columns in the GROUP BY clause. Each column appearing in the SELECT list of the query must also appear in the GROUP BY clause. This restriction does not apply to constants and to columns that are part of an aggregate function. (Aggregate functions are explained in the next subsection.) This makes sense, because only columns in the GROUP BY clause are guaranteed to have a single value for each group.

A. It throws an error because the aggregate functions used in HAVING clause must be in SELECT list. Use the GROUP BY clause with aggregate functions in a SELECT statement to collect data across multiple records. In this lesson you learned to use the SQL GROUP BY and aggregate functions to increase the power expressivity of the SQL SELECT statement. You know about the collapse issue, and understand you cannot reference individual records once the GROUP BY clause is used. The GROUP BY statement groups rows that have the same values. This statement is often used with some aggregate function like SUM, AVG, COUNT atc.

We can use HAVING clause to place conditions to decide which group will be the part of final result-set. Also we can not use the aggregate functions like SUM(), COUNT() etc. with WHERE clause. So we have to use HAVING clause if we want to use any of these functions in the conditions.

How To Read Your Bcbs Card

Medigap is a term for a health insurance policy sold by private insurance companies to fill the "gaps" in original Medicare Plan coverage. Medigap policies help pay some of the healthcare costs that the original Medicare Plan doesn't cover. Medigap policies are regulated under federal and state laws and are "standardized." There may be up to 12 different standardized Medigap policies . Each plan, A through L, has a different set of basic and extra benefits. The benefits in any Medigap Plan A through L are the same for any insurance company. Each insurance company decides which Medigap policies it wants to sell.

Most of the Medigap claims are submitted electronically directly from the Medicare intermediary to the member's BCBS Plan via Medicare Crossover process. Medigap does not include Medicare Advantage products, which are a separate program under the Centers for Medicare & Medicaid Services . Members who have a Medicare Advantage Plan do not typically have a Medigap policy because under Medicare Advantage these policies do not pay any deductibles, copayments or other cost-sharing. Occasionally, you may see identification cards from members of International Licensees or that are for international-based products. Currently, those Licensees include Blue Cross Blue Shield of the U.S.

ID cards from these Licensees and for these products will also contain three-character prefixes and may or may not have one of the benefit product logos referenced in the following sections. See below for sample ID cards for international members and products. If you do not see your coverage amounts and co-pays on your health insurance card, call your insurance company . Ask what your coverage amounts and co-pays are, and find out if you have different amounts and co-pays for different doctors and other health care providers. BlueCard is a national program that enables members of one BCBS Plan to obtain health care services while traveling or living in another Blue Cross and Blue Shield Plan's service area. A Medicare Advantage PPO is a plan that has a network of providers, but unlike traditional HMO products, it allows members who enroll access to services provided outside the contracted network of providers.

Required member cost-sharing may be greater when covered services are obtained out-of-network. Medicare Advantage PPO plans may be offered on a local or regional (frequently multi-state) basis. This is usually the amount of your co-payment, or "co-pay." A co-pay is a set amount you pay for a certain type of care or medicine. If you see several dollar amounts, they might be for different types of care, such as office visits, specialty care, urgent care, and emergency room care. If you see 2 different amounts, you might have different co-pays for doctors in your insurance company's network and outside the network.

Providers should make sure they understand the applicable Medicare Advantage reimbursement rules by reviewing the Terms & Conditions under the member's Blue Plan. Other than the applicable member cost sharing amounts, reimbursement is made directly by a Blue Cross Blue Shield Plan. In general, you may collect only the applicable cost sharing (e.g., co-payment) amounts from the member at the time of service, and may not otherwise charge or balance bill the member. BlueCard is a national program that enables Blue Cross and Blue Shield of Nebraska members to obtain in-network services while traveling or living in another state. The program links participating health care providers with Blue Plans across the country and internationally through a single electronic network for claims processing and reimbursement. This federal mandate applies to all individual policies, fully insured group health plans and both ERISA and non-ERISA self-funded groups, where the state law does not apply.

Coordination of benefits is the process used when a member has two health insurance plans. This process allows the two plans to work together getting you the most out of your coverage. The second plan becomes your secondary plan, which may pay toward the remaining cost, depending on the plan. Understanding which plan is your primary and which plan is your secondary is important to help prevent delays in claims processing. When you provide covered services to other BCBS MA out-of-area members', benefits will be based on the Medicare allowed amount.

Once you submit the claim, Highmark Blue Cross Blue Shield of Western New York will send you the payment. However, these services will be paid under the member's out-of-network benefits unless for urgent or emergency care. The Blue HPN EPO product includes an HPN in a suitcase logo on the ID card.

Members must obtain services from Blue HPN providers to receive full benefits. If you are a Blue HPN provider, you will be reimbursed for covered services in accordance with your Blue HPN contract with Highmark Blue Cross Blue Shield of Western New York. If you are not a Blue HPN provider, it's important to note that benefits for services incurred with non – Blue HPN providers are limited to emergent care within Blue HPN product areas, and to urgent and emergent care outside of Blue HPN product areas. For these limited benefits, if you are a PPO provider, you will be reimbursed according to Highmark Blue Cross Blue Shield of Western New York PPO provider contract, just like you are for other EPO products. The first percent, which is normally larger, shows how much the insurance company pays doctors and other health care providers who are considered "in network." "In network" means that the insurance company has an agreement with this group of providers. The second percent amount is the amount your insurance company pays doctors and other health care providers who are "out of network." Your insurance company does not have an agreement with providers who are outside the insurance company's network.

A health savings account is a tax-advantaged savings account that can be funded by individuals whose only health care coverage is a qualified high deductible health plan . An HSA is an alternative way for you to pay for your qualified health care expenses and save for future qualified health care expenses on a tax-free basis. Expenses such as out-of-pocket costs for office visits, prescription drugs, dental expenses and laboratory tests may be paid for from your HSA. A qualified health plan will have a certification by each Marketplace in which it is sold.

When you see any Blue members and you are aware that they might have other health insurance coverage give a copy of the questionnaire to them during their visit. Once the form is complete, send it to your local BCBS Plan as soon as possible. Your local BCBS Plan will work with the member's Plan to get the COB information updated. Collecting COB information from members before you file their claim eliminates the need to gather this information later, thereby reducing processing and payment delays. If you are not a Medicare Advantage PPO contracted provider, you may see Medicare Advantage members from other Blue Cross Blue Shield Plans but you are not required to do so.

For urgent or emergency care, you will be reimbursed at the in-network benefit level. The program links participating health care providers with the independent BCBS Plans across the country and in more than 200 countries and territories worldwide through a single electronic network for claims processing and reimbursement. The above-referenced claim thus was pended due to non-payment of premium, and will be denied if the premium is not paid by the end of the grace period.

The ACA mandates a three month grace period for individual members who receive a premium subsidy from the government and are delinquent in paying their portion of premiums. The grace period applies as long as the individual has previously paid at least one month's premium within the benefit year. The health insurance plan is only obligated to pay claims for services rendered during the first month of the grace period. The ACA clarifies that the health insurance plan may pend claims during the second and third months of the grace period. All states have health insurance marketplaces where consumers can compare health insurance product features, coverage, and costs.

Department of Health and Human Services has established a federally facilitated Marketplace, federally supported Marketplace, or a state-partnership Marketplace in the state. A Medicare Advantage HMO is a Medicare managed care option in which members typically receive a set of predetermined and prepaid services provided by a network of physicians and hospitals. Generally , medical services are only covered when provided by in-network providers. The level of benefits and the coverage rules may vary by Medicare Advantage plan. Members who have Consumer Directed Health Care plans often have healthcare debit cards that allow them to pay for out-of-pocket costs using funds from their Health Reimbursement Arrangement , Health Savings Account or Flexible Spending Account .

All three are types of tax favored accounts offered by the member's employer to pay for eligible expenses not covered by the health plan. Your health insurance company might pay for some or all the cost of prescription medicines. But not all cards have this symbol, even if your health insurance pays for prescriptions. Sometimes, the Rx symbol has dollar or percent amounts next to it, showing what you or your insurance company will pay for prescriptions.

Cards show important health plan information, including the network the member may access, who is responsible for managing the member's care, where to submit claims, covered riders, and copayments. Diagrams in the "Sample ID Cards" section of this chapter show how to quickly locate key coverage details and contact information. Provides basic and/or supplemental hospital and medical/surgical benefits (e.g., basic, major medical and add-on riders) designed to cover various services. Such products generally include cost sharing features, such as deductibles, coinsurance or copayments.

An agreement with a health care provider not to bill the member for any difference between billed charges for covered services and the amount the health care provider has contractually agreed on with a BCBS Plan as full payment for these services. A health benefits program in which the member receives no benefits for care obtained outside the PPO network except emergency care and does not include a Primary Care Physician selection. EPO benefit coverage may be delivered via BlueCard PPO and is restricted to services provided by BlueCard PPO providers. When these logos are displayed on the front of a member's ID card, it indicates the coverage type the member has in his/her BCBS Plan service area or region. However, when the member receives services outside his/her BCBS Plan service area or region, provider reimbursement for covered services is based on the Medicare allowed amount, except for PPO network-sharing arrangements.

If you are a MA PPO contracted provider with Highmark Blue Cross Blue Shield of Western New York, benefits will be based on your contracted MA PPO rate for providing covered services to MA PPO members form any MA PPO Plan. Once you submit the MA claim, Highmark Blue Cross Blue Shield of Western New York will work with the other Plan to determine benefits and send you the payment. If you are not a contracted MA PPO provider with Blue Cross and Blue Shield of Western New York and you provide services for any Blue Cross Blue Shield Medicare Advantage members, you will receive the Medicare allowed amount for covered services. For urgent or emergency care, you will be reimbursed at the member's in-network benefit level.

Other services will be reimbursed at the out-of-network benefit level. After the member of another Blue Plan receives services from you, you should file the claim with Highmark Blue Cross Blue Shield of Western New York. We will work with the member's Plan to process the claim and the member's Plan will send an explanation of benefit or EOB to the member. We will send you an explanation of payment or the remittance advice and issue the payment to you under the terms of our contract with you and based on the members benefits and coverage.

The cards include a magnetic strip allowing providers to swipe the card to collect the member's cost-sharing amount (i.e., copayment). With healthcare debit cards, members can pay for copayments and other out-of-pocket expenses by swiping the card though any debit card swipe terminal. The funds will be deducted automatically from the member's appropriate HRA, HSA or FSA account. When you go to an appointment with your health care provider, they will ask you for your insurance information.

To find out if a provider is "in network" contact your insurance company. The "coverage amount" tells you how much of your treatment costs the insurance company will pay. It is usually listed by percent, such as 10 percent, 25 percent, or 50 percent. For example, if you see 4 different percent amounts, they could be for office visits, specialty care, urgent care, and emergency room care. If you forget or aren't sure what type of health insurance plan you have , you can find out on your BCBS ID card.

If you have an HMO, your card may also list the physician or group you've selected for primary care. Determining whether a provider is in-network is an important part of choosing a primary care physician. Facilities are defined as a general acute hospital, satellite emergency department or ambulatory surgical center licensed pursuant to the Health Care Facility Licensure Act. Effective Jan. 1, 2021, providers in Nebraska may not balance bill patients for medical care received from out-of-network providers or facilities in emergency situations. This state mandate applies to all fully insured plans and non-ERISA groups.

Program designed to assist qualified small employers in facilitating the enrollment of their employees in qualified health plans offered in the small group market. The program allows employers to choose the level of coverage and offer choices among health insurance plans. SHOP insurance is generally available to employers with 1-50 employees, but in some states SHOP is available to employers with employees.

The Medicare Advantage Organization, rather than the Medicare program, pays for services rendered to such members. Members are responsible for cost-sharing, as specified in the plan, and balance billing may be permitted in limited instance where the provider is a network provider and the plan expressly allows for balance billing. The reference costs are established for an episode of care based on claims data received by Highmark Blue Cross Blue Shield of Western New York from providers in your area. Give the following article a thorough read to find out how to read a blue cross blue shield insurance card.

Members can login to myNebraskaBlue to access cost estimates and cost comparisons for a variety of treatments and services. By logging in, your benefits will be applied to the estimate so you can see costs based on your benefit plan (copay, deductible, coinsurance, etc.). ASO accounts are self-funded, where the local plan administers claims on behalf of the account, but does not fully underwrite the claims. ASO accounts may have benefit or claims processing requirements that may differ from non-ASO accounts. There may be specific requirements that affect; medical benefits, submission of medical records, Coordination of Benefits or timely filing limitations.

All Blue Cross Blue Shield Medicare Advantage PPO Plans participate in reciprocal network sharing. This network sharing allows all Blue Cross Blue Shield MA PPO members to obtain in-network benefits when traveling or living in the service area of any other Blue Cross Blue Shield MA PPO Plan as long as the member sees a contracted MA PPO provider. Medicare Advantage plans may allow in- and out-of-network benefits, depending on the type of product selected. Blue High Performance Network is a narrow network that is available to members that live in key metropolitan areas. Blue HPN members must access Blue HPN providers in order to receive full benefits.

If you are a Blue HPN provider, you will be reimbursed for services provided to Blue HPN members according to the Blue HPN contract with the Highmark Blue Cross Blue Shield of Western New York. After rendering services, the provider in Illinois files a claim locally with Blue Cross and Blue Shield of Illinois. Blue Cross and Blue Shield of Illinois forward the claim to Blue Cross Blue Shield of Tennessee that adjudicates the claim according to the member's benefits and the provider's arrangement with the Illinois Plan.

When the claim is finalized, the Tennessee Plan issues an explanation of benefit or EOB to the member, and the Illinois Plan issues the explanation of payment or remittance advice to its provider and pays the provider. The back or bottom of your health insurance card usually has contact information for the insurance company, such as a phone number, address, and website. This information is important when you need to check your benefits or get other information. For example, you might need to call to check your benefits for a certain treatment, send a letter to your insurance company, or find information on the website.

If you have health insurance through work, your insurance card probably has a group plan number. The insurance company uses this number to identify your employer's health insurance policy. On your card, it is often marked "Policy ID" or "Policy #." The insurance company uses this number to keep track of your medical bills. Getting a checkup now will help your PCP learn about your medical history before any health issues occur. You must use the BlueCross BlueShield of South Carolina card to receive medical or dental services, the Express Scripts card to fill prescriptions and the EyeMed card to receive vision care. Express Scripts is an independent company that contracts directly with the State Health Plan.

EyeMed is an independent company that contracts directly with the State Health Plan. It's your identification that says, "I am a Blue Cross NC member." The back of your card has several important phone numbers to use when you need help. You'll need to show it every time you visit an emergency room, urgent care center or health care provider. The out-of-pocket maximum is the amount each covered person must pay in a calendar year before your insurance covers at 100%. The out-of-pocket limit includes deductible, coinsurance and copayment amounts for medical and pharmacy services. The out-of-pocket limit does not include premium amounts over the allowable charge, charges for non-covered services, or penalties for failure to comply with certification requirements or as imposed under the Rx Nebraska Prescription Drug Program.

Out-of-network benefits are benefits provided by a provider who has not contracted with us to provide services as a part of the preferred provider organization in Nebraska. These benefits mean more out-of-pocket for members when services are incurred. SCHIP is a public program administered by the United States Department of Health and Human Services that provides matching funds to states for health insurance to families with children.