RQ_DEFECT

(SQL Table)
 Index Back

Defect Record

added sub record 01/15/01 changed default defect type to "DEFC" 1/18/02

  • Related Language Record: RQ_DEFECT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.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

    Default Value: NEXT

    3 R_REPORTED_BY Character(15) VARCHAR2(15) NOT NULL First Reported By .... FK to PERSONAL_DATA

    Prompt Table: RQ_EMPL_PRSN_VW

    4 R_DATE_REPORTED Date(10) DATE NOT NULL Reported date

    Default Value: %Date

    5 R_ST_STATUS_CD Character(4) VARCHAR2(4) NOT NULL STATUS CODE

    Default Value: OPEN

    Prompt Table: RQ_UD_ST_STATUS

    6 R_ST_REASON_CD Character(4) VARCHAR2(4) NOT NULL Status Reason

    Prompt Table: RQ_UD_ST_REASON

    7 R_SYMPTOM_CD Character(4) VARCHAR2(4) NOT NULL Defect Symptom

    Prompt Table: RQ_UD_DEF_SYMPT

    8 R_PROD_IMPACT_CD Character(4) VARCHAR2(4) NOT NULL Porduct Impact
    AFF=Affected - Use Workaround
    DEG=Degraded
    UNA=Unaffected
    UNU=Unusable
    9 R_SEVERITY_LEVEL Character(2) VARCHAR2(2) NOT NULL Defect Severity
    1=High
    2=Medium
    3=Low
    10 R_SUBJECT Character(254) VARCHAR2(254) NOT NULL subject
    11 R_PARENT_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Parent Defect Id

    Prompt Table: RQ_PARENT_DEFCT

    12 R_PROD_RLSE_ID Character(18) VARCHAR2(18) NOT NULL Product Release ID / Product ID. 05/19/2003 Increased field length from 15 to 18 in order to be compatible with field PRODUCT_ID.

    Prompt Table: RQ_PROD_DESC_VW

    13 R_PHASE_INTRO_CD Character(4) VARCHAR2(4) NOT NULL Phase Introduced in
    ALPH=Alpha
    ANAL=Analysis/Design
    BETA=Beta
    CONC=Concept
    IMPL=Implementation
    MAIN=Maintenance
    PROD=Production
    REQU=Requirements
    RETI=Retirement
    14 R_PRODUCTION_ID Character(15) VARCHAR2(15) NOT NULL Production Identification number for Quality Application

    Prompt Table: RQ_PROD_VERS_VW

    15 R_DUPL_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Duplicate Defect Identification

    Prompt Table: RQ_DEFECT_SRCH

    16 R_REPEATABILITY_CD Character(4) VARCHAR2(4) NOT NULL Repeat
    INTE=Intermittent
    ONCE=One time occurence
    RECU=Recurring
    REPO=Reproducible
    17 R_SUSPECTED_CD Character(4) VARCHAR2(4) NOT NULL suspicious

    Prompt Table: RQ_UD_DEF_SUSPC

    18 R_VOID_SW Character(1) VARCHAR2(1) NOT NULL Defect

    Y/N Table Edit

    19 R_PRIORITY_CODE Character(2) VARCHAR2(2) NOT NULL Priority
    1=High
    2=Medium
    3=Low

    Default Value: 2

    20 R_DEFECT_TYPE Character(4) VARCHAR2(4) NOT NULL Defect Type
    DEFC=Defect
    ENHC=Enhancement

    Default Value: DEFC

    21 R_XFR_TO_VENDOR_ID Character(15) VARCHAR2(15) NOT NULL Defect
    22 R_VENDORS_CASE_NBR Character(20) VARCHAR2(20) NOT NULL Defect Vendors Case Identification
    23 R_TARGET_VERSION Character(10) VARCHAR2(10) NOT NULL Defect target Version
    24 R_FIXED_PROD_RLSE Character(15) VARCHAR2(15) NOT NULL Product Release where Fix was made
    25 R_DATE_RESOLVED Date(10) DATE Date resolved
    26 R_FAIL_VERIFIED_BY Character(15) VARCHAR2(15) NOT NULL Defect Verified Person

    Prompt Table: RQ_EMPL_PRSN_VW

    27 R_DATE_FAIL_VERIFY Date(10) DATE Date the Defect was Verified
    28 R_FIX_VERIFIED_BY Character(15) VARCHAR2(15) NOT NULL Fix verified by this person

    Prompt Table: RQ_EMPL_PRSN_VW

    29 R_DATE_FIX_VERIFY Date(10) DATE Date the Fix was Verified
    30 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
    31 R_OS_VERSION Character(15) VARCHAR2(15) NOT NULL Operating System Version
    32 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
    33 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
    34 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
    35 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
    36 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    37 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    38 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    39 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    40 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.
    41 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    42 R_DELETED_SW Character(1) VARCHAR2(1) NOT NULL Deleted indicator
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    43 DESCRLONG Long Character CLOB Long Description
    44 R_FIXED_METHOD Character(4) VARCHAR2(4) NOT NULL Resolution Method
    CANC=Cancelled
    DEFR=Deferred
    IMPL=Fix Implemented
    WRKA=Work Around Used
    45 R_COMPONENT_ID Character(15) VARCHAR2(15) NOT NULL COMPONENT ID
    46 R_ASSGN_PRSN_ID Character(15) VARCHAR2(15) NOT NULL Defect Assigned to Person Id
    47 R_ASSGN_NAME Character(80) VARCHAR2(80) NOT NULL Defect Assigned To Name
    48 R_ST_ST_RSN_CD Character(4) VARCHAR2(4) NOT NULL Status State Reason Code

    Prompt Table: RQ_UD_ST_ST_RSN

    49 R_ENV_LABEL Character(30) VARCHAR2(30) NOT NULL Environment Label in Quality application