PA_CONS_EARNHIR(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 | 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 |