INJ_ILL_IND_VW

(SQL View)
 Index Back

Injury Illness View for India

INJ_ILL_IND_VW is a view used in Health and Safety to sort INJURY_ILL_IND records by incident number. It is the point of entry for listing employees or non-employees involved in incidents in the workplace. Once a person involved has been entered for an incident, information on their injury or illness can be accessed and updated using their ID.

SELECT INCIDENT_NBR , EMPLID , EMPL_RCD , NON_EMPLOYEE_ID , HS_DISABL_TYPE_IND , HS_INJURY_TYPE_IND , HS_DISABL_CD_IND , SETID , OCC_ILLNESS_CD , DESCR254 , HS_JOB_TYPE_IND , JOB_START_DT_IND , JOB_END_DT_IND , HS_LEAVE_TYPE_IND , LEAVE_FROM_DT_IND , LEAVE_TO_DT_IND , APPROVE_DATE , HS_APPROVALBY_IND , HS_SHIFT_IND , START_TIME , END_TIME , SUPERVISOR_ID , INSPECTOR_NAME , INSPECTOR_JOBTITLE , INSPECTOR_DATE , INSPECTOR_TIME , CORRECTIVE_PREVENT , HS_ACTION_DATE_IND , HS_OFFCR_RESP_IND , REPORTED_TO , DESIGNATE_EMPLID , DEPTID , HS_INSUR_NBR_IND , HS_INSUR_DATE_IND , NEAREST_PRACT_DIST , NEAREST_HOSP_DIST , NEAREST_HOSP_NAME , CORRECTIVE_ACTION , HS_EMPLID_APPR_IND FROM PS_INJURY_ILL_IND A

  • Parent record: INCIDENT_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: PER_ORG_ASGN_VW

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

    Prompt Table: NE_INCIDNT_SRCH

    5 HS_DISABL_TYPE_IND Character(1) VARCHAR2(1) NOT NULL This field defines the type of Disablement,such as Permanent Partial/Total,Occupational Disease/Illness and Others
    1=Permanent Partial Disablement
    2=Permanent Total Disablement
    3=Occupational Disease/Illness
    4=Other
    6 HS_INJURY_TYPE_IND Character(1) VARCHAR2(1) NOT NULL This field defines the Injury type for India
    1=Partial
    2=Total
    7 HS_DISABL_CD_IND Character(3) VARCHAR2(3) NOT NULL This field defines the Disablement Code for India

    Prompt Table: HS_DISABL_IND

    8 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: IND01

    Prompt Table: SETID_TBL

    9 OCC_ILLNESS_CD Character(6) VARCHAR2(6) NOT NULL Occupational Illness

    Prompt Table: OCC_ILLNESS_TBL

    10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    11 HS_JOB_TYPE_IND Character(1) VARCHAR2(1) NOT NULL This field defines the Job Type for India
    1=Alternate Job
    2=Light Work
    12 JOB_START_DT_IND Date(10) DATE This Field Defines the Job Start Date for India
    13 JOB_END_DT_IND Date(10) DATE This field Defines the Job End Date for India
    14 HS_LEAVE_TYPE_IND Character(1) VARCHAR2(1) NOT NULL This field defines the leave type for India.
    1=Accident Leave
    2=Special Leave
    15 LEAVE_FROM_DT_IND Date(10) DATE This Field Defines the Leave From Date for India
    16 LEAVE_TO_DT_IND Date(10) DATE This field Defines the Leave To Date for India
    17 APPROVE_DATE Date(10) DATE This field is used to store the current approval date throughout batch processes.
    18 HS_APPROVALBY_IND Character(1) VARCHAR2(1) NOT NULL This field defines the Approval By
    1=Employee ID
    2=Physician ID

    Default Value: 1

    19 HS_SHIFT_IND Character(1) VARCHAR2(1) NOT NULL This field defines the Shift type for India
    1=General Shift
    2=Shift One
    3=Shift Two
    4=Shift Three
    20 START_TIME Time(15) TIMESTAMP Interview Start Time
    21 END_TIME Time(15) TIMESTAMP Interview End Time
    22 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Prompt Table: PERSON_NAME

    23 INSPECTOR_NAME Character(30) VARCHAR2(30) NOT NULL This Field defines the Inspector Name
    24 INSPECTOR_JOBTITLE Character(30) VARCHAR2(30) NOT NULL This Field Defines the Inspector Title
    25 INSPECTOR_DATE Date(10) DATE This Field Defines the Inspection Date
    26 INSPECTOR_TIME Time(15) TIMESTAMP This Field Defines the Inspection Time
    27 CORRECTIVE_PREVENT Character(1) VARCHAR2(1) NOT NULL Corrective or Preventive Actn
    C=Corrective Action
    P=Preventive Action
    28 HS_ACTION_DATE_IND Date(10) DATE This is a Date of Action field for India
    29 HS_OFFCR_RESP_IND Character(30) VARCHAR2(30) NOT NULL This field defines the Officer Responsible.
    30 REPORTED_TO Character(11) VARCHAR2(11) NOT NULL Reported To EmplID

    Prompt Table: PERSON_NAME

    31 DESIGNATE_EMPLID Character(11) VARCHAR2(11) NOT NULL Employer Designate ID

    Prompt Table: PERSON_NAME

    32 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    33 HS_INSUR_NBR_IND Character(30) VARCHAR2(30) NOT NULL Insurance Number
    34 HS_INSUR_DATE_IND Date(10) DATE This is a Field for Insurance Date india specific
    35 NEAREST_PRACT_DIST Number(8,2) DECIMAL(7,2) NOT NULL Nearest Practitioner Distance
    36 NEAREST_HOSP_DIST Number(8,2) DECIMAL(7,2) NOT NULL Nearest Hospital Distance
    37 NEAREST_HOSP_NAME Character(30) VARCHAR2(30) NOT NULL Nearest Hospital Name
    38 CORRECTIVE_ACTION Long Character CLOB Corrective Action
    39 HS_EMPLID_APPR_IND Character(11) VARCHAR2(11) NOT NULL Field added to store Emplid in Injury Component

    Prompt Table: PERSON_NAME