FEATURE_CDFFS_FUNCTION_CDDESCR150_MIXEDPNLNAMERECNAMEFIELDNAME12=Push Button/Link
2=Group Box
4=Edit Box
5=Drop Down
7=Check Box
10=Operator
20=Role
30=Business Unit
40=Installation
FFS_FLDDSCN_VW(SQL View) |
Index Back |
|---|
| 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) , PF.PNLNAME , PF.RECNAME , PF.FIELDNAME , FS.FFS_FIELDTYPE , FS.UPDT_ALLOWED , UM.OPRID , UM.ROLENAME , UM.BUSINESS_UNIT , UM.FFS_PRIORITY , FS.FFS_VALUE_CHK FROM PSPNLFIELD PF , PSPNLDEFN PD , PS_FFS_FIELDS FS , PS_FFS_USERMAIN UM WHERE PF.PNLNAME = PD.PNLNAME AND PF.PNLNAME = FS.PNLNAME AND PF.RECNAME = FS.RECNAME AND PF.FIELDNAME = FS.FIELDNAME AND %NumToChar(PF.FIELDTYPE) = FS.FFS_FIELDTYPE AND NOT EXISTS( SELECT 'X' FROM PS_FFS_USERFIELDS UF WHERE UF.FEATURE_CD = FS.FEATURE_CD AND UF.FFS_FUNCTION_CD = FS.FFS_FUNCTION_CD AND UF.PNLNAME = FS.PNLNAME AND UF.RECNAME = FS.RECNAME AND UF.FIELDNAME = FS.FIELDNAME AND UF.FFS_FIELDTYPE = FS.FFS_FIELDTYPE AND UF.FFS_HASH = UM.FFS_HASH) 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) , PF.PNLNAME , PF1.RECNAME , PF1.FIELDNAME , FS.FFS_FIELDTYPE , FS.UPDT_ALLOWED , UM.OPRID , UM.ROLENAME , UM.BUSINESS_UNIT , UM.FFS_PRIORITY , FS.FFS_VALUE_CHK FROM PSPNLFIELD PF , PSPNLFIELD PF1 , PSPNLDEFN PD , PS_FFS_FIELDS FS , PS_FFS_USERMAIN UM WHERE PD.PNLNAME = PF.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 AND NOT EXISTS ( SELECT 'X' FROM PS_FFS_USERFIELDS UF WHERE UF.FEATURE_CD = FS.FEATURE_CD AND UF.FFS_FUNCTION_CD = FS.FFS_FUNCTION_CD AND UF.PNLNAME = FS.PNLNAME AND UF.RECNAME = FS.RECNAME AND UF.FIELDNAME = FS.FIELDNAME AND UF.FFS_FIELDTYPE = FS.FFS_FIELDTYPE AND UF.FFS_HASH = UM.FFS_HASH) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FEATURE_CD |
Character(10) | VARCHAR2(10) NOT NULL | Feature Code |
| 2 | FFS_FUNCTION_CD |
Character(10) | VARCHAR2(10) NOT NULL | Function Code |
| 3 | DESCR150_MIXED |
Character(150) | VARCHAR2(150) NOT NULL | Description |
| 4 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 5 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | 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 |
| 8 | UPDT_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL | Update Allowed |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 12 | FFS_PRIORITY | Character(2) | VARCHAR2(2) NOT NULL |
Feature Priority
10=Operator 20=Role 30=Business Unit 40=Installation |
| 13 | FFS_VALUE_CHK | Character(1) | VARCHAR2(1) NOT NULL | Defined by Value |