RC_ASSOC_T_HST (SQL Table)	Index Back
Case Associtations This record is used to store the related objects like RMA,SO,Lead, Branch Script and Business Project

RC_ASSOC_T_HST

(SQL Table)

Case Associtations

This record is used to store the related objects like RMA,SO,Lead, Branch Script and Business Project

Parent record: RC_CASE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

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

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

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

7 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

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

9 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.

10 RC_BRSCR_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Branh Script Instance Number

11 RC_SRVY_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Case Survey Instance field. Survey Instance built from concatenaton of Case Id and Sequence Number.

12 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

13 DLG_BU Character(5) VARCHAR2(5) NOT NULL This field stores the Business Unit that the transactions belong to.

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

15 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

16 RBB_BPEL_INST_ID Character(100) VARCHAR2(100) NOT NULL Business Process Instance ID

17 RBB_SERV_OPR_ID Character(100) VARCHAR2(100) NOT NULL Service Operation ID

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

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

20 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

21 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

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

23 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	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.
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RC_NONVW
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	LINK_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	This identifies the category that the link will be displayed under
7	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
8	RC_LINK	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated
9	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
10	RC_BRSCR_INSTANCE	Number(15,0)	DECIMAL(15) NOT NULL	Branh Script Instance Number
11	RC_SRVY_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Case Survey Instance field. Survey Instance built from concatenaton of Case Id and Sequence Number.
12	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
13	DLG_BU	Character(5)	VARCHAR2(5) NOT NULL	This field stores the Business Unit that the transactions belong to.
14	TYPE	Character(4)	VARCHAR2(4) NOT NULL	Association Types
15	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
16	RBB_BPEL_INST_ID	Character(100)	VARCHAR2(100) NOT NULL	Business Process Instance ID
17	RBB_SERV_OPR_ID	Character(100)	VARCHAR2(100) NOT NULL	Service Operation ID
18	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
19	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
20	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
21	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
22	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.
23	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time