PROJECTNAMEPrompt Table: PSADSPROJECT_VW
PTADSNAMEPrompt Table: PTADSDEFN_DVW
PSADSPROJADS_VW(SQL View) |
Index Back |
|---|---|
ADS Project ADS viewLists distinct ADS names in a project |
| 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Project Name (see PSPROJECTDEFN).
Prompt Table: PSADSPROJECT_VW |
| 2 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Data Set Name (see PSADSDEFN).
Prompt Table: PTADSDEFN_DVW |