INJ_CLM_MGM_VWL (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.

INJ_CLM_MGM_VWL

(SQL View)

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 C.CLAIM_NBR , L.LANGUAGE_CD , L.CLAIMS_MANAGER , L.COMMENTS FROM PS_INJURY_CLM_MGMT C , PS_INJ_CLM_MGM_LNG L WHERE C.CLAIM_NBR = L.CLAIM_NBR

Related Language Record for INJURY_CLM_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 CLAIMS_MANAGER Character(40) VARCHAR2(40) NOT NULL Claims Manager

4 COMMENTS Long Character CLOB Comment

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	CLAIMS_MANAGER	Character(40)	VARCHAR2(40) NOT NULL	Claims Manager
4	COMMENTS	Long Character	CLOB	Comment