GVT_DISP_E_LANG(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. Related Language record for GVT_DISP_EVENT. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | DISCIPLINE_DT | Date(10) | DATE NOT NULL | Reported Date |
3 | DISCIPLINARY_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Disciplinary Type |
4 | DISCIPLINARY_STEP | Character(3) | VARCHAR2(3) NOT NULL | Disciplinary Step |
5 | GVT_DISP_EVNT_NBR | Number(3,0) | SMALLINT NOT NULL | Disciplinary Action Event Nbr |
6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
7 | COMMENTS | Long Character | CLOB | Comment |