WL_DISTR_GRP

index back

Distribution Groups

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

PeopleSoft Field NameField TypeColumn TypeDescription
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
SEQNONumber(5,0)INTEGER NOT NULLSequence Number
WL_OCCURSCharacter(1)VARCHAR2(1) NOT NULLOccurs Level
0=Level 0
1=Level 1

Default: 0

WL_RECNAMEPRIMARYCharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name

Prompt Table: WL_RECORD_VW

RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: WL_RECORD2_VW

FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

Prompt Table: PSRECFIELD

LABEL_IDCharacter(18)VARCHAR2(18) NOT NULLLABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

Prompt Table: WL_FLDLABEL_VW

WL_ADDED_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAdded By
WL_ADDED_DTTMDateTime(26)TIMESTAMPDate/Time Created
WL_LASTMANT_OPRIDCharacter(30)VARCHAR2(30) NOT NULLLast Maintained By
WL_LASTMANT_DTTMDateTime(26)TIMESTAMPDate Modified
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19