EMPLIDEMPL_RCDCOMPANYPCMP_PROD_TYPEPCMP_COMPPRDTVW(SQL View) |
Index Back |
|---|---|
Prof Comp Company ProductsUsed in the Professional Compliance module. View of all active Product Types that a Company sells. |
| SELECT DISTINCT B.EMPLID ,B.EMPL_RCD ,B.COMPANY ,A.PCMP_PROD_TYPE ,PT.PCMP_PRODTYP_DESCR FROM PS_PCMP_COMPPRDEFF A ,PS_CURRENT_JOB_ALL B ,PS_PCMP_PROD_TYPE PT WHERE A.COMPANY=B.COMPANY AND A.EFF_STATUS='A' AND A.EFFDT=( SELECT MAX(C.EFFDT) FROM PS_PCMP_COMPPRDEFF C WHERE C.COMPANY=A.COMPANY AND C.PCMP_PROD_TYPE=A.PCMP_PROD_TYPE AND C.PCMP_PRODUCT=A.PCMP_PRODUCT) AND PT.SETID=B.SETID_JOBCODE AND PT.PCMP_PROD_TYPE=A.PCMP_PROD_TYPE |
| # | 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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | PCMP_PROD_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | Used in the Professional ompliance module. Prodtuct Type category. |
| 5 | PCMP_PRODTYP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Used in the Professional Compliance module. Product type description. |