EMPLMT_SRCH_GBL

(SQL View)
 Index Back

Employee Search - Global

EMPLMT_SRCH_GBL is an Employment Search record containing all of the localized alternate search keys. None of the localized search keys are maked as alternate searches. However, it's easy for a customer to mark any/all of them as alternate search keys if they choose to. Use it to select person records for a specific EMPL_RCD (ERN) for you to use when you access a panel. This view shows you records only for persons in departments that your operator class is allowed to access. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. To access records keyed by EMPLID without EMPL_RCD#, use one of ther Personal Searches.

SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, OPR, SEC) , %Sql(SCRTY_SEL_CORSBR, NM, SEC) , %Sql(SCRTY_SEL_FLDSBR, SEC) , %Sql(SCRTY_SEL_PAYSBR, SEC) FROM %Table(SJT_PERSON) SEC , %Table(PSOPRDEFN) OPR , %Table(SJT_CLASS_ALL) CLS , %Table(SJT_OPR_CLS) SOC , %Table(NAMES) NM WHERE SEC.APPT_TYPE <> '1' AND NM.EMPLID = SEC.EMPLID AND NM.NAME_TYPE = 'PRI' AND NM.EFFDT = ( SELECT MAX(NM1.EFFDT) FROM PS_NAMES NM1 WHERE NM1.EMPLID = NM.EMPLID AND NM1.NAME_TYPE = 'PRI' AND NM1.EFFDT <= %CurrentDateIn) AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND SOC.OPRID = OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND CLS.SCRTY_SET_CD = 'PPLJOB' AND (CLS.TREE = 'N' OR (CLS.TREE = 'Y' AND SOC.CLASSID = OPR.ROWSECCLASS AND SOC.SEC_RSC_FLG IN ('1', '3')))

  • Related Language Record: PERS_SRCH_LNG

  • Parent Record Of GPBR_ACM_INSS_T GPBR_ACM_IT_T GPBR_DEPEN_TMP GPBR_K300_INS_T GPBR_K300_IT_T GPBR_PAYEE_PARM GPBR_PAYEE_PA_T GPBR_PAYEE_PIS GPBR_PYRAI_PARM GPBR_RSLT_DTL_T GPBR_RSLT_INS_T GPBR_RSLT_IT_T GPBR_TR_VACN_VW GPBR_VACN_AP GPBR_VACN_AP_VW GPMX_PAYEE_DATA GPUS_EE_TAX_OTH MED_ASO_H_BRA

    • # 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 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 Last 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 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest
    17 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
    18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    19 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

    Prompt Table: SETID_TBL

    20 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: PERS_DEPT_VW

    21 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    22 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    23 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    24 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    25 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    26 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    27 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    28 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

    Prompt Table: MIL_SERVICE_TBL

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

    Prompt Table: MIL_RANK_TBL

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

    Prompt Table: MIL_RANK_TBL

    31 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
    0=Core Appointment
    1=Japan Kenmu Appointment
    2=French Public Sector Appt
    3=Staffing
    32 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    33 OTHER_ID_JPN Character(11) VARCHAR2(11) NOT NULL Other Identifier
    34 FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current
    35 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    36 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
    37 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    38 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    39 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    OT=Other
    PI=Payroll Interface
    40 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    41 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group