END_ACTIONACTION_REASONA=Active
I=Inactive
PA_SP_END_ACT_R(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.EFF_STATUS ,ACT.DESCR ,ACT.DESCRSHORT FROM PS_ACTN_REASON_TBL ACT WHERE %EffdtCheck(ACTN_REASON_TBL, 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |