Last updated on Jan 31, 2021, 18:27 UTC by Authentification.will.come.later.on@brussels.msf.org.
Description

This DataSet contains HQ Cost Center's basic information.
!!! Only active cost centers !!! we are working on giving inactive cost center

Access

URL: https://hasura-main-catalog.ocb.msf.org/v1/graphql
OBJECT: ocb_catalog_hq_cost_center_v10

Example

Here is a full example of the data you will get in the future from the GraphQL API.

Data Ownership

All the data are maintained by the Fin.

Data Lineage

In this section we describe the sources and the transformations from the source to this model. We also list the consumers of the data.

FIN: Financial Planning Team (Adeline Jansen/Filipa Morgao/Thi Thanh Ly)

Coda
Xls file maintained by Adeline Jansen for some infos like the supervisors and they are first created in Coda

Every night the Cost Centers are imported in Board

Master data application is currently an Excel file maintained by the Finance and then from this file the Cost Centers are then created in Coda.

Mobile Expenses - talend (TALEND_731_MOBILE_EXPENSE_FIN_M_Import_MX)
Mobile Expenses - talend (TALEND_731_MOBILE_EXPENSE_FIN_M_Export_MX_Coda)
Board - The Cost Centers are imported in the capsule HQ_Project in Board

Data Glossary

Here is the business description of each future data field.

Master Data
All master data comes in priori from Fin.

FieldTypeBusiness descriptionLineage
codeStringUnique identifier of the Cost CenterFin
descriptionStringName and short description of the Cost CenterFin
StatusStringStatus of the Cost Center: EL4AA if active and EL4NA if inactiveFin
accounting_start_dateDate (YYYY-MM-DD)Opening date of the Cost CenterFin
accounting_end_dateDate (YYYY-MM-DD)Closing date of the Cost Center. Empty for ongoing Cost Center.Fin



Application Data
Same as Master Data