GRIEVANCE_IDLANGUAGE_CDGRIEV_RPT_LN_VW(SQL View) |
Index Back |
|---|---|
Grievance Report ViewLanguage View used by Crystal report OHS006-- Grievance summary |
| SELECT A.GRIEVANCE_ID ,C.LANGUAGE_CD , C.DESCRSHORT , D.DESCR FROM PS_GRIEVANCE A , PS_GRIEVANCE_STEP B , PS_GRIEV_TYPE_LANG C , PS_GRIEV_STEP_LANG D WHERE A.GRIEVANCE_ID = B.GRIEVANCE_ID AND B.GRIEVANCE_STEP = D.GRIEVANCE_STEP AND A.GRIEVANCE_TYPE = C.GRIEVANCE_TYPE AND C.LANGUAGE_CD = D.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GRIEVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Grievance ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR_GRV_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Grievance Type Description |
| 4 | DESCR_GRV_STEP | Character(30) | VARCHAR2(30) NOT NULL | Grievance Step Description |