The BookParentChild store is the source of the builder for the BookHierarchy store.
It is an isolated store and not part of any cube facts.
It contains the structure of the book hierarchy along with a description of the desks.
It is indexed by Child and AsOfDate.
Store Field
Key
CanBeNull
Type (+Default Value - if applicable)
Cube Field
Description
Child
Y
String
Populated using CSV file data - used as part of intermediary step to create the “BookHierarchy” Store.
Name of the node in the Book/Desk hierarchy.
Parent
String
Populated using CSV file data - used as part of intermediary step to create the “BookHierarchy” Store.
Name of the parent node (or null if there is no parent).
Desk
String
Populated using CSV file data - used as part of intermediary step to create the “BookHierarchy” Store.
Flag indicating if this node in the hierarchy is a desk. Set to ‘Y" for nodes that are desks.
Category
String
Populated using CSV file data - used as part of intermediary step to create the “BookHierarchy” Store.
Optional category for the node (and all Descendant nodes).
DeskModel
String
Populated using CSV file data - used as part of intermediary step to create the “BookHierarchy” Store.
For FRTB desks, should the desk be treated as “IMA” or “SA” for the capital charge calculations.
PLA_Zone
String
Populated using CSV file data - used as part of intermediary step to create the “BookHierarchy” Store.
For FRTB desks, this field indicates which zone the desk falls into according to the PLA test metrics [MAR32.42]. If not an FRTB desk, this field is empty.
IRT_Desk
String
Populated using CSV file data - used as part of intermediary step to create the “BookHierarchy” Store.
Indicates whether the desk is an IRT desk. ACR is calculated separately for desks flagged as IRT.