RB_WL_REASGN_TM (SQL Table)	Index Back
Reassignment temporary record Temporary record for implementing reassignment of case, service order, help desk transactions based on worklist items.

RB_WL_REASGN_TM

(SQL Table)

Reassignment temporary record

Temporary record for implementing reassignment of case, service order, help desk transactions based on worklist items.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
N=NO
Y=YES
Y/N Table Edit
Default Value: N

3 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

4 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

5 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

6 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

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

8 ROW_NUMBER Number(10,0) DECIMAL(10) NOT NULL Row Number

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

11 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID

12 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.

13 SECURE_CASE_FLG Character(1) VARCHAR2(1) NOT NULL Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case.
N=No
Y=Yes
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SELECTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selected Flag N=NO Y=YES Y/N Table Edit Default Value: N
3	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
4	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
5	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
6	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
7	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
8	ROW_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	Row Number
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	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.
11	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
12	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number.
13	SECURE_CASE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case. N=No Y=Yes Default Value: N