Tamil,

1. We are doing a SUBSTR of Locator where Locator values are like '1', '1.1', '1.1.1', ....
2. We are doing a BITAND for an integer column where for anything above 1st grade "BITAND (cbs.internal_grade_levels, 2) > 0" is true, for anything above 2nd grade,
"BITAND(cbs.internal_grade_levels, 4) > 0" is true and so on..