TRN_SRCH_WOERN

(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

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

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

Prompt Table: POI_TYPE_TRN_VW

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

Prompt Table: MIL_SERVICE_TBL

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

Prompt Table: MIL_RANK_TBL

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

Prompt Table: MIL_RANK_TBL