STG_ETABLISSEMENT
⚠️ Auto-generated — do not edit this file directly.
Re-run python scripts/generate_docs.py to refresh it.
Info
| Property |
Value |
| Source |
SIRENE |
| Database |
RESILIANS_SIRENE_DB |
| Schema |
STG_DBO |
| Layer |
🪙 Staging |
| Type |
BASE TABLE |
| Rows |
37,720,071 |
| Columns |
29 |
Columns
| # |
Column |
Type |
Nullable |
Default |
Description |
| 1 |
SIREN |
TEXT |
✅ |
— |
— |
| 2 |
NIC |
TEXT |
✅ |
— |
— |
| 3 |
SIRET |
TEXT |
✅ |
— |
— |
| 4 |
STATUT_DIFFUSION |
TEXT |
✅ |
— |
— |
| 5 |
DATE_CREATION |
DATE |
✅ |
— |
— |
| 6 |
DATE_DEBUT_PERIODE |
DATE |
✅ |
— |
— |
| 7 |
DATE_DERNIERE_MAJ |
TIMESTAMP_NTZ |
✅ |
— |
— |
| 8 |
ETAT_ADMINISTRATIF |
TEXT |
✅ |
— |
— |
| 9 |
EST_ACTIF |
BOOLEAN |
✅ |
— |
— |
| 10 |
EST_SIEGE |
BOOLEAN |
✅ |
— |
— |
| 11 |
COMPLEMENT_ADRESSE |
TEXT |
✅ |
— |
— |
| 12 |
NUMERO_VOIE |
TEXT |
✅ |
— |
— |
| 13 |
INDICE_REPETITION |
TEXT |
✅ |
— |
— |
| 14 |
TYPE_VOIE |
TEXT |
✅ |
— |
— |
| 15 |
LIBELLE_VOIE |
TEXT |
✅ |
— |
— |
| 16 |
CODE_POSTAL |
TEXT |
✅ |
— |
— |
| 17 |
COMMUNE |
TEXT |
✅ |
— |
— |
| 18 |
CODE_INSEE_COMMUNE |
TEXT |
✅ |
— |
— |
| 19 |
ADRESSE_VOIE |
TEXT |
✅ |
— |
— |
| 20 |
CODE_NAF |
TEXT |
✅ |
— |
— |
| 21 |
CODE_NAF_BRUT |
TEXT |
✅ |
— |
— |
| 22 |
CODE_NAF_2025 |
TEXT |
✅ |
— |
— |
| 23 |
ENSEIGNE |
TEXT |
✅ |
— |
— |
| 24 |
DENOMINATION_USUELLE |
TEXT |
✅ |
— |
— |
| 25 |
TRANCHE_EFFECTIFS |
TEXT |
✅ |
— |
— |
| 26 |
EST_EMPLOYEUR |
BOOLEAN |
✅ |
— |
— |
| 27 |
EST_ETRANGER |
BOOLEAN |
✅ |
— |
— |
| 28 |
_LOADED_AT |
TIMESTAMP_NTZ |
✅ |
— |
— |
| 29 |
_SOURCE_FILE |
TEXT |
✅ |
— |
— |