FFS_PAGEFUNC_VW (SQL View)	Index Back
Selected functions

FFS_PAGEFUNC_VW

(SQL View)

Selected functions

SELECT DISTINCT UF.FFS_HASH , UF.FEATURE_CD , UF.FFS_FUNCTION_CD , F.DESCR50 , ' ' , ' ' , ' ' FROM PS_FFS_USERFIELDS UF , PS_FFS_FTR_FUNC F WHERE UF.FEATURE_CD = F.FEATURE_CD AND UF.FFS_FUNCTION_CD = F.FFS_FUNCTION_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FFS_HASH Character(28) VARCHAR2(28) NOT NULL Feature Security Hash

2 FEATURE_CD Character(10) VARCHAR2(10) NOT NULL Feature Code

3 FFS_FUNCTION_CD Character(10) VARCHAR2(10) NOT NULL Function Code

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

5 ENABLE_ALL_FIELDS Character(1) VARCHAR2(1) NOT NULL Enable All Fields
Y/N Table Edit

6 FIELD_PB Character(1) VARCHAR2(1) NOT NULL Select Fields

7 DELETE_FLAG Character(1) VARCHAR2(1) NOT NULL Deletion Flag
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FFS_HASH	Character(28)	VARCHAR2(28) NOT NULL	Feature Security Hash
2	FEATURE_CD	Character(10)	VARCHAR2(10) NOT NULL	Feature Code
3	FFS_FUNCTION_CD	Character(10)	VARCHAR2(10) NOT NULL	Function Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	ENABLE_ALL_FIELDS	Character(1)	VARCHAR2(1) NOT NULL	Enable All Fields Y/N Table Edit
6	FIELD_PB	Character(1)	VARCHAR2(1) NOT NULL	Select Fields
7	DELETE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Deletion Flag Default Value: Y