DISCIPLINARY_TYPEEFFDTGVT_OFFENSE_NR1=1st Offense
2=2nd Offense
3=3rd Offense
4=4th Offense
5=5th Offense
DISCIPLINARY_STEPPrompt Table: DISCIP_STEP_TBL
GVT_RECMND_ACTN(SQL Table) |
Index Back |
|---|---|
Recommended Disciplinary ActnsGVT: Use this table to identify the recommended disciplinary actions to take for an employee based on the discipline type and number of offenses. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISCIPLINARY_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Disciplinary Type |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | GVT_OFFENSE_NR |
Character(1) | VARCHAR2(1) NOT NULL |
Disciplinary Offense Number
1=1st Offense 2=2nd Offense 3=3rd Offense 4=4th Offense 5=5th Offense |
| 4 | DISCIPLINARY_STEP |
Character(3) | VARCHAR2(3) NOT NULL |
Disciplinary Step
Prompt Table: DISCIP_STEP_TBL |