Organisation Load Control Interface Table

This extract file interface is used to control various elements of the customer In the context of the Cloud Monetisation Platform, an individual or organisation who has signed an agreement to take goods and services from a service provider. A customer receives a bill associated with one or more subscriptions, and can be a single end user or a large company with many subscriptions assigned to one agreement. hierarchy loading process. There is only a single record in this file per extract. The record format includes an effective date for use when building organisation unit snapshots and a series of extract file record counts for validation purposes. Data loaded via this interface is primarily bound for the HIERARCHY_LOAD and DATA_LOAD 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_Load_Control_Interface	Staging	org_load_control.dat

 

Organisation load control interface table fields

Column Heading	Type	Length	Description
EXTERNAL_DATA_SOURCE_ID	VarChar2	40	An identifier for the instance of the CRM database from which the hierarchy data has been extracted.
EXTRACT_ID	VarChar2	40	A unique identifier for the current extract. This value will usually be derived by the CRM from a sequence that it controls and tracks.
ORG_LOAD_CONTROL _COUNT	Integer		Number of records in the Org_Load_Control extract file. Used to confirm that the contents of that extract file have been successfully delivered without truncation.
ORGANISATION_COUNT	Integer		Number of records in the Organisation extract file. Used to confirm that the contents of that extract file have been successfully delivered without truncation.
ORGANISATION_STRUCTURE_COUNT	Integer		Number of records in the organisation_structure extract file. Used to confirm that the contents of that extract file have been successfully delivered without truncation.
ORG_NODE_ATTRIBUTE_COUNT	Integer		Number of records in the org_node_attribute extract file. Used to confirm that the contents of that extract file have been successfully delivered without truncation.
HIERARCHY_EFFECTIVE_DATE	Date		Date on which the hierarchy structure described within the current extract is true. yyyymmddhh24miss format .
EXTRACTION_TIMESTAM	Date		Date and time that the extract file set was generated. yyyymmddhh24miss format.