SETIDPrompt Table: SP_SETID_NONVW
PARENT_NODEPrompt Table: WM_PROBLEM_TREE
TREE_NODEPrompt Table: WM_PROBLEM_TREE
A=Active
I=Inactive
1=Top
2=Middle
3=Bottom
WM_PRB_LVL_VW(SQL View) |
Index Back |
|---|---|
Work Request Problem Tree ViewProblem Tree view |
| SELECT SETID , PARENT_NODE , TREE_NODE , EFF_STATUS , DESCR80 , DESCR20_MIXED , NODE_LEVEL , PROBLEM_GROUP , PROBLEM_CD FROM PS_WM_PROBLEM_TREE WHERE SHOW_IN_SELFSERV = 'Y' AND EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | PARENT_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Parent Tree Node
Prompt Table: WM_PROBLEM_TREE |
| 3 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: WM_PROBLEM_TREE |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | Description |
| 6 | DESCR20_MIXED | Character(20) | VARCHAR2(20) NOT NULL | Description 20 characters, mixed case |
| 7 | NODE_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Node level
1=Top 2=Middle 3=Bottom |
| 8 | PROBLEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Problem Group |
| 9 | PROBLEM_CD | Character(15) | VARCHAR2(15) NOT NULL | Problem code |