POSITION_NBRDefault Value: 00000000
A=Approved
P=Proposed
R=Frozen
SUCC_ROLE_ADD_S(SQL View) |
Index Back |
|---|---|
Position Match Search.Search view that selects rows from Postion Data when those position are involved in a role. |
| SELECT A.POSITION_NBR ,A.DESCR ,A.POSN_STATUS ,A.BUSINESS_UNIT ,A.DEPTID ,A.JOBCODE FROM PS_POSITION_DATA A , PS_CM_ROLE B WHERE A.POSITION_NBR = B.POSITION_NBR AND (A.EFFDT>=%CurrentDateIn OR A.EFFDT= ( SELECT MAX(D.EFFDT) FROM PS_POSITION_DATA D WHERE D.POSITION_NBR = A.POSITION_NBR AND D.EFFDT<=%CurrentDateIn)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 00000000 |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 6 | POSN_JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Position Job Code |