GP_ED_SETUP_CAT(SQL Table) |
Index Back |
---|---|
Setup By CategorySetup by Category |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_PSLP_CTRY_VW |
2 | PIN_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL |
Element Category
Prompt Table: GP_PIN_CAT_C_VW |
3 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table: GP_ENT_E_D_VW |
4 | 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 Default Value: 20 |
5 | GP_CREF_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Content Reference Name
Prompt Table: GP_PRTLOBJ_VW |
6 | 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 Default Value: 20 |
7 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: MSG_SET_VW |
8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: MSG_CAT_VW |
9 | GP_LABEL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Label name. |
10 | GP_DISP_ADL_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Displa Additional Overrides Chek Box
Y/N Table Edit Default Value: Y |