FIELDNAMESET_FIELDNAMEVW(SQL View) |
Index Back |
|---|---|
TableSet Fields |
| select distinct a.fieldname ,c.longname from PSDBFIELD a ,psrecdefn b ,psdbfldlabl c where (a.fieldname = b.setcntrlfld and a.fieldname = c.fieldname and c.default_label = 1) or (a.fieldname = 'SETID' and a.fieldname = c.fieldname and c.default_label = 1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |