TL_SRCH_JB_P_VW(SQL View) |
Index Back |
|---|---|
Position detail ViewPosition detail View for TL Search Index for all EffDt |
| SELECT POSN.POSITION_NBR , POSN.DESCR FROM PS_POSITION_DATA POSN WHERE POSN.EFFDT=( SELECT MAX(POSN1.EFFDT) FROM PS_POSITION_DATA POSN1 WHERE POSN1.POSITION_NBR = POSN.POSITION_NBR AND POSN1.EFFDT<= %CurrentDateIn AND POSN1.EFF_STATUS='A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |