SHEET_ID1=Level 1
2=Level 2
3=Level 3
4=Level 4
5=Level 5
EX_ED_RISK_VW(SQL View) |
Index Back |
|---|---|
Expense Report Risk LevelDetermine the highest Risk level for a given Expense Report |
| SELECT A.SHEET_ID , MAX(A.RISK_LEVEL) FROM PS_EX_RISK_ER_DTL A , PS_EX_SHEET_HDR B WHERE A.SHEET_ID = B.SHEET_ID GROUP BY A.SHEET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | RISK_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Risk Level
1=Level 1 2=Level 2 3=Level 3 4=Level 4 5=Level 5 |