Skip to content

JOS_APPLI_EMPLOYES

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

Info

Property Value
Source ANTISS
Database RESILIANS_ANTISS_DB
Schema STG_DBO
Layer 🪙 Staging
Type BASE TABLE
Rows 1,168
Columns 52

Columns

# Column Type Nullable Default Description
1 CREATED_AT TIMESTAMP_NTZ ✅ — —
2 UPDATED_AT TIMESTAMP_NTZ ✅ — —
3 ID_EMPLOYE NUMBER ✅ — —
4 CODE_AGENCE_ASSISTANTE TEXT ✅ — —
5 DEPARTEMENTS TEXT ✅ — —
6 TOUTES_LES_AGENCES_ASSISTANTE NUMBER ✅ — —
7 CODE_AGENCE_CHARGE_AFFAIRE TEXT ✅ — —
8 CODE_AGENCE_CHARGE_AFFAIRE_INTRANET TEXT ✅ — —
9 SELECTED_CODE_AGENCE TEXT ✅ — —
10 METIER TEXT ✅ — —
11 COMPTE_APIZEE TEXT ✅ — —
12 CODE_SALARIE TEXT ✅ — —
13 ROLE TEXT ✅ — —
14 NOM TEXT ✅ — —
15 PRENOM TEXT ✅ — —
16 EMAIL TEXT ✅ — —
17 ADRESSE TEXT ✅ — —
18 CODE_POSTAL TEXT ✅ — —
19 VILLE TEXT ✅ — —
20 DEPART_DOMICILE TEXT ✅ — —
21 HEURE_DEBUT_MATIN TEXT ✅ — —
22 HEURE_FIN_MATIN TEXT ✅ — —
23 HEURE_DEBUT_APREM TEXT ✅ — —
24 HEURE_FIN_APREM TEXT ✅ — —
25 LAST_SEARCHED_AGENCE TEXT ✅ — —
26 REF_ID_USER_PHOTOTHEQUE NUMBER ✅ — —
27 ADRESSE_DEPART_LUNDI TEXT ✅ — —
28 AUTOUR_DE_LUNDI TEXT ✅ — —
29 TEMPS_TRAJET_LUNDI NUMBER ✅ — —
30 ADRESSE_DEPART_MARDI TEXT ✅ — —
31 AUTOUR_DE_MARDI TEXT ✅ — —
32 TEMPS_TRAJET_MARDI NUMBER ✅ — —
33 ADRESSE_DEPART_MERCREDI TEXT ✅ — —
34 AUTOUR_DE_MERCREDI TEXT ✅ — —
35 TEMPS_TRAJET_MERCREDI NUMBER ✅ — —
36 ADRESSE_DEPART_JEUDI TEXT ✅ — —
37 AUTOUR_DE_JEUDI TEXT ✅ — —
38 TEMPS_TRAJET_JEUDI NUMBER ✅ — —
39 ADRESSE_DEPART_VENDREDI TEXT ✅ — —
40 AUTOUR_DE_VENDREDI TEXT ✅ — —
41 TEMPS_TRAJET_VENDREDI NUMBER ✅ — —
42 CR_LUNDI_MATIN TEXT ✅ — —
43 CR_LUNDI_APREM TEXT ✅ — —
44 CR_MARDI_MATIN TEXT ✅ — —
45 CR_MARDI_APREM TEXT ✅ — —
46 CR_MERCREDI_MATIN TEXT ✅ — —
47 CR_MERCREDI_APREM TEXT ✅ — —
48 CR_JEUDI_MATIN TEXT ✅ — —
49 CR_JEUDI_APREM TEXT ✅ — —
50 CR_VENDREDI_MATIN TEXT ✅ — —
51 CR_VENDREDI_APREM TEXT ✅ — —
52 IS_DELETED NUMBER ✅ — —