EMPLIDJPM_PROFILE_IDLANGUAGE_CDHRS_PPROFL_DR_L(SQL View) |
Index Back |
|---|---|
Related Language RecordRelated Language Record for HRS_PPROFL_DR_I |
| SELECT PRFL.EMPLID , PRFL.JPM_PROFILE_ID , PER.LANGUAGE_CD , PER.NAME_DISPLAY FROM PS_JPM_PROFILE_I PRFL , PS_PERSON_NAME_LNG PER , PS_JPM_JP_SEC_VW S WHERE PRFL.EMPLID = PER.EMPLID AND PRFL.JPM_JP_TYPE = S.JPM_JP_TYPE AND PRFL.JPM_JP_PRFL_STATUS = 'A' AND PRFL.JPM_JP_TYPE = ( SELECT JPM_PRI_PERS_TYPE FROM PS_JPM_JP_PRI_TYPE) AND S.JPM_ROLE = 'EMP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | JPM_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL | The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |