GPFR_DA_CON_TYPEGPFR_CONTYP_VW(SQL View) |
Index Back |
|---|---|
Contact TypeContact Type |
| SELECT DISTINCT GPFR_DA_CODE ,%Substring(DESCR254 ,1 ,100) FROM PS_GPFR_DT_VALUES A WHERE COUNTRY='FRA' AND GPFR_AF_APPL='DSN' AND GPFR_DA_DATTYP = 'DSN07.004' AND GPFR_DA_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_CON_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Contact Type |
| 2 | GPFR_CON_TYPE_DESC | Character(100) | VARCHAR2(100) NOT NULL | Content Type |