Organisation Node Attribute Interface Table

This extract file interface handles records that contain descriptive attributes for each hierarchy node. Each record contains a single attribute for a node and the number of attributes that any one hierarchy node can have is potentially unlimited. It is only necessary to pass in data via this interface when an organisation unit has attributes that need to be added or changed. Data loaded via this interface is primarily bound for the ORG_UNIT_ATTRIBUTE_SNAPSHOT CXP Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. Admin schema tables.

External table name	Schema	Mapped file
org_node_attribute_Interface	Staging	org_node_attribute.dat

 

Organisation node attribute interface table fields

Column Heading	Type	Length	Description
EXTERNAL_ORGANISATION_UNIT_ID	VarChar2	40	Unique identifier denoting the organisation unit element to which the attribute information on this record belongs.
ORGANISATION_UNIT_LEVEL	Integer		The level within the organisation unit hierarchy, at which the organisation unit resides.
ATTRIBUTE_NUMBER	Integer		Identifier for the current attribute. Used by the application when retrieving the attribute value for display.
ATTRIBUTE_TYPE	VarChar2	40	The type of data represented by the attribute value (TEXT or NUMERIC).
ATTRIBUTE_VALUE	VarChar2	100	A piece of custom data associated with an organisation unit.