GB_GROUP_IDPrompt Table: GB_GROUP_SRCH
BUDGET_START_DTPrompt Table: GRP_INCR_VW
BUDGET_IDGRP_INCR_BUDGT1(SQL Table) |
Index Back |
|---|---|
Group Pay Increase BudgetGRP_INCR_BUDGT1 is the parent budget record for the Salary Planning application. It contains the description of each budget for each group participating in the plan. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SRCH |
| 2 | BUDGET_START_DT |
Date(10) | DATE NOT NULL |
Budget Start Date
Prompt Table: GRP_INCR_VW |
| 3 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | TOTAL_COUNT | Number(7,0) | INTEGER NOT NULL | Total Count |
| 7 | TOTAL_FTE_UNROUND | Number(16,11) | DECIMAL(15,11) NOT NULL | Total Unrounded FTE |
| 8 | TOTAL_SALARIES | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Total Annual Salaries |