PA_CONS_EARNST1(SQL Table) |
Index Back |
|---|---|
Consolidated EarningsThis is a setup table containing the Consolidated Earnings parameters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DEFINITION_NAME |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 2 | HR_ACTION_CATEGORY |
Character(10) | VARCHAR2(10) NOT NULL |
HR Action / Reason Category
Prompt Table: PA_HR_ACT |
| 3 | GENERATE_EARNS | Character(1) | VARCHAR2(1) NOT NULL |
Generation Method
A=Replace with Fixed Amount C=Replace with Previous Complete F=Uplift with a Factor N=Replace with Previous Non-Zero R=Replace with Compensation Rate U=User Code |
| 4 | REPLACE_AMT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Replacement Amount Field Type
A=Alias Name N=Numeric Constant |
| 5 | REPLACE_AMOUNT | Number(12,2) | DECIMAL(11,2) NOT NULL | Replacement Amount |
| 6 | REPLACE_AMT_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Replacement Amount
Prompt Table: PA_ALIAS_USE |
| 7 | REPLACE_AMT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Alias Type |
| 8 | UPLIFT_FACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Uplift Factor Field Type
A=Alias Name N=Numeric Constant |
| 9 | UPLIFT_FACTOR | Number(8,4) | DECIMAL(7,4) NOT NULL | Uplift Factor |
| 10 | UPLIFT_FACT_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Uplift Factor
Prompt Table: PA_ALIAS_USE |
| 11 | UPLIFT_FACT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Alias Type |