ILLNESS_GER_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 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	JOB_DESCR_GER	Character(50)	VARCHAR2(50) NOT NULL	Current Job Description
7	JOB_DESCR_EXT_GER	Character(50)	VARCHAR2(50) NOT NULL	External Person Job Descr
8	CHECKUP_RESULT_GER	Character(150)	VARCHAR2(150) NOT NULL	Medical Checkup Results
9	AUTOPSY_RESULT_GER	Character(50)	VARCHAR2(50) NOT NULL	Autopsy Result
10	PHYSICIAN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Physician Name
11	PAT_RESIDENCE_GER	Character(30)	VARCHAR2(30) NOT NULL	Patient's Residence
12	SYMPTOMS_GER	Character(50)	VARCHAR2(50) NOT NULL	Symptoms
13	WORK_RESP_GER	Character(50)	VARCHAR2(50) NOT NULL	Work Responsible
14	WORK_DANGERS_GER	Character(50)	VARCHAR2(50) NOT NULL	Work Dangers
15	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
16	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
17	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
18	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
19	COMMENTS	Long Character	CLOB	Comment