ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
HR.JOB_HISTORY_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(4)
»
public.getoutagetimeinwindow_(function)
»
SH.TIMES_(table)
»
HR.JOB_HISTORY_(table)
[X]
»
public.qrtz_job_details_(table)
»
public.getoutagetimeinwindow_(function)
»
SH.TIMES_(table)
»
HR.JOB_HISTORY_(table)
Edit
wikibot
Table
HR.JOB_HISTORY
Column
Data Type
Nullable
Default
PK
Index
EMPLOYEE_ID
NUMBER(6, 0)
not null
JHIST_EMP_ID_ST_DATE_PK
JHIST_EMPLOYEE_IX
START_DATE
DATE(7)
not null
JHIST_EMP_ID_ST_DATE_PK
END_DATE
DATE(7)
not null
JOB_ID
VARCHAR2(10)
not null
JHIST_JOB_IX
DEPARTMENT_ID
NUMBER(4, 0)
null
JHIST_DEPARTMENT_IX
Relation
Column
Referenced Column
HR.DEPARTMENTS
DEPARTMENT_ID
DEPARTMENT_ID
HR.EMPLOYEES
EMPLOYEE_ID
EMPLOYEE_ID
HR.JOBS
JOB_ID
JOB_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.