RC_CASE_WO_URL (SQL Table)	Index Back
Record used to store Case URL This record will store the Case URL when a Service Order is created from case, which in turn creates Work Order in FSCM database. URL stored in this table will be used by AAF Notifications sent from Message Handler (which cannot generate URL since %Poratl etc., cannot be resolved).

RC_CASE_WO_URL

(SQL Table)

Record used to store Case URL

This record will store the Case URL when a Service Order is created from case, which in turn creates Work Order in FSCM database. URL stored in this table will be used by AAF Notifications sent from Message Handler (which cannot generate URL since %Poratl etc., cannot be resolved).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 URLS Long Character(2000) VARCHAR2(2000) URLs

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	URLS	Long Character(2000)	VARCHAR2(2000)	URLs