| JOB_INAIL_LNGVW(SQL View) | Index Back | 
|---|---|
| INAIL Codes Vw - ITAINAIL Codes View for Italy | 
| SELECT A.INAIL_CODE , B.LANGUAGE_CD FROM PS_JOBFUNCTION_TBL A , PS_JOBFUNCTION_LNG B WHERE A.JOB_FUNCTION = B.JOB_FUNCTION AND A.EFFDT = B.EFFDT | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | INAIL Code | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Language Code |