RQ_FIX

(SQL Table)
 Index Back

Fix record

Quality application Fix record definition added sub record 01/15/01

  • Related Language Record: RQ_FIX_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_FIX_ID Character(15) VARCHAR2(15) NOT NULL Fix Identification

    Default Value: NEXT

    3 R_SUBJECT Character(254) VARCHAR2(254) NOT NULL subject
    4 R_COMPLEXITY_LEVEL Character(2) VARCHAR2(2) NOT NULL the level of complexity this defect is ranked as
    1=Trivial
    2=Easy
    3=Medium
    4=Very Complex
    5 R_CONFIDENCE_LEVEL Character(2) VARCHAR2(2) NOT NULL Quality Fix confidence level indicator
    H=High
    L=Low
    M=Medium
    6 R_ACTUAL_FIX_TIME Number(7,2) DECIMAL(6,2) NOT NULL Fix Time (Hrs.Mins)
    7 R_FIX_TEST_STATUS Character(4) VARCHAR2(4) NOT NULL testing status of the fix in quality management
    FAIL=Failed
    IPRG=In Progress
    PASS=Passed
    PEND=Pending
    PPAS=Partially Passed
    8 R_INTRODUCED_IN Character(15) VARCHAR2(15) NOT NULL defines environment in which this defect was found

    Prompt Table: RQ_PROD_VERS_VW

    9 R_1ST_FOUND_IN Character(15) VARCHAR2(15) NOT NULL defect problem found in 1st environment

    Prompt Table: RQ_PROD_VERS_VW

    10 R_FIXED_IN Character(15) VARCHAR2(15) NOT NULL defines the environment in which this fix was done

    Prompt Table: RQ_PROD_VERS_VW

    11 R_DATE_FIXED Date(10) DATE Fixed Date
    12 R_FIX_VERIFIED_IN Character(15) VARCHAR2(15) NOT NULL version of production used to verify the fix

    Prompt Table: RQ_PROD_VERS_VW

    13 R_VERIFIED_BY Character(15) VARCHAR2(15) NOT NULL Verified By

    Prompt Table: RQ_EMPL_PRSN_VW

    14 R_DATE_VERIFIED Date(10) DATE Date Verified
    15 R_EXT_INSERT_SW Character(1) VARCHAR2(1) NOT NULL External Insert

    Y/N Table Edit

    Default Value: N

    16 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    17 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    18 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    19 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    20 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.
    21 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    22 DESCRLONG Long Character CLOB Long Description
    23 R_FIX_COMPLETED_BY Character(15) VARCHAR2(15) NOT NULL Fix completed By this person

    Prompt Table: RQ_EMPL_PRSN_VW

    24 R_FIX_COMPLETED_DT Date(10) DATE Fix Completed Date
    25 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

    26 R_COMPONENT_ID Character(15) VARCHAR2(15) NOT NULL COMPONENT ID