GB_GROUP_IDPrompt Table: SAL_CHG_GRP_VW
ACTION_DT_SSDefault Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL
Default Value: A
Prompt Table: COMP_FREQ_VW
HR_SALCHGRP_DAT(SQL Table) |
Index Back |
|---|---|
Salary Chg for Grp w/o BudgetMain Record for the self service transaction 'Salary Change for Group without 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 | ACTION_DT_SS |
Date(10) | DATE NOT NULL | Termination Date |
| 3 | HR_WF_STATUS | Character(30) | VARCHAR2(30) NOT NULL | Status |
| 4 | REQUESTED_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Requested Amount |
| 5 | CURR_BUDGET_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Current Budget Amount |
| 6 | AVAIL_BUDGET_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Budget Amount |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 8 | 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.
Default Value: A Prompt Table: COMP_FREQ_VW |