| # |
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 Record
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 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_HANDS_VW
|
| 6 |
INC_RELATED_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Incident Related
Y/N Table Edit
Default Value: N
|
| 7 |
INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table:
INJ_CLM_INCD_VW
|
| 8 |
JOB_DESCR_GER |
Character(50) |
VARCHAR2(50) NOT NULL |
Current Job Description
|
| 9 |
JOB_DESCR_EXT_GER |
Character(50) |
VARCHAR2(50) NOT NULL |
External Person Job Descr
|
| 10 |
USE_CURRENT_JOB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Current Job Details
Y/N Table Edit
Default Value: N
|
| 11 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 12 |
CASE_OFFICER_GER |
Character(11) |
VARCHAR2(11) NOT NULL |
Case Officer ID
Prompt Table:
LOC_CASEOFF_VW2
|
| 13 |
FATALITY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Fatal Injuries Sustained
Y/N Table Edit
Default Value: N
|
| 14 |
OCC_ILLNESS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Occupational Illness
Prompt Table:
OCC_ILLNESS_TBL
|
| 15 |
ILLNESS_RESULT |
Character(1) |
VARCHAR2(1) NOT NULL |
Illness Resulted In
N=Not Applicable
T=Termination
X=Transfer
|
| 16 |
ILLNESS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Illness Type
1=Occupational Skin Disease
2=Dust Disease of the Lungs
3=Toxic Agent Respiratory Cond.
4=Toxic Poisoning
5=Physical Agents Disorder
6=Repeated Trauma Disorder
7=Other Occupational Illness
8=Not Applicable
|
| 17 |
ILL_START_DT_GER |
Date(10) |
DATE |
Illness Start Date
|
| 18 |
ILL_END_DT_GER |
Date(10) |
DATE |
Illness End Date
|
| 19 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 20 |
END_DT |
Date(10) |
DATE |
end date
|
| 21 |
CHECKUP_RESULT_GER |
Character(150) |
VARCHAR2(150) NOT NULL |
Medical Checkup Results
|
| 22 |
AUTOPSY_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Autopsy
Y/N Table Edit
Default Value: N
|
| 23 |
AUTOPSY_DT_GER |
Date(10) |
DATE |
Autopsy Date
|
| 24 |
AUTOPSY_RESULT_GER |
Character(50) |
VARCHAR2(50) NOT NULL |
Autopsy Result
|
| 25 |
PHYSICIAN_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Physician Name
|
| 26 |
OWNR_PRTNR_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Owner Partner
Y/N Table Edit
Default Value: N
|
| 27 |
PARTNER_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Partner
Y/N Table Edit
Default Value: N
|
| 28 |
RELATION_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Relation
Y/N Table Edit
Default Value: N
|
| 29 |
RELATIONSHIP |
Character(2) |
VARCHAR2(2) NOT NULL |
Relationship to Employee
|
| 30 |
INCOMPETENT_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Incompetent
Y/N Table Edit
Default Value: N
|
| 31 |
PAY_CONT_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Payments Continue
Y/N Table Edit
Default Value: N
|
| 32 |
PAY_UNTIL_DT_GER |
Date(10) |
DATE |
Payments Continue Until
|
| 33 |
WRK_AFTR_ST_SW_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Work After Start
Y/N Table Edit
Default Value: N
|
| 34 |
WRK_STOP_CD_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Work Stop
N=No
S=Immediately
SP=Later
|
| 35 |
WRK_STOP_DT_GER |
Date(10) |
DATE |
Work Stop Date
|
| 36 |
PAT_RESIDENCE_GER |
Character(30) |
VARCHAR2(30) NOT NULL |
Patient's Residence
|
| 37 |
SYMPTOMS_GER |
Character(50) |
VARCHAR2(50) NOT NULL |
Symptoms
|
| 38 |
WORK_RESP_GER |
Character(50) |
VARCHAR2(50) NOT NULL |
Work Responsible
|
| 39 |
WORK_DANGERS_GER |
Character(50) |
VARCHAR2(50) NOT NULL |
Work Dangers
|
| 40 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 41 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 42 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 43 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 44 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 45 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 46 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 47 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 48 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 49 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 50 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 51 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 52 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 53 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 54 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 55 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 56 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 57 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 58 |
RETURN_DT |
Date(10) |
DATE |
Return Date
|