The applications team has informed me that CloudLink does not have the functionality to recognize expired enrollments using hours. I want the system to be able to calculate all enrollment expirations by more than just date.
SQL Solution:
CASE WHEN Contract_Status = 'P' THEN 'PENDING'
WHEN Contract_Close_Date > '1901-01-01' and Contract_Close_Date <= GETDATE() THEN 'CLOSED' -- close on data
WHEN Contract_End_Date <= GETDATE() and Contract_End_Date_Or_Usg = 'On Date' THEN 'EXPIRED' -- expired on date
WHEN Max_Smu >= Contract_End_Smu and Contract_End_Date_Or_Usg = 'On SMU' THEN 'EXPIRED' -- expired on SMU
WHEN (Contract_End_Date <= GETDATE() and Contract_End_Date_Or_Usg = 'First To Occur') or (Max_Smu >= Contract_End_Smu and Contract_End_Date_Or_Usg = 'First To Occur') THEN 'EXPIRED' -- expired on first to occur
ELSE 'ACTIVE'
END AS Contract_Status
Enich McStotts
| How often would this idea be used? | Daily |
| How much time would you save when the idea is implemented? | It would save hours of work |
| How many people at your company would benefit from this idea? | Most people (25 + ) |
|
What problem is your idea trying to solve?
Incorrect data. |
|
Enich, did you mean for this to be for EMT? This is currently in the SalesLink section. If you meant for it to be in SalesLink, could you be more precise about what part of the application you're referring to?