REFERENTIEL_TIERS

⚠️ 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	CURATED_DBO
Layer	🥇 Curated
Type	VIEW
Rows	—
Columns	46

Columns

#	Column	Type	Nullable	Default	Description
1	SIREN	TEXT	✅	—	—
2	SIRET_SIEGE	TEXT	✅	—	—
3	NIC_SIEGE	TEXT	✅	—	—
4	RAISON_SOCIALE	TEXT	✅	—	—
5	SIGLE	TEXT	✅	—	—
6	NOM_USAGE	TEXT	✅	—	—
7	DENOMINATION_USUELLE_SIEGE	TEXT	✅	—	—
8	ENSEIGNE_SIEGE	TEXT	✅	—	—
9	CODE_CATEGORIE_JURIDIQUE	TEXT	✅	—	—
10	STATUT_ENTREPRISE	TEXT	✅	—	—
11	EST_ACTIVE	BOOLEAN	✅	—	—
12	DATE_CREATION_UL	DATE	✅	—	—
13	DATE_CREATION_SIEGE	DATE	✅	—	—
14	CATEGORIE_ENTREPRISE	TEXT	✅	—	—
15	ANNEE_CATEGORIE_ENTREPRISE	NUMBER	✅	—	—
16	TRANCHE_EFFECTIFS_UL	TEXT	✅	—	—
17	ANNEE_EFFECTIFS_UL	NUMBER	✅	—	—
18	EST_EMPLOYEUR_UL	BOOLEAN	✅	—	—
19	TRANCHE_EFFECTIFS_SIEGE	TEXT	✅	—	—
20	EST_EMPLOYEUR_SIEGE	BOOLEAN	✅	—	—
21	NAF_UL	TEXT	✅	—	—
22	NAF_BRUT_UL	TEXT	✅	—	—
23	NAF_2025_UL	TEXT	✅	—	—
24	NOMENCLATURE_NAF_UL	TEXT	✅	—	—
25	NAF_SIEGE	TEXT	✅	—	—
26	NAF_BRUT_SIEGE	TEXT	✅	—	—
27	NAF_2025_SIEGE	TEXT	✅	—	—
28	ECONOMIE_SOCIALE_SOLIDAIRE	BOOLEAN	✅	—	—
29	COMPLEMENT_ADRESSE	TEXT	✅	—	—
30	NUMERO_VOIE	TEXT	✅	—	—
31	INDICE_REPETITION	TEXT	✅	—	—
32	TYPE_VOIE	TEXT	✅	—	—
33	LIBELLE_VOIE	TEXT	✅	—	—
34	ADRESSE_VOIE	TEXT	✅	—	—
35	CODE_POSTAL	TEXT	✅	—	—
36	LIBELLE_COMMUNE	TEXT	✅	—	—
37	CODE_INSEE_COMMUNE	TEXT	✅	—	—
38	EST_ETRANGER	BOOLEAN	✅	—	—
39	DEADLINE_EFACTURE	DATE	✅	—	—
40	DATE_DERNIERE_MAJ_UL	TIMESTAMP_NTZ	✅	—	—
41	DATE_DERNIERE_MAJ_SIEGE	TIMESTAMP_NTZ	✅	—	—
42	DATA_LOADED_AT	TIMESTAMP_NTZ	✅	—	—
43	SOURCE_FILE_UL	TEXT	✅	—	—
44	SOURCE_FILE_SIEGE	TEXT	✅	—	—
45	DATE_DEBUT_PERIODE_UL	DATE	✅	—	—
46	DATE_DEBUT_PERIODE_SIEGE	DATE	✅	—	—