PTADSNAMEPTGROUPNAMEPSGROUPCONTDefault: O
PTPROPNAMESEQNODefault: 1
PSADSPROP_VW |
index back |
|---|
| SELECT PTADSNAME ,PTGROUPNAME ,PSGROUPCONT ,PTPROPNAME , SEQNO , PTPROPVALUE FROM %Table(PSADSGROUPPROP) WHERE PSGROUPCONT = 'O' |
| 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 Code |
| PSGROUPCONT |
Character(4) | VARCHAR2(4) NOT NULL |
Group Content
Default: O |
| PTPROPNAME |
Character(30) | VARCHAR2(30) NOT NULL | Property Code |
| SEQNO |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default: 1 |
| 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 |