TRNPER_SEC_SRCA

(SQL View)
 Index Back

Srch - People for Training

TRNPER_SEC_SRCH is used as a search view to select person records for you to use when you access a panel. This view includes all people with Jobs (except Kenmu appts) AND POI type of External Trainee. Includes Future dated rows. One row per EMPLID and distinct Search Items. Uses Security Sets PPLPOI and PPLJOB BUG 21744435 - added exclusion for terminated empl rcds BUG 26930276 - changed condition check from EMPL_STATUS to HR_STATUS. Also limited the HR_STATUS check to only people with job.

SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, OPR,SEC) , SEC.POI_TYPE , %Sql(SCRTY_SEL_NM2SBR,NM,SEC) , %Sql(SCRTY_SEL_MILSBR,SEC,SEC) FROM %Sql(SCRTY_PER_NM_FROM) WHERE ((SEC.HR_STATUS = 'A' AND %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_WHERE, 'PPLJOB')) OR (SEC.POI_TYPE = '00007' AND %Sql(SCRTY_WHERE, 'PPLPOI'))) AND %Sql(SCRTY_NAME)

  • Related Language Record: PERS_SRC_PMPT_L

    • # 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 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.

    Prompt Table: POI_TYPE_TRN_VW

    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    8 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI
    9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    10 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    11 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    12 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    13 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    14 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    15 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    16 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    17 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

    Prompt Table: MIL_SERVICE_TBL

    18 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank

    Prompt Table: MIL_RANK_TBL

    19 MIL_WORN_RANK Character(5) VARCHAR2(5) NOT NULL Worn Rank

    Prompt Table: MIL_RANK_TBL