GPDE_GR_RSRH_VW(SQL View) |
Index Back |
|---|---|
Employee Result Search - GarnGPDE_GR_RSRH_VW 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 employee records for you to use when you access a panel. This view shows you records only for employees 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 %Sql(SCRTY_SEL_PKEY,SEC,SEC) , %Sql(SCRTY_SEL_PERSBR,SEC,SEC) ,B.GPDE_GR_SEQ ,B.GPDE_GR_TYPE FROM PS_PERS_SRCH_GBL SEC ,PS_GPDE_GR_RSLT_VW B WHERE B.EMPLID = SEC.EMPLID AND B.EMPL_RCD=SEC.EMPL_RCD |
| # | 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 | 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 | 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 SetID
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 SetID |
| 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 | GPDE_GR_SEQ |
Number(3,0) | SMALLINT NOT NULL | Garnishment Priority |
| 32 | GPDE_GR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Garnishment Type
1=General Garnishment 2=Support Garnishment |