The Joys of Home Ownership - Dishwasher Edition

The things you learn as a homeowner. In Kentucky, code requires that an air gap device be installed on the drain line from the dishwasher. Conceptually, I understood that this was a backflow prevention device that kept waste water from flowing back into the dishwasher during the drain cycle. However, I was ignorant of the exact mechanical workings.

Well, the past few weeks, the air gap was overflowing into the sink whenever we ran the dishwasher. Naturally, my wife was concerned about it and wanted the problem fixed. Thanks to the wonders of the internet and various DIY sites and videos on YouTube, I now understand how these things work, and what usually goes wrong with them.

The good news is that the air gap itself is a very simple device, mechanically. There are no moving parts whatsoever.

Dishwasher Air Gap

The dishwasher drain line connects to the nipple at the bottom of the air gap. The water flows up into a reservoir, and then is gravity fed back out through the nipple that sticks out at an angle. That outflow line is a 7/8" inner diameter hose that connects to the garbage disposal (if you have one) or to the plumbing stand pipe under your sink. The number one cause of overflow is constriction in that outflow hose. That constriction can either be a kink in the line or a dip (a u-shape) that drops below the connection point to the plumbing, or it can a build-up of gunk in the line.

In my case, it was a build-up of gunk. The link was a straight shot from my air gap to my disposal with no kinks or dips (it was "downhill all the way"). I removed the hose and upon visual inspection I could only see a pin prick of light through one end. I flushed the hose with water from my outside hose. I didn't bother washing it out with soap or other cleaners. Once it was nice and clear, I hooked it back up to the air gap and the disposal.

I haven't run a load through the dishwasher since I fixed it, but I'm fairly confident my issue has been resolved.

Oh, the number reason for the outflow device to overflow? That would be an incorrect installation of your garbage disposal. There is a nipple on the garbage disposal for your dishwasher drain line. Well, since not everybody has a dishwasher, the inlet hole is covered with a knockout plug. If you don't remove that knockout plug, obviously there's no where for the water to go. I almost made that mistake myself when I replaced our garbage disposal a year ago.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

The ACA, Utilization, and Premiums

An overlooked aspect of the ACA (at least, I've not seen anyone talk about this specifically), is what will happen to utilization. In a letter to employees about our 2014 benefits, the following comment was made: "However, premiums are directly affected by utilization and, as determined by our actuaries, utilization increased requiring the increases that we have implemented." That is specifically talking about why our insurance premiums are increasing.

But, that statement encompasses a more general central truth in insurance. Premium levels are set to cover the costs of utilization, or the amount that the insurer will have to pay out in claims. Think about auto and home owners insurance policies. Everyone knows that if you have a bunch of claims, your rates go up. This is because you are more expensive to insure. This also explains the popularity of "good driver" or "accident forgiveness" discounts. If you have a track record of low or no claims, they're "making money" on your policy, so they can afford to overlook one bad act.

Now, extend this thought model to health insurance and the ACA. A significant number of people who either had catastrophic plans or had no insurance at all will now carry insurance per the individual mandate. One of the core basket of services are annual check-ups/physicals, at no cost to the policy holder. Please notice I didn't say "free", as the physician will still be reimbursed for their time. I don't know about you, but if my policy says I'm entitled to something, I'm most likely going to get it or use, especially if it's "free".

So you will now have this spike in utilization. Imagine what this will do from a supply and demand perspective. Demand (for physician services) will increase, and supply is fairly static, and may actually be decreasing as doctors change how they run their practices. This means that you will wait longer for appointments, and delays will inevitably increase. So there will be a negative impact just on being able to see your doctor.

And now back to my primary point. "[P]remiums are directly affected by utilization." Utilization is going to increase. After a year or two of solid actuarial data, what do you think will necessarily happen to policy premiums?

In other words, if you think the ACA plans are expensive now, you ain't seen nothing yet.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Praise Matters

I started teaching a Wednesday night bible study at my church this "semester". We're about 7 weeks into it, and it has been a thoroughly enjoyable experience so far.

After class last night, one of the regular attendees came up to me. He asked "Are you a teacher? I mean, a real teacher?" He was asking if that was my trade or profession. I told him that no, I did computer stuff, but at one time I'd thought about being a teacher.

He gripped my upper arm, stared me in the eyes and said "No, you ARE a teacher. You're doing a great job leading this class." As many times as I've felt inadequate to the task of teaching this class, that moment meant a lot to me. I left church last night encouraged in my spirit much more than usual.

Sometimes the simplest of encouragements can mean the world to the recipient. You do have to be extravagant or over the top in your praise, but sincerity does matter. This gentleman didn't just say "good class" or "good job tonight" as he walked past me. He took the time to stop and engage with me, to stare me in the eye, and to speak from the bottom of his heart.

When is the last time you offered someone sincere praise for a job well done?

Praise matters, and sincere praise even more so.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Unused Employee Access Groups in Kronos

Back in April, I wrote about how to clean up Employee Access Groups in Kronos. Specifically, I looked at how to identify inactive labor levels that were still assigned to an access group.

Another bit of maintenance that I like to do is periodically removing unused access groups. I frequently create user-specific groups. When that employee is no longer with the organization, there is no need to keep their access group hanging around. It just clutters up the list of available groups and is one more item you may have to audit.

Fortunately, the query to identify unused groups is very straightforward. All we have to is join over to the 'prsnaccsassign' table, get a count of how many managers are assigned to an access group, and then limit the output to those access groups with a count of 0.

select
    laboracctsetid 'LAS ID',
    shortnm 'Mgr Acces Grp Name',
    count(personid) 'Count of Mgrs Using'
from
    laboracctset
left outer join
    prsnaccsassign
on
    laboracctset.laboracctsetid = prsnaccsassign.mgraccesslasid
where
    labacctsettypeid = 2
group by
    laboracctsetid,
    shortnm
having
    count(personid) = 0

Again, just like last time I'm filtering on labor account sets being used as Employee Access Groups (labacctsettypeid = 2). Also, I'm running this across all employees, not just active ones. If an access group is assigned to a terminated associate, it will still get a count and be excluded from this report.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

12 Years Later

12 years ago today, I was sitting in a conference room in an office building on the North Dallas Parkway, getting ready for a vendor demo from PeopleSoft. As more and more people arrived, word started trickling in about the planes crashing into the WTC towers. At the morning break, all of the consultants were busy trying to catch up with friends and co-workers that had been traveling that day, to see if they were safe. Everyone else was glued to the TV screens in the lobby of the building, trying to make sense of what happened.

We canceled the demo, and my company shut down. I was working for Greyhound at the time, so a shut down meant that all of our buses came off the roads. They were allowed to continue to the nearest Greyhound terminal, and then they stopped. Passengers were stranded, and emotions were running high.

Living in the D/FW metroplex meant that you got used to all the air traffic. A major international airport, and another regional airport, will fill the skies with planes. It was a surreal experience to not see any contrails arcing across the sky, or hear the roar of a passenger jet clawing for altitude.

To my knowledge, I didn't know anyone that died that day, but it still had a profound impact on me. It made me more aware of my surroundings, and unfortunately less trusting of those around me. It showed that our physical life is ephemeral, and can end in an instant. It proved that there are those in the world that seek harm for harm's sake.

And yet I'm comforted by the words of Joseph to his brothers, upon the death of their father, "as for you, you meant evil against me, but God meant it for good." God is in control. We might not understand why something happens, but that doesn't mean God is clueless. Life is not a series of random chaotic events. There is a Maker, and He still reigns.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Serving Christ by Serving Others

During my social media fast, one of the things I realized was just how much time I had been spending on social media. A quick stop by the computer to just check up on Facebook real quick turned into a 45 minute dive down the rabbit hole as I followed links, chased stories and otherwise wasted time. Likewise, what was intended to be a quick perusal of my Twitter timeline turned into 30 or minutes of watching the various columns scroll, in some vain effort to keep up with a vast information flow.

While I wasn't on social media, I found that I had more time to read, more time to spend with my wife and family, and more time to just simply do the things that needed doing. Now, don't get me wrong, I didn't suddenly become some productive machine of a perfect little angel. I found new ways to waste my time, but that's a discussion for another day. So, even though I'm dipping my toes back into the social media ocean, I'm trying to be much more cognizant of exactly how much time I'm spending on it. I'm trying to set firmer boundaries, and do more productive things with my time.

So what does all of that have to do with the title of this post? Exactly this. We need to be more intentional about what we're doing with our time. I've often heard it said that we must be the hands and feet of Jesus in this world. I had thought it was a scripture reference, but it appears that it's actually a quote from Mother Teresa:

"Christ has no body on earth but yours, no hands but yours, no feet but yours. Yours are the eyes through which Christ's compassion for the world is to look out; yours are the feet with which He is to go about doing good; and yours are the hands with which He is to bless us now."
~Saint Teresa of Avila

This goes along with the story of Jesus washing the disciples feet, found in John 13. But the more important verses immediately follow, when Jesus talks about what he did. Take a look at John 13:12-16:

12 When he had washed their feet and put on his outer garments and resumed his place, he said to them, “Do you understand what I have done to you? 13 You call me Teacher and Lord, and you are right, for so I am. 14 If I then, your Lord and Teacher, have washed your feet, you also ought to wash one another’s feet. 15 For I have given you an example, that you also should do just as I have done to you. 16 Truly, truly, I say to you, a servant is not greater than his master, nor is a messenger greater than the one who sent him.

"For I have given you an example, that you also should do just as I have done to you." Is he saying that we should go around washing the feet of our friends? Not quite, unless they're laid up and need the help. He's talking about service. The job of washing feet was relegated to the lowest servants and slaves in a household. It was definitely not a job of high honor. Jesus is telling us that we need to debase ourselves, get off our high horse, and get dirty helping our neighbors.

What does that look like? It doesn't have to be any huge undertaking. For instance, when I got home from work this afternoon I knew it was going to be at least an hour before dinner. Everyone was off doing various different things, and I had some free time. Instead of getting sucked into a social media time waste, I thought about going for a walk. But then I thought about my next door neighbors. She is a single mom, and her son, who usually mows the yard,  broke his leg last week. He's still in a cast and hasn't been able to get it mowed. So, instead of walking in circles around the neighborhood with buds jammed in my ears, I dragged out the mower and walked in circles around their yard. It was probably a better workout for me too. I'd hoped to get it done before she got home, but she caught me in the act. The was the most welcome "confused" look I've ever seen.

This is what service looks like. And we need to talk about it, and tell others about it, but not to brag on ourselves. We need to brag on Jesus, and we need to model what servanthood looks like. We have to be a model for the younger Christians in our church, and for our families. As I was heading outside, my oldest daughter commented that I was "so kind." I'm glad that she noticed, and that she thinks that. But I also want her to understand that it's not just kindness that leads me to do that.

It's serving Christ by serving others.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

A Social Media Fast

I was listening to a podcast yesterday from Desiring God entitled "Sacred and Secular". One of the themes discussed was how Matt Reagan, a college minister, responds to students asking him "Is it okay if I do this or that?" Part of the discussion he has with them revolves around how much control that activity has in their lives. Is it something that makes you twitchy when you've been away from it for a while? Are you constantly thinking about when you can do it again? In short, does it control you or do you control it?

As I was reflecting on that, I was reminded of a discussion I'd read about fasting. It was said that fasting will show you what's REALLY important to you. As you try and cope with your hunger for food, other internal hungers can come to the fore. When we are stressed, more of our true inner nature is revealed.

Putting all of this together, I came to the realization that I was spending way too much time on various social media sites. I was stuck in a rut, where I'd be sitting in front of the computer, refreshing the page or just watching my timeline scroll by, waiting for the next interesting nugget to pop up on my screen. There are so many other things I could be doing instead, like writing this blog post. I haven't posted since the end of June, to commemorate my anniversary. There have been many things I've wanted to write about, but I've wasted my time and not put deed to intent.

So, yesterday around lunch I posted on both Facebook and Twitter that I was taking a break from social media for at least one week. I removed the tabs from my default home group in my browser and logged out of the applications on my various electronic devices. The time that I would have spent there I intend to spend reading, or writing, or studying or with my family.

I know others, like Rod Dreher, tried something similar. I believe it was last summer he and his wife implemented a "no electronics" policy with their kids. As I recall, it wasn't a total ban, but they dramatically limited the amount of time the kids spent with their noises 6" away from a 4" screen. He said that the difference in attitude and behavior was palpable. I'm hoping for a similar result through this effort.

Fasting from food is intended to have us focus more on God and our spiritual appetites, and less on our physical appetites. I think fasting from social media can be used in much the same way.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Old enough to drive

16 years marks a major milestone in contemporary American culture. It marks the requisite age for obtaining a drivers license (or at least a permit). It signifies freedom; the permission to cram as many friends as possible into a vehicle with a full tank of gas and your favorite tunes on the radio, and the truth that the journey really is the destination.

16 years ago today, my wife stood in front of God and everyone and bound her life to mine. I still can't believe she said yes all those years ago, but I'm so grateful and blessed that she did.

Our journey has really only just begun, and I'm so glad that she is taking it with me.

16 years, 4 kids, and still counting.
(the years, not the kids)

 

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Random Musing on Faith

I have been working on a lesson plan for teaching on James 2:14-26. This is the "faith without works is dead" passage in James.

If you're treating your faith as fire insurance, you might want to check that policy. It might not be any good.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

The Orchard of our Soul

We've all heard the list, those personality traits that comprise the fruit of the Spirit: love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control. Often times, however, they seem very lacking in our lives. We want stuff done now, we want ti done our way, and we'll break down any wall to get it done. I know I've prayed and prayed and prayed for God to give me more of each one of these at various.

And then Dr. Corey Abney, pastor at Florence Baptist at Mt. Zion did a sermon series he titled "Rooted", on the fruit of the Spirit. One of the first things he taught was that these are not individual gifts of the spirit. When we accept Christ and the Holy Spirit comes into our lives, we are have the fruit of the Spirit (singular) in all its entirety. These are all individual aspects, if you will, of the fruit. It's not as if God gives us patience one day, and then another day we get the gift of kindness or self-control, and then He gives us faithfulness. It's an all-or-nothing package deal. Instead, we have to let these attributes blossom within us, and evince themselves more completely. They are already there, we have to let them out.

So, what is it that stunts the orchard of our soul and keeps the fruit from blossoming? Why do we struggle so often with anger, and slander and the other emotions Paul warns about in Ephesians 4:31?

I think the answer can be found in Matthew 3:8. John the Baptist is baptizing in the river Jordan, and the Pharisees and Sadducees have come to him for baptism. Look at what he tells them: "Bear fruit in keeping with repentance." So if we don't keep with repentance, we won't bear fruit. When we have unconfessed sin in our lives, that gets between us and God and stunts our growth and maturation. Instead of drawing closer to God, we feel guilty and pull away instead. So the simple, but definitely not easy, answer is that we have to continually examine our lives, and confess to God when we have sinned. Don't sit on it and wait. It's not going anywhere. Like a splinter that you leave in your finger, it will fester and get infected, and then it's that much more painful to extract later.

What in your life are you hiding from God and yourself? What is stunting the growth of the orchard of your soul? What is keeping the fruit of the Spirit from blossoming more fully in you life?

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Free book from Ligonier Ministries

Ligonier Ministries, the ministry of R.C. Sproul, is offering a free ebook on biblical manhood in honor of Father's Day.

The book is title "The Masculine Mandate: God's Calling to Men" and is written by Richard D. Phillips.

You can grab it from Amazon, or they have the ePub version in their store.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

What are you reading?

I was thinking about all of the books I currently have in progress.

I just finished God's Favorite Place on Earth by Frank Viola. This was an interesting look at the town of Bethany, and how much of Jesus' life and ministry revolved around it, especially in His final week before the crucifixion.

I'm also currently reading (in fits and starts) Blood Covenant by Michael Franzese. Michael came and spoke out our church several years ago, and the thought of a mobster that quit the mob and survived is just fascinating to me.

In the Christian Living realm, I'm reading Why Trust Jesus?: An Honest Look at Doubts, Plans, Hurts, Desires, Fears, Questions, and Pleasures by Dave Sterrett. I'll be perfectly honest. I wasn't very familiar with him at all, but this book popped up free for a short time in the Kindle version, so I nabbed it. It's an easy read so far (I'm not very far into it yet). It's a straightforward look at who Jesus is, and why that matters. It's a "back to the basics" type book, which I think is good to revisit every now and then.

Finally, in the Christian fiction realm, I'm currently reading Green by Ted Dekker. It's part of his Circle series. I'd previously read the other three books, but picked up the boxed set of all four when I ran across it at Half Price Books one day. It's basically a parable writ large, across four books, that ties into another series (The Paradise Trilogy) that he wrote.

So what has me thinking about what I'm reading? It's realizing what I'm NOT reading, at least not regularly or enough. I have an anthology of 66 books that I carry around frequently. I have a study version of it, multiple translations in electronic version, and accounts on several websites to try and help me study it. Yet I may read a few passages each morning with my devotionals, and a bit more here and there if I'm studying for a lesson. Yet I don't treat my Bible as a work of literature to sit down and read, and that's a shame.

I look forward to grabbing a Dekker book, or an essay by John Piper, or the latest from David Platt. Yet I find it burdensome to sit down with the Word of God and read it. The full arc of human history is spelled out in its pages, from the creation of the world to the fall of man to our final redemption through Christ's death on the cross. It's part narrative, part poetry, part mystery, part thriller, and wholly truth.

I wonder. If God's people spent as much time reading and studying His Word as we do immersing ourselves in all of the other mindless and inane forms of entertainment at our disposal, what would our world look like?

2 Timothy 3:16
Psalm 119:11
2 Timothy 2:15
Deuteronomy 11:18

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Why are we so hesitant to share the Gospel?

This is something I've struggled with over the years. Christians are clearly called to share the good news and to spread the Gospel to all corners of the world. However, it is easier to write a check for the missions budget of the local church or to financially support a missionary organization than it is to talk to our next door neighbor. If I know someone is already a Christian, I can talk God all day long, but if there is any doubt about their faith, I find myself tongue-tied and reluctant to talk.

This past Sunday, my pastor was continuing his sermon series on the book of Acts. His scripture this time was Acts 17, specifically Paul's sermon in the Areopagus. He pointed out that whenever the Gospel is preached, there will be one of three responses. The hearer will either reject the message, reconsider their position, or will come to repentance.

What does this have to do with sharing the Gospel? Human nature. It finally clicked in my head that what muzzles me is that first possible response. I fear their rejection. I've struggled with this before in other areas. I care, probably too much, about what other people think about me, and I jealously guard whatever good reputation I think I have. Since I fear rejection, that stifles my witness.

I think this is unfortunately true for too many of us. We are called to live in the world but not be of it, yet we worry what the world thinks of us. First, we need to remember that when someone rejects the Gospel, they are ultimately rejecting God and His message, not us. Yes, as the messenger, that rejection frequently follows onto us, but we are not the ultimate target of the rejection. Second, Christ warned that just as He was rejected, so too would we be rejected. If the world is NOT rejecting us, then perhaps we are doing something wrong. Or, as the teacher in my small group put it, as we mature in Christ, we should feel more and more uncomfortable living in the world.

Are you sharing the Gospel every opportunity you have, or do you hold back? Do you worry more about what your neighbor or co-worker thinks about you, or more about what they know of God?

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

QOTD - The Cost of Discipleship

Barry Cooper looks at the difference between free grace and cheap grace, the cost of discipleship, and asks why don't churches do a better job of discipleship.

When the gospel is preached in your local church, what do your people hear? Do they hear, “Of course you’ve sinned. But now everything is forgiven. Jesus paid the price for your sin. So everything’s taken care of.”

That’s okay as far as it goes. But it doesn’t go far enough. The problem is that this gospel contains no demand for discipleship. There’s no requirement for repentance. No holding out for holiness. Isn’t that at odds with Jesus’ insistence in Mark 8:34? “If anyone would come after me, let him deny himself and take up his cross and follow me.”

As the old truism goes, grace may be free—but it isn’t cheap. It cost Jesus his life. And it will cost us our lives too, if we want to follow him. The invitation may be extended to all, but only those who obey Jesus’ call—deny yourself and take up your cross—have received it.

And the question is, are we teaching this gospel in our local churches? Does our gospel contain the demand for discipleship? Or do we cough loudly over Mark 8:34, and relegate it to the small print, hoping no one will notice until after they’ve signed on the dotted line? Are we lowering the cost of discipleship in the hope that more will buy? (emphasis mine)

Is the church pulling a bait-and-switch on its followers? We need to preach the entire gospel, without pulling any punches or hiding any of the hard truths. The fact is that life in this world will not automatically be made "easy" just because we choose to follow Christ. In fact, He tells us exactly the opposite. Jesus warns that just as he was persecuted so will his followers be persecuted. Our treasures are stored in Heaven, and we serve with an eternal purpose.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Goodbye Google+ comments

I was experimenting with Google+ comments, but didn't like them. I wasn't getting notifications, and it required commenters to have a G+ account.

I read numerous complaints about how it worked, especially on blogs that had customized their templates in any fashion (which I had). So, I've turned off G+ comments and reverted to standard Blogger comments.

One downside to this is it appears any G+ comments have now gone the way of the dodo bird. I don't believe it was very many, but since I never got any notifications I really don't know.

So, if you had commented on a post, and it's now gone, my apologies. I didn't delete it on purpose, and I'm not trying to stifle the signal. I just changed commenting systems.

One of these days I may have to finally take the plunge and move over to WordPress instead.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Cleaning up Kronos Employee Groups and Labor Level Sets

In Kronos Workforce 6, one the key components of security is the Labor Level Set when used as an Employee Group. These sets restrict the employees that a manager can see.

One issue with these sets are that they are not self-healing or self-maintaining. If you deactivate a labor level entry, it will still be included in a labor level set. While this doesn't directly cause any harm (it won't grant someone access to employees they shouldn't, for example) it can negatively impact system performance. Why include a condition that is no longer valid?

Unfortunately, there are no system-delivered reports that will identify inactive labor level entries assigned to sets. Likewise, there is no magic "cleanup" button that will just go through and remove them for you.

This became a specific pain point for me just recently. We went through a major account change in our financials system that reworked a bunch of our labor levels. This rework included inactivating a lot of old ones that are no longer used. This was coupled with a quarterly audit report of manager accounts that showed exactly what labor levels each manager had access to. Seeing a lot of old inactive departments included on the audit report caused a bit of consternation and raised a few yellow flags.

The question then became, "What is the easiest way to clean up the labor level sets?" In our case, we completely changed our naming schema, so it was pretty easy to tell the old accounts by visual inspection. However, I didn't relish the thought of manually going through hundreds and hundreds of labor level sets looking for old labor level entries to remove. Instead, I poked around in the database schema and was able to come up with a query to identify inactive entries for me.

This query was written against the 6.0 schema on SQL Server 2005. If you are on Oracle, you may have to tweak the syntax slightly. I don't believe these tables have changed in the 6.x product line, so it should work all the way up to 6.3.

select
    laboracctset.shortnm,
    laboracctset.laboracctsetid,
    llelabacctstmm.laborlevelentryid,
    laborlevelentry.laborleveldefid,
    laborlevelentry.name,
    laborlevelentry.description,
    laborlevelentry.inactive
from
    laboracctset
inner join
    llelabacctstmm
on
    laboracctset.laboracctsetid = llelabacctstmm.laboracctsetid
inner join
    laborlevelentry
on
    llelabacctstmm.laborlevelentryid = laborlevelentry.laborlevelentryid
where
    laboracctset.labacctsettypeid = 2 and
    laborlevelentry.inactive = 1
order by
    laboracctset.shortnm,
    laborlevelentry.laborleveldefid,
    laborlevelentry.name
   
A few explanations are in order. The field 'LabAcctSetTypeID' in the LaborAcctSet table specifies what type of Labor Account Set it is. Since I was just worried about Employee Groups, I specified a value of '2'. The other possible values are 1 (All Sets) and 3 (Labor Level Transfer Sets).

I plan on adding this query to my routine maintenance checks, so that we can keep our Employee Groups cleaned up. Also, a partner query that I plan on writing is one that will identify unused Labor Level Sets. I prefer to keep these types of configuration items as lean as possible. There is no reason to hold on to old, unused sets if they're no longer used by anyone.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Social Media Customer Service Done Right

First, a little background.

I've been slogging through some drudgery work here at the office, reviewing user account audits and making changes as necessary. I have a dual-monitor setup on a laptop running Windows 7 Pro SP1. Well, it's a docking stations for my laptop with an external monitor, configured in dual display mode.

The external monitor is configure as my primary display, and the laptop as secondary. For processing these reports, I've had the application window open on the monitor, and the audit reports open on the laptop screen. The reports are Adobe Acrobat PDF files. My frustration is that whenever I double-click on one of the reports to open it, it has been opening on the primary monitor, even though the secondary monitor has "focus".

With most other business applications, they launch on whatever screen currently has the active window. So, basically, where ever I have Windows Explorer when I double-click the file to open, that's where the application launches. Either that, or the application remembers the last monitor it was on and opens there.

But not Acrobat Reader, for some reason. The only way I can get it to open a new PDF file on my secondary monitor is to close the document I was viewing but leave the application running. Then, when I open a new file, it opens in the active application window. But if Acrobat has to launch a new application window, it always does it on the primary monitor.

So, now that I've bored you with the technical details, on to the moral of the story.

I was pretty frustrated by this after the 15th or 20th time I had to move the Acrobat Reader application window, so I took to Twitter to vent. I fired off a quick screed and thought nothing else of it. I felt better, so my primary purpose was accomplished. I didn't even tag Adobe's primary Twitter account, mostly because I wasn't sure what it was and was too lazy to go look it up. I just used the hashtags #adobe and #acrobat in my tweet.

Imagine my surprise when I received a response to my tweet from Adobe today. They apologized for my troubles and said they would forward it on to the development team. Do I actually expect the dev team to do anything about it. Probably not. But the fact that they have a social media team actively looking for Adobe mentions, and not account mentions but just name and product mentions is impressive. And they actually responded, which is even more impressive.

I like Reader for the most part, and the PDF format is ubiquitous, especially in the business world. (Don't get me started on Flash; that's a post for another time). It's refreshing to see a major technology company not just resting on its laurels, but actively engaging the community and hopefully looking to improve the usability of their product.

Even if it's something as simple as opening on the "right" monitor.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

How to be a friend

We all go through trials and tribulations in life. Some are relatively minor while others can be earth-shattering in their impact. Whether it's an external pressure or an internal struggle, having someone come alongside you and help you through it is of immeasurable worth.

Ecclesiastes 4:12 makes it abundantly clear when it says that "[a]nd though a man might prevail against one who is alone, two will withstand him--a threefold cord is not quickly broken."

This is something that we talk about in Celebrate Recovery as well. Having a support team, comprised of accountability partners and a sponsor, along with regular fellowship and attendance at the meetings is crucial to facing down our personal demons. 

Regardless of whether it's an addiction, depression, co-dependency, or being unfairly attacked and maligned, a helping hand is most helpful indeed. It's even more helpful if you can find someone that has already walked that road before you. It gives you the hope that the obstacle can be surmounted. And it gives you the wisdom of someone that's already made the mistakes, so you don't have to make them again.

Jennifer is standing in the gap with a friend. I have no idea what life circumstances her friend is going through, and it's really none of my business, but it's obvious Jennifer has been there before. For being willing to share the pain, and share your wisdom, I thank you. And please tell your friend that she has my prayers.

For others that are struggling with life, regardless of what it may be, please know that there is hope, and there is help. Reach out to someone. Be willing to admit your weakness and cry out for help. You'd be surprised how many people are willing to stand in the gap with you.

I know I was.

For those that have friends that are struggling, please know that you can help. Be a friend. Lend your ear, not your judgement. One of their biggest fears is that people will be disappointed with them, or won't understand, or they'll be angry about it. Let them vent their spleen. Let them share. Stand in the gap with them, and it will make all the difference in the world.

I know it did for me.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Happy Pi Day!!

Why have I never noticed that before?!?!?

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)

Google is killing off Reader - No More RSS For You

According to this blog post, Google Reader is going the way of the dodo bird in their latest round of spring cleaning. I understand that development and maintenance resources are limited commodities, and they should be focused on those applications that are growing or heavily utilized. I find it highly ironic, however, that I read about the impending shut-down using the very tool that they are killing off.

The D-Day for Reader is July 1, 2013, or just under 4 months from now. The one good thing is that Google provides the Google Takeout tool (part of their data liberation initiative) to export all of your Reader subscription data. It also includes files with all your starred items, bloggers you follow, etc.

The only trick now is finding a suitable replacement RSS tool. One of the things I liked about Google Reader was that it was "in the cloud" and was browser agnostic. Most of the previous RSS tools I've used were plug-ins or add-ons for specific browsers. Either that, or they were thick-client installs. Reader allowed me to maintain one RSS subscription list that I could access from a multitude of devices. Granted, the Chrome browser is available on almost every device I use, and it has synchronization capabilities for its plug-ins, favorites, etc. I don't know how that plays with RSS readers, and I still don't like the idea of my RSS feed being tied to another piece of software. When it was in the cloud, I could use any browser to access it, so I was only halfway tied to the Google ecosystem.

So, does anyone have recommendations for an RSS reader that works across multiple devices and OSes, will synchronize item state across all of them, and is not a pain to manage?

I'll share anything I find and let you know what I settle on, if you care.

The LORD bless you and keep you; the LORD make his face to shine upon you and be gracious to you; the LORD lift up his countenance upon you and give you peace.
Numbers 6:24-26 (ESV)