SchemaSpy - Table slot9.WORLD.TSTA.EMP_RANK_TITLE

This table defines the valid ranks that can be added to 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

CODE

varchar2

CERTIFICATION_RANK.EMP_RANK_TITLE_CODE	CERTRNK_RANK_EJSCD_FK R
EMP_SERVICE_ASSIGN_CODES.CODE	Implied Constraint R
EMP_SERVICE_HISTORIES.RANK_TITLE_CODE	EMPSRVHST_EMPRTC_FK R

Rank/Title code.

RANK_TITLE_DESC

varchar2

√

null

Rank/Title description.

ACTIVE_YN

varchar2

√

null

Yes or No Fields

EMP_TYPE_CODE

varchar2

√

null

EJS_CODES.CODE

EMPRTC_EMP_TYPE_CO_EJS_CODE_FK R

EMP_TYPE_CODE_TYPE

varchar2

√

null

EJS_CODES.CODE_TYPE

EMPRTC_EMP_TYPE_CO_EJS_CODE_FK R

REC_ID

number

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
ACTIVE_YN IN ('Y', 'N')	CK_EMPRTC_ACTIVE_YN
"CODE" IS NOT NULL	EMPRTC_CODE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
CODE	Primary key	Asc	EMPRTC_PK
EMP_TYPE_CODE_TYPE + EMP_TYPE_CODE	Performance	Asc/Asc	EMPRTC_EMP_TYPE_CO_EJS_CODE_I
EMP_TYPE_CODE	Performance	Asc	EMPRTC_ETC_FK_I