HCSC_NOTIF_LINK_NMPrompt Table: HCSC_LINK_SETUP
PNLGRPNAMEPrompt Table: PSPNLGRPDFN_VW1
MARKETPrompt Table: HCSC_PNL_MKT_VW
HCSC_LINK_VW(SQL View) |
Index Back |
|---|---|
Link listEmbedded link list for adhoc notification |
| SELECT S.HCSC_NOTIF_LINK_NM ,A.PNLGRPNAME ,A.MARKET FROM PS_HCSC_LINK_SETUP S ,PS_HCSC_LINK_ASSIG A ,PS_HCSC_LINK_SRCH B WHERE A.HCSC_NOTIF_LINK_NM = S.HCSC_NOTIF_LINK_NM AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_NOTIF_LINK_NM |
Character(30) | VARCHAR2(30) NOT NULL |
Name for embedded link on adhoc notification
Prompt Table: HCSC_LINK_SETUP |
| 2 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSPNLGRPDFN_VW1 |
| 3 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL |
Market
Prompt Table: HCSC_PNL_MKT_VW |