Table slot9.WORLD.TSTA.IJIS_USER_PROFILES
This table stores a user's profile and is accessed under user admin and from the user's profile within the application, clicking on the user's name in the upper left of the header page
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
LOGIN_ID varchar2 100
AGENCY_ADMINISTRATORS.LOGIN_ID AGENCY_ADMIN_IUP_FK R
AGENCY_CASE_SUPERVISORS.LOGIN_ID AGCASU_IUP_FK R
ARREST_PROPERTIES.DELETE_USER_ID ARP_IUP_FK R
ASSIGNMENT_ORGS.LOGIN_ID ORGSTRAO_IUP_FK R
ASSOCIATE_DETAILS_VW.LOGIN_ID Implied Constraint R
CRIMINAL_COMPLAINTS.STATE_SUBMITTING_USER CRMCMP_IUP_FK R
DS_ICR_HEADER_FILES.SUBMITTED_BY DSICRHF_IUP_FK R
DV_FUEL_OIL.ASSIGNED_USER_ID DVFUEL_IUP_FK R
DV_OFFICERS.LOGIN_ID DVOFF_IUP_FK R
DV_SERVICE_REQUEST.REQUEST_LOGIN_ID DVREQST_IUP_REQ_FK R
DV_SERVICE_REQUEST.REVIEW_LOGIN_ID DVREQST_IUP_REV_FK R
EJS_FTP.LOGIN_ID Implied Constraint R
EMP_LANGUAGE_VW.LOGIN_ID Implied Constraint R
EMP_SERVICE_HISTORY_VW.LOGIN_ID Implied Constraint R
EMP_VW.LOGIN_ID Implied Constraint R
EMPLOYEE_SALARY_VW.LOGIN_ID Implied Constraint R
EMPLOYEES.LOGIN_ID EMP1_IUP_1_FK R
EXTERNAL_INFO_REQUESTS.LOGIN_ID EXTINFRQ_IUP_FK R
GUEST_LOG_ENTRIES.IUP_LOGIN_ID GLE_IUP_FK R
HOME_AGENCY_AUDIT.LOGIN_ID HAGA_LOGIN_ID_FK R
IJIS_USER_PROFILE_AFFILIATES.LOGIN_ID ORGSTRIUPA_IUP_FK R
IJIS_USER_PROFILE_OAUTH.LOGIN_ID IUPO_IUP_FK R
IJIS_USER_PROFILE_ROLES.LOGIN_ID IUPR_IUP_FK R
IJIS_USER_PROFILE_WORKGROUPS.LOGIN_ID IUP_WRKGRPS_LOGIN_ID_FK R
INC_CASE_ACTIVITY_NOTIFIES.LOGIN_ID ICAN_IUP_FK R
INC_PAGE_VISITS.LOGIN_ID Implied Constraint R
INC_REVIEW_ROUTE_INSTANCES.USER_NAME INCRVWRTINST_IUP_FK R
INC_USER_RESTORE_POINTS.USER_ID IURP_IUP_FK R
INCIDENT_WARNING_NOTIFY_LOG.SENT_TO_LOGIN_ID INCWARNOTLG_IUP_FK R
ITEM_INSTANCES.DISPOSITION_USER ITII_IUP_FK R
ITEM_LOCATION_MANAGERS.LOGIN_ID ITLCM_IUP_FK R
ITEM_LOG_ENTRIES.LOGIN_ID ILE_IUP_FK R
ITEM_LOG_VW.LOGIN_ID Implied Constraint R
JS_USER_ASSIGNMENT_VW.LOGIN_ID Implied Constraint R
JS_USERS_VW.LOGIN_ID Implied Constraint R
MAP_SHAPE_USERS.LOGIN_ID MSUS_IUP_FK R
NOTIFY_DETAIL_DISABLE_ALERTS.LOGIN_ID NDDA_LGIN_ID_FK R
OFFICER_EMPLOYEE_VW.LOGIN_ID Implied Constraint R
PERSONNEL_CERT_SEARCH_VIEW.LOGIN_ID Implied Constraint R
PERSONNEL_COURSE_SEARCH_VIEW.LOGIN_ID Implied Constraint R
PERSONNEL_SEARCH_VIEW.LOGIN_ID Implied Constraint R
PROFILE_SCREEN_ITEMS.LOGIN_ID PROSI_IUP_FK R
QUICK_LINK_USERS.LOGIN_ID QLU_IUP_FK R
RESTRICTION_LISTS.LOGIN_ID ORGSTRRL_IUP_FK R
ROUTE_ACTION_INST_USERS.LOGIN_ID RTEACTINUS_IUP_FK R
ROUTE_ACTION_USERS.LOGIN_ID RTEAU_IUP_FK R
SEARCH_INTERFACE_RESULTS.QUERY_USER SI_RESULT_IUP_FK R
SUBSCRIPTIONS.LOGIN_ID SUBSCRIPTIONS_USER_FK R
TABLE_ADMIN_AUDIT.LOGIN_ID TAA_IUP_FK R
TRACE_ENTRIES.LOGIN_ID Implied Constraint R
USER_AGENCIES.LOGIN_ID UPJ_IUP_1_FK R
USER_AGENCY_ACCESS_VW.LOGIN_ID Implied Constraint R
USER_ASSIGNMENT_AGENCIES.LOGIN_ID UAA_LOGIN_ID_FK R
USER_GROUP_USERS.LOGIN_ID USRGRP_USR_IUP_FK R
USER_GROUPS.LOGIN_ID USRGRP_IUP_FK R
USER_PINNED_RECORDS.LOGIN_ID USRPINREC_IUP_FK C
USER_PROFILES_VW.LOGIN_ID Implied Constraint R
USER_SCREEN_ADMINS.LOGIN_ID USRSCRAD_IUP_FK C
USER_SCREEN_AUDIT_LOG.LOGIN_ID USAL_IUP_FK R
USER_SCREEN_COMMENTS.LOGIN_ID USRSCRN_COM_IUP_FK R
USER_SCREEN_MISC_NOTES.LOGIN_ID USR_SCRNMN_IUP_FK R
USER_SCREEN_USER_PRIVS.LOGIN_ID USRSCRPR_IUP_FK C
USER_SEARCH_INTERFACES.LOGIN_ID USRSRCHINT_IUP_FK R
USER_SEARCH_OPTIONS.LOGIN_ID USO_IUP_FK R
The login ID for a user.
GUEST_LEA varchar2 1 Yes or No Fields
AGNCY_CD_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE IUP_AGNCY_CD_FK R
Agency involved
TIMER_SECONDS number 0  √  null The number of seconds for a notification refresh.
LNAME varchar2 20  √  null The last name of the user.
EXPIRE_DATE date 7  √  null
FNAME varchar2 20  √  null The first name of the user.
TELEPHONE_NUMBER varchar2 10  √  null The phone number of a user.
IUP_EXPIRE_DATE date 7  √  null
TITLE varchar2 20  √  null The job title for a user.
INTERNAL_ID varchar2 100  √  null
EMAIL_ADDR varchar2 100  √  null E*Mail address for of the user.
EMAIL_ENABLED varchar2 1 'Y' Indicates if user wishes to recieve email.
LAST_LOGIN_DATE date 7  √  null
EXTERNAL_ACCESS_YN varchar2 1 'Y' User is allowed Access to the database outside of application Y or N
INDX_SEC_LEVEL_CODE number 0  √  null
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE IUP_MIS_CD_FK R
INCIDENT_INTERVIEW_MODE varchar2 1  √  null
INC_SEC_LEVEL_CODE number 38  √  null
INCIDENT_SECURITY_LEVEL_CODES.INC_SEC_LEVEL_CODE IUP_INC_SEC_LEVEL_FK R
NOTIFICATION_SOUND_YN varchar2 1 'Y'
EMAIL_NOTIFICATIONS_PRIORITY number 1  √  null
NOTIFY_PRIORITY_CODES.PRIORITY_CODE IUP_NPC2_FK R
DSPLY_NOTIFICATIONS varchar2 1  √  'Y'
DSPLY_NOTIFY_ITEMS number 0  √  4
DSPLY_NOTIFY_LAYOUT_CODE varchar2 30  √  null
EJS_CODES.CODE IUP_NOTIFY_LAYOUT_CD_FK R
DSPLY_NOTIFY_LAYOUT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE IUP_NOTIFY_LAYOUT_CD_FK R
DSPLY_LOG varchar2 1  √  'Y'
DSPLY_LOG_ITEMS number 0  √  null
DSPLY_LOG_LAYOUT_CODE varchar2 30  √  null
EJS_CODES.CODE IUP_LOG_LAYOUT_CD_FK R
DSPLY_LOG_LAYOUT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE IUP_LOG_LAYOUT_CD_FK R
DSPLY_MSGS varchar2 1  √  'Y'
MNAME varchar2 20  √  null
REC_ID number 0  √  null
BREADCRUMB_CODE varchar2 30  √  null
EJS_CODES.CODE IUP_BREADCRUMB_FK R
BREADCRUMB_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE IUP_BREADCRUMB_FK R
TIME_CODE varchar2 30  √  null
EJS_CODES.CODE IUP_TIME_CODE_FK R
TIME_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE IUP_TIME_CODE_FK R
EMAIL_NOTIFY_BEGIN varchar2 4  √  null
EMAIL_NOTIFY_END varchar2 4  √  null
SUBSCRIPTION_OVERRIDE varchar2 1  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
TERMINAL_ID varchar2 255  √  null Terminal Id for Mobile XSI Web App.
UNIT_ID varchar2 255  √  null Unit Id for Mobile XSI Web App.
SELF_ASSIGN_ENABLED_FLAG varchar2 1  √  null
EXT_AUTH_ENABLED_FLAG varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
EMAIL_ENABLED IN ('Y','N') CK_IUP_EMAIL_ENABLED
EXTERNAL_ACCESS_YN IN ('Y', 'N') CK_IUP_EXTERNAL_ACCESS_YN
GUEST_LEA IN ('Y', 'N') CK_IUP_GUEST_LEA
SELF_ASSIGN_ENABLED_FLAG IN ( 'Y' , 'N' ) CK_IUP_SLF_ASSIGN_FLAG
SUBSCRIPTION_OVERRIDE IN('Y','N') CK_IUP_SUBSCRIPTION_OVERRIDE
"EMAIL_ENABLED" IS NOT NULL IUP_EMAIL_ENABLED_NN
"EXTERNAL_ACCESS_YN" IS NOT NULL IUP_EXTERNAL_ACCESS_YN_NN
"GUEST_LEA" IS NOT NULL IUP_GUEST_LEA_NN
"LOGIN_ID" IS NOT NULL IUP_LOGIN_ID_NN
"NOTIFICATION_SOUND_YN" IS NOT NULL IUP_NOTIFICATION_SOUND_YN_NN

Indexes:
Column(s) Type Sort Constraint Name
LOGIN_ID Primary key Asc IUP_PK
AGNCY_CD_AGENCY_CODE Performance Asc IUP_AGNCY_CD_FK_I
BREADCRUMB_CODE_TYPE + BREADCRUMB_CODE Performance Asc/Asc IUP_BREADCRUMB_FK_I
INC_SEC_LEVEL_CODE Performance Asc IUP_INC_SEC_LEVEL_FK_I
DSPLY_LOG_LAYOUT_CODE_TYPE + DSPLY_LOG_LAYOUT_CODE Performance Asc/Asc IUP_LOG_LAYOUT_CD_FK_I
INDX_SEC_LEVEL_CODE Performance Asc IUP_MIS_CD_FK_I
DSPLY_NOTIFY_LAYOUT_CODE_TYPE + DSPLY_NOTIFY_LAYOUT_CODE Performance Asc/Asc IUP_NOTIFY_LAYOUT_CD_FK_I
EMAIL_NOTIFICATIONS_PRIORITY Performance Asc IUP_NPC2_FK_I
TIME_CODE_TYPE + TIME_CODE Performance Asc/Asc IUP_TIME_CODE_FK_I
Performance IUP_UPPER_FNCBAS_I
Performance IUP_UPPER_LOGIN_FNCBAS_I
Performance IUP_UPPERTRIM_AGNCY_FNCBAS_I
Performance IUP_UPPERTRIM_USR_FNCBAS_I

Close relationships  within of separation: