NM_FIELD_VW (SQL View)	Index Back
Valid Name Fields Global Naming. Contains the system data defined fields that are valid for Global Names. These fields MUST appear in the NAMEGBL_SBR subrecord.

NM_FIELD_VW

(SQL View)

Valid Name Fields

Global Naming. Contains the system data defined fields that are valid for Global Names. These fields MUST appear in the NAMEGBL_SBR subrecord.

SELECT FIELDNAME , EDITTABLE FROM PSRECFIELD WHERE RECNAME = 'NAMEGBL_SBR' AND FIELDNAME <> 'COUNTRY_NM_FORMAT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NM_FIELD Character(19) VARCHAR2(19) NOT NULL Used to identify which fields are used in the NAMEGBL_SBR for global naming.

2 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NM_FIELD	Character(19)	VARCHAR2(19) NOT NULL	Used to identify which fields are used in the NAMEGBL_SBR for global naming.
2	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table