FBIP_sys (cdf)

1. Input Data

Configuration files.

Manage the generation of all SQL tables and documentation outputs.

Field	Type	Data Level	Observations
dt	datetime	A	[1]
dtint	bigint	A	[1]
locationID	varchar(100)	A	[2]
partnumberID	varchar(150)	A
processingTime	float	B	[3]
processingTags	string	B	[4]

Table Observations:

[1]: Datetime string with the format “yyyy/mm/dd HH:MM:SS.f” and its corresponding UTC integer; Timestamp obtained when the partnumID leaves the locationID
[2]: The location identification of the UseCase
[3]: Time in seconds representing the processing time of the partnumberID on the locationID;
[4]: Space separated string with tags labelling the processingTime (e.g. stop_maintenance_curative)

General Observations:

— sys: Base system framework (inFiles: sbroETL-sys.yml, class: FOSM/project) – mandatory

[exec sys_install/M01] (Re)create default system tables
[…] (Re)create datain table “DinINST” [institutional format]
[…] (Re)reate dataout table “DoutINST” [institutional format]
[…] (Re)create datain table “DinSDL” [CDF/sys format]
[…] (Re)create dataout table “DoutSDL” [CDF/sys format]
[…] Create tables of other frameworks (if needed)
[exec sys_config/M01] Set system configurations
[exec sys_docs/M02] Generate Product-UseCase documentation
[up] Load SDL specific services, sbroETL variants “{*}F|{b,k}D{in,out}G” services and sbroBRT services
[down] Unload all services create by up
[exec sys_main/M01] Execution of Product-UseCase maintenance tasks and management of services
[run] exec sys_docs

Identification: sys_main
Description: Execution of Product-UseCase maintenance tasks and management of services
Implementation team: [UA.ER]
Plugins: Do not use plugins