Hierarchy Node Check Interface Table

This extract file interface is used to validate that all invoice components in the invoice extract can be successfully attached to hierarchy nodes already stored in the CXP Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. database.

The hierarchy_node_check.dat extract file must contain a record for every hierarchy node that is associated with invoicing data in the extract.

Each hierarchy_node_check.dat record must correspond with an existing organisation_unit_snapshot table record in the database and that organisation_unit_snapshot record must be effective on the invoice date used within the current invoice extract.

To correspond with an organisation unit snapshot record, the parent and child nodes included on the hierarchy_node_check.dat record must both match

If an effective match cannot be found for any records in the hierarchy_node_check.dat file, then the current extract file set is rejected.

External table name	Schema	Mapped file
hierarchy_node_check_Interface	Staging	hierarchy_node_check.dat

 

Hierarchy node check interface table fields

Column Heading	Type	Length	Description
EXTERNAL_ORGANISATION_UNIT_ID	VarChar2	40	Unique identifier denoting an organisation unit element within a customer's organisation unit hierarchy.
ORGANISATION_UNIT_LEVEL	Integer		The level within the organisation unit hierarchy, at which the current organisation unit resides.
EXTERNAL_PARENT_ORG_UNIT_ID	VarChar2	40	Identifier denoting the parent organisation unit of the current organisation unit within the organisation unit hierarchy. If the current organisation unit has no parent (it is at the top of its hierarchy) then the parent value will be NULL.
PARENT_ORG_UNIT_LEVEL	Integer		The level within the organisation unit hierarchy, at which the parent organisation unit resides.