where will be work statuses stored
Where will be work statuses informaiton stored? Its definetly not in table.
All of the following appies to BPC MS; NW is considerably different...
That table tblAppNameLock is a little tricky. Just because you see a record in that table, you can't assume the node (intersection of your work status dimensions) is locked.
You need to find the record with the most recent LastUpdate time, to determine the current work status for a given node.
The value in the StatusCode field (always an integer) corresponds to the tblStatusCode.Status field.
For example if you first lock a node, and then later unlock it, there will be two records in tblAppNameLock.