HR_OBD_INSTSRCL

(SQL View)
 Index Back

Rel Lang for HR_OBD_INST_SRC

Related Language View for HR_OBD_INST_SRC

SELECT STAT.EMPLID , STAT.EMPL_RCD , NMLNG.LANGUAGE_CD , NMLNG.NAME_DISPLAY , NMLNG.FIRST_NAME , NMLNG.LAST_NAME , NMLNG.SECOND_LAST_NAME , NMLNG.NAME_AC , NMLNG.MIDDLE_NAME , NMLNG.NAME_DISPLAY_SRCH , NMLNG.LAST_NAME_SRCH , NMLNG.FIRST_NAME_SRCH , NMLNG.SECOND_LAST_SRCH , XLNG.XLATLONGNAME FROM PS_HR_OBD_STAT_VW STAT , PS_NAMES_LNG NMLNG , PSXLATITEM XLAT , PSXLATITEMLANG XLNG WHERE NMLNG.EMPLID = STAT.EMPLID AND NMLNG.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES_LNG NMLNG1, NMLNG, %CurrentDateIn) AND XLAT.FIELDNAME = 'HR_OBD_LIST_STATUS' AND XLAT.FIELDVALUE = STAT.HR_OBD_LIST_STATUS AND %EffdtCheck(PSXLATITEM XLAT1, XLAT, %CurrentDateIn) AND XLNG.EFFDT = XLAT.EFFDT AND XLNG.FIELDNAME = XLAT.FIELDNAME AND XLNG.FIELDVALUE = XLAT.FIELDVALUE AND XLNG.LANGUAGE_CD = NMLNG.LANGUAGE_CD UNION SELECT STAT.EMPLID , STAT.EMPL_RCD , XLNG.LANGUAGE_CD , NM.NAME_DISPLAY , NM.FIRST_NAME , NM.LAST_NAME , NM.SECOND_LAST_NAME , NM.NAME_AC , NM.MIDDLE_NAME , NM.NAME_DISPLAY_SRCH , NM.LAST_NAME_SRCH , NM.FIRST_NAME_SRCH , NM.SECOND_LAST_SRCH , XLNG.XLATLONGNAME FROM PS_HR_OBD_STAT_VW STAT , PS_NAMES NM , PSXLATITEM XLAT , PSXLATITEMLANG XLNG WHERE NM.EMPLID = STAT.EMPLID AND NM.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES NM1, NM, %CurrentDateIn) AND XLAT.FIELDNAME = 'HR_OBD_LIST_STATUS' AND XLAT.FIELDVALUE = STAT.HR_OBD_LIST_STATUS AND %EffdtCheck(PSXLATITEM XLAT1, XLAT, %CurrentDateIn) AND XLNG.EFFDT = XLAT.EFFDT AND XLNG.FIELDNAME = XLAT.FIELDNAME AND XLNG.FIELDVALUE = XLAT.FIELDVALUE AND NOT EXISTS ( SELECT 'X' FROM PS_NAMES_LNG NMLNG WHERE NMLNG.EMPLID = NM.EMPLID AND NMLNG.NAME_TYPE = NM.NAME_TYPE AND NMLNG.EFFDT = NM.EFFDT AND NMLNG.LANGUAGE_CD = XLNG.LANGUAGE_CD) UNION SELECT STAT.EMPLID , STAT.EMPL_RCD , NMLNG.LANGUAGE_CD , NMLNG.NAME_DISPLAY , NMLNG.FIRST_NAME , NMLNG.LAST_NAME , NMLNG.SECOND_LAST_NAME , NMLNG.NAME_AC , NMLNG.MIDDLE_NAME , NMLNG.NAME_DISPLAY_SRCH , NMLNG.LAST_NAME_SRCH , NMLNG.FIRST_NAME_SRCH , NMLNG.SECOND_LAST_SRCH , XLAT.XLATLONGNAME FROM PS_HR_OBD_STAT_VW STAT , PS_NAMES_LNG NMLNG , PSXLATITEM XLAT WHERE NMLNG.EMPLID = STAT.EMPLID AND NMLNG.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES_LNG NMLNG1, NMLNG, %CurrentDateIn) AND XLAT.FIELDNAME = 'HR_OBD_LIST_STATUS' AND XLAT.FIELDVALUE = STAT.HR_OBD_LIST_STATUS AND %EffdtCheck(PSXLATITEM XLAT1, XLAT, %CurrentDateIn) AND NOT EXISTS ( SELECT 'X' FROM PSXLATITEMLANG XLNG WHERE XLNG.FIELDNAME = XLAT.FIELDNAME AND XLNG.FIELDVALUE = XLAT.FIELDVALUE AND XLNG.EFFDT = XLAT.EFFDT AND XLNG.LANGUAGE_CD = NMLNG.LANGUAGE_CD )

  • Related Language Record for HR_OBD_INST_SRC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    7 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    8 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    9 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    10 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    12 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    13 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    14 HR_OBD_INST_STATUS Character(50) VARCHAR2(50) NOT NULL Guided Process Instance Status