LM_JOBCODE_IDEFFDTBUSINESS_UNITLANGUAGE_CDLM_JOBBUS_VW_LG(SQL View) |
Index Back |
|---|---|
setid viewsetid view from job code tbl |
| SELECT C.LM_JOBCODE_ID ,C.EFFDT ,A1.BUSINESS_UNIT , E.LANGUAGE_CD , E.LM_JOBCD_DESCR , A1.LM_BUS_UNIT_DESCR FROM PS_LM_BU_LVW A1 , PS_LM_BU_VW A , PS_SET_CNTRL_REC B , PS_LM_JOBCODE_TBL C , PS_LM_JOBCODE_LANG E WHERE C.LM_HR_SETID = B.SETID AND B.SETCNTRLVALUE = A1.BUSINESS_UNIT AND B.RECNAME = 'LM_SETID_JOB_VW' AND C.LM_JOBCODE_ID = E.LM_JOBCODE_ID AND C.EFFDT = E.EFFDT AND A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND A1.LANGUAGE_CD = E.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_JOBCODE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | LM_JOBCD_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Job Code Description |
| 6 | LM_BUS_UNIT_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Business Unit Description |