BI Data Extract Guide - Revision history

Anw: Minor formatting change

2025-11-04T09:18:54Z

Minor formatting change

← Older revision		Revision as of 11:18, 4 November 2025
Line 49:		Line 49:
	The tables are listed. It is expected that each column will be delimited with a '®' symbol and that extract can be scheduled and run on with records created or updated in the last 4 days.		The tables are listed. It is expected that each column will be delimited with a '®' symbol and that extract can be scheduled and run on with records created or updated in the last 4 days.

	{{Note}} * Up to 50 columns may be configured per extract.		{{Note\|* Up to 50 columns may be configured per extract.
	* The list below shows common fields for the tables, and these may be selected from for the 50 columns.		* The list below shows common fields for the tables, and these may be selected from for the 50 columns.
	* If more than 50 columns are required, then an additional extract for that table may be defined.		* If more than 50 columns are required, then an additional extract for that table may be defined.
			}}

Anw: Minor update

2025-11-04T09:17:42Z

Minor update

← Older revision		Revision as of 11:17, 4 November 2025
Line 29:		Line 29:
	SCH_TRIP		SCH_TRIP
	SCH_TRIP_STOP		SCH_TRIP_STOP
	Note: Other tables are available and may be exported – these are the most common. The tables and fields exported can be configured.		Note: Other tables are available and may be exported – these are the most common. The tables and fields exported can be configured (added to or removed, based on customer processing requirements).


Line 48:		Line 48:

	The tables are listed. It is expected that each column will be delimited with a '®' symbol and that extract can be scheduled and run on with records created or updated in the last 4 days.		The tables are listed. It is expected that each column will be delimited with a '®' symbol and that extract can be scheduled and run on with records created or updated in the last 4 days.

			{{Note}} * Up to 50 columns may be configured per extract.
			* The list below shows common fields for the tables, and these may be selected from for the 50 columns.
			* If more than 50 columns are required, then an additional extract for that table may be defined.


Line 870:		Line 874:
	* File Type PROCESS		* File Type PROCESS
	* The interval should be once daily at a defined time after midnight.		* The interval should be once daily at a defined time after midnight.
	* The folders should point to a known folder within ~~teh~~ CTMS system data structure.		* The folders should point to a known folder within the CTMS system data structure.
	* The Params should be		* The Params should be
	** Title PACKAGE_NAME, name PROCESS, Value ~~MP_MIS~~.pr_create_all_extracts		** Title PACKAGE_NAME, name PROCESS, Value DP_MIS.pr_create_all_extracts

	The following shows the data extracted, grouped by type.		The following shows the data extracted, grouped by type.

Anw: Added EDI to BI data extracts

2025-10-31T11:29:23Z

Added EDI to BI data extracts

← Older revision		Revision as of 13:29, 31 October 2025
Line 36:		Line 36:
	The following schemas indicate the links between the tables (Primary & Foreign keys)		The following schemas indicate the links between the tables (Primary & Foreign keys)

	<gallery widths=600 heights=800px perrow=1>		<gallery widths="600" heights="800px" perrow="1">
	Image:BI_Data_Extract_Links_1.png		Image:BI_Data_Extract_Links_1.png
	Image:BI_Data_Extract_Links_2.png		Image:BI_Data_Extract_Links_2.png
Line 862:		Line 862:
	= Extraction =		= Extraction =

	Data is scheduled to run on an Oracle DMBS_JOB that will produce delimited flat files that will be pushed to an agreed server.		Data is scheduled to run on an Oracle DMBS_JOB that will produce delimited flat files that will be pushed to an agreed server. <center>
			[[File:BI Data Extract EDI.png\|800x800px]]
			</center>The set up must contain

			* A unique Process Name
			* Direction Outbound
			* File Type PROCESS
			* The interval should be once daily at a defined time after midnight.
			* The folders should point to a known folder within teh CTMS system data structure.
			* The Params should be
			** Title PACKAGE_NAME, name PROCESS, Value MP_MIS.pr_create_all_extracts

			The following shows the data extracted, grouped by type.

	Business Area Trip		Business Area Trip

Anw: Categorisation

2024-05-09T13:44:20Z

Categorisation

← Older revision		Revision as of 15:44, 9 May 2024
Line 912:		Line 912:
	There is no method to identify when records are deleted. Therefore records removed from CTMS will not be extracted.		There is no method to identify when records are deleted. Therefore records removed from CTMS will not be extracted.

			<noinclude>
	[[Category: Interfaces]]		[[Category: Interfaces]]
			</noinclude>

Anw: Categorisation

2024-02-16T09:44:24Z

Categorisation

← Older revision		Revision as of 11:44, 16 February 2024
Line 911:		Line 911:

	There is no method to identify when records are deleted. Therefore records removed from CTMS will not be extracted.		There is no method to identify when records are deleted. Therefore records removed from CTMS will not be extracted.

			[[Category: Interfaces]]

Anw: Added BI Data Extract Guide

2023-11-15T10:58:15Z

Added BI Data Extract Guide

Show changes