PNLGRPNAMEMARKETSEQNO0=Level 0
1=Level 1
Default Value: 0
Prompt Table: WL_RECORD_VW
Prompt Table: WL_RECORD2_VW
Prompt Table: PSRECFIELD
Prompt Table: WL_FLDLABEL_VW
WL_DISTR_GRP(SQL Table) |
Index Back |
|---|---|
Distribution GroupsHolds the distribution group definition fields for the component notification templates. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | WL_OCCURS | Character(1) | VARCHAR2(1) NOT NULL |
Occurs Level
0=Level 0 1=Level 1 Default Value: 0 |
| 5 | WL_RECNAMEPRIMARY | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name
Prompt Table: WL_RECORD_VW |
| 6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: WL_RECORD2_VW |
| 7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELD |
| 8 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table: WL_FLDLABEL_VW |
| 9 | WL_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 10 | WL_ADDED_DTTM | DateTime(26) | TIMESTAMP | Date/Time Created |
| 11 | WL_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By |
| 12 | WL_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | Date Modified |