Table slot9.WORLD.TSTA.ENROLLMENTS
This table is not currently used
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
ENROLLMENT_ID number 30
WEAPONS_TRAININGS.ENROLLMENT_ID WT_ENR120_FK R
HOURS_COMPLETED varchar2 4  √  null Used to capture the hours or credits completed for a course or degree.
CERTIFICATION_END_DATE date 7  √  null The date that a certification expires.
GRADE varchar2 2  √  null Used to capture the grade of a class or seminar.
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date record created
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
PERSON_ID number 38  √  null
PEOPLE.PERSON_ID ENR120_PER_FK R
Person ID number
TRAIN_ID number 30  √  null
TRAININGS.TRAIN_ID ENR120_TRA_FK R
Sequence used to uniquely identify a training session.
STATUS_CODE varchar2 2
ENROLLMENT_STATUS_CODES.CODE ENR120_ESC120_FK R
The status code for a particular enrollment. (i.e. Scheduled, No show, Cancelled, Appeared.)
EJS_EMP_ID number 30  √  null
EMPLOYEES.EJS_EMP_ID ENR120_EMP1_FK R
EJS sequence to uniquely identify an employee.
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ENR_1_AGNCY_CD_FK R
Agency involved
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL ENR120_AGENCY_CODE_NN
"ENROLLMENT_ID" IS NOT NULL ENR120_ENROLLMENT_ID_NN
"STATUS_CODE" IS NOT NULL ENR120_STATUS_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
ENROLLMENT_ID Primary key Asc ENR120_PK
EJS_EMP_ID Performance Asc ENR120_EMP1_FK_I
STATUS_CODE Performance Asc ENR120_ESC120_FK_I
PERSON_ID Performance Asc ENR120_PER_FK_I
TRAIN_ID Performance Asc ENR120_TRA_FK_I
AGENCY_CODE Performance Asc ENR_1_AGNCY_CD_FK_I

Close relationships  within of separation: