HR_MSS_CT_CFG_V (SQL View)	Index Back
Guided self service

HR_MSS_CT_CFG_V

(SQL View)

Guided self service

SELECT A.HR_MSS_CT_NAME , A.EFFDT , A.STATUS , A.DESCR50 , A.REG_REGION FROM PS_HR_MSS_CT_CFG A WHERE A.STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_HR_MSS_CT_CFG B WHERE B.HR_MSS_CT_NAME = A.HR_MSS_CT_NAME AND A.REG_REGION = B.REG_REGION AND B.EFFDT <= %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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Prompt Table: REG_STANDARD_VW

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW