EMPLIDDISCIPLINE_DTDESCR_INC_TYPEEMP_DISACT_VW(SQL View) |
Index Back |
|---|---|
Employee Discipl Action ViewView used by Crystal report OHS005-- Employee Disciplinary Action |
| SELECT A.EMPLID , A.DISCIPLINE_DT , A.DISCIPLINARY_TYPE , A.SUPERVISOR_ID , E.NAME , E.ACTION_DT , D.DESCR , E.NAME , E.COMMENTS FROM PS_DISCIPLIN_ACTN A, PS_DISCIP_STEP_TBL D, PS_DISCIPLIN_STEP E WHERE A.EMPLID = E.EMPLID AND A.DISCIPLINE_DT = E.DISCIPLINE_DT AND A.DISCIPLINARY_TYPE = E.DISCIPLINARY_TYPE AND D.DISCIPLINARY_STEP = E.DISCIPLINARY_STEP AND D.EFFDT = (SELECT MAX(EFFDT) FROM PS_DISCIP_STEP_TBL E1 WHERE E1.DISCIPLINARY_STEP = E.DISCIPLINARY_STEP AND E1.EFFDT <= A.DISCIPLINE_DT) |
| # | 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 | Reported Date |
| 3 | DESCR_INC_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Incident Type Description |
| 4 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 5 | SUPERVISOR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Supervisor Name |
| 6 | ACTION_DT | Date(10) | DATE | Action Date |
| 7 | DESCR_ACT_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Action Type Description |
| 8 | DISCUSSION_NAME | Character(50) | VARCHAR2(50) NOT NULL | Discipl Discussion Person |
| 9 | COMMENTS | Long Character | CLOB | Comment |