PSPTRECFLDLBLVW |
index back |
|---|---|
record field label view |
| SELECT T.RECNAME , W.FIELDNAME , W.LABEL_ID , T.FIELDNUM , V.FIELDTYPE FROM %Table(PSRECFIELDDB) T ,%Table(PSDBFIELD) V ,%Table(PSDBFLDLABL) W WHERE T.FIELDNAME=V.FIELDNAME AND T.FIELDNAME=W.FIELDNAME AND T.LABEL_ID=W.LABEL_ID UNION SELECT T.RECNAME , W.FIELDNAME , W.LABEL_ID , T.FIELDNUM , V.FIELDTYPE FROM %Table(PSRECFIELDDB) T ,%Table(PSDBFIELD) V ,%Table(PSDBFLDLABL) W WHERE T.FIELDNAME=V.FIELDNAME AND T.FIELDNAME=W.FIELDNAME AND W.DEFAULT_LABEL=1 AND T.LABEL_ID=' ' |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101) |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |