PNLGRPNAMEPrompt Table: HCSC_PNLGRP_FVW
MARKETPrompt Table: HCSC_MKT_LKP_VW
Prompt Table: HCSC_CAT_TBL
Default Value: N
HCSC_CAT_COMP(SQL Table) |
Index Back |
|---|---|
Notif Category Component TableNotification Category and Component mapping Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: HCSC_PNLGRP_FVW |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL |
Market
Prompt Table: HCSC_MKT_LKP_VW |
| 3 | HCSC_CATEGORY_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Notification Category Name
Prompt Table: HCSC_CAT_TBL |
| 4 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |