Do we know why

socialsecuritynumber

isn’t available using

SuiteQL

while it is available using

search

?

AI generated answer (using internal Slack threads):

The

socialsecuritynumber

field is not available in SuiteQL due to NetSuite's data privacy and security policies. This field contains sensitive personal information, and NetSuite has implemented measures to ensure that this data is not easily accessible or exposed. Even with the

Administrator

role, the social security number is masked when retrieved. In contrast, the

search

API allows for more granular control over data access and permissions, which is why you might be able to access the

socialsecuritynumber

field using this method. However, it's important to note that even with the

search

API, the social security number is typically returned in a masked format (******) to protect sensitive information. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******