SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_08
DIAGNOSIS_CDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
DIAGNOSIS_TBL(SQL Table) |
Index Back |
|---|---|
Injury/Illness Diagnosis CodesDIAGNOSIS_TBL is an edit table used to record medical diagnoses of injuries or illnesses suffered by workers. This data is part of the Health and Safety module and the Regulatory Requirements 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: SET_VLD_HR_08 |
| 2 | DIAGNOSIS_CD |
Character(6) | VARCHAR2(6) NOT NULL | Diagnosis Code |
| 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |