BranchCharStates

tblBranchCharStates, linking table for block to match branch with character state. This is used for matrix blocks, but not for dichotomous blocks.

• KeyBlockID, integer, 2 bytes, = tblKeyBlocks.KeyBlockID
• CharIndex, integer, 2 bytes, = tblBlockCharStates.CharIndex
• CharStateIndex, 2 bytes, = tblBlockCharStates.CharStateIndex
• BranchIndex, integer, 1 byte, = tblKeyBlockBranches.BranchIndex; KeyBlockID, CharIndex, CharStateIndex and BranchIndex form a composite primary key
• Code, integer, 1 byte, relationship of character state to branch
  • 0 = not specified
  • 1 = state in branch unknown; if a branch has this setting for one state, it must have this for all states of that character
  • 2 = not applicable to this branch; if a branch has this setting for one state, it must have this for all states of that character
  • 3 = state never found in branch; if all but one state for a character have this setting, then the remaining state for the branch must be 6
  • 4 = state found only rarely in branch
  • 5 = states found commonly in branch
  • 6 = sole state found in branch; if a branch has this setting for one state, all other states for that character must be 3
• LastUpdate, smalldatetime, date and time row last updated
• ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
• CreatedOn, smalldatetime, date and time row was created
• CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row