PNLNAMEFIELDNAMELABEL_IDLANGUAGE_CDTU_PGFIELD4_VW | |
View: PS_TU_PGFIELD4_VW |
| Platform | View Text |
|---|---|
| Default | SELECT E.PNLNAME ,D.FIELDNAME ,D.LABEL_ID ,D.LANGUAGE_CD ,F.DEFAULT_LABEL ,R.VERSION ,F.LONGNAME , D.LONGNAME ,F.SHORTNAME ,D.SHORTNAME FROM PSDBFLDLABLLANG D , PSPNLFIELD E , PSDBFLDLABL F , PSDBFIELD R WHERE D.FIELDNAME=E.FIELDNAME AND E.RECNAME <>' ' AND D.FIELDNAME=F.FIELDNAME AND D.LABEL_ID=F.LABEL_ID AND D.LABEL_ID<>E.LABEL_ID AND D.FIELDNAME=R.FIELDNAME AND E.LBLTYPE IN (2,3,0) AND D.LABEL_ID NOT IN ( SELECT T.LABEL_ID FROM PSPNLFIELD T WHERE T.FIELDNAME=D.FIELDNAME AND T.LABEL_ID=D.LABEL_ID AND T.PNLNAME=E.PNLNAME) |
| PeopleSoft Field Name | Description |
|---|---|
| PNLNAME | Page Name |
| FIELDNAME | Field Name |
| LABEL_ID | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| LANGUAGE_CD | Language Code translate values |
| DEFAULT_LABEL | DEFAULT_LABEL identifys default Field Label of DB Field. |
| VERSION | Internal PeopleTools version to control reloading of objects in cache. |
| LONGNAME | Long Name |
| DESCR | Description |
| SHORTNAME | Field Short Name |
| SUBDIVISION_LBL | Subdivision Label |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |