WM_PRB_LOC_LVW(SQL View) |
Index Back |
---|---|
Problem / Location viewContains Work Request and Work Order defaults by problem type and location |
SELECT a.setid , a.tree_node , a.location_setid , a.wr_location , b.effdt , b.language_cd , b.descr FROM PS_WM_PROBLEM_LOC a , ps_location_lang b WHERE a.location_setid = b.setid AND a.wr_location = b.location |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
2 | Character(20) | VARCHAR2(20) NOT NULL | An internal work field that contains the name of the node of a given current position during cash position w | |
3 | Character(5) | VARCHAR2(5) NOT NULL |
Location Set ID
Prompt Table: SP_SETID_NONVW |
|
4 | Character(10) | VARCHAR2(10) NOT NULL |
Service Location
Prompt Table: WR_LOCATION_VW |
|
5 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
6 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |