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

This DataSet contains field project's basic information.
A project code can be a financial code and/or a operational code

A financial code is ... .

A operational code is ... .

Access

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

Power BI Report : DatCat_Field_Porject_Codes_v1_0

Example

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

Data Ownership

Operational data are maintained by the Ops. (Christine Januel).

Financial data are maintained by the finance dept (Fuilhem Messaut).

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 (Guilhem Messaut)
OPS (Christine Januel)

Coda
Xls file maintained by Ops

Data are updated every night (02:00 AM GMT+1)

Master data application is an Excel file maintains by the OPS.
When a code is operational and financial, then the master data is filled by the ops info

talend (job DW_M_10_ProjectCodesFromOpsXls)
talend (job DW_M_10_ProjectFromCoda)
talend (job DW_M_10_ProjectFromGIS)

WEFIN - talend (WEFIN_M_ProjectCode_Sync)
IMT - talend (FIN_IMT_M_Field_Project_Codes_Synch) Power BI Report : DataCatalog - Project v1.0
Log Basics Monitoring (LOG_M_Log_Basics_Montitoring_Chart) Power BI Report : Log Basics Monitoring

Data Glossary

Here is the business description of each future data field.

Master Data
All master data comes in priori from Ops then Fin.

FieldTypeBusiness descriptionLineage
mission_codeStringCode of the project's mission
Link to the Field Mission Codes DataSet		Ops, Fin
codeStringUnique identifier of the projectOps, Fin
nameStringName of the ProjectOps, Fin
cellStringCellule where the project is handledOps, Fin
opening_dateDate (YYYY-MM-DD)Opening date of the operation for this projectOps, Fin
estimated_closing_dateDate (YYYY-MM-DD)Closing date of the operation for this project. Empty for ongoing project.Ops, Fin
closing yearIntegerActual closing year of the project (empty for active project)financial code : year of ops closing date
else TODO
activityArray of StringOperation activitiesOps
typeArray of stringType of the entry
+ ocb_operationStringIs an ocb operation projectOps
+ financeStringIs an fincial projectFin



Application Data
From Coda

FieldTypeBusiness description
codeStringUnique identifier of the project
nameStringName of the Project
cellStringCellule where the project is handled
start_periodDate (YYYY-MM-DD)First day of the accounting opening period
end_periodDate (YYYY-MM-DD)Last Day of the accounting closing period
coda_system String Flag to categorise the code ALL: à créer dans tous les sytemes (comme la majeurité de codes terrain standard)
FSP (Fin Supply) : codes projets seulement pour finance et supply (ex EPREP)
FIN : codes projets seulement pour les finances (ex. associatif)
NWF (No WeFin): pour tous les codes projets qui doivent etre crées seulement dans coda
ops_start_dateTODOTODOOps start date in coda
ops_end_dateTODOTODOOps End date in Coda