GVT_DISP_EVENT(SQL Table) |
Index Back |
|---|---|
EE Disciplinary Action EventsGVT: Use GVT_DISP_EVENT to record the particular events involved in a disciplinary action taken against an employee. The high-level information on a disciplinary action is recorded in the parent record named DISCIPLIN_STEP. You can create more than one GVT_DISP_EVENT record for each disciplinary action taken against an employee. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | DISCIPLINE_DT |
Date(10) | DATE NOT NULL | Reported Date |
| 3 | DISCIPLINARY_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Disciplinary Type
Prompt Table: DISCIP_TYPE_TBL |
| 4 | DISCIPLINARY_STEP |
Character(3) | VARCHAR2(3) NOT NULL |
Disciplinary Step
Prompt Table: DISCIP_STEP_TBL |
| 5 | GVT_DISP_EVNT_NBR |
Number(3,0) | SMALLINT NOT NULL | Disciplinary Action Event Nbr |
| 6 | GVT_DISP_EVENT | Character(3) | VARCHAR2(3) NOT NULL |
Disciplinary Action Event
Prompt Table: GVT_DIS_EVNT_TB |
| 7 | ACTION_DT | Date(10) | DATE NOT NULL |
Action Date
Default Value: DISCIPLIN_ACTN.DISCIPLINE_DT |
| 8 | GVT_DAYS_TO_COMPLT | Number(3,0) | SMALLINT NOT NULL | Days To Complete |
| 9 | GVT_FOLLOW_UP | Date(10) | DATE NOT NULL | Follow-Up Date |
| 10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 11 | RESOLUTION_DT | Date(10) | DATE | Resolution Date |
| 12 | COMMENTS | Long Character | CLOB | Comment |
| 13 | GVT_FOLLOW_UP_CMPL | Character(1) | VARCHAR2(1) NOT NULL |
Follow-Up Completed
Y/N Table Edit Default Value: N |