PTIAAUARTIDPTIAAUARTDL_VW(SQL View) |
Index Back |
|---|---|
Downloaded artifacts |
| SELECT AD.PTIAAUARTID ,AD.PTIAAUARTNAME , AD.PTIAAUPRONAME %Concat ' ' %Concat AD.PTIASPAPPVERSION , AD.PTIAAUARTTYPE , AD.PTIAAUARTFILESIZE , %DateTimeOut(AM.PTIAAUARTAVALDTTM) FROM PS_PTIAAUARTDAT AD LEFT JOIN PS_PTIAAUARTMANLOG AM ON AD.PTIAAUARTID = AM.PTIAAUARTID WHERE AD.PTIAAUARTTYPE <> 'LOCAL - PRP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIAAUARTID |
Character(36) | VARCHAR2(36) NOT NULL | Artifact ID |
| 2 | PTIAAUARTNAME | Character(254) | VARCHAR2(254) NOT NULL | Artifact Name |
| 3 | PTIAAUPRONAME | Character(254) | VARCHAR2(254) NOT NULL | Product Name |
| 4 | PTIAAUARTTYPE | Character(64) | VARCHAR2(64) NOT NULL | Artifact Type |
| 5 | PTIAAUARTFILESIZE | Character(64) | VARCHAR2(64) NOT NULL | File Size |
| 6 | PTIAAU_DTTM_STAMP | DateTime(26) | TIMESTAMP | Downloaded Datetime |