VRBT_CLMPRCS_RC (SQL Table)	Index Back
Claims Processing Run Control Supplier Rebate Claims Processing Run Control

VRBT_CLMPRCS_RC

(SQL Table)

Claims Processing Run Control

Supplier Rebate Claims Processing Run Control

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

5 CLAIM_RECON_OPT Character(1) VARCHAR2(1) NOT NULL Incoming Payment Reconciliation Run Option
1=Specific Rebate Agreement
2=Specific Claim ID
3=All Rebate IDs
4=Specific Claimback Contract
5=All Claimback Contracts

6 CLAIM_RUN_OPT Character(1) VARCHAR2(1) NOT NULL Claim Run Options
0=All Rebate Agreements
1=Specific Rebate Agreements
Default Value: 1

7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

8 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
Prompt Table: VRBT_HDR_DVW

9 THRU_DATE Date(10) DATE Through Date

10 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID

11 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID
Prompt Table: %EDITTABLE3

12 CB_CONTRACT_SETID Character(5) VARCHAR2(5) NOT NULL Claimback Contract Setid
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: CB_SETID_VW

13 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID
Prompt Table: CB_CON_DVW

14 NOTIFY_STLMENT_MGR Character(1) VARCHAR2(1) NOT NULL Notify Settlement Manager
Y/N Table Edit
Default Value: N

15 NOTIFY_REBATE_MGR Character(1) VARCHAR2(1) NOT NULL Notify Rebate Manager
Y/N Table Edit

16 VRBT_UNRESTRICT_FL Character(1) VARCHAR2(1) NOT NULL Unrestricted Rebate Manager
Y/N Table Edit

17 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
5	CLAIM_RECON_OPT	Character(1)	VARCHAR2(1) NOT NULL	Incoming Payment Reconciliation Run Option 1=Specific Rebate Agreement 2=Specific Claim ID 3=All Rebate IDs 4=Specific Claimback Contract 5=All Claimback Contracts
6	CLAIM_RUN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Claim Run Options 0=All Rebate Agreements 1=Specific Rebate Agreements Default Value: 1
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
8	VRBT_ID	Character(25)	VARCHAR2(25) NOT NULL	Vendor Rebate ID Prompt Table: VRBT_HDR_DVW
9	THRU_DATE	Date(10)	DATE	Through Date
10	WORKBENCH_ID	Character(10)	VARCHAR2(10) NOT NULL	WorkBench ID
11	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID Prompt Table: %EDITTABLE3
12	CB_CONTRACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Claimback Contract Setid Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: CB_SETID_VW
13	CB_CONTRACT_ID	Character(25)	VARCHAR2(25) NOT NULL	Claimback Contract ID Prompt Table: CB_CON_DVW
14	NOTIFY_STLMENT_MGR	Character(1)	VARCHAR2(1) NOT NULL	Notify Settlement Manager Y/N Table Edit Default Value: N
15	NOTIFY_REBATE_MGR	Character(1)	VARCHAR2(1) NOT NULL	Notify Rebate Manager Y/N Table Edit
16	VRBT_UNRESTRICT_FL	Character(1)	VARCHAR2(1) NOT NULL	Unrestricted Rebate Manager Y/N Table Edit
17	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.