RUN_CNTL_PBM (SQL Table)	Index Back
Run Cntl record for Fin Rpts

RUN_CNTL_PBM

(SQL Table)

Run Cntl record for Fin Rpts

# 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 PAY_END_DT Date(10) DATE Pay Period End Date

4 PAY_PERIOD Character(1) VARCHAR2(1) NOT NULL Pay Period
1=First
2=Second
3=Third
4=Fourth
5=Fifth

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_FS

6 FO_BRANCH Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FO.FO_BRANCH
Prompt Table: FO_BRANCH_TBL

7 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.
Default Value: OPR_DEF_TBL_FO.CUST_ID
Prompt Table: CUSTOMER

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: OPR_DEF_TBL_FO.CURRENCY_CD
Prompt Table: CUR_CD_ALL_VW

9 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT_VW

10 NUM_HOURS Number(3,0) SMALLINT NOT NULL This field would be used in the RUN_CNTL_PBM record and page for the forecasting report, as an input parameter for number of hours

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

12 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type
Default Value: OPR_DEF_TBL_FO.USER_ORDER_TYPE
Prompt Table: FO_ORDER_TYPE

13 END_DATE Date(10) DATE End Date

14 START_DATE Date(10) DATE Start Date for Gen Standing PO

15 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

#	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	PAY_END_DT	Date(10)	DATE	Pay Period End Date
4	PAY_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Pay Period 1=First 2=Second 3=Third 4=Fourth 5=Fifth
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_FS
6	FO_BRANCH	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FO.FO_BRANCH Prompt Table: FO_BRANCH_TBL
7	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. Default Value: OPR_DEF_TBL_FO.CUST_ID Prompt Table: CUSTOMER
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_FO.CURRENCY_CD Prompt Table: CUR_CD_ALL_VW
9	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_VW
10	NUM_HOURS	Number(3,0)	SMALLINT NOT NULL	This field would be used in the RUN_CNTL_PBM record and page for the forecasting report, as an input parameter for number of hours
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	USER_ORDER_TYPE	Character(5)	VARCHAR2(5) NOT NULL	User Order Type Default Value: OPR_DEF_TBL_FO.USER_ORDER_TYPE Prompt Table: FO_ORDER_TYPE
13	END_DATE	Date(10)	DATE	End Date
14	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
15	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.