TRGR_EVENT_IDCOUNTRYEFFDTDefault Value: %Date
PIN_NUMPrompt Table: %RECNAME_EDIT
Prompt Table: GP_ENT_SEGEV_VW
GP_NRP_SEVLT_VW(SQL View) |
Index Back |
|---|---|
Segment Event List - ViewSegmentation Event List - Packaging view |
| SELECT TRGR_EVENT_ID ,COUNTRY ,EFFDT ,PIN_NUM + 50000000 ,ENTRY_TYPE_ID FROM PS_GP_SEG_EVT_LST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRGR_EVENT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Trigger Event ID |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %Date |
| 4 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %RECNAME_EDIT |
| 5 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GP_ENT_SEGEV_VW |