PTADSNAMEPrompt Table: PSADSDEFN
PTGROUPNAMEPrompt Table: PSADSGROUP
PSGROUPCONTRECNAMEPrompt Table: PSADSREC_VW
FIELDNAMEPrompt Table: PSADSGMFLD_VW
PTPROPNAMESEQNOPTADSGRPPROP_VW(SQL View) |
Index Back |
|---|---|
Dataset Group Member propertyDefines 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Data Set Name (see PSADSDEFN).
Prompt Table: PSADSDEFN |
| 2 | PTGROUPNAME |
Character(40) | VARCHAR2(40) NOT NULL |
Group Code
Prompt Table: PSADSGROUP |
| 3 | PSGROUPCONT |
Character(4) | VARCHAR2(4) NOT NULL | Group Content |
| 4 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSADSREC_VW |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSADSGMFLD_VW |
| 6 | PTPROPNAME |
Character(30) | VARCHAR2(30) NOT NULL | Property Code |
| 7 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 8 | PTPROPVALUE | Character(254) | VARCHAR2(254) NOT NULL | Value Code |