ACTNREASONT_UPG

(SQL Table)
Index Back

Action/Reason Combinations

ACTN_REASON_TBL is an edit table. Use it to record combinations of action codes and the reason codes that are valid for an action. For example, two valid reasons for a termination action might be attendance and misconduct.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

2 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
8 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data

Y/N Table Edit

Default Value: N

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.