| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTIASPRPTNO |
Number(10,0) |
DECIMAL(10) NOT NULL |
BUG Number
|
| 2 |
PTIASPRPTNOPRE |
Number(10,0) |
DECIMAL(10) NOT NULL |
BUG Number
|
| 3 |
PTIASPSPVERS |
Number(5,0) |
INTEGER NOT NULL |
Numeric value for Patch Database Version Number
|
| 4 |
PTIASPSPVERSPRE |
Number(5,0) |
INTEGER NOT NULL |
Numeric value for Patch Database Version Number
|
| 5 |
PTIASPREQTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
This specifies the Requisite Type. The type might be Calculated, Functional etc.
|
| 6 |
PTIASPREQDIRECTN |
Character(4) |
VARCHAR2(4) NOT NULL |
This is the direction of the requisite, valid values would bu UP, DOWN, BOTH
|