| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RQ_NONVW
|
| 2 |
R_DEFECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Quality Defect Identification key unique by business unit
|
| 3 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 4 |
R_TEST_ENV_LABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Defect tested Enviornment
|
| 5 |
R_TEST_ENV_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Defect Tested Environment
NREP=Not Reproduced
PREP=Partially Reproduced
REP=Reproduced
|
| 6 |
R_OS_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Operating System Code
AIX=AIX
DOS=MS DOS
HPUX=HP/UX
LINX=Linux
MAC=Macintosh
OTHR=Other
SUN=Solaris
UNIX=Unix
VMS=VMS
W200=Windows 2000
W31=Windows 3.1
W95=Windows 95
W98=Windows 98
WNT=Windows NT
|
| 7 |
R_OS_VERSION |
Character(15) |
VARCHAR2(15) NOT NULL |
Operating System Version
|
| 8 |
R_ENVIRONMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Environment Identification
DB2=DB2
DBAS=dBASE
INFS=Informix SE
INFT=Informix Turbo
MSQL=MS SQL Server
ORAC=Oracle
PARA=Paradox
SANY=SQL Anywhere
SSQL=Sybase SQL-Server
|
| 9 |
R_PLATFORM_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Platform code
AS40=AS 400
HP90=HP 9000
MAC=Macintosh
P286=PC 286
P386=PC 386
P486=PC 486
PEN1=Pentium
PEN2=Pentium II
PEN3=Pentium III
PEN4=Pentium PRO
RS60=IBM RS6000
SUN=SUN SPARC IPX
VAX=VAX
|
| 10 |
R_NETWORK_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Network Identification
BANY=Banyan Vines
BNW=Beame and Whiteside
NET1=NetWare v2.x
NET2=NetWare v3.x
OTCP=Other TCP/IP
PNFS=PC-NFS
PTCP=PC-TCP
WTCP=Winsock TCP/IP
|
| 11 |
R_UI_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Defect User interface
CHAR=Character-Based
MAC=Macintosh
MOTI=Motif
OPEN=Open Look
PMGR=Presentation Manager
W31=Windows 3.1
W95=Windows 95
W98=Windows 98
|
| 12 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
RQ_EMPL_PRSN_VW
|
| 13 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 14 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 15 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 16 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 17 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 18 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 19 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|