PTIASPPKGGUIDPTIATESTNAMEDefault Value: 1
Default Value: 1
Default Value: 1
Default Value: 1
N=No
Y=Yes
Default Value: Y
PTIASPPKGTESTVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT PTIASPPKGGUID ,PTIATESTNAME ,PTIATESTDESC ,PTIATESTCRIT1 ,PTIATESTCRIT2 ,PTIATESTCRIT3 ,PTIATESTCRIT4 ,PTIATESTPKGINCLUDE FROM PS_PTIASPPKGTEST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPPKGGUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 2 | PTIATESTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Test Name |
| 3 | PTIATESTDESC | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 4 | PTIATESTCRIT1 | Number(10,0) | DECIMAL(10) NOT NULL |
Test Criteria 1
Default Value: 1 |
| 5 | PTIATESTCRIT2 | Number(10,0) | DECIMAL(10) NOT NULL |
Test Criteria 2
Default Value: 1 |
| 6 | PTIATESTCRIT3 | Number(10,0) | DECIMAL(10) NOT NULL |
Test Criteria 3
Default Value: 1 |
| 7 | PTIATESTCRIT4 | Number(10,0) | DECIMAL(10) NOT NULL |
Test Criteria 4
Default Value: 1 |
| 8 | PTIATESTPKGINCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Include in Package
N=No Y=Yes Default Value: Y |