HR_OBD_INST_SRC

(SQL View)
 Index Back

OnBoarding Status Search

Returns those job assignments for which an OnBoarding trigger and/or instance exists.

SELECT DISTINCT OPR.OPRID ,OPR.ROWSECCLASS ,SEC.EMPLID ,SEC.EMPL_RCD ,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 ,STAT.HR_OBD_LIST_STATUS ,XLAT.XLATLONGNAME ,STAT.HR_OBD_TRG_DT ,STAT.HR_OBD_INST_DT FROM %Sql(SCRTY_PER_NM_FROM) , PS_HR_OBD_STAT_VW STAT , PSXLATITEM XLAT WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_NAME) AND %Sql(SCRTY_WHERE, 'PPLJOB') AND STAT.EMPLID = SEC.EMPLID AND STAT.EMPL_RCD = SEC.EMPL_RCD AND XLAT.FIELDNAME = 'HR_OBD_LIST_STATUS' AND XLAT.FIELDVALUE = STAT.HR_OBD_LIST_STATUS AND %EffdtCheck(PSXLATITEM XLAT1, XLAT, %CurrentDateIn)

  • Related Language Record: HR_OBD_INSTSRCL

    • # 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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    8 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    9 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    11 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    13 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    14 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    15 HR_OBD_LIST_STATUS Character(2) VARCHAR2(2) NOT NULL AG Instance status
    CA=Cancelled
    CP=Complete
    IP=In Progress
    NS=Not Started
    16 HR_OBD_INST_STATUS Character(50) VARCHAR2(50) NOT NULL Guided Process Instance Status
    17 HR_OBD_TRG_DT Date(10) DATE OnBoarding trigger creation date
    18 HR_OBD_INST_DT Date(10) DATE OnBoarding instance creation date