FFS_PAGEFLD_VW

(SQL View)
 Index Back

selected fields and use


SELECT DISTINCT ' ' , FS.FEATURE_CD , FS.FFS_FUNCTION_CD , %TrimSubstr(PF.LBLTEXT, 1, 60) %Concat ' / ' %Concat %TrimSubstr(PD.DESCR, 1, 30) %Concat ' / ' %Concat %TrimSubstr(FS.DESCR, 1, 30) , FS.PNLNAME , FS.RECNAME , FS.FIELDNAME , FS.FFS_FIELDTYPE , FS.UPDT_ALLOWED , ' ' , ' ' , FS.FFS_VALUE_CHK , ' ' FROM PSPNLFIELD PF , PSPNLDEFN PD , PS_FFS_FIELDS FS WHERE PD.PNLNAME = FS.PNLNAME AND PF.PNLNAME = FS.PNLNAME AND PF.RECNAME = FS.RECNAME AND PF.FIELDNAME = FS.FIELDNAME AND %NumToChar(PF.FIELDTYPE) = FS.FFS_FIELDTYPE UNION SELECT DISTINCT ' ' , FS.FEATURE_CD , FS.FFS_FUNCTION_CD , %TrimSubstr(PF1.LBLTEXT, 1, 60) %Concat ' / ' %Concat %TrimSubstr(PD.DESCR, 1, 30) %Concat ' / ' %Concat %TrimSubstr(FS.DESCR, 1, 30) , FS.PNLNAME , FS.RECNAME , FS.FIELDNAME , FS.FFS_FIELDTYPE , FS.UPDT_ALLOWED , ' ' , ' ' , FS.FFS_VALUE_CHK , ' ' FROM PSPNLFIELD PF , PSPNLFIELD PF1 , PSPNLDEFN PD , PS_FFS_FIELDS FS WHERE PD.PNLNAME = FS.PNLNAME AND PF.PNLNAME = FS.PNLNAME AND PF1.PNLNAME = PF.SUBPNLNAME AND PF1.RECNAME = FS.RECNAME AND PF1.FIELDNAME = FS.FIELDNAME AND %NumToChar(PF1.FIELDTYPE) = FS.FFS_FIELDTYPE

# 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 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
5 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
8 FFS_FIELDTYPE Character(2) VARCHAR2(2) NOT NULL Feature Field Type
12=Push Button/Link
2=Group Box
4=Edit Box
5=Drop Down
7=Check Box
9 UPDT_ALLOWED Character(1) VARCHAR2(1) NOT NULL Update Allowed
10 USER_DISPLAY Character(1) VARCHAR2(1) NOT NULL Display

Y/N Table Edit

Default Value: N

11 USER_UPDT Character(1) VARCHAR2(1) NOT NULL Enable for Update

Y/N Table Edit

Default Value: N

12 FFS_VALUE_CHK Character(1) VARCHAR2(1) NOT NULL Defined by Value
13 EXIST Character(1) VARCHAR2(1) NOT NULL Exist