H_EMPL_ACCDNT_INFO |
Default Table Name | H_EMPL_ACCDNT_INFO |
Definition |
H_EMPL_ACCDNT_INFO Columns |
ColumnName | Domain | Datatype | NULL | Definition |
INTRNL_CASE_ID![]() |
VARCHAR2(10) | NO | ||
EMPL_ID | VARCHAR2(12) | NO | ||
INJURY_DT | DATE | NO | ||
PARENT_CO_ID | VARCHAR2(10) | YES | ||
PARENT_CO_DESC | VARCHAR2(40) | NO | ||
BUSINESS_DESC | VARCHAR2(254) | NO | ||
CITY_COUNTY_NAME | VARCHAR2(30) | NO | ||
S_CITY_COUNTY_CD | VARCHAR2(1) | NO | ||
INJURY_RPTD_DT | DATE | NO | ||
INJURY_TIME | VARCHAR2(10) | NO | ||
INCAPCTY_DT | DATE | YES | ||
INCAPCTY_TIME | VARCHAR2(10) | NO | ||
PD_INJURY_DAY_FL | VARCHAR2(1) | NO | ||
PD_INCAPCTY_DAY_FL | VARCHAR2(1) | NO | ||
EMPLR_PREMISE_FL | VARCHAR2(1) | NO | ||
ST_PROPERTY_FL | VARCHAR2(1) | NO | ||
RPT_TO_EMPL_ID | VARCHAR2(12) | YES | ||
WITNESS_EMPL_ID | VARCHAR2(12) | YES | ||
FATALITY_DT | DATE | YES | ||
MACHINE_DESC | VARCHAR2(30) | NO | ||
MACHINE_PART_DESC | VARCHAR2(30) | NO | ||
SAFEGRD_PRVIDED_FL | VARCHAR2(1) | NO | ||
SAFEGRD_USED_FL | VARCHAR2(1) | NO | ||
INJURY_CAUSE_DESC | VARCHAR2(254) | NO | ||
INJURY_NATR_DESC | VARCHAR2(254) | NO | ||
PHYS_NAME | VARCHAR2(25) | NO | ||
PHYS_ADR_LN1 | VARCHAR2(30) | NO | ||
PHYS_CITY_NAME | VARCHAR2(25) | NO | ||
PHYS_MAIL_STATE_DC | VARCHAR2(15) | NO | ||
PHYS_POSTAL_CD | VARCHAR2(10) | NO | ||
HOSP_NAME | VARCHAR2(25) | NO | ||
HOSP_ADR_LN1 | VARCHAR2(30) | NO | ||
HOSP_CITY_NAME | VARCHAR2(25) | NO | ||
HOSP_MAIL_STATE_DC | VARCHAR2(15) | NO | ||
HOSP_POSTAL_CD | VARCHAR2(10) | NO | ||
INS_NAME | VARCHAR2(25) | NO | ||
INS_ADR_LN1 | VARCHAR2(30) | NO | ||
INS_CITY_NAME | VARCHAR2(25) | NO | ||
INC_MAIL_STATE_DC | VARCHAR2(15) | NO | ||
INS_POSTAL_CD | VARCHAR2(10) | NO | ||
POLICY_NO_ID | VARCHAR2(20) | YES | ||
POLICY_END_DT | DATE | YES | ||
DISABLE_LNGTH_NO | NUMBER(5, 0) | NO | ||
S_DIS_LNGTH_CD | VARCHAR2(1) | NO | ||
RETURNED_WRK_FL | VARCHAR2(1) | NO | ||
RETURNED_WRK_DT | DATE | YES | ||
RET_WRK_HRLY_AMT | NUMBER(10, 4) | NO | ||
PHONE_ID | VARCHAR2(25) | NO | ||
DEP_CHILD_NO | NUMBER(5, 0) | NO | ||
S_MARITAL_CD | VARCHAR2(1) | NO | ||
FUNC_JOB_CD | VARCHAR2(10) | YES | ||
FUNC_JOB_DESC | VARCHAR2(30) | NO | ||
ORG_ID | VARCHAR2(20) | YES | ||
ORG_DESC | VARCHAR2(30) | NO | ||
CURR_JOB_YR_NO | NUMBER(5, 0) | NO | ||
CURR_JOB_MOS_NO | NUMBER(5, 0) | NO | ||
CURR_EMPLR_YR_NO | NUMBER(5, 0) | NO | ||
CURR_EMPLR_MOS_NO | NUMBER(5, 0) | NO | ||
HRS_WRK_DAY_AMT | NUMBER(14, 2) | NO | ||
DAYS_WRK_WK_AMT | NUMBER(4, 2) | NO | ||
PD_HRLY_FL | VARCHAR2(1) | NO | ||
PD_PIECE_FL | VARCHAR2(1) | NO | ||
WKLY_EARNINGS_AMT | NUMBER(14, 2) | NO | ||
HRLY_AMT | NUMBER(10, 4) | NO | ||
PERQ_MEALS_AMT | NUMBER(14, 2) | NO | ||
PERQ_LODG_AMT | NUMBER(14, 2) | NO | ||
PERQ_TIPS_AMT | NUMBER(14, 2) | NO | ||
PERQ_OTHER_AMT | NUMBER(14, 2) | NO | ||
EMPL_WORK_COMP_CD | VARCHAR2(6) | YES | ||
WORK_COMP_RSN_CD | VARCHAR2(10) | YES | ||
WORK_COMP_CASE_ID | VARCHAR2(10) | YES | ||
ACCDNT_ADR_LN1 | VARCHAR2(40) | NO | ||
TAXBLE_ENTITY_ID | VARCHAR2(10) | YES | ||
EMERG_ROOM_FL | VARCHAR2(1) | NO | ||
HOSP_OVRNT_FL | VARCHAR2(1) | NO | ||
HIRE_DT | DATE | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
H_EMPL_ACCDNT_INFO Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6439 | PrimaryKey | INTRNL_CASE_ID |
H_EMPL_ACCDNT_INFO Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
H_OSHA_300_HDR | Identifying | One To Zero or More | F21590 | NO | NO | NO |