ILL_CARE_GER (SQL Table)	Index Back
Injury/Illness Physician Addrs This is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJURY_ILL_ADDR to record details about PHYSICIANS who attended the cases.

ILL_CARE_GER

(SQL Table)

Injury/Illness Physician Addrs

This is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJURY_ILL_ADDR to record details about PHYSICIANS who attended the cases.

Related Language Record: ILL_CARE_LNG

Parent record: ILLNESS_GER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: INJURY_ILL.EMPLID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
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 ILLNESS_NBR_GER Character(8) VARCHAR2(8) NOT NULL Illness Number

5 CARE_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Health Care
A=1st Treatment (Physician)
B=Company Physician
E=Emergency Care
H=Family Physician
K=Hospital
L=Further Treatment (Hospital)
O=Ongoing Health Care
S=Specialist
W=Further Treatment (Physician)

6 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Default Value: ILLNESS_GER.REG_REGION
Prompt Table: REG_HANDS_VW

7 FIRST_VISIT_DT_GER Date(10) DATE First Visit

8 PHYSICIAN_ID Character(11) VARCHAR2(11) NOT NULL Physician ID
Prompt Table: PHYSICIAN_SRCH

9 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name

10 MEDICAL_FAC_CD Character(4) VARCHAR2(4) NOT NULL Medical Facility
Prompt Table: MEDICAL_FAC_TBL

11 HOSPITAL Character(30) VARCHAR2(30) NOT NULL Hospital Name

12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: SCC_CNT_ADFMTVW

13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

14 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

15 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

16 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

17 CITY Character(30) VARCHAR2(30) NOT NULL City

18 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

19 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

20 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

21 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

22 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

23 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

24 COUNTY Character(30) VARCHAR2(30) NOT NULL County

25 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

27 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

28 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

29 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code

30 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: INJURY_ILL.EMPLID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr 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	ILLNESS_NBR_GER	Character(8)	VARCHAR2(8) NOT NULL	Illness Number
5	CARE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Health Care A=1st Treatment (Physician) B=Company Physician E=Emergency Care H=Family Physician K=Hospital L=Further Treatment (Hospital) O=Ongoing Health Care S=Specialist W=Further Treatment (Physician)
6	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: ILLNESS_GER.REG_REGION Prompt Table: REG_HANDS_VW
7	FIRST_VISIT_DT_GER	Date(10)	DATE	First Visit
8	PHYSICIAN_ID	Character(11)	VARCHAR2(11) NOT NULL	Physician ID Prompt Table: PHYSICIAN_SRCH
9	PHYSICIAN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Physician Name
10	MEDICAL_FAC_CD	Character(4)	VARCHAR2(4) NOT NULL	Medical Facility Prompt Table: MEDICAL_FAC_TBL
11	HOSPITAL	Character(30)	VARCHAR2(30) NOT NULL	Hospital Name
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
13	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
14	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
15	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
16	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
17	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
18	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
19	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
20	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
21	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
22	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
23	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
24	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
25	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
26	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
27	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
28	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
29	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
30	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone