Skip to content

USERS

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

Info

Property Value
Source CEGID
Database RESILIANS_CEGID_DB
Schema RAW_DBO
Layer 🟤 Raw
Type BASE TABLE
Rows 91
Columns 54

Columns

# Column Type Nullable Default Description
1 USERNAME TEXT
2 _FIVETRAN_SYNCED TIMESTAMP_TZ
3 ALLOW_PASSWORD_RECOVERY BOOLEAN
4 _FIVETRAN_DELETED BOOLEAN
5 SOURCE NUMBER
6 LAST_PASSWORD_CHANGED_DATE TIMESTAMP_TZ
7 ALLOWED_SESSIONS NUMBER
8 FAILED_PASSWORD_ATTEMPT_WINDOW_START TIMESTAMP_TZ
9 FAILED_PASSWORD_ATTEMPT_COUNT NUMBER
10 PASSWORD TEXT
11 OLD_PASSWORD TEXT
12 APPLICATION_NAME TEXT
13 STATE TEXT
14 FAILED_PASSWORD_ANSWER_ATTEMPT_COUNT NUMBER
15 FORBID_LOGIN_WITH_PASSWORD BOOLEAN
16 IS_LOCKED_OUT BOOLEAN
17 LAST_ACTIVITY_DATE TIMESTAMP_TZ
18 CREATION_DATE TIMESTAMP_TZ
19 PASSWORD_QUESTION TEXT
20 DISPLAY_NAME TEXT
21 LAST_LOGIN_DATE TIMESTAMP_TZ
22 FULL_NAME TEXT
23 DELETED_DATABASE_RECORD BOOLEAN
24 PASSWORD_NEVER_EXPIRES BOOLEAN
25 OVERRIDE_ADROLES BOOLEAN
26 GUEST BOOLEAN
27 LOCKED_OUT_DATE TIMESTAMP_TZ
28 OVERRIDE_LOCAL_ROLES_WITH_OIDC_PROVIDER_ROLES BOOLEAN
29 IS_ADUSER BOOLEAN
30 IS_HIDDEN BOOLEAN
31 LAST_LOCKED_OUT_DATE TIMESTAMP_TZ
32 CONFIRM_PASSWORD TEXT
33 MULTI_FACTOR_TYPE NUMBER
34 PSEUDONYMIZATION_STATUS NUMBER
35 IS_PENDING_ACTIVATION BOOLEAN
36 IS_ON_LINE BOOLEAN
37 INCLUDED BOOLEAN
38 FIRST_NAME TEXT
39 EMAIL TEXT
40 NOTE_ID TEXT
41 PKID TEXT
42 PASSWORD_ANSWER TEXT
43 LOGIN_TYPE_ID NUMBER
44 IS_ASSIGNED BOOLEAN
45 LAST_NAME TEXT
46 CHK_SERVICE_MANAGEMENT BOOLEAN
47 PASSWORD_CHANGE_ON_NEXT_LOGIN BOOLEAN
48 MULTI_FACTOR_OVERRIDE BOOLEAN
49 FAILED_PASSWORD_ANSWER_ATTEMPT_WINDOW_START TIMESTAMP_TZ
50 PASSWORD_CHANGEABLE BOOLEAN
51 NEW_PASSWORD TEXT
52 IS_APPROVED BOOLEAN
53 COMMENT TEXT
54 GENERATE_PASSWORD BOOLEAN