HR_MSSCT_RSN_VW (SQL View)	Index Back
Default Reason View View used in Guided Self Service to default Action Reasons.

HR_MSSCT_RSN_VW

(SQL View)

Default Reason View

View used in Guided Self Service to default Action Reasons.

SELECT DISTINCT A.HR_MSS_CT_NAME , A.ACTION , A.EFFDT , A.REG_REGION , A.SYSTEM_DATA_FLG , B.ACTION_REASON FROM PS_HR_MSS_CT_SEQ A , PS_ACTN_REASON_VW B WHERE A.ACTION = B.ACTION AND B.EFF_STATUS = 'A' AND %EffdtCheck(HR_MSS_CT_SEQ, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_MSS_CT_NAME Character(25) VARCHAR2(25) NOT NULL Compound Transaction Name

2 ACTION Character(3) VARCHAR2(3) NOT NULL Action

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

5 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.

6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_MSS_CT_NAME	Character(25)	VARCHAR2(25) NOT NULL	Compound Transaction Name
2	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
5	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.
6	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code