PSPTADSRTMG_VW

index back

Datasets with mergeable groups


SELECT AGM.PTADSNAME , AGM.PTGROUPNAME , AGM.RECNAME , AGM.FIELDNAME FROM PSADSGROUPMEMB AGM , PSADSGROUPPROP AGP WHERE AGM.PTGROUPNAME = AGP.PTGROUPNAME AND AGM.PTADSNAME = AGP.PTADSNAME AND AGM.PSGROUPCONT= AGP.PSGROUPCONT AND AGP.PTPROPNAME = 'MERGE' ORDER BY AGM.PTADSNAME, AGM.RECNAME, AGM.FIELDNAME, AGM.PTGROUPNAME

PeopleSoft Field Name Field Type Column Type Description
PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).
PTGROUPNAME Character(40) VARCHAR2(40) NOT NULL Group Name
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20