AR_RUNCNTL_RISK (SQL Table)	Index Back
Risk Scoring Run Control Risk Scoring Run Control

AR_RUNCNTL_RISK

(SQL Table)

Risk Scoring 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_ALL_A2_VW
Set Control Field: SETID

5 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
Prompt Table: AR_CUSTGP_VW
Set Control Field: SETID

6 RISK_SCORE_ID Character(5) VARCHAR2(5) NOT NULL Risk Score ID
Prompt Table: AR_RISK_ID_VW

7 ANCHOR_DATE Date(10) DATE NOT NULL Anchor Date
Default Value: %date

8 ANCHOR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_OPT_AR.RT_TYPE
Prompt Table: AR_SS_RTYPE_VW

9 RISK_DT_OPT Character(1) VARCHAR2(1) NOT NULL Risk Scoring date option for history elements
1=Use Run Date
2=Specify Date
Default Value: 1

10 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

11 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

12 HIST_DT Date(10) DATE History Date

13 LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On

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

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_ALL_A2_VW Set Control Field: SETID
5	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group Prompt Table: AR_CUSTGP_VW Set Control Field: SETID
6	RISK_SCORE_ID	Character(5)	VARCHAR2(5) NOT NULL	Risk Score ID Prompt Table: AR_RISK_ID_VW
7	ANCHOR_DATE	Date(10)	DATE NOT NULL	Anchor Date Default Value: %date
8	ANCHOR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: BUS_UNIT_OPT_AR.RT_TYPE Prompt Table: AR_SS_RTYPE_VW
9	RISK_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Risk Scoring date option for history elements 1=Use Run Date 2=Specify Date Default Value: 1
10	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
11	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
12	HIST_DT	Date(10)	DATE	History Date
13	LAST_RUN_DTM	DateTime(26)	TIMESTAMP	Last Run On
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance