| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_CASE |
Character(30) |
VARCHAR2(30) NOT NULL |
BTF Test Case
|
| 2 |
COMPARE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected)
2=Expected data not in Results
3=Unexpected data in Results
|
| 3 |
COMPARE_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals
E=Expected
|
| 4 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 5 |
SFTWR_TITLE |
Character(50) |
VARCHAR2(50) NOT NULL |
Software Title
|
| 6 |
RULE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Rule ID
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 8 |
SFTWR_INSTALL_DT |
Date(10) |
DATE |
Software Installation Date
|
| 9 |
SFTWR_ERR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Software Error Flag
N=No Errors/Exceptions
O=Over The Limit
P=Processed / In Process
R=Resolved
U=Unauthorized Install
W=Auto Processed Unauthorized
X=Auto Processed Over Limit
Y=Processed Over the Limit
Z=Processed Unauthorized Install
|
| 10 |
IT_GRP_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee Group Id
|
| 11 |
GRP_OWNER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Group Owner Id
|
| 12 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 13 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
|
| 14 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|