DSMAPNAMERECNAMEFIELDNAMEHCDI_MSGFLD_VW(SQL View) |
Index Back |
|---|---|
Directories - Rec/Field viewView to display all the fields of a record in an app message |
| SELECT D.DSMAPNAME , A.RECNAME , B.FIELDNAME FROM PSRECFIELD A , PSRECFIELD B , PS_HCDI_MSGREC_VW D WHERE D.RECNAME = A.RECNAME AND ((B.RECNAME = %Substring(A.FIELDNAME,1,15) AND A.SUBRECORD = 'Y') OR (A.RECNAME = B.RECNAME AND A.SUBRECORD = 'N' AND A.FIELDNAME = B.FIELDNAME)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DSMAPNAME |
Character(50) | VARCHAR2(50) NOT NULL | Directory Entry Map Name |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |