Table slot9.WORLD.TSTA.EMPLOYMENTS
This table stores the association between MASTER PEOPLE and MASTER BUSINESSES along with occupation information when the MASTER PERSON is added to the business as an employee
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
EMPLOYMENT_NO number 8
BUSINESS_RMS_SEARCH_VW.EMPLOYMENT_NO Implied Constraint R
PER_PERSON_ID number 0
PEOPLE.PERSON_ID EMP_PER_FK C
Person ID number
BUSNS_BUSINESS_NUMBER number 0
BUSINESSES.BUSINESS_NUMBER EMP_BUSNS_FK R
Unique id for business
EMP_TYPE_EMPLOYMENT_CODE varchar2 3  √  null Code for the employment type
EMPLOYMENT_LENGTH varchar2 10  √  null Length of employment at job
START_DATE date 7  √  null Start date for employment
HOURS_PER_WEEK varchar2 4  √  null Hours worked
INCOME varchar2 11  √  null Income from employment
REASON_FOR_LEAVING varchar2 30  √  null Reason employee left
OCUPATION varchar2 240  √  null Occupation of offender
DATE_OF_INFO date 7  √  null Date employment information received.
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
EMPLOYER_NAME varchar2 25  √  null
EMPLOYMENT_CODE varchar2 30  √  null
EJS_CODES.CODE EMP_EMPLOYMENT_COD_EJS_CODE_FK R
EMPLOYMENT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMP_EMPLOYMENT_COD_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"BUSNS_BUSINESS_NUMBER" IS NOT NULL EMP_BUSNS_BUSINESS_NUMBER_NN
"EMPLOYMENT_NO" IS NOT NULL EMP_EMPLOYMENT_NO_NN
"PER_PERSON_ID" IS NOT NULL EMP_PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EMPLOYMENT_NO Primary key Asc EMP_PK
BUSNS_BUSINESS_NUMBER Performance Asc EMP_BUSNS_FK_I
EMPLOYMENT_CODE Performance Asc EMP_EMP_TYPE_FK_I
EMPLOYMENT_CODE_TYPE + EMPLOYMENT_CODE Performance Asc/Asc EMP_EMPLOYMENT_COD_EJS_CODE_I
PER_PERSON_ID Performance Asc EMP_PER_FK_I

Close relationships  within of separation: