GP_NRP_ESP_VW

(SQL View)
 Index Back

Setup By Element

NRP view for GP_ED_SETUP

SELECT COUNTRY ,PIN_NUM + 50000000 ,GP_USE_CUST_COMP ,GP_CREF_NAME ,GP_LABEL_TYPE ,MESSAGE_SET_NBR ,MESSAGE_NBR ,GP_LABEL_NAME ,GP_DISP_ADL_OVRD FROM PS_GP_ED_SETUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
3 GP_USE_CUST_COMP Character(2) VARCHAR2(2) NOT NULL Radio Button to set if the element assignment uses a customer defined component
10=Use Alternate Page
20=Use Standard Page

Y/N Table Edit

4 GP_CREF_NAME Character(30) VARCHAR2(30) NOT NULL Content Reference Name
5 GP_LABEL_TYPE Character(4) VARCHAR2(4) NOT NULL Used for Label Type eaider Message Catalog or static Text
10=Static Text
20=Message Catalog
6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
8 GP_LABEL_NAME Character(30) VARCHAR2(30) NOT NULL Label name.
9 GP_DISP_ADL_OVRD Character(1) VARCHAR2(1) NOT NULL Displa Additional Overrides Chek Box

Y/N Table Edit