SchemaSpy - Table slot9.WORLD.TSTA.EMP_SERVICE_ASSIGN

This table defines the valid service assign codes 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

EMP_SERVICE_HISTORIES.SRV_ASSIGN_CODE	EMPSRVHST_EMPSRVASC_FK R
INC_CASE_ROUTING.WORKGROUP_CODE	ICR_EMPSRVASC_FK R
INCIDENT_CASES.UNIT_CODE	IC_EMPSRVASC_FK R
NOTIFICATION_DETAILS.UNIT_CODE	NDTL_EMPSRVASC_FK R

EMP_RANK_TITLE_CODES.CODE

Implied Constraint R

Service Assign code.

SRV_ASSIGN_DESC

varchar2

√

null

Service Assign description.

CNT_AS_SERVICE_TIME_YN

varchar2

'N'

Yes or No Fields

ACTIVE_YN

varchar2

'N'

Yes or No Fields

EMP_TYPE_CODE

varchar2

√

null

EJS_CODES.CODE

EMPSRVASC_EMP_TYPE_EJS_CODE_FK R

WORKGROUP

varchar2

√

'N'

EMP_TYPE_CODE_TYPE

varchar2

√

null

EJS_CODES.CODE_TYPE

EMPSRVASC_EMP_TYPE_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_EMPSRVASC_ACTIVE_YN
CNT_AS_SERVICE_TIME_YN IN ('Y', 'N')	CK_EMPSRVASC_CNT_AS_SERVICE_TI
"ACTIVE_YN" IS NOT NULL	EMPSRVASC_ACTIVE_YN_NN
"CNT_AS_SERVICE_TIME_YN" IS NOT NULL	EMPSRVASC_CNT_AS_SERVICE_TI_NN
"CODE" IS NOT NULL	EMPSRVASC_CODE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
CODE	Primary key	Asc	EMPSRVASC_PK
EMP_TYPE_CODE_TYPE + EMP_TYPE_CODE	Performance	Asc/Asc	EMPSRVASC_EMP_TYPE_EJS_CODE_I
EMP_TYPE_CODE	Performance	Asc	EMPSRVASC_ETC_FK_I