SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL
UNSAFE_ACT_CDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
UNSAFE_ACT_TBL(SQL Table) |
Index Back |
|---|---|
Unsafe Act CodesUNSAFE_ACT_TBL catalogs unsafe acts that can cause injury or illness to employees in the workplace. This is an edit table used in tracking causes of incidents in the Health and Safety module. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 2 | UNSAFE_ACT_CD |
Character(5) | VARCHAR2(5) NOT NULL | Unsafe Act Performed |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |