PTFP_DATATYPE_IDPTFP_FIELD_NAMEFPDTYPEATTR_VW(SQL View) |
Index Back |
|---|
| SELECT PTFP_DATATYPE_ID ,PTFP_FIELD_NAME ,PTFP_VALUE FROM PSFP_DTYPE_ATTR WHERE PTFP_VALUE<>' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTFP_DATATYPE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Data Type (see PSFP_DATATYPE). |
| 2 | PTFP_FIELD_NAME |
Character(40) | VARCHAR2(40) NOT NULL | Field Name |
| 3 | PTFP_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Value |