HR_GSS_RSN_TMP (SQL Table)	Index Back
GSS Default Reasons Temp Table used for data conversion to default Action Reasons for GSS.

HR_GSS_RSN_TMP

(SQL Table)

GSS Default Reasons

Temp Table used for data conversion to default Action Reasons for GSS.

# 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 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

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

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

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

#	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	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
6	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.