PROJECTNAMEPrompt Table: PSADSPROJECT_VW
PTADSNAMEPrompt Table: PTADSDEFN_DVW
PSADSPROJADS_VW |
index back |
|---|---|
ADS Project ADS view |
| SELECT DISTINCT B.PROJECTNAME , B.PTADSNAME FROM PSPROJADSBIND B , PSPROJECTITEM I WHERE I.PROJECTNAME = B.PROJECTNAME AND I.OBJECTTYPE = 106 AND I.OBJECTID1 = 173 AND CAST(I.OBJECTVALUE1 AS INTEGER ) = B.PTADSCONTENTID |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PROJECTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Project Name (see PSPROJECTDEFN).
Prompt Table: PSADSPROJECT_VW |
| PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Data Set Name (see PSADSDEFN).
Prompt Table: PTADSDEFN_DVW |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |