DEFINITION_NAMEPA_SEQ_NUMA=Alias Name
N=Numeric Constant
Default Value: N
Prompt Table: PA_ALIAS_USE
C=Current Period
P=Prior Period
Default Value: C
PA_CONS_EARN_RT(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 | PA_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | EFFDT_MONTH | Number(2,0) | SMALLINT NOT NULL | Effective on Month |
| 4 | EFFDT_DAY | Number(2,0) | SMALLINT NOT NULL | Effective on Day |
| 5 | COMP_MULT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Compensation Rate Multiplier
A=Alias Name N=Numeric Constant Default Value: N |
| 6 | COMP_RATE_MULT | Number(8,4) | DECIMAL(7,4) NOT NULL | Multiplied By |
| 7 | COMP_MULT_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Compensation Rate Multiplier
Prompt Table: PA_ALIAS_USE |
| 8 | COMP_MULT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Alias Type |
| 9 | COMP_RATE_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Current or Prior Period
C=Current Period P=Prior Period Default Value: C |