EMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: PER_ORG_ASGN_VW
NON_EMPLOYEE_IDPrompt Table: NE_INCIDNT_SRCH
INCIDENT_NBRPrompt Table: INCIDENT_DATA
ACTION_SEQUENCELANGUAGE_CDINJ_REHAB_LNG(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 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 | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | PHYSICIAN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Physician Name |
| 8 | PROVIDER_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Provider Description |
| 9 | CORRECTIVE_ACTION | Long Character | CLOB | Corrective Action |