FIELDNAMENAME_RECDTLVW(SQL View) |
Index Back |
|---|---|
Record field prompt viewView joining PSRECFIELD to PSDBFLDLABL, to be used for prompting. |
| SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B WHERE A.RECNAME = 'NAMEGBL_SBR' AND A.FIELDNAME NOT IN ('COUNTRY_NM_FORMAT','NAME','NAME_DISPLAY','NAME_FORMAL','LAST_NAME_SRCH', 'FIRST_NAME_SRCH', 'SECOND_LAST_SRCH') AND B.FIELDNAME=A.FIELDNAME AND B.DEFAULT_LABEL = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | FIELDLABEL | Character(30) | VARCHAR2(30) NOT NULL | Field Label |