RBC_REQUEST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CMF_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence ID Default Value: NEXT
2	CMF_REQST_DESCR	Character(80)	VARCHAR2(80) NOT NULL	Request Description
3	CMF_REQST_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Correspondence Request Status APPR=Send For Approval CNCL=Cancelled COMP=Completed IP=In Progress PREV=Preview and Personalize PVRD=Preview Ready SBMT=Submitted Default Value: IP
4	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
5	CMF_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Correspondence Request Status BAM=Oracle BAM CM=Correspondence Management ERMS=Email Response Management RTS=PS Real Time Suite Dashboard Default Value: CM
6	RB_LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch ENG=English ESP=Spanish FIN=Finnish FRA=French GER=German GRK=Greek HEB=Hebrew HUN=Hungarian ITA=Italian JPN=Japanese KOR=Korean MAY=Bahasa Malay NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai TUR=Turkish ZHS=Simplified Chinese ZHT=Traditional Chinese Default Value: ENG
7	RB_DELV_CHANNEL	Character(1)	VARCHAR2(1) NOT NULL	Delivery Channel. Please make sure to update the RB_DELV_CHANNEL2 field with the XLAT values in future when Fax channel is enabled. RB_DELV_CHANNEL2 field is used in the Correspondence search. 0=All 1=Email 2=Print 3=Fax 4=Print & Fax Default Value: 1
8	RB_USAGE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Unique Usage Identifier
9	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
10	NBR_SEND	Number(9,0)	DECIMAL(9) NOT NULL	Correspondences Send
11	NBR_ERROR	Number(9,0)	DECIMAL(9) NOT NULL	Correspondences Errored
12	MERGE_OPTN	Character(4)	VARCHAR2(4) NOT NULL	Correspondence Management Merge options IMDT=Merge & Send Immediately MRGL=Merge Later, Send Later SNDL=Merge Now, Send Later Default Value: IMDT
13	MERGE_DATE	Date(10)	DATE	Correspondence Send Date Default Value: %Date
14	MERGE_TIME	Time(15)	TIMESTAMP	Correspondence Send Time Default Value: %Time
15	SEND_DATE	Date(10)	DATE	Correspondence Send Date Default Value: %Date
16	SEND_TIME	Time(15)	TIMESTAMP	Correspondence Send Time Default Value: %Time
17	SUBMIT_DATE	Date(10)	DATE	Correspondence Submit Date
18	SUBMIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Submitted By OPRID.........................................
19	EMAIL_ADDR_SENDER	Long Character	CLOB	This is the senders email address field.
20	GEN_MSG_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=High 2=Medium 3=Low Default Value: 2
21	URL1	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
22	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
23	RB_WF_NOTIFY_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Notification delivery time L=Send Later N=Send Now
24	RB_ACT_RQST_CD	Character(30)	VARCHAR2(30) NOT NULL	Action Request Code - this code is used primarily for Quality Worklist/Workflow when 'Assign To' is manually entered.
25	SEND_URL	Character(1)	VARCHAR2(1) NOT NULL	SEND_URL
26	MENUNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Name (see PSMENUDEFN).
27	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
28	RB_SHOW_DNLOAD_BTN	Character(1)	VARCHAR2(1) NOT NULL	Flag to specify whether to show Download Button on Correspondence Request page or not
29	RB_PREVW_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Preview option to decide whether to merge documents for the all recipients or only for the first recipient
30	RB_ALLOW_FILE_CHG	Character(1)	VARCHAR2(1) NOT NULL	Flag to identify whether Agent can modify the attachments or not
31	EMAIL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Email Flag
32	WORKLIST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Worklist Flag.........................................................
33	PARENT_INTER_ID	Character(15)	VARCHAR2(15) NOT NULL	Parent Interaction ID....................................
34	RB_EDIT_RECIPIENTS	Character(1)	VARCHAR2(1) NOT NULL	Flag to allow end user to edit recipients at run time
35	CONTEXT_TAG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Need Context Tag in Email.........................
36	PRINTER_ID	Number(6,0)	INTEGER NOT NULL	Printer ID Prompt Table: %EDITTABLE
37	COMPONENT_MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market Default Value: GBL
38	EOCF_CTXPERSIST_ID	Number(31,0)	DECIMAL(31) NOT NULL	Persisted Context ID
39	RB_PROCESSING_MODE	Character(1)	VARCHAR2(1) NOT NULL	Processing Mode - indicates processing mode: 0 - Foreground (Synchronous) 1 - Background (Asynchronous) 0=Foreground 1=Background and Sending
40	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
41	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
42	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
43	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
44	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.
45	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
46	CHARSET	Character(40)	VARCHAR2(40) NOT NULL	Character Set
47	RBC_SINGLE_JOB	Character(1)	VARCHAR2(1) NOT NULL	Define if create single print job Y/N Table Edit Default Value: N
48	RBC_IS_PRT_LATER	Character(1)	VARCHAR2(1) NOT NULL	Define if create need to sent the printer later Y/N Table Edit Default Value: N
49	RBC_IS_BULK_REQ	Character(1)	VARCHAR2(1) NOT NULL	Define if the request is bulk Y/N Table Edit Default Value: N