NAME_RECDTLVW

(SQL View)
 Index Back

Record field prompt view

View 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*/ SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B WHERE a.RECNAME IN ('NAMEGBL_SBR','NAMES') AND a.FIELDNAME NOT IN ('COUNTRY_NM_FORMAT','NAME','NAME_DISPLAY','NAME_FORMAL','LAST_NAME_SRCH', 'FIRST_NAME_SRCH', 'SECOND_LAST_SRCH', 'EFFDT', 'EFF_STATUS', 'EMPLID', 'LASTUPDDTTM','LASTUPDOPRID', 'NAME_DISPLAY_SRCH', 'NAME_TYPE','PREF_FIRST_NM_SRCH','PREF_LAST_NM_SRCH','PREF_MIDL_NM_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