LMS_SCENA_PURGE(SQL Table) |
Index Back |
---|---|
LMS - Purge Scenario RecordSalary 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 |