SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
R_PRODUCTION_IDR_COMPONENT_IDPrompt Table: RQ_ROOT_CDFN_VW
RQ_PROD_ADD(SQL View) |
Index Back |
|---|---|
Component Definition Recordadd record for production version in quality |
| SELECT SETID , R_PRODUCTION_ID , R_COMPONENT_ID , R_IDENTIFICATION FROM PS_RQ_PRODUCTION |
| # | 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 | R_IDENTIFICATION | Character(40) | VARCHAR2(40) NOT NULL | Id |