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 |
STG_DBO |
| Layer |
🪙 Staging |
| 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 |
✅ |
— |
— |