RC_ASSOC_LNK_VW (SQL View)	Index Back
Actions-Links - SS Manage Case View for joining information from the following tables : RC_ASSOC_TABLE and RC_LINK_TBL for showing actions taken (links) in Manage Case Page.

RC_ASSOC_LNK_VW

(SQL View)

Actions-Links - SS Manage Case

View for joining information from the following tables : RC_ASSOC_TABLE and RC_LINK_TBL for showing actions taken (links) in Manage Case Page.

SELECT A.CASE_ID , A.BUSINESS_UNIT , A.SEQNUM , A.TYPE , A.LINK_CATEGORY , A.LINK_VERSION , A.RC_LINK , A.ROW_ADDED_OPRID , A.ROW_ADDED_DTTM , B.RC_SS_IND , B.RC_DESCR_SS , A.SYNCID , A.RECORDNAME FROM PS_RC_ASSOC_TABLE A , PS_RC_LINK_TBL B WHERE A.LINK_CATEGORY = B.LINK_CATEGORY AND A.LINK_VERSION = B.LINK_VERSION AND A.RC_LINK = B.RC_LINK AND B.RC_SS_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RC_NONVW

3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 TYPE Character(4) VARCHAR2(4) NOT NULL Association Types

5 LINK_CATEGORY Character(5) VARCHAR2(5) NOT NULL This identifies the category that the link will be displayed under

6 LINK_VERSION Character(4) VARCHAR2(4) NOT NULL Version of Human Resource Management System application.
12.1=EBS 12.1
8.0=8.0 SP1
8.3=8.3
8.8=8.8
8.9=8.9
9.0=9.0
9.1=9.1
9.2=9.2
OTH=Other

7 RC_LINK Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated

8 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

9 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

10 RC_SS_IND Character(1) VARCHAR2(1) NOT NULL Defines if this is a self service transaction or not.

11 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages

12 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.

13 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_VENDOR_EC
06=ITM_VNDR_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
11=MANUFACTURER_EC
12=ITEM_MFG_EC
13=EN_REVISION_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RC_NONVW
3	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	TYPE	Character(4)	VARCHAR2(4) NOT NULL	Association Types
5	LINK_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	This identifies the category that the link will be displayed under
6	LINK_VERSION	Character(4)	VARCHAR2(4) NOT NULL	Version of Human Resource Management System application. 12.1=EBS 12.1 8.0=8.0 SP1 8.3=8.3 8.8=8.8 8.9=8.9 9.0=9.0 9.1=9.1 9.2=9.2 OTH=Other
7	RC_LINK	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated
8	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
9	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
10	RC_SS_IND	Character(1)	VARCHAR2(1) NOT NULL	Defines if this is a self service transaction or not.
11	RC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Description to be shown on Self-Service Pages
12	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.
13	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_VENDOR_EC 06=ITM_VNDR_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 11=MANUFACTURER_EC 12=ITEM_MFG_EC 13=EN_REVISION_EC