GB_GROUP_IDPrompt Table: SAL_CHG_GRP_VW
BUDGET_START_DTBUDGET_IDEFFDTPrompt Table: CURRENCY_CD_TBL
Prompt Table: COMP_FREQ_VW
HR_SALCHBGT_DAT(SQL Table) |
Index Back |
|---|---|
Salary Chg for Grp with BudgetMain Record for the self service transaction 'Salary Change for Group with Allocated Budget'. |
| # | 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: SAL_CHG_GRP_VW |
| 2 | BUDGET_START_DT |
Date(10) | DATE | Budget Start Date |
| 3 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | HR_WF_STATUS | Character(30) | VARCHAR2(30) NOT NULL | Status |
| 6 | REQUESTED_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Requested Amount |
| 7 | CURR_BUDGET_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Current Budget Amount |
| 8 | AVAIL_BUDGET_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Budget Amount |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | FREQUENCY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
Prompt Table: COMP_FREQ_VW |