PTIAAUARTIDPTIAAUARTLC_VW(SQL View) |
Index Back |
|---|---|
Local ArtifactsManually uploaded artifacts |
| SELECT AD.PTIAAUARTID , AD.PTIASPRPTNO , AD.PTIASPPRPNAME ,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 PTIAAUARTTYPE = 'LOCAL - PRP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIAAUARTID |
Character(36) | VARCHAR2(36) NOT NULL | Artifact ID |
| 2 | PTIASPRPTNO | Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
| 3 | PTIASPPRPNAME | Character(30) | VARCHAR2(30) NOT NULL | PRP Name |
| 4 | PTIAAUARTNAME | Character(254) | VARCHAR2(254) NOT NULL | Artifact Name |
| 5 | PTIAAUPRONAME | Character(254) | VARCHAR2(254) NOT NULL | Product Name |
| 6 | PTIAAUARTTYPE | Character(64) | VARCHAR2(64) NOT NULL | Artifact Type |
| 7 | PTIAAUARTFILESIZE | Character(64) | VARCHAR2(64) NOT NULL | File Size |
| 8 | PTIAAU_DTTM_STAMP | DateTime(26) | TIMESTAMP | Downloaded Datetime |