ACTN_RSN_SRC_VW (SQL View)	Index Back
Action/Reason Search View Action/Reason Search View.

ACTN_RSN_SRC_VW

(SQL View)

Action/Reason Search View

Action/Reason Search View.

SELECT ACTION , ACTION_REASON , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , OBJECTOWNERID , SYSTEM_DATA_FLG , LASTUPDDTTM , LASTUPDOPRID FROM PS_ACTN_REASON_TBL

Related Language Record: ACT_RSN_VW_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTN_SRCH_VW

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 This Y/ N field is used to identify which rows in a table are considered 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTN_SRCH_VW
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	This Y/ N field is used to identify which rows in a table are considered 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.