ACCOMPLISH_LANG

(SQL View)
 Index Back

Accomplishments Related Lang

ACCOMPLISH_LANG is the language record related to ACCOMPLISHMENTS. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT B.EMPLID ,%Substring(A.JPM_CAT_ITEM_ID,1,8) ,A.EFFDT ,A.MAJOR_CODE ,C.LANGUAGE_CD ,%Substring(A.JPM_TEXT254_4,1,30) ,%Substring(A.JPM_TEXT254_2,1,15) ,%Substring(A.JPM_TEXT254_3,1,15) ,%Substring(A.JPM_TEXT254_4,1,50) ,%Substring(A.JPM_TEXT1325_1,1,30) ,%Substring(A.JPM_TEXT254_1,1,30) ,%Substring(A.JPM_TEXT254_4,1,20) ,%Substring(A.JPM_TEXT254_2,1,30) ,%Substring(A.JPM_TEXT254_3,1,50) ,A.JPM_TEXT1325_1 FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B ,PSOPRDEFN C WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B.JPM_JP_TYPE = 'PERSON' AND A.JPM_CAT_TYPE IN( SELECT FIELDVALUE FROM PSXLATITEM WHERE FIELDNAME = 'ACCOMP_CATEGORY') AND A.JPM_ITEM_KEY_ID = ( SELECT MAX(X.JPM_ITEM_KEY_ID) FROM PS_JPM_JP_ITEMS X WHERE A.JPM_PROFILE_ID = X.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND A.EFFDT = X.EFFDT) AND C.OPRID = %OperatorId

  • Related Language Record for ACCOMPLISHMENTS

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: %RECNAME_EDIT

    3 DT_ISSUED Date(10) DATE Issue Date
    4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
    7 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    8 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    9 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
    10 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    11 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
    12 GRANTOR Character(20) VARCHAR2(20) NOT NULL The name of the person granting the award
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 SUBFACULTY_NAME Character(50) VARCHAR2(50) NOT NULL Sub Faculty Name(Description)(Japan HR)
    15 JPM_TEXT1325_1 Long Character(1325) VARCHAR2(1325) User Text - 1325 Char