GP_NRP_ECD_VW(SQL View) |
Index Back |
|---|---|
Setup by Category DetailNRP view for GP ED SET DTL C |
| SELECT COUNTRY ,PIN_CATEGORY ,ENTRY_TYPE_ELEM ,PIN_ELEM_NUM + 50000000 ,SEQNUM ,ENTRY_TYPE_ELEM2 ,GP_ED_REQUIRED ,GP_EDITTYPE ,PROMPTVIEW ,FLD_FMT ,GP_LABEL_TYPE_D ,GP_ED_LABEL ,GP_OVRD_TYPE FROM PS_GP_ED_SET_DTL_C |
| # | 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 |
| 5 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | ENTRY_TYPE_ELEM2 | Character(3) | VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table: GP_ENT_SOVR4_VW |
| 7 | GP_ED_REQUIRED | Character(2) | VARCHAR2(2) NOT NULL |
Indicates whether something is required for ED assignment, for PI or for both. Has translate values
10=Both 20=Element Assignment 30=Positive Input |
| 8 | GP_EDITTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Used for the Edit Type in Elemet setup page
10=Prompt 20=No Prompt 30=Yes / No 40=Xlat Value |
| 9 | PROMPTVIEW | Character(18) | VARCHAR2(18) NOT NULL | Element Entry Prompt View |
| 10 | FLD_FMT | Character(1) | VARCHAR2(1) NOT NULL |
Field format for Global Payroll elements
1=Character 2=Date 3=Monetary 4=Decimal 5=Element Pointer 6=Not Applicable |
| 11 | GP_LABEL_TYPE_D | Character(2) | VARCHAR2(2) NOT NULL |
Label Type D is used for labeling SOVR on configurable ED and PI pages.
10=Static Text 20=Use Element Name 30=Use Description |
| 12 | GP_ED_LABEL | Character(30) | VARCHAR2(30) NOT NULL | User Field 1-Label, this label will be displayed in the E/D Assignment Pages |
| 13 | GP_OVRD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Indicates whether an override is used in Positive Input, ED Assignment or Both
10=Both 20=Element Assignment 30=Positive Input Default Value: 10 |