GRIEVANCE_IDE=Employee/Applicant
O=Other
U=Union
A=Appealed
D=Dismissed
P=Pending
R=Rejected
S=Settled
U=Upheld
W=Withdrawn
GRIEV_RPT_VW(SQL View) |
Index Back |
|---|---|
Grievance Report ViewView used by Crystal report OHS006-- Grievance summary |
| select a.grievance_id, c.descrshort,a.grievance_dt, a.filed_by, a.grievance_status, a.status_dt, d.descr, b.action_dt, b.name, b.resolution_dt from ps_grievance a, PS_GRIEVANCE_STEP b, ps_griev_type_tbl c, ps_griev_step_tbl d where a.grievance_id = b.grievance_id and b.grievance_step = d.grievance_step and a.grievance_type = c.grievance_type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GRIEVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Grievance ID |
| 2 | DESCR_GRV_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Grievance Type Description |
| 3 | GRIEVANCE_DT | Date(10) | DATE | Grievance Date |
| 4 | FILED_BY | Character(1) | VARCHAR2(1) NOT NULL |
Filed By
E=Employee/Applicant O=Other U=Union |
| 5 | GRIEVANCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Appealed D=Dismissed P=Pending R=Rejected S=Settled U=Upheld W=Withdrawn |
| 6 | STATUS_DT | Date(10) | DATE | Status Date |
| 7 | DESCR_GRV_STEP | Character(30) | VARCHAR2(30) NOT NULL | Grievance Step Description |
| 8 | ACTION_DT | Date(10) | DATE | Action Date |
| 9 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 10 | RESOLUTION_DT | Date(10) | DATE | Resolution Date |