View slot9.WORLD.TSTA.EMPLOYEE_SALARY_VW
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
EMPLOYEE_ID varchar2 20  √  null
EJS_EMP_ID number 30
EMPLOYEES.EJS_EMP_ID Implied Constraint R
SSN raw 32  √  null
DOB raw 32  √  null
PLACE_OF_BIRTH raw 512  √  null
EMERGENCY_CONTACT varchar2 255  √  null
EMERGENCY_PHONE varchar2 14  √  null
RANK varchar2 255  √  null
LOGIN_ID varchar2 100  √  null
IJIS_USER_PROFILES.LOGIN_ID Implied Constraint R
OFFICER_ID number 38  √  null
ATT_ID number 6  √  null
BLOOD_CODE varchar2 30  √  null
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE Implied Constraint R
LNAME raw 64  √  null
FNAME raw 64  √  null
EMP_TYPE_CODE varchar2 30  √  null
DL_NUMBER varchar2 30  √  null
MIDDLE_NAME raw 64  √  null
LONGEVITY_DATE date 7  √  null
DL_STATE_CODE varchar2 30  √  null
SEX_CODE varchar2 30  √  null
TITLE_CODE varchar2 30  √  null
ETHNICITY_CODE varchar2 30  √  null
RACE_CODE varchar2 30  √  null
NUM_ASSIGNED number 6  √  null
NUM_CLOSED number 6  √  null
NUM_PENDING number 6  √  null
LAST_ASSIGNED_DATE date 7  √  null
ACTIVE varchar2 1
SALARY_ID number 38
SALARY.SALARY_ID Implied Constraint R
SALARY number 0  √  null
ANNUAL number 0  √  null
SALARY_START date 7  √  null
SALARY_END date 7  √  null
HR_MO_FLAG varchar2 1  √  null
VACATION number 0  √  null
SICK number 0  √  null
SUPERVISOR_ID number 38  √  null
DUTY_STATION varchar2 255  √  null
OVERTIME_BONUS_FLAG varchar2 1  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT e.EMPLOYEE_ID , e.EJS_EMP_ID , e.ENC_SSN , e.ENC_DOB , e.ENC_PLACE_OF_BIRTH , e.EMERGENCY_CONTACT , e.EMERGENCY_PHONE , e.RANK , e.LOGIN_ID , e.OFFICER_ID , e.ATT_ID , e.BLOOD_CODE , e.AGENCY_CODE , e.ENC_LNAME , e.ENC_FNAME , e.EMP_TYPE_CODE , e.DL_NUMBER , e.ENC_MNAME , e.LONGEVITY_DATE , e.DL_STATE_CODE , e.SEX_CODE , e.TITLE_CODE , e.ETHNICITY_CODE , e.RACE_CODE , e.NUM_ASSIGNED , e.NUM_CLOSED , e.NUM_PENDING , e.LAST_ASSIGNED_DATE , e.ACTIVE , s.SALARY_ID , s.SALARY , DECODE(s.HR_MO_FLAG,'M',s.SALARY*12,'H',s.SALARY*2000) , s.SALARY_START , s.SALARY_END , s.HR_MO_FLAG , s.VACATION , s.SICK , s.SUPERVISOR_ID , s.DUTY_STATION , s.OVERTIME_BONUS_FLAG FROM salary s , employees e WHERE s.employee_id=e.ejs_emp_id AND (SYSDATE>NVL(s.salary_start,SYSDATE-1) AND SYSDATE < NVL(s.salary_end,SYSDATE+1))
 
Possibly Referenced Tables/Views:
EMPLOYEES SALARY 


Close relationships: