DEFINITION_NAMEHR_ACTION_CATEGORYPrompt Table: PA_HR_ACT
A=Annualize
I=Ignore
S=Use As Is
U=User Code
D=Count Days
M=Count Months
PA_CONS_HOURTER(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 | 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 |