SETIDDEPTIDPOSITION_NBREFFDTDefault Value: %date
EFFDT_DEPTPOSN_BDG_EFF_VW(SQL View) |
Index Back |
|---|---|
Position budget viewPosition budget view |
| SELECT DISTINCT B.SETID ,B.BUDGET_DEPTID ,A.POSITION_NBR ,A.EFFDT ,B.EFFDT ,A.DESCR FROM PS_POSITION_DATA A , PS_DEPT_TBL B WHERE B.SETID=( SELECT Z.SETID FROM PS_SET_CNTRL_REC Z WHERE Z.SETCNTRLVALUE=A.BUSINESS_UNIT AND Z.RECNAME='DEPT_TBL') AND B.DEPTID=A.DEPTID |
| # | 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 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFFDT_DEPT |
Date(10) | DATE | Dept Effective Date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |