GB_RF_VALUE_VW (SQL View)	Index Back
GB Rec Fld - Fields View Prompt view for the field GB_PRE_REQ_FLD.GB_PROMPT_FIELD. It makes sure that the user can only select fields that are allowed for the equivalent record fields. NOTE that the user can only select fields that are defined in the new subrecord GB_VALUES_SBR

GB_RF_VALUE_VW

(SQL View)

GB Rec Fld - Fields View

Prompt view for the field GB_PRE_REQ_FLD.GB_PROMPT_FIELD. It makes sure that the user can only select fields that are allowed for the equivalent record fields. NOTE that the user can only select fields that are defined in the new subrecord GB_VALUES_SBR

SELECT A.FIELDNAME , B.LONGNAME , A.EDITTABLE FROM PSRECFIELDDB A , PSDBFLDLABL B WHERE A.RECNAME = 'GB_VALUES_SBR' AND A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1

Related Language Record: GB_RF_VALVW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL Required for Prompt

2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_PROMPT_FIELD	Character(18)	VARCHAR2(18) NOT NULL	Required for Prompt
2	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
3	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table