Icon

MST_​Payroll_​Daily (GCP)

Actual Payroll & Hours
Error Handling
Data Availability Check
Calendar
Forecasted Payroll & Hours
PostgreSQL
GCP BigQuery
Column Rename (deprecated)
Determine weekday
Rule Engine
Load temp table data
DB Loader
Remove 0 or missing
Rule-based Row Filter
Insert to prod; clean up
DB SQL Executor
Column Rename (deprecated)
Payroll
Column Filter
Create temp table (actual)
DB Table Creator
Hours + payroll
Joiner
Column Rename (deprecated)
Determine weekday
Rule Engine
Filter columns
Column Filter
Filter columns
Column Filter
Unpivot columns
Unpivot
Filter columns
Column Filter
Column Rename (deprecated)
Hours
Column Filter
Calendar
Column Filter
Column Rename (deprecated)
Filter columns
Column Filter
Column Rename (deprecated)
Determine weekday
Rule Engine
Read refresh time
DB Query Reader
Past = Actuals
Date&Time-based Row Filter
Converting row to variable
Table Row to Variable
Success Message
Send Email
Perform Success or Failure Path
CASE Switch Start
Failure Message
Send Email
Folder > Latest File
Unpivot columns
Unpivot
Load temp actual data
DB Writer
run_status
Column Expressions (legacy)
Cast numbers
Column Expressions (legacy)
Load temp forecast data
DB Writer
Column Resorter
Sign in with your GCP Account
Google Authenticator (Deprecated)
PostgreSQL (Prod / Admin)
PostgreSQL Connector
Filter columns
Column Filter
Rename columns
Column Rename (deprecated)
Insert to prod; clean up
DB SQL Executor
Date format
String to Date&Time (deprecated)
Insert to prod; clean up
DB SQL Executor
Check availabilty of data
Rule Engine Variable
Column Resorter
Create temp table (forecast)
DB Table Creator
BigQuery Connector
Google BigQuery Connector
Create run time
Create Date&Time Range (deprecated)
Insert to prod; clean up
DB SQL Executor
Add Date
Joiner
Load temp table data
DB Loader
Converting into variable
Table Row to Variable
Unpivot columns
Unpivot
Unpivot columns
Unpivot
Determine weekday
Rule Engine
Hours
Column Filter
Payroll
Column Filter
Add Date
Joiner
Capture Workflow Details
Extract Context Properties
Unpivot columns
Unpivot
Capture Errors
Catch Errors (Var Ports)
Unique values
Duplicate Row Filter
Perform Success or Failure Path
CASE Switch Start
Determine Success or Failure
Rule Engine Variable
Collect Failure Info
Try (Variable Ports)
Remove 0 or missing
Rule-based Row Filter
Hours + payroll
Joiner

Nodes

Extensions

  • No modules found

Links