SETID_LOCATIONRC_LOC_DESCRRC_LOCATION_VW(SQL View) |
Index Back |
|---|---|
HelpDesk LocationsView used for displaying location information for HelpDesk. |
| SELECT A.SETID , A.DESCR , A.LOCATION , A.EFFDT FROM PS_LOCATION_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_LOCATION_TBL A1 WHERE A.SETID = A1.SETID AND A.LOCATION = A1.LOCATION AND A1.EFFDT <= %CurrentDateIn AND A1.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_LOCATION |
Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 2 | RC_LOC_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Descripton of the Location to be displayed in helpdesk page. |
| 3 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 4 | LOCATION_EFFDT | Date(10) | DATE | Location Effective Date |