FEATURE_CDPrompt Table: FFS_FTR
DESCR50Prompt Table: FFS_FTR
FFS_FUNCTION_CDPrompt Table: FFS_FTR_FUNC
DESCR50_MIXEDPrompt Table: FFS_FTR_FUNC
FFS_FIELDS_SRCH(SQL View) |
Index Back |
|---|
| SELECT F1.FEATURE_CD , F1.DESCR50 , F2.FFS_FUNCTION_CD , F2.DESCR50 FROM PS_FFS_FTR_FUNC F2 , PS_FFS_FTR F1 WHERE F2.FEATURE_CD = F1.FEATURE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FEATURE_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Feature Code
Prompt Table: FFS_FTR |
| 2 | DESCR50 |
Character(50) | VARCHAR2(50) NOT NULL |
Description of length 50
Prompt Table: FFS_FTR |
| 3 | FFS_FUNCTION_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Function Code
Prompt Table: FFS_FTR_FUNC |
| 4 | DESCR50_MIXED |
Character(50) | VARCHAR2(50) NOT NULL |
Description 50 characters, mixed case
Prompt Table: FFS_FTR_FUNC |