SETIDDEPTIDHRCD_DEPT_CC_VW(SQL View) |
Index Back |
|---|---|
Department Cost Center View.Department Cost Center View. |
| SELECT B.SETID , B.DEPTID , A.HPYP_CNTRL_AREA , A.HPYP_CC_ID , A.DESCR40 , A.BUSINESS_UNIT_GL FROM PS_HPYP_CC_TBL A , PS_HPIP_DEPT_CC B WHERE A.HPYP_CNTRL_AREA = B.HPYP_CNTRL_AREA AND A.HPYP_CC_ID = B.HPYP_CC_ID AND A.EFF_STATUS = 'A' AND %EffdtCheck(HPYP_CC_TBL A1, A, %CurrentDateIn) AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_HPIP_DEPT_CC B1 WHERE B1.SETID = B.SETID AND B1.DEPTID = B.DEPTID AND B1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 3 | HPYP_CNTRL_AREA | Character(5) | VARCHAR2(5) NOT NULL | Controlling Area |
| 4 | HPYP_CC_ID | Character(12) | VARCHAR2(12) NOT NULL | Cost Center ID. |
| 5 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 6 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | General Ledger Unit |