tblOrgSystem
OrgSystemID OrgSystem
1 USA
2 CANADA
tblOrgSystemNod e
OrgSystemID OrgNodeID OrgNode
1 3 Manistique
1 4 Houston
1 7 M-Sales
1 8 M-IT
1 10 H-Sales
1 11 H-IT
2 5 Toronto
2 6 Ontario
2 13 T-Sales
2 14 T-IT
2 16 O-Sales
2 17 O-IT
tblOrgSystemNod eParent
OrgSystemID OrgNodeId OrgNodeParentID
1 3 -1
1 4 -1
1 7 3
1 8 3
1 10 4
1 11 4
2 5 -1
2 6 -1
2 13 5
2 14 5
2 16 6
2 17 6
OrgSystemID OrgSystem
1 USA
2 CANADA
tblOrgSystemNod e
OrgSystemID OrgNodeID OrgNode
1 3 Manistique
1 4 Houston
1 7 M-Sales
1 8 M-IT
1 10 H-Sales
1 11 H-IT
2 5 Toronto
2 6 Ontario
2 13 T-Sales
2 14 T-IT
2 16 O-Sales
2 17 O-IT
tblOrgSystemNod eParent
OrgSystemID OrgNodeId OrgNodeParentID
1 3 -1
1 4 -1
1 7 3
1 8 3
1 10 4
1 11 4
2 5 -1
2 6 -1
2 13 5
2 14 5
2 16 6
2 17 6