PTADSNAMEPrompt Table: PSADSDEFN
PTGROUPNAMEPrompt Table: PSADSGROUP
PSGROUPCONTRECNAMEPrompt Table: PSADSREC_VW
FIELDNAMEPrompt Table: PSADSGMFLD_VW
PTPROPNAMESEQNOPTADSGRPPROP_VW |
index back |
|---|---|
Dataset Group Member property |
| 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 |