| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTIASPPKGGUID |
Character(36) |
VARCHAR2(36) NOT NULL |
Unique Identifier
|
| 2 |
PTIASPRPTNO |
Number(10,0) |
DECIMAL(10) NOT NULL |
BUG Number
|
| 3 |
PTIASPRPTNOUSEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that this BUG was user selected and formed the basis of the requisite calculation
|
| 4 |
PTIASPRPTNOAPLD |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates a BUG has already been applied
|
| 5 |
PTIASPTLSIMPCTFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tools Impact
|
| 6 |
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
|
| 7 |
PTIASPRPTREQUPG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required For Upgrade
|
| 8 |
PTIASPRPTCUSTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Impact
A=Excluded
B=Included
D=Run Calc
N=No Impact
R=Requisite
|
| 9 |
PTIASPRPTTESTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Exists
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
|
| 10 |
PTIASPRPTUSEREXCL |
Character(1) |
VARCHAR2(1) NOT NULL |
User Excluded
|