INJ_REHAB_ACTN(SQL Table) |
Index Back |
|---|---|
Injury/Ill Rehabilitatn ActionThis 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 INJ_REHAB_ACTN to set up a list of rehabilitation actions that are taken to relieve or correct a person's injury. |
| # | 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 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table: INCIDENT_DATA |
| 5 | ACTION_SEQUENCE |
Number(2,0) | SMALLINT NOT NULL | Action Sequence |
| 6 | REHAB_ACTION_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Rehabilitation Action Type
MED=Medication PHY=Physician Visit PSY=Physiotherapy TST=Medical Test |
| 7 | ACTION_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Action Status
C=Completed I=In Progress P=Planned R=Recommended V=Existing Default Value: R |
| 8 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table: PERSON_NAME |
| 9 | PHYSICIAN_ID | Character(11) | VARCHAR2(11) NOT NULL |
Physician ID
Prompt Table: PHYSICIAN_SRCH |
| 10 | PHYSICIAN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Physician Name |
| 11 | PROVIDER_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Provider Description |
| 12 | DIAGNOSIS_CD | Character(6) | VARCHAR2(6) NOT NULL |
Diagnosis Code
Prompt Table: DIAGNOSIS_TBL |
| 13 | EST_COMPLETION_DT | Date(10) | DATE | Estimated Completion Date |
| 14 | ACT_COMPLETION_DT | Date(10) | DATE | Actual Completion Date |
| 15 | CORRECTIVE_ACTION | Long Character | CLOB | Corrective Action |