TL_SRCH_JB_L_VW(SQL View) |
Index Back |
|---|---|
Location detail ViewLocation detail View for TL Search Index for all EffDt |
| SELECT LOC.SETID , LOC.LOCATION , LOC.DESCR FROM PS_LOCATION_TBL LOC WHERE LOC.EFFDT=( SELECT MAX(LOC1.EFFDT) FROM PS_LOCATION_TBL LOC1 WHERE LOC1.LOCATION = LOC.LOCATION AND LOC1.SETID = LOC.SETID AND LOC1.EFFDT<= %CurrentDateIn AND LOC1.EFF_STATUS='A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |