WP_AGREEMENT_IDEMPLIDEMPL_RCDPERIOD_IDWP_EE_FUND_SRCH(SQL View) |
Index Back |
|---|---|
Employee Search - GlobalEMPLMT_SRCH_GBL 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 B.WP_AGREEMENT_ID , D.EMPLID , 0 , E.OPRID , B.DESCR50 , C.PERIOD_ID FROM PS_WP_EE_FUND A , PS_WP_AGREEMENT B , PS_WP_AGRT_PERIOD C , PS_PERSON D , PSOPRDEFN E WHERE A.WP_AGREEMENT_ID = B.WP_AGREEMENT_ID AND A.WP_AGREEMENT_ID = C.WP_AGREEMENT_ID AND A.PERIOD_ID = C.PERIOD_ID AND B.WP_AGRT_STATUS = 'A' AND C.WP_PERIOD_STATUS = 'A' AND A.EMPLID = E.EMPLID AND E.EMPLID = D.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WP_AGREEMENT_ID |
Character(5) | VARCHAR2(5) NOT NULL | Profit-Sharing: Agreement Identifier |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 6 | PERIOD_ID |
Character(12) | VARCHAR2(12) NOT NULL | Reference Period |