LMS_SCENARIO_IDPrompt Table: LMS_SCENARIO
LMS_SCENARIO_DTTMFROM_DATEEMPLIDEMPL_RCDDefault Value: JOB.EMPL_RCD
LMS_AMOUNT_TAO(SQL Table) |
Index Back |
|---|---|
LMS - Temp table for AE PrcsSalary Forecasting - This record is a temporary table for process HR_LMSSCENAR. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LMS_SCENARIO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
LMS - Scenario Id
Prompt Table: LMS_SCENARIO |
| 2 | LMS_SCENARIO_DTTM |
DateTime(26) | TIMESTAMP NOT NULL | Scenario Run Date Time |
| 3 | FROM_DATE |
Date(10) | DATE NOT NULL | From Date |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: JOB.EMPL_RCD |
| 6 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |