PA_CONS_HRSTAT4(SQL Table) |
Index Back |
|---|---|
Consolidated HoursThis is a setup table containing the Consolidated Hours 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 | CUSTOM_STMT_NAME |
Character(10) | VARCHAR2(10) NOT NULL |
Custom Statement Name
Prompt Table: PA_CUSTOM |
| 3 | GENERATION_METHOD | 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 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 | UPLIFT_FACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Uplift Factor Field Type
A=Alias Name N=Numeric Constant |
| 8 | UPLIFT_FACTOR | Number(8,4) | DECIMAL(7,4) NOT NULL | Uplift Factor |
| 9 | UPLIFT_FACT_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Uplift Factor
Prompt Table: PA_ALIAS_USE |
| 10 | REPLACE_AMT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Alias Type |
| 11 | UPLIFT_FACT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Alias Type |