RUN_CNTL_DELSC (SQL Table)	Index Back
HR RnCtl - Delete Gbl Scenario RUN_CNTL_DELSC is used to hold input parameters for the TRNDELSC application engine process, that deletes inactive, global scenarios. The user is prompted for scenarios using TRN_INACT_GBL_VW, which filters out active and non-global scenarios. This is part of the Budget Training application.

RUN_CNTL_DELSC

(SQL Table)

HR RnCtl - Delete Gbl Scenario

RUN_CNTL_DELSC is used to hold input parameters for the TRNDELSC application engine process, that deletes inactive, global scenarios. The user is prompted for scenarios using TRN_INACT_GBL_VW, which filters out active and non-global scenarios. This is part of the Budget Training application.

# 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 SCENARIO Character(10) VARCHAR2(10) NOT NULL Scenario
Prompt Table: TRN_INACT_SC_VW

4 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

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

#	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	SCENARIO	Character(10)	VARCHAR2(10) NOT NULL	Scenario Prompt Table: TRN_INACT_SC_VW
4	BUDGET_PERIOD	Character(10)	VARCHAR2(10) NOT NULL	Budget Period
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit