RQ_PRODUCTION

(SQL Table)
 Index Back

Production record

Quality application added sub record 01/15/01

  • Related Language Record: RQ_PRODUCTN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 R_PRODUCTION_ID Character(15) VARCHAR2(15) NOT NULL Production Identification number for Quality Application
    3 R_COMPONENT_ID Character(15) VARCHAR2(15) NOT NULL COMPONENT ID

    Prompt Table: RQ_ROOT_CDFN_VW

    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RQ_PROD_DESC_V2

    5 R_IDENTIFICATION Character(40) VARCHAR2(40) NOT NULL Id
    6 R_PREDECESSOR_ID Character(15) VARCHAR2(15) NOT NULL Predecessor ID
    7 R_SUCCESSOR_ID Character(15) VARCHAR2(15) NOT NULL Successor ID
    8 R_PRODUCTION_DATE Date(10) DATE Production Date
    9 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
    10 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
    11 R_PHASE_INTRO_DATE Date(10) DATE Phase introduced date
    12 R_HEAD_SW Character(1) VARCHAR2(1) NOT NULL Head
    13 R_LINES_CHANGED Number(9,0) DECIMAL(9) NOT NULL Lines Changed
    14 R_LINES_ADDED Number(9,0) DECIMAL(9) NOT NULL Lines Added
    15 R_LINES_DELETED Number(9,0) DECIMAL(9) NOT NULL Lines Deleted
    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