Table slot9.WORLD.TSTA.ASSIGNMENT_ORGS
This table stores the organization information for an assignment in the OFFICER DAILY LOG in 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
ASSIGNMENT_ORG_ID number 38
JS_USER_ASSIGNMENT_VW.ASSIGNMENT_ORG_ID Implied Constraint R
RESTRICTION_LISTS.ASSIGNMENT_ORG_ID ORGSTRRL_ORGSTRAO_FK R
Unique identifier to identify the specific ASSIGNEMENT_ORG row, PK
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID ORGSTRAO_IUP_FK R
Foreign key to the IJIS_USER_PROFILES table, points to the user for whom the assignment was made.
START_DATE date 7 DateTime field contains the date that the assignment starts
END_DATE date 7  √  null DateTime field contains the date that the assignment ends, need to automatically de-activate and flag the assignment as removed when this date is reached.
IS_USER_ASSIGNED varchar2 1 Y value indicates that the user made this assignment via his/her user profile, N value indicates that the assignment was made by someone else for the user.
IS_RESTRICTED_ORG varchar2 1 Y value indicates that the org object referenced in the assignment is restricted, signals a check against the restriction list, N value indicates no restriction flag for the org object.
IS_ACTIVE varchar2 1 Y value indicates that the Assignment is active (i.e. falls between start and end dates), N value indicates that the assignment is not active, may not yet have started, may have ended.
IS_REMOVED varchar2 1 Y value indicates that the Assignment has been removed and should not be used, N value indicates that the assignment has not been removed and the IS_ACTIVE flag should be checked to determine whether or not the assignment can be used.
POD_ID number 38  √  null
PSEUDO_ORG_DESCRIPTORS.POD_ID ORGSTRAO_ORGSTRPOD_FK R
Foreign key to the PSEUDO_ORG_DESCRIPTOR table, points to the assignment subject organizational element.
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ORGSTRAO_AGNCY_CD_FK R
Foreign key to the AGENCY_CODES table, maintained to identify which organizations are involved in assignments, from the agency view
CREATOR_ID varchar2 100  √  null USER ID for the initial record creation.
CREATOR_DATE date 7  √  null Date record was created.
UPDATOR_ID varchar2 100  √  null USER ID for the last record update.
UPDATOR_DATE date 7  √  null Date record was last updated.
OLD_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ORGSTRAO_OLD_AGNCY_CD_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ASSIGNMENT_ORG_ID" IS NOT NULL ORGSTRAO_ASSIGN_ORG_ID_NN
"IS_ACTIVE" IS NOT NULL ORGSTRAO_IS_ACTIVE_NN
"IS_USER_ASSIGNED" IS NOT NULL ORGSTRAO_IS_ASSIGNED_NN
"IS_REMOVED" IS NOT NULL ORGSTRAO_IS_REMOVED_NN
"IS_RESTRICTED_ORG" IS NOT NULL ORGSTRAO_IS_RESTRICTED_NN
"LOGIN_ID" IS NOT NULL ORGSTRAO_LOGIN_ID_NN
"START_DATE" IS NOT NULL ORGSTRAO_START_DATE_NN

Indexes:
Column(s) Type Sort Constraint Name
ASSIGNMENT_ORG_ID Primary key Asc ORGSTRAO_PK
AGENCY_CODE Performance Asc ORGSTRAO_AGNCY_CD_FK_I
LOGIN_ID Performance Asc ORGSTRAO_IUP_FK_I
OLD_AGENCY_CODE Performance Asc ORGSTRAO_OLD_AGNCY_CD_FK_I
POD_ID Performance Asc ORGSTRAO_ORGSTRPOD_FK_I

Close relationships  within of separation: