RF_INST_LINK_VW(SQL View) |
Index Back |
|---|---|
Installed Links viewView used for getting installed links |
| SELECT instlink.setid , instlink.inst_link_id , instlink.inst_prod_id , instlink.rel_inst_prod_id , instlink.inst_ext_svc_id , instlink.prod_rel_type , status.rb_xlatlongname , instlink.disconnect_date , instlink.installed_date ,instlink.inst_link_status FROM ps_rf_inst_link instlink , PS_RF_LINK_STATUS status WHERE instlink.setid = status.setid AND instlink.inst_link_status = status.fieldvalue |
| # | 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. |
| 2 | INST_LINK_ID | Character(20) | VARCHAR2(20) NOT NULL | Field used for storing installed link id information |
| 3 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 4 | REL_INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | Field used for storing releated installed product information |
| 5 | INST_EXT_SVC_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 6 | PROD_REL_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Product Relationship Type |
| 7 | RB_XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 8 | DISCONNECT_DATE | Date(10) | DATE | Disconnect Date |
| 9 | INSTALLED_DATE | Date(10) | DATE | Field used for storing Installed Date of Installed product |
| 10 | INST_LINK_STATUS | Character(4) | VARCHAR2(4) NOT NULL | Field used for storing installed link status information |