GRP_ANNIV2_TBL(SQL Table) |
Index Back |
|---|---|
Anniversary Date tableGRP_ANNIV_TBL finds employees in a department eligible for salary increases based on the month and day of their hire or rehire date. It is different from the GRP_PLAN_VW since it does not check for new hire eligibility date and it uses the substring function to check for hire/rehire month & day from JOB to verify it is within the budget period. There is peoplecode in SALARY_PLAN.EFFDT that determines the appropriate year (budget start or end date year) to attach to the EFFDT. It is used as a SelectRecord for ScrollSelect in the Salary Planning application. When the anniversary switch is "Y", all eligible employees are automatically brought into the panel using this record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 2 | BUDGET_START_DT | Date(10) | DATE | Budget Start Date |
| 3 | BUDGET_ID | Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 8 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 9 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 10 | HIRE_DT | Date(10) | DATE | First Start Date |
| 11 | REHIRE_DT | Date(10) | DATE | Rehire Date |
| 12 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 13 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 14 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |