Finding the value of the state and status codes

If you’ve ever wondered how to find the values for the statecode and statuscode, you can use the following SQL script to find those values:

select 
    AttributeName, 
    AttributeValue,
    Value
from dbo.StringMap 
where
(dbo.StringMap.AttributeName = 'statuscode' 
or
dbo.StringMap.AttributeName = 'statecode')
and 
dbo.StringMap.ObjectTypeCode = 1

Will display the following values for the Account Entity ( ObjectTypeCode = 1 ):

AttributeName AttributeValue Value

statecode

0

Active

statecode   

1

Inactive

statuscode

1

Active

statuscode

2

Inactive

Leave a Reply 2 comments