FIELDNAME_RPTLANGUAGE_CDAM_REPT_LANG_VW(SQL View) |
Index Back |
|---|
| SELECT A.FIELDNAME , D.LANGUAGE_CD , D.LONGNAME , D.SHORTNAME FROM PS_FS_CF_TEMPLATE A , PSRECFIELDDB B , PSDBFLDLABL C , PSDBFLDLABLLANG D WHERE B.RECNAME = 'COST' AND B.FIELDNAME =A.FIELDNAME AND C.FIELDNAME = A.FIELDNAME AND C.DEFAULT_LABEL = 1 AND D.LABEL_ID = C.LABEL_ID AND D.FIELDNAME = C.FIELDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME_RPT |
Character(18) | VARCHAR2(18) NOT NULL | Report By Fieldname |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 4 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |