ST_PRTC_RFND_VW

(SQL View)
 Index Back

AdministerRefund Search Record

Union of the purchase period participation records and the manual contributions which have been entered for people for which there are no participation rows.

SELECT DISTINCT %Sql(SCRTY_SEL_PKEY,SEC,SEC) , A.STOCK_ID , A.STOCK_PLAN_TYPE , A.STOCK_PLAN , A.OFFERING_ID , C.PERIOD_END_DT , %Sql(SCRTY_SEL_PERSBR,SEC,SEC) FROM PS_ST_PURCHASE_PD C , PS_ST_ESPP_PARTIC A , PS_PERS_SRCH_GBL SEC WHERE A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD AND C.STOCK_ID = A.STOCK_ID AND C.STOCK_PLAN_TYPE = A.STOCK_PLAN_TYPE AND C.STOCK_PLAN = A.STOCK_PLAN AND C.OFFERING_ID = A.OFFERING_ID

  • Parent record: ST_ESPP_PARTIC

    • # 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 Rcd Nbr
    5 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Prompt Table: STOCK_TBL

    6 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Plan Type
    E=Purchase Plan
    O=Option Plan
    7 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

    Prompt Table: STOCK_PLAN_TBL

    8 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID

    Prompt Table: ST_OFFERING_PD

    9 PERIOD_END_DT Date(10) DATE Period End Date

    Prompt Table: ST_PURCHASE_PD

    10 NAME Character(50) VARCHAR2(50) NOT NULL Name
    11 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    12 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI
    13 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    14 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
    15 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    17 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    18 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    19 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    20 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    21 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
    22 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
    23 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    24 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: PERS_DEPT_VW

    26 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    27 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    28 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    29 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    30 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    31 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    32 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    33 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

    Prompt Table: MIL_SERVICE_TBL

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

    Prompt Table: MIL_RANK_TBL

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

    Prompt Table: MIL_RANK_TBL