---
title: "Code Generation"
canonical: "https://docs.vaultspeed.com/space/VPD/3012919349/Code%20Generation"
format: markdown
---
# Code Structure

In the zip files that are generated, each file has a certain structure that VaultSpeed adheres to. Below you can find the different structures and the files that can be generated by VaultSpeed. Please note that not always all files will be generated. This depends on the settings you choose.

## File formatting

- DDL:
  - "<id>_<order>_GENERATE_DDL_<layer>_<source name>_<schema name>_<date>_<time>.sql"
  - "<id>_<order>_GENERATE_DDL_<layer>_<schema name>_<date>_<time>.sql"
  - "<id>_<order>_GENERATE_DDL_ALTER_DV_<schema name>_<table name>_<column name>_<date>_<time>.sql"
  - "<id>_<order>_GENERATE_DDL_CREATE_DV_<schema name>_<table name>_<column name>_<date>_<time>.sql"
  - "<id>_00_GENERATE_DDL_SCHEMAS_<source name>.sql"
  - "<id>_00_GENERATE_DDL_SCHEMAS.sql"
- ETL:
  - <load type (INCR, INIT, DDL)>/<layer>/<layer order>_<in layer order>_<layer>_<source short name>_<table short name>_<mapping type>
  - <load type (INCR, INIT, DDL)>/<layer>/<layer order>_<in layer order>_<object>_<source short name>_<table short name>_<mapping type>

The <order> and <in layer order> will hint at the order of execution.

Views have load-type DDL in the ETL generation.

### **Initial load mappings**

| Mapping | Abbreviation | Layer order | In layer order | Type | Conditioned |
| --- | --- | --- | --- | --- | --- |
| Extraction | EXT | 10 | 1 | MAP | / |
| Staging | STG | 12 | 1 | MAP | / |
| Staging many to many link | STG_DL | 12 | 1 | MAP | / |
| Hub | HUB | 14 | 1 | MAP | / |
| Satellite | SAT | 14 | 1 | MAP | / |
| Link | LNK | 14 | 1 | MAP | / |
| Satellite on Link | LKS | 14 | 1 | MAP | / |
| Many to Many link | LND | 14 | 1 | MAP | / |
| Satellite on Many to Many link | LDS | 14 | 1 | MAP | / |
| Reference | REF | 14 | 1 | MAP | / |
| Link Across Sources | LNA | 16 | 1 | MAP | / |
| Satellite on Link Across Sources | LAS | 16 | 1 | MAP | / |
| Snapshot date views | SSD | 16 | 1 | VIEW | / |
| Point-in-time | PIT | 16 | 1 | MAP | / |
| Bridge | BRIDGE | 16 | 1 | MAP | / |
| Business view | BV | 16 | 1 | VIEW | / |

### **Incremental load mappings**

| Mapping | Abbreviation | Layer order | In layer order | Type | Conditions |
| --- | --- | --- | --- | --- | --- |
| Remote source delta view | SDV | 6 | 1 | VIEW | REMOTE_JOURNALING:Y + CREATE_REMOTE_DELTA_VIEW:Y |
| Target delta table | TDT | 6 | 1 | MAP | REMOTE_JOURNALING:Y + USE_REMOTE_CDC_DBLINK:Y |
| Target view | TV | 8 | 1 | VIEW | PERSIST_DELTA_FIREWALL_VIEWS:Y |
| Target delta firewall table | TDFT | 8 | 1 | MAP | REMOTE_JOURNALING:N + PERSIST_DELTA_FIREWALL_VIEWS:Y |
| Target Firewall view | TFV | 8 | 1 | VIEW | REMOTE_JOURNALING:Y + PERSIST_DELTA_FIREWALL_VIEWS:N |
| Target Firewall table | TFT | 8 | 1 | MAP | REMOTE_JOURNALING:Y + PERSIST_DELTA_FIREWALL_VIEWS:Y |
| Target delta firewall view | TDFV | 8 | 1 | VIEW | REMOTE_JOURNALING:N + PERSIST_DELTA_FIREWALL_VIEWS:N |
| Extraction | EXT | 10 | 1 | MAP |  |
| Staging | STG | 12 | 1 | MAP |  |
| Staging many to many link | STG_DL | 12 | 1 | MAP |  |
| Prepare deletes staging | PREP_DELETE_STG | 12 | 2 | MAP | Full Load … with Delete Management |
| Prepare deletes Staging many to many link | PREP_DELETE_STG_DL | 12 | 2 | MAP | Full Load … with Delete Management |
| Hub | HUB | 14 | 1 | MAP | / |
| Satellite | SAT | 14 | 1 | MAP | / |
| Link | LNK | 14 | 1 | MAP | / |
| Satellite on Link | LKS | 14 | 1 | MAP | / |
| Many to Many link | LND | 14 | 1 | MAP | / |
| Satellite on Many to Many link | LDS | 14 | 1 | MAP | / |
| Reference | REF | 14 | 1 | MAP | / |
| Link Across Sources | LNA | 16 | 1 | MAP | / |
| Satellite on Link Across Sources | LAS | 16 | 1 | MAP | / |
| Snapshot date views | SSD | 16 | 1 | VIEW | / |
| Point-in-time | PIT | 16 | 1 | MAP | / |
| Bridge | BRIDGE | 16 | 1 | MAP | / |
| Business view | BV | 16 | 1 | VIEW | / |