EMPLIDPrompt Table: PERSON
DISCIPLINE_DTDefault Value: %date
DISCIPLINARY_TYPEPrompt Table: DISCIP_TYPE_TBL
DISCIPLINARY_STEPPrompt Table: DISCIP_STEP_TBL
Default Value: %date
Y/N Table Edit
Default Value: N
Prompt Table: RESLTN_TYPE_TBL
DISCIPLIN_STEP(SQL Table) |
Index Back |
|---|---|
EE Disciplinary Action StepsUse DISCIPLIN_STEP to record the particular steps 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_ACTN. You can create more than one DISCIPLIN_STEP 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
Default Value: %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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | ACTION_DT | Date(10) | DATE NOT NULL |
Action Date
Default Value: %date |
| 7 | COMMENTS | Long Character | CLOB | Comment |
| 8 | GVT_STEP_LNGTH_DYS | Number(3,0) | SMALLINT NOT NULL | Step Length (Days) |
| 9 | GVT_UNION_RPT_DT | Date(10) | DATE | Reported to Union |
| 10 | GVT_DAYS_TO_COMPLT | Number(3,0) | SMALLINT NOT NULL | Days To Complete |
| 11 | GVT_UNION_RPRTABLE | Character(1) | VARCHAR2(1) NOT NULL |
Action Reportable to Union
Y/N Table Edit Default Value: N |
| 12 | STEP_RESLTN | Character(3) | VARCHAR2(3) NOT NULL |
Step Resolution
Prompt Table: RESLTN_TYPE_TBL |