ACTIONGP_WC_TERACT_VW(SQL View) |
Index Back |
|---|---|
Action DescriptionAction Description |
| SELECT DISTINCT A.ACTION , A.ACTION_DESCR FROM PS_ACTION_TBL A , PS_GP_WC_ACT_DTL D WHERE D.GP_WC_ACTION_ID = 'T' AND A.ACTION = D.ACTION AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ACTION_TBL A2 WHERE A.ACTION = A2.ACTION ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTION |
Character(3) | VARCHAR2(3) NOT NULL | Action |
| 2 | ACTION_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Action Description |