FEATURE_CDDESCR50FFS_FUNCTION_CDLANGUAGE_CDDESCR50_MIXEDFFS_FIELDSRCLNG(SQL View) |
Index Back |
|---|
| SELECT F1.FEATURE_CD , F4.LONGNAME , F2.FFS_FUNCTION_CD , F3.LANGUAGE_CD , F5.DESCR FROM PS_FFS_FTR_FUNC F2 , PS_FFS_FTR F1 , PSPNLDEFNLANG F3 , PSDBFLDLABLLANG F4 , PS_FFS_FIELDS_LNG F5 WHERE F2.FEATURE_CD = F1.FEATURE_CD AND F2.FFS_FUNCTION_CD = F5.FFS_FUNCTION_CD AND F3.PNLNAME = F5.PNLNAME AND F3.LANGUAGE_CD = F4.LANGUAGE_CD AND F4.FIELDNAME = F5.FIELDNAME AND F1.FEATURE_CD = F5.FEATURE_CD AND F4.LANGUAGE_CD = F5.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FEATURE_CD |
Character(10) | VARCHAR2(10) NOT NULL | Feature Code |
| 2 | DESCR50 |
Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | FFS_FUNCTION_CD |
Character(10) | VARCHAR2(10) NOT NULL | Function Code |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR50_MIXED |
Character(50) | VARCHAR2(50) NOT NULL | Description 50 characters, mixed case |