COUNTRYPIN_CATEGORYENTRY_TYPE_ELEMPIN_ELEM_NUMPrompt Table: GP_PIN_VAR_VW
LANGUAGE_CDGP_NRP_DCL_VW(SQL View) |
Index Back |
|---|---|
Assignment Setup Detail LangNRP view for GP ED DTL C LNG |
| SELECT COUNTRY ,PIN_CATEGORY ,ENTRY_TYPE_ELEM ,PIN_ELEM_NUM + 50000000 ,LANGUAGE_CD ,GP_ED_LABEL FROM PS_GP_ED_DTL_C_LNG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | PIN_CATEGORY |
Character(4) | VARCHAR2(4) NOT NULL | Element Category |
| 3 | ENTRY_TYPE_ELEM |
Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 4 | PIN_ELEM_NUM |
Number(8,0) | INTEGER NOT NULL |
Element Number
Prompt Table: GP_PIN_VAR_VW |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | GP_ED_LABEL | Character(30) | VARCHAR2(30) NOT NULL | User Field 1-Label, this label will be displayed in the E/D Assignment Pages |