INJURY_ILL_ESP

(SQL Table)
 Index Back

Injury Ill Spain

Spanish Sibling or Injury Ill Record

  • Related Language Record: INJ_ILL_ESP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: PER_ORG_ASGN_VW

    3 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

    Prompt Table: NE_INCIDNT_SRCH

    4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    5 DLT_INC_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Incident Type
    P=Industrial Acc. Sick Note
    R=Industrial Acc. No Sick Note
    6 DLT_INCIDENT_NBR Character(12) VARCHAR2(12) NOT NULL Delta File Number

    Default Value: 000000000000

    7 INJURY_DATE Date(10) DATE Injury Date
    8 ABS_END_DT Date(10) DATE Absence End Date
    9 ABS_BEGIN_DT Date(10) DATE Absence Begin Date
    10 DLT_RELAPSE_ESP Character(1) VARCHAR2(1) NOT NULL Relapse
    1=Accident
    2=Relapse

    Default Value: 1

    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    16 CITY Character(30) VARCHAR2(30) NOT NULL City
    17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    24 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    28 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    29 DLT_CNO_ESP Character(4) VARCHAR2(4) NOT NULL Occupational Code

    Prompt Table: DLT_CNO_ESP_VW

    30 DLT_SEN_DAYS_ESP Character(2) VARCHAR2(2) NOT NULL Seniority Days
    31 DLT_SEN_MONTH_ESP Character(3) VARCHAR2(3) NOT NULL Seniority Months
    32 DLT_ETT Character(1) VARCHAR2(1) NOT NULL Temporary Work Company

    Y/N Table Edit

    Default Value: N

    33 DLT_HIR Character(1) VARCHAR2(1) NOT NULL Hiring Flag

    Y/N Table Edit

    Default Value: N

    34 DLT_NBR_OF_EMPL Number(6,0) INTEGER NOT NULL Number of Employees in the company.
    35 DLT_PLACE_CODE_ESP Character(1) VARCHAR2(1) NOT NULL Place Code
    1=Usual Work Center
    2=Taken Journey
    3=In Itinere
    4=Other Work Center

    Default Value: 1

    36 DLT_COMPNY_FLG_ESP Character(1) VARCHAR2(1) NOT NULL In Company Facilities

    Y/N Table Edit

    Default Value: N

    37 DLT_COMP_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Company Type
    E=Temporary Work Company
    H=Hiring
    O=Other
    38 FISCAL_ID_CD2_ESP Character(10) VARCHAR2(10) NOT NULL Fiscal ID ETT
    39 FISCAL_ID_CD3_ESP Character(10) VARCHAR2(10) NOT NULL Fiscal ID Other
    40 FISCAL_ID_CD4_ESP Character(10) VARCHAR2(10) NOT NULL Fiscal ID Hiring
    41 RESPONSIBLE_ROLE Character(30) VARCHAR2(30) NOT NULL Responsible Role
    42 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

    Prompt Table: SOCS_ALL_CCC_VW

    43 INDSTRY_CD_ESP Character(5) VARCHAR2(5) NOT NULL Industry Activity Code

    Prompt Table: INDSTRY_ACT_ESP

    44 DLT_NBR_EMPL2_ESP Number(6,0) INTEGER NOT NULL Number of Employees
    45 RAF_CONFIRMED_ESP Character(1) VARCHAR2(1) NOT NULL Indicates if the RAF has been confirmed (in case of Accident Type = RAF).

    Y/N Table Edit

    46 DLT_RAF_GRD_ESP Character(2) VARCHAR2(2) NOT NULL RAF Injuy Grade
    1=Moderate
    2=High Damage
    3=Very High Damage
    4=Death
    47 DLT_RAF_MODF_ESP Character(1) VARCHAR2(1) NOT NULL Modified

    Y/N Table Edit

    48 DLT_RAF_REASON_ESP Character(2) VARCHAR2(2) NOT NULL Reason Discharge
    00=Recovery
    01=Death
    02=Recovery
    02=Recovery
    03=Medical Inspection
    03=Medical Inspection
    04=Proposed Disability
    05=Dead Line Expired
    05=Dead Line Expired
    06=Improvement
    06=Improvement
    07=Absence
    08=Begin Maternity Leave
    10=INSS Control 12 Months
    10=INSS Control 12 Months
    17=Recovery
    18=Training Courses Absenteeism
    49 DLT_RAF_CONF_ESP Character(1) VARCHAR2(1) NOT NULL Confirmed

    Y/N Table Edit

    50 DLT_RAF_SND_ID_ESP Character(5) VARCHAR2(5) NOT NULL Raf Sending Id
    51 DLT_INJRY_GRD_ESP Character(1) VARCHAR2(1) NOT NULL Injury Grade
    1=Low Damage
    2=High Damage
    3=Very High Damage
    4=Death
    52 DLT_INJURY_ESP Character(3) VARCHAR2(3) NOT NULL Injury

    Prompt Table: DLT_INJ_ESP_VW

    53 DLT_SOURCE_ESP Character(11) VARCHAR2(11) NOT NULL Source of Injury

    Prompt Table: DLT_TOOL_ESP_VW

    54 DLT_PLACE_TYPE_ESP Character(3) VARCHAR2(3) NOT NULL Industrial Accident Place Type

    Prompt Table: DLT_PLC_ESP_VW

    55 DLT_WORK_TYPE_ESP Character(2) VARCHAR2(2) NOT NULL Work Type

    Prompt Table: DLT_WRK_ESP_VW

    56 DLT_BODY_PART_ESP Character(2) VARCHAR2(2) NOT NULL Delta Body Part

    Prompt Table: DLT_DIA_ESP_VW

    57 DLT_USUAL_TOOL_ESP Character(11) VARCHAR2(11) NOT NULL Usual Working Tool

    Prompt Table: DLT_TOOL_ESP_VW

    58 DLT_DEVIATION_ESP Character(2) VARCHAR2(2) NOT NULL Deviation

    Prompt Table: DLT_DEV_ESP_VW

    59 DLT_UNUS_TOOL_ESP Character(11) VARCHAR2(11) NOT NULL Unusual Working Tool

    Prompt Table: DLT_TOOL_ESP_VW

    60 DLT_MULTIPLE_ESP Character(1) VARCHAR2(1) NOT NULL Multiple

    Y/N Table Edit

    Default Value: N

    61 DLT_WITNS_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Witness

    Y/N Table Edit

    Default Value: N

    62 DLT_WITNS_DATA_ESP Character(50) VARCHAR2(50) NOT NULL Witness Data
    63 DIAGNOSIS_CD Character(6) VARCHAR2(6) NOT NULL Diagnosis Code

    Prompt Table: DLT_CIE_ESP_VW

    64 DLT_ASIST_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Assistance Type
    1=Hospital
    2=Ambulatory
    65 CONTRIB_BASE_ESP Number(19,6) DECIMAL(18,6) NOT NULL Common Contingency Base
    66 CONTRIB_DAYS_ESP Number(4,0) SMALLINT NOT NULL Contribution Days
    67 CONTRIB_OVER_ESP Number(19,6) DECIMAL(18,6) NOT NULL Contribution Overtime
    68 AVERAGE_A_ESP Number(9,2) DECIMAL(8,2) NOT NULL Average A
    69 AVERAGE_B_ESP Number(9,2) DECIMAL(8,2) NOT NULL Average B
    70 AVERAGE_ESP Number(9,2) DECIMAL(8,2) NOT NULL Average
    71 AVERAGE_TOTAL_ESP Signed Number(10,2) DECIMAL(8,2) NOT NULL Average Total
    72 AVERAGE_BNFIT_ESP Number(9,2) DECIMAL(8,2) NOT NULL Benefit
    73 SUM_B1_B2_ESP Number(15,2) DECIMAL(14,2) NOT NULL Sum Base1 and Base 2
    74 CONFIRMED Character(1) VARCHAR2(1) NOT NULL Confirmed

    Y/N Table Edit

    Default Value: N

    75 DLT_CAR_INC_ESP Character(1) VARCHAR2(1) NOT NULL Car Incident
    76 DLT_LOCATN_FLG_ESP Character(1) VARCHAR2(1) NOT NULL In Location Facilities

    Y/N Table Edit

    Default Value: N

    77 DLT_MODIFIED_ESP Character(1) VARCHAR2(1) NOT NULL Modified

    Y/N Table Edit

    Default Value: N

    78 DLT_PREVENTIVA_ESP Character(1) VARCHAR2(1) NOT NULL Preventive
    A=Business Owner
    E=External
    I=Internal
    M=Shared
    N=None
    W=Designed Workers
    79 DLT_REGLR_TASK_ESP Character(1) VARCHAR2(1) NOT NULL Regular Task

    Y/N Table Edit

    Default Value: N

    80 DLT_RISK_EVAL_ESP Character(1) VARCHAR2(1) NOT NULL Risk Evaluation

    Y/N Table Edit

    Default Value: N

    81 DLT_SCHD_HOUR_ESP Character(1) VARCHAR2(1) NOT NULL Scheduled Hour
    82 PAT_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL PAT Type
    1=Accident
    2=Recurrence
    83 PRESENTED_DT Date(10) DATE Evidence Presented
    84 REG_BASE_ESP Number(9,2) DECIMAL(8,2) NOT NULL Regulatory Base

    Default Value: 0

    85 REPORT_EMPLID Character(11) VARCHAR2(11) NOT NULL Person Reporting

    Prompt Table: PERSON_NAME

    86 STATE2 Character(6) VARCHAR2(6) NOT NULL State
    87 DLT_SND_ID_ESP Character(5) VARCHAR2(5) NOT NULL Sending Id
    88 DLT_TASK_ESP Character(2) VARCHAR2(2) NOT NULL Task

    Prompt Table: DLT_TSK_ESP_VW

    89 DLT_EMPL_COMP Character(1) VARCHAR2(1) NOT NULL Center belongs to EE Company

    Y/N Table Edit

    Default Value: Y

    90 DLT_OTHR_COMP Character(1) VARCHAR2(1) NOT NULL External Company

    Y/N Table Edit

    Default Value: N

    91 DLT_CMP_NAME_ESP Character(30) VARCHAR2(30) NOT NULL Company Name for Delta where company where the accident occurr is diferent
    92 DLT_EMPL_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Multiple Employees

    Y/N Table Edit

    Default Value: N

    93 DLT_CONTACT_ESP Character(2) VARCHAR2(2) NOT NULL Contact Mode

    Prompt Table: DLT_CNT_ESP_VW

    94 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: JOB.COMPANY

    95 INSUR_COMP_CD_ESP Character(5) VARCHAR2(5) NOT NULL Insurance Company Code
    96 DLT_COMP_NM_ESP Character(30) VARCHAR2(30) NOT NULL Company Name Delta File
    97 DLT_ADDRESS1_ESP Character(60) VARCHAR2(60) NOT NULL Address Company
    98 DLT_STATE_ESP Character(2) VARCHAR2(2) NOT NULL State Company
    99 DLT_CITY_ESP Character(5) VARCHAR2(5) NOT NULL City Company
    100 DLT_POSTAL_ESP Character(5) VARCHAR2(5) NOT NULL Postal Company
    101 DLT_PHONE_ESP Character(14) VARCHAR2(14) NOT NULL Phone Company
    102 DLT_STAFF_ESP Character(5) VARCHAR2(5) NOT NULL Staff
    103 DLT_SSN_EMPLER_ESP Character(11) VARCHAR2(11) NOT NULL SSN Employer
    104 DLT_INDUSTRYCD_ESP Character(5) VARCHAR2(5) NOT NULL Industry

    Prompt Table: INDSTRY_ACT_ESP

    105 DLT_WORKHOUR_ESP Character(2) VARCHAR2(2) NOT NULL Weeking Hour
    0=In Itinere
    1=Hour 1
    10=Hour 10
    11=Hour 11
    12=Hour 12
    2=Hour 2
    3=Hour 3
    4=Hour 4
    5=Hour 5
    6=Hour 6
    7=Hour 7
    8=Hour 8
    9=Hour 9
    99=In Itinere
    106 DLT_INCHOUR_ESP Character(2) VARCHAR2(2) NOT NULL Incident Time Delta
    107 DLT_INCWORK_ESP Character(1) VARCHAR2(1) NOT NULL Usual Work

    Y/N Table Edit

    Default Value: N

    108 DLT_CAUSE_ESP Character(200) VARCHAR2(200) NOT NULL Cause
    109 DAY_OF_WK Character(1) VARCHAR2(1) NOT NULL Day of the Week
    1=Sunday
    2=Monday
    3=Tuesday
    4=Wednesday
    5=Thursday
    6=Friday
    7=Saturday
    110 DLT_ITINERE_ESP Character(2) VARCHAR2(2) NOT NULL Place Code
    0=To Work
    99=Back from Work
    111 DLT_OTH_ADDR_ESP Character(40) VARCHAR2(40) NOT NULL Place Code
    112 DLT_VIAKM_ESP Character(40) VARCHAR2(40) NOT NULL Place Code
    113 DLT_HOSPITALZD_ESP Character(1) VARCHAR2(1) NOT NULL Place Code

    Y/N Table Edit

    Default Value: N

    114 DLT_CNTR_BASE_ESP Number(9,2) DECIMAL(8,2) NOT NULL Common Contingency Base
    115 DLT_CNTR_OVER_ESP Number(9,2) DECIMAL(8,2) NOT NULL Contribution Overtime
    116 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    117 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    118 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    119 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    120 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    121 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    122 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    123 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    124 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    125 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    126 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    127 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    128 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    129 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    130 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    131 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    132 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    133 DLT_REPORT_STATUS Character(1) VARCHAR2(1) NOT NULL Delta Reporting Status
    0=Not Communicated
    1=XML Generated

    Default Value: 0

    134 DLT_RAF_STATUS Character(1) VARCHAR2(1) NOT NULL Delta RAF Status.
    0=Not Reported
    1=XML Generated

    Default Value: 0