index back

Distribution Groups

Holds the distribution group definition fields for the component notification templates.

PeopleSoft Field Name Field Type Column Type Description
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
WL_OCCURS Character(1) VARCHAR2(1) NOT NULL Occurs Level
0=Level 0
1=Level 1

Default: 0

WL_RECNAMEPRIMARY Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

Prompt Table: WL_RECORD_VW

RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: WL_RECORD2_VW

FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSRECFIELD

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

WL_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
WL_ADDED_DTTM DateTime(26) TIMESTAMP Date/Time Created
WL_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19