PTRECNAME_TOPTFIELDNAME_TOLANGUAGE_CDPSADSRELFT_LVW(SQL View) |
Index Back |
|---|
| SELECT t.recname , W.fieldname , W.LANGUAGE_CD , W.LONGNAME FROM %Table(PSRECFIELDDB) T ,%Table(PSDBFLDLABLLANG) W WHERE T.FIELDNAME=W.FIELDNAME AND T.LABEL_ID=W.LABEL_ID UNION SELECT t.recname , W.fieldname , P.language_cd , P.LONGNAME FROM %Table(PSRECFIELDDB) T ,%Table(PSDBFLDLABL) W , %Table(PSDBFLDLABLLANG) P WHERE T.FIELDNAME=W.FIELDNAME AND W.FIELDNAME=P.FIELDNAME AND W.LABEL_ID=P.LABEL_ID AND W.DEFAULT_LABEL=1 AND T.LABEL_ID=' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTRECNAME_TO |
Character(15) | VARCHAR2(15) NOT NULL | To Data Set Record |
| 2 | PTFIELDNAME_TO |
Character(18) | VARCHAR2(18) NOT NULL | To Data Set Field |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |