PYGL_CO_CFMAPVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.COMPANY , A.BUSINESS_UNIT , A.COMPANY_LEVEL_INDC , A.DEPTID , A.JOBCODE , A.POSITION_NBR , A.EMPLID , A.EMPL_RCD , B.DESCR FROM PS_PYGL_CF_CPNYLEV A , PS_PYGL_CF_MAPPING C , PS_COMPANY_TBL B WHERE A.COMPANY = C.COMPANY AND B.COMPANY = A.COMPANY AND B.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_PYGL_CF_CPNYLEV D WHERE D.COMPANY = A.COMPANY AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.DEPTID = A.DEPTID AND D.JOBCODE = A.JOBCODE AND D.POSITION_NBR = A.POSITION_NBR AND D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD) AND B.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_COMPANY_TBL E WHERE E.COMPANY = A.COMPANY AND E.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 3 | COMPANY_LEVEL_INDC |
Character(1) | VARCHAR2(1) NOT NULL |
Mapping Level Indicator for Expense Mapping
A=Employee Level C=Company Level D=Department Level J=Job Code Level P=Position Level |
| 4 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL_EFF_VW |
| 5 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL_VW |
| 6 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_VW |
| 7 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 8 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: EMPLOYMENT |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |