LMS_SCENA_PURGE

(SQL Table)
Index Back

LMS - Purge Scenario Record

Salary Forecasting: This record list scenarios to purge. It is used by process HR_LMS_PURGE.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LMS_SCENARIO_ID Character(10) VARCHAR2(10) NOT NULL LMS - Scenario Id
4 LMS_SCENARIO_DTTM DateTime(26) TIMESTAMP NOT NULL Scenario Run DateTime