GRP_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 Period 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 |