RSEC_FUNC_ST_VW (SQL View)	Index Back
Function Display State Values Function Display State Values view.

RSEC_FUNC_ST_VW

(SQL View)

Function Display State Values

Function Display State Values view.

SELECT A.RSEC_FUNC_CD , B.FIELDVALUE , B.XLATLONGNAME , B.XLATSHORTNAME FROM PS_RSEC_FUNC_DEFN A , PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFF_STATUS = 'A' AND C.EFFDT <= %CurrentDateIn)

Related Language Record: RSEC_FST_LNG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_FUNC_CD Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges

2 RSEC_FUNC_STATE Character(4) VARCHAR2(4) NOT NULL Field to as drop down to capture the translate fied value of a functional option.

3 EOEC_MP_XLATLONG Character(30) VARCHAR2(30) NOT NULL Long description from the xlat table.

4 EOEC_MP_XLATSHORT Character(10) VARCHAR2(10) NOT NULL Short description from the xlat table.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_FUNC_CD	Character(30)	VARCHAR2(30) NOT NULL	Security privilege code. Used by CRM self-service to define security privileges
2	RSEC_FUNC_STATE	Character(4)	VARCHAR2(4) NOT NULL	Field to as drop down to capture the translate fied value of a functional option.
3	EOEC_MP_XLATLONG	Character(30)	VARCHAR2(30) NOT NULL	Long description from the xlat table.
4	EOEC_MP_XLATSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short description from the xlat table.