EMPL_COMP_SRCH1(SQL View) |
Index Back |
---|---|
Search Vw-PayrollThis search view is used to locate specific payroll data by emplid, company and paygroup Based on PERS_SRCH_GBL but adds PAYGROUP and COMPANY as keys |
SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) ,JB.COMPANY , JB.PAYGROUP , %Sql(SCRTY_SEL_NMSBR,SEC,SEC) FROM PS_PERS_SRCH_GBL SEC , PS_JOB_CURR_EFF_VW JB WHERE JB.EMPLID = SEC.EMPLID AND JB.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 Record |
5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
6 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
8 | NAME_DISPLAY_SRCH | Character(50) | VARCHAR2(50) NOT NULL | Uppercase version of Name to improve performance on searches. |
9 | NAME_PSFORMAT | Character(50) | VARCHAR2(50) NOT NULL | A Person's name in the Peoplesoft Format (basically LN,FN MI |
10 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
11 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
12 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
13 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
14 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
15 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
16 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
17 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |