GRP_INC_CMP1_VW(SQL View) |
Index Back |
|---|---|
Required Budget - ComponentsGRP_INC_CMP_REQ is the required budget components record for the Salary Planning application. It's a child record of GRP_INCR_BUDGET which contains informations regarding each budget (Group Increase Budget). |
| SELECT GB_GROUP_ID , BUDGET_START_DT , BUDGET_ID , EFFDT , EFFSEQ , COMP_RATECD , CHANGE_AMT , AMOUNT_PCT , CHANGE_PCT , CHANGE_PTS , POINT_PCT , COMPRATE , CURRENCY_CD , FREQUENCY_ID , LOOKUP_ID FROM PS_GRP_INC_CMP_REQ |
| # | 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_TBL |
| 2 | BUDGET_START_DT |
Date(10) | DATE NOT NULL |
Budget Start Date
Default Value: GROUP_INCR_CNTL.BUDGET_START_DT Prompt Table: GROUP_INCR_CNTL |
| 3 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: COMP_RATE_BP_VW |
| 7 | CHANGE_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Change Amount |
| 8 | AMOUNT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent Amount |
| 9 | CHANGE_PCT | Signed Number(8,3) | DECIMAL(6,3) NOT NULL | Change Percent |
| 10 | CHANGE_PTS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Change Points |
| 11 | POINT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent of Points |
| 12 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 14 | 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 |
| 15 | LOOKUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Main unique identifier for Configurable Matrices. |