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 |
RAW_TEST_DBO |
| Layer |
🟤 Raw |
| Type |
BASE TABLE |
| Rows |
1,079 |
| 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 |
✅ |
— |
— |