As I have mentioned above my solution is to wrap the script around SET PARSEONLY OFF/ON. And here is the implementation:

SET PARSEONLY OFF -- turn off the syntax and name...

The error is : "Invalid column name 'NotEligible'"

However, I have managed to solve it by using SET PARSEONLY OFF/ON around the script to turn off the reference checking at parsing/compile...