OPRIDEMPLIDCOMPANYPrompt Table: COMPANY_TBL
TIPS_ESTABPrompt Table: ESTAB_TBL
POST_DTPERS_SRCH_TIPS(SQL View) |
Index Back |
|---|---|
Search Vw-EE Data for TipsThis view is used as a search view to select employee input records for the tips process. This view shows you records only for employees in departments that your operator class is allowed to access. Joins PERS_SRCH_GBL with TIPS_ALLOC_EMPL |
| SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) ,TIPS.COMPANY ,TIPS.TIPS_ESTAB ,TIPS.POST_DT , %Sql(SCRTY_SEL_NMSBR,SEC,SEC) , SEC.BUSINESS_UNIT ,TIPS.GRS_TIP_HRS ,TIPS.GRS_RCPTS ,TIPS.RCPT_HRS_RATIO ,TIPS.EMPL_SHARE ,TIPS.EMPL_SHORTFALL ,TIPS.SHORTFALL_RATIO ,TIPS.GRS_TIPS ,TIPS.TOT_ALLOCATION ,TIPS.PREV_ALLOCATION ,TIPS.CUR_ALLOCATION FROM PS_PERS_SRCH_GBL SEC ,PS_TIPS_ALLOC_EMPL TIPS WHERE SEC.EMPLID=TIPS.EMPLID AND TIPS.EMPL_RCD = SEC.EMPL_RCD AND SEC.COMPANY = TIPS.COMPANY |
| # | 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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 6 | TIPS_ESTAB |
Character(20) | VARCHAR2(20) NOT NULL |
Tips Establishment ID
Prompt Table: ESTAB_TBL |
| 7 | POST_DT |
Date(10) | DATE | The Date a transaction was Posted. |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | NAME_DISPLAY_SRCH | Character(50) | VARCHAR2(50) NOT NULL | Uppercase version of Name to improve performance on searches. |
| 10 | NAME_PSFORMAT | Character(50) | VARCHAR2(50) NOT NULL | A Person's name in the Peoplesoft Format (basically LN,FN MI |
| 11 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 12 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Name |
| 13 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 14 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 15 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 16 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 17 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 18 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 19 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 20 | GRS_TIP_HRS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | YTD Gross Rpt Tippable Hrs |
| 21 | GRS_RCPTS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | YTD Gross Receipts |
| 22 | RCPT_HRS_RATIO | Signed Number(8,5) | DECIMAL(6,5) NOT NULL | YTD Empl Rcpt or Hrs Ratio |
| 23 | EMPL_SHARE | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | YTD Employee Share |
| 24 | EMPL_SHORTFALL | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | YTD Employee Shortfall |
| 25 | SHORTFALL_RATIO | Signed Number(8,5) | DECIMAL(6,5) NOT NULL | YTD Shortfall Ratio |
| 26 | GRS_TIPS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | YTD Gross Tips |
| 27 | TOT_ALLOCATION | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | YTD Total Alloc Amt |
| 28 | PREV_ALLOCATION | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | YTD Prev Alloc Tips |
| 29 | CUR_ALLOCATION | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Current Allocation |