EMPLIDEMPL_RCDHP_CONTRACT_NUMHP_CNTRACT_VW(SQL View) |
Index Back |
|---|---|
Contract ListHP_CNTRACT_LIST contains all employees contracts and their corresponding contract status with recalculation indicator. |
| SELECT A.EMPLID , A.EMPL_RCD , A.HP_CONTRACT_NUM FROM PS_HP_CNTRACT_LIST A WHERE A.HP_CONTRACT_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_HP_CONTPAY_PARM B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.HP_CONTRACT_NUM = A.HP_CONTRACT_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | HP_CONTRACT_NUM |
Number(7,0) | INTEGER NOT NULL | Contract Number |