PTIACPTMPLTPTIACPTMPLTDEFN(SQL Table) |
Index Back |
|---|---|
CA Template Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIACPTMPLT |
Character(50) | VARCHAR2(50) NOT NULL | Structure Name |
| 2 | PTIACPTMPLTTYPE | Character(10) | VARCHAR2(10) NOT NULL | The source could be from a UOW or Manually defined |
| 3 | PTIASPRPTNO | Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | PTIACPTMPLTDTTM | DateTime(26) | TIMESTAMP | Structure Date. If this Strucutre is based on a UOW relating to BUG, then this is the BUG fix date. The Structure Date is used for aggregation of BUG fixes |