INJURY_CLM_VW

(SQL View)
 Index Back

Injury/Illness Claims Managmnt

This is one of several records used in the Health and Safety module to record details about claims filed by employees or non-employees relating to a health/safety-related incident in the workplace. Use INJURY_CLM_MGMT, INJURY_CLM_CHRG, and INJURY_CLM_COST to record the details of the claim. INJURY_CLM_MGMT is the parent record. It contains claim information other than costs.

SELECT CLAIM_NBR , INCIDENT_NBR , EMPLID , EMPL_RCD , NON_EMPLOYEE_ID , CLAIM_STATUS ,PROVIDER_CLAIM_NBR ,PROVIDER_DESCR , CLAIMS_MANAGER , COMMENTS FROM PS_INJURY_CLM_MGMT

  • Related Language Record: INJ_CLM_MGM_VWL

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

    Default Value: 0

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

    Prompt Table: INJ_CLM_INCD_V3

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

    Prompt Table: PERSON_NAME

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

    Prompt Table: PER_ORG_ASGN_VW

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

    Prompt Table: NE_INCIDNT_SRCH

    6 CLAIM_STATUS Character(1) VARCHAR2(1) NOT NULL Claim Status
    A=Approved
    D=Denied
    P=Pending
    W=Withdrawn

    Default Value: P

    7 PROVIDER_CLAIM_NBR Character(10) VARCHAR2(10) NOT NULL Provider Claim Nbr
    8 PROVIDER_DESCR Character(30) VARCHAR2(30) NOT NULL Provider Description
    9 CLAIMS_MANAGER Character(40) VARCHAR2(40) NOT NULL Claims Manager
    10 COMMENTS Long Character CLOB Comment