CR 9 - Sybase ASA 6.0.2
Having a difficult time finding the correct way to come up with a sum....
group 1 - ServCatDesc
group 2 - AccountNo
group 3 - ActivityTypeDesc
group 4 - ActivityNo
detail - pat.masterno (may or may not be present), activitylength (always...
CR 9.0/Sybase ASA 6.0.2
Table Activity LOJ to table Program.ProgDesc (to determine program name that may or may not have been selected for Activity)
Table Activity also LOJ to table PatReg.ProgNo (through 2 other tables) (to determine program name patient belongs to if activity included patient)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.