CONFIG_CODERC_BS_INSTANCEFORM_INSTANCE_IDCASE_IDBUSINESS_UNITRBF_APP_ISS_VW(SQL View) |
Index Back |
|---|---|
Case information ViewThis view brings the associated script/configurator from case |
| SELECT CONFIG_CODE , RC_BS_INSTANCE , FORM_INSTANCE_ID , CASE_ID , BUSINESS_UNIT FROM PS_RC_CASE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 2 | RC_BS_INSTANCE |
Number(15,0) | DECIMAL(15) NOT NULL | RC_BS_INSTANCE |
| 3 | FORM_INSTANCE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Instance ID |
| 4 | CASE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |