Table slot9.WORLD.TSTA.HOME_AGENCY_AUDIT
This table is used to audit the changing of a users home agency within the application
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
AUDIT_ID number 38
USER_SCREEN_AUDIT_LOG.AUDIT_ID Implied Constraint R
WARRANT_REFERENCES_AUDIT.AUDIT_ID Implied Constraint R
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID HAGA_LOGIN_ID_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE HAGA_AGENCY_CD_FK R
OLD_AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE HAGA_OLD_AGENCY_CD_FK R
START_DATE date 7  √  null
END_DATE date 7  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL HAGA_AGENCY_CD_NN
"AUDIT_ID" IS NOT NULL HAGA_AUDIT_ID_NN
"LOGIN_ID" IS NOT NULL HAGA_LOGIN_ID_NN
"OLD_AGENCY_CODE" IS NOT NULL HAGA_OLD_AGENCY_CD_NN

Indexes:
Column(s) Type Sort Constraint Name
AUDIT_ID Primary key Asc HAGA_PK
AGENCY_CODE Performance Asc HAGA_AGENCY_CD_I
LOGIN_ID Performance Asc HAGA_LOGIN_ID_I
OLD_AGENCY_CODE Performance Asc HAGA_OLD_AGENCY_CD_I

Close relationships  within of separation: