UPG_ASSOC_AET (SQL Table)	Index Back
Temporary table Temporary table used in UPG_RC upgrade AE program.

UPG_ASSOC_AET

(SQL Table)

Temporary table

Temporary table used in UPG_RC upgrade AE program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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 TYPE Character(4) VARCHAR2(4) NOT NULL Association Types

10 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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
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	TYPE	Character(4)	VARCHAR2(4) NOT NULL	Association Types
10	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
11	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.