Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

IM_EMPLOYEE_INFO

Columns

NameTypeNullableDefault valueComment
USER_IDNUMBER(38)N  
JOB_TITLEVARCHAR2(200.0)Y  
JOB_DESCRIPTIONVARCHAR2(4000.0)Y  
TEAM_LEADER_PCHAR(1.0)Y  
PROJECT_LEAD_PCHAR(1.0)Y  
PERCENTAGENUMBER(38)Y  
SUPERVISOR_IDNUMBER(38)Y  
GROUP_MANAGESVARCHAR2(100.0)Y  
CURRENT_INFORMATIONVARCHAR2(4000.0)Y  
LAST_MODIFIEDDATENsysdate  
SS_NUMBERVARCHAR2(20.0)Y  
SALARYNUMBER(9.0,2.0)Y  
SALARY_PERIODVARCHAR2(12.0)Y'month'  
DEPENDANT_PCHAR(1.0)Y  
ONLY_JOB_PCHAR(1.0)Y  
MARRIED_PCHAR(1.0)Y  
DEPENDANTSNUMBER(38)Y0 
HEAD_OF_HOUSEHOLD_PCHAR(1.0)Y  
BIRTHDATEDATEY  
SKILLSVARCHAR2(2000.0)Y  
FIRST_EXPERIENCEDATEY  
YEARS_EXPERIENCENUMBER(5.0,2.0)Y  
EDUCATIONAL_HISTORYVARCHAR2(4000.0)Y  
LAST_DEGREE_COMPLETEDVARCHAR2(100.0)Y  
RESUMECLOBY  
RESUME_HTML_PCHAR(1.0)Y  
START_DATEDATEY  
TERMINATION_DATEDATEY  
RECEIVED_OFFER_LETTER_PCHAR(1.0)Y  
RETURNED_OFFER_LETTER_PCHAR(1.0)Y  
SIGNED_CONFIDENTIALITY_PCHAR(1.0)Y  
MOST_RECENT_REVIEWDATEY  
MOST_RECENT_REVIEW_IN_FOLDER_PCHAR(1.0)Y  
FEATURED_EMPLOYEE_APPROVED_PCHAR(1.0)Y  
FEATURED_EMPLOYEE_APPROVED_BYNUMBER(38)Y  
FEATURED_EMPLOYEE_BLURBCLOBY  
FEATURED_EMPLOYEE_BLURB_HTML_PCHAR(1.0)Y'f'  
REFERRED_BYNUMBER(38)Y  
REFERRED_BY_RECORDING_USERNUMBER(38)Y  
EXPERIENCE_IDNUMBER(38)Y  
SOURCE_IDNUMBER(38)Y  
ORIGINAL_JOB_IDNUMBER(38)Y  
CURRENT_JOB_IDNUMBER(38)Y  
QUALIFICATION_IDNUMBER(38)Y  
DEPARTMENT_IDNUMBER(38)Y  
TERMINATION_REASONVARCHAR2(4000.0)Y  
VOLUNTARY_TERMINATION_PCHAR(1.0)Y'f'  
RECRUITING_BLURBCLOBY  
RECRUITING_BLURB_HTML_PCHAR(1.0)Y'f'  

Primary key:

Constraint NameColumns
SYS_C002088395USER_ID

Check Constraints:

Constraint NameCheck Condition
FEATURED_EMPLOYEE_P_CONfeatured_employee_approved_p in ('t','f')
FEATURED_EMP_BLURB_HTML_P_CONfeatured_employee_blurb_html_p in ('t','f')
IEI_USER_SUPERVISE_SELF_CKsupervisor_id is null or user_id <> supervisor_id
IEI_VOLUNTARY_TERMINATION_P_CKvoluntary_termination_p in ('t','f')
IM_EMPLOYEE_CONF_P_CONsigned_confidentiality_p in ('t','f')
IM_EMPLOYEE_DEPENDANT_P_CONdependant_p in ('t','f')
IM_EMPLOYEE_HEAD_OF_HOUSE_CONhead_of_household_p in ('t','f')
IM_EMPLOYEE_MARRIED_P_CONmarried_p in ('t','f')
IM_EMPLOYEE_ONLY_JOB_P_CONonly_job_p in ('t','f')
IM_EMPLOYEE_PROJECT_LEAD_CONproject_lead_p in ('t','f')
IM_EMPLOYEE_RECENT_REVIEW_CONmost_recent_review_in_folder_p in ('t','f')
IM_EMPLOYEE_RECV_OFFER_CONreceived_offer_letter_p in ('t','f')
IM_EMPLOYEE_RESUME_HTML_P_CONresume_html_p in ('t','f')
IM_EMPLOYEE_RETURN_OFFER_CONreturned_offer_letter_p in ('t','f')
IM_EMPLOYEE_SALARY_PERIOD_CONsalary_period in ('hour','day','week','month','year')
IM_EMPLOYEE_TEAM_LEAD_CONteam_leader_p in ('t','f')
RECRUITING_BLURB_HTML_P_CONrecruiting_blurb_html_p in ('t','f')
SYS_C002088377"LAST_MODIFIED" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088396USER_ID USERS SYS_C002087135 NO ACTION
SYS_C002088397SUPERVISOR_ID USERS SYS_C002087135 NO ACTION
SYS_C002088398FEATURED_EMPLOYEE_APPROVED_BY USERS SYS_C002087135 NO ACTION
SYS_C002088399REFERRED_BY USERS SYS_C002087135 NO ACTION
SYS_C002088400REFERRED_BY_RECORDING_USER USERS SYS_C002087135 NO ACTION
SYS_C002088401EXPERIENCE_ID CATEGORIES SYS_C002087169 NO ACTION
SYS_C002088402SOURCE_ID CATEGORIES SYS_C002087169 NO ACTION
SYS_C002088403ORIGINAL_JOB_ID CATEGORIES SYS_C002087169 NO ACTION
SYS_C002088404CURRENT_JOB_ID CATEGORIES SYS_C002087169 NO ACTION
SYS_C002088405QUALIFICATION_ID CATEGORIES SYS_C002087169 NO ACTION
SYS_C002088406DEPARTMENT_ID CATEGORIES SYS_C002087169 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
IM_EMPLOYEE_INFO_IDX1NORMALNONUNIQUEUSER_ID , SUPERVISOR_ID
IM_EMPLOYEE_INFO_IDX2NORMALNONUNIQUESUPERVISOR_ID , USER_ID
IM_EMPLOYEE_INFO_REFERRED_IDXNORMALNONUNIQUEREFERRED_BY
SYS_C002088395NORMALUNIQUEUSER_ID
SYS_IL0001977091C00025$$LOBUNIQUE 
SYS_IL0001977091C00036$$LOBUNIQUE 
SYS_IL0001977091C00048$$LOBUNIQUE 

Referenced by:

TableConstraint
IM_STATUS_REPORT_PREFERENCES ISRP_USER_ID_FK

Triggers

Name: IM_EMPLOYEE_INFO_LAST_MODIF_TR
CREATE TRIGGER im_employee_info_last_modif_tr
before update on im_employee_info
for each row
REFERENCING NEW AS NEW OLD AS OLD
DECLARE
BEGIN
     :new.last_modified := sysdate;
END;



Generated by OraSchemaDoc, (c) Aram Kananov, 2002