PTPROMPTFLD_VW(SQL View) |
Index Back |
---|
SELECT recname , fieldname , edittable FROM PSRECFIELD WHERE edittable <> ' ' AND edittable NOT LIKE '!%%' ESCAPE '!' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). | |
2 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
3 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |