| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 PTIASPPKGGUID |
Character(36) |
VARCHAR2(36) NOT NULL |
Unique Identifier
|
| PTIASPRPTNO |
Number(10,0) |
DECIMAL(10) NOT NULL |
BUG Number
|
| PTIASPRPTNOUSEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that this BUG was user selected and formed the basis of the requisite calculation
|
| PTIASPRPTNOAPLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates a BUG has already been applied
|
| PTIASPTLSIMPCTFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tools Impact
|
| RELEASELABEL |
Character(50) |
VARCHAR2(50) NOT NULL |
Release Label
00=Core
10=Education and Government
18=Service Industries
19=Comm., Transportation & Util
20=Retail
21=Performance Measurement
22=HealthCare
23=Student Administration
25=U.S. Federal Govt
26=Canadian Govt
30=Intl Translations
32=Netherlands
33=United Kingdom
34=Espanol/Spain
35=France
36=Portuguese
37=Italy
39=German
50=South Africa
60=Latin America Local
61=Mexico
62=Argentina
63=Brazil
81=Japanese
88=Asia/Pacific
99=PeopleSoft Select
|
| PTIASPRPTREQUPG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required For Upgrade
|
| PTIASPRPTCUSTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Impact
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
|
| PTIASPRPTTESTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Exists
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
|
| PTIASPRPTUSEREXCL |
Character(1) |
VARCHAR2(1) NOT NULL |
User Excluded
|