RESPONSE_MSGFIELDNAMERB_TD_KEYEIP_VW(SQL View) |
Index Back |
|---|---|
Unique Key FieldsView of fields defined as part of the primary unique key on a record. Similar to PSRECFLDKEYVW except that view only works for records that are of Record Type SQL Table. This view also displays unique keys on records based solely on PeopleTools Record MetaData, i.e. works for views and work records also. |
| SELECT A.MSGNAME , B.FIELDNAME FROM PSMSGREC A , PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND B.SUBRECORD = 'N' AND B.FIELDNAME IN ( SELECT C.FIELDNAME FROM PSRECFIELDALL C WHERE %DecMult(%Round(%DECDIV(C.USEEDIT,2),0 ) , 2) <> C.USEEDIT AND C.RECNAME = B.RECNAME) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RESPONSE_MSG |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |