PTADSGRPPROP_VW

index back

Dataset Group Member property

Defines dataset group member and their properties
SELECT M.PTADSNAME , M.PTGROUPNAME , M.PSGROUPCONT , M.RECNAME , M.FIELDNAME , P.PTPROPNAME , P.SEQNO , P.PTPROPVALUE FROM PSADSGROUPMEMB M LEFT JOIN PSADSGROUPPROP P ON M.PTADSNAME=P.PTADSNAME AND M.PTGROUPNAME=P.PTGROUPNAME AND M.PSGROUPCONT=P.PSGROUPCONT

PeopleSoft Field Name Field Type Column Type Description
PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).

Prompt Table: PSADSDEFN

PTGROUPNAME Character(40) VARCHAR2(40) NOT NULL Group Code

Prompt Table: PSADSGROUP

PSGROUPCONT Character(4) VARCHAR2(4) NOT NULL Group Content
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSADSREC_VW

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

Prompt Table: PSADSGMFLD_VW

PTPROPNAME Character(30) VARCHAR2(30) NOT NULL Property Code
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
PTPROPVALUE Character(254) VARCHAR2(254) NOT NULL Value Code
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20