WM_PCR_CSEAC_VW(SQL View) |
Index Back |
---|---|
PCR Grp/Prb/Cause Active ViewActive Cause codes for a Problem Group / Problem |
SELECT W.SETID , W.PROBLEM_GROUP , W.PROBLEM_CD , W.CAUSE_CD , P.DESCR50 FROM PS_WM_PCR_CAUSE W , PS_WM_CAUSE P WHERE %Join(COMMON_KEYS, WM_PCR_CAUSE W, WM_CAUSE P) AND P.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
|
2 | Character(15) | VARCHAR2(15) NOT NULL | Problem Group | |
3 | Character(15) | VARCHAR2(15) NOT NULL | Problem code | |
4 | Character(15) | VARCHAR2(15) NOT NULL |
Cause Code
Prompt Table: WM_CAUSE |
|
5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |