GP_NRP_ESD_VW(SQL View) |
Index Back |
|---|---|
Assignment Setup NRPNon rule packager view for GPUS_ELEM_S_DET |
| SELECT COUNTRY , PIN_NUM + 50000000 ,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 |
| # | 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 | PIN_ELEM_NUM |
Number(8,0) | INTEGER NOT NULL | Element Number |
| 4 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | ENTRY_TYPE_ELEM2 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
| 6 | 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 |
| 7 | 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 |
| 8 | PROMPTVIEW | Character(18) | VARCHAR2(18) NOT NULL | Element Entry Prompt View |
| 9 | 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 |
| 10 | 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 |
| 11 | GP_ED_LABEL | Character(30) | VARCHAR2(30) NOT NULL | User Field 1-Label, this label will be displayed in the E/D Assignment Pages |
| 12 | 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 |