JPM_OPR_APPR_LW(SQL View) |
Index Back |
---|---|
Rel Lang for JPM_OPR_APPR_VWRelated language record for JPM_OPR_APPR_VW. |
SELECT O.OPRID , N.LANGUAGE_CD , N.NAME_DISPLAY FROM PSOPRDEFN O , PS_NAMES_LNG N WHERE O.EMPLID = N.EMPLID AND N.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES_LNG, N, %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |