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 | INAIL_CODE | Character(11) | VARCHAR2(11) NOT NULL | INAIL Code |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |