FFS_PAGEFTR_VW(SQL View) |
Index Back |
---|---|
Selected features |
SELECT DISTINCT UF.FFS_HASH , UF.FEATURE_CD , F.DESCR50 , ' ' , ' ' FROM PS_FFS_USERFIELDS UF , PS_FFS_FTR F WHERE UF.FEATURE_CD = F.FEATURE_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(28) | VARCHAR2(28) NOT NULL | Feature Security Hash | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Feature Code | |
3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
4 | ENABLE_ALL | Character(1) | VARCHAR2(1) NOT NULL |
Enable All Functions
Y/N Table Edit |
5 | FUNC_PB | Character(1) | VARCHAR2(1) NOT NULL | Select Functions |