END_ACTIONACTION_REASONLANGUAGE_CDPA_SP_EARVW_LNG(SQL View) |
Index Back |
|---|---|
SP End Action/ReasonsPA_SP_END_ACT_R is view on action resons by Actions. Use it to record combinations of action codes and the reason codes that are valid for an action in the service purchase type definition, end action/reason. |
| SELECT ACT.ACTION ,ACT.ACTION_REASON ,ACT.LANGUAGE_CD ,ACT.DESCR ,ACT.DESCRSHORT FROM PS_ACTN_RSN_LANG ACT WHERE %EffdtCheck(ACTN_RSN_LANG, ACT, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | END_ACTION |
Character(3) | VARCHAR2(3) NOT NULL | End Action |
| 2 | ACTION_REASON |
Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |