| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 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 |
INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table:
INCIDENT_DATA
|
| 5 |
HS_DISABL_TYPE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines the type of Disablement,such as Permanent Partial/Total,Occupational Disease/Illness and Others
1=Permanent Partial Disablement
2=Permanent Total Disablement
3=Occupational Disease/Illness
4=Other
|
| 6 |
HS_INJURY_TYPE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines the Injury type for India
1=Partial
2=Total
|
| 7 |
HS_DISABL_CD_IND |
Character(3) |
VARCHAR2(3) NOT NULL |
This field defines the Disablement Code for India
Prompt Table:
HS_DISABL_IND
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: IND
Prompt Table:
SETID_TBL
|
| 9 |
OCC_ILLNESS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Occupational Illness
Prompt Table:
OCC_ILLNESS_TBL
|
| 10 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 11 |
HS_JOB_TYPE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines the Job Type for India
1=Alternate Job
2=Light Work
|
| 12 |
JOB_START_DT_IND |
Date(10) |
DATE |
This Field Defines the Job Start Date for India
|
| 13 |
JOB_END_DT_IND |
Date(10) |
DATE |
This field Defines the Job End Date for India
|
| 14 |
HS_LEAVE_TYPE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines the leave type for India.
1=Accident Leave
2=Special Leave
|
| 15 |
LEAVE_FROM_DT_IND |
Date(10) |
DATE |
This Field Defines the Leave From Date for India
|
| 16 |
LEAVE_TO_DT_IND |
Date(10) |
DATE |
This field Defines the Leave To Date for India
|
| 17 |
APPROVE_DATE |
Date(10) |
DATE |
This field is used to store the current approval date throughout batch processes.
|
| 18 |
HS_APPROVALBY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines the Approval By
1=Employee ID
2=Physician ID
Default Value: 1
|
| 19 |
HS_SHIFT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines the Shift type for India
1=General Shift
2=Shift One
3=Shift Two
4=Shift Three
|
| 20 |
START_TIME |
Time(15) |
TIMESTAMP |
Interview Start Time
|
| 21 |
END_TIME |
Time(15) |
TIMESTAMP |
Interview End Time
|
| 22 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table:
PERSON_NAME
|
| 23 |
INSPECTOR_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field defines the Inspector Name
|
| 24 |
INSPECTOR_JOBTITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
This Field Defines the Inspector Title
|
| 25 |
INSPECTOR_DATE |
Date(10) |
DATE |
This Field Defines the Inspection Date
|
| 26 |
INSPECTOR_TIME |
Time(15) |
TIMESTAMP |
This Field Defines the Inspection Time
|
| 27 |
CORRECTIVE_PREVENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Corrective or Preventive Actn
C=Corrective Action
P=Preventive Action
|
| 28 |
HS_ACTION_DATE_IND |
Date(10) |
DATE |
This is a Date of Action field for India
|
| 29 |
HS_OFFCR_RESP_IND |
Character(30) |
VARCHAR2(30) NOT NULL |
This field defines the Officer Responsible.
|
| 30 |
REPORTED_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
Reported To EmplID
Prompt Table:
PERSON_NAME
|
| 31 |
DESIGNATE_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employer Designate ID
|
| 32 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPARTMENT_VW
|
| 33 |
HS_INSUR_NBR_IND |
Character(30) |
VARCHAR2(30) NOT NULL |
Insurance Number
|
| 34 |
HS_INSUR_DATE_IND |
Date(10) |
DATE |
This is a Field for Insurance Date india specific
|
| 35 |
NEAREST_PRACT_DIST |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Nearest Practitioner Distance
|
| 36 |
NEAREST_HOSP_DIST |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Nearest Hospital Distance
|
| 37 |
NEAREST_HOSP_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Nearest Hospital Name
|
| 38 |
CORRECTIVE_ACTION |
Long Character |
CLOB |
Corrective Action
|
| 39 |
HS_EMPLID_APPR_IND |
Character(11) |
VARCHAR2(11) NOT NULL |
Field added to store Emplid in Injury Component
Prompt Table:
PERSON_NAME
|