I am pulling from the table used in the PR_EarningsReport but not all fields are being populated in my query. For example, I can get Employee Number but not First and Last Name?
I am pulling from the table used in the PR_EarningsReport but not all fields are being populated in my query. For example, I can get Employee Number but not First and Last Name?
If on version 2018+, certain information considered Personally Identifiable Information (PII) is encrypted and can't be viewed via ODBC by querying the table directly.
See these KB articles.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=88325
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=101302
However, I'm not sure how this would be accomplished with sage intelligence.
If on version 2018+, certain information considered Personally Identifiable Information (PII) is encrypted and can't be viewed via ODBC by querying the table directly.
See these KB articles.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=88325
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=101302
However, I'm not sure how this would be accomplished with sage intelligence.
*Community Hub is the new name for Sage City