PA_CONS_EARNTER(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 | Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL | |
2 | Character(10) | VARCHAR2(10) NOT NULL |
HR Action/Reason Category
Prompt Table: PA_HR_ACT |
|
3 | PERIOD_METHODS | Character(1) | VARCHAR2(1) NOT NULL |
Break-In-Svc Methods
A=Annualize I=Ignore S=Use As Is U=User Code |
4 | ANNUALIZE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Annualize Options
D=Count Days M=Count Months |