PY_IC_CO_W4_VW

(SQL View)
 Index Back

Company Description View

View contains s a list of company descriptions.

SELECT DISTINCT A.EMPLID ,B.DESCR ,A.COMPANY ,B.DESCR_AC ,B.DESCRSHORT FROM PS_JOB A , PS_COMPANY_TBL B WHERE A.COMPANY = B.COMPANY AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_COMPANY_TBL B1 WHERE B1.COMPANY = B.COMPANY AND B1.EFF_STATUS = 'A') AND B.COUNTRY='USA' AND A.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = A.EMPLID AND J1.EMPL_RCD = A.EMPL_RCD AND J1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = A.EMPLID AND J2.EMPL_RCD = A.EMPL_RCD AND J2.EFFDT = A.EFFDT) AND B.TAX_REPORT_TYPE<>'R'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

4 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Char Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description