HR_OBD_DOC_SRCH

(SQL View)
 Index Back

OnBoarding Emp Doc Search

Returns employee OnBoarding uploaded and acknowledged documents that the administrator has row level access for. This view can only be used as a search view, but not a prompt view.

SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, OPR,SEC) , %Sql(SCRTY_SEL_CORSBR,NM,SEC) , TMPL.AGC_CATEGORY_ID , OBD.PTAI_LIST_ID , OBD.PTAI_PARENT_TMPL FROM %Sql(SCRTY_PER_NM_FROM) , PS_HR_OBD_AG_ATT OBD , PS_AGC_TMPL_TBL TMPL WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_NAME) AND %Sql(SCRTY_WHERE, 'PPLJOB') AND OBD.EMPLID = SEC.EMPLID AND OBD.EMPL_RCD = SEC.EMPL_RCD AND OBD.ATTACH_EMP_ACTION IN ('A','U') AND OBD.LASTUPDDTTM IS NOT NULL AND TMPL.AGC_LIST_ID = OBD.PTAI_PARENT_TMPL

  • Related Language Record: PERSON_NAME_LNG

    • # 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 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: AGC_CAT_TBL

    32 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    33 PTAI_PARENT_TMPL Character(31) VARCHAR2(31) NOT NULL Template ID