OPRIDGB_GROUP_IDPrompt Table: GB_GROUP_TBL
BUDGET_START_DTPrompt Table: GROUP_INCR_CNTL
BUDGET_IDEFFDTPrompt Table: ACTION_TBL
HR_SAL_BGT_SRCH(SQL View) |
Index Back |
|---|---|
Sal Chg by Budget - Search RecSearch Record for the Salary Change by Budget self service transactions. |
| SELECT O.OPRID , G.GB_GROUP_ID , G.BUDGET_START_DT , G.BUDGET_ID , G.EFFDT , G.EFFSEQ , GI.DESCR50 , G.ACTION , G.ACTION_REASON FROM PS_GRP_INCR_BUDGET G ,PS_GRP_INCR_BUDGT1 GI ,PSOPRDEFN O WHERE G.GB_GROUP_ID = GI.GB_GROUP_ID AND G.BUDGET_START_DT = GI.BUDGET_START_DT AND G.BUDGET_ID = GI.BUDGET_ID AND EXISTS ( SELECT 'X' FROM PS_GB_GROUP_TBL GB WHERE GB.GB_GROUP_ID = G.GB_GROUP_ID AND GB.MANAGER_ID = O.EMPLID AND GB.EFF_STATUS = 'A' AND GB.EFFDT = ( SELECT MAX(GB1.EFFDT) FROM PS_GB_GROUP_TBL GB1 WHERE GB1.GB_GROUP_ID = GB.GB_GROUP_ID AND GB1.MANAGER_ID = GB.MANAGER_ID AND GB1.EFFDT <= G.BUDGET_START_DT)) AND G.BUDGET_APPROVED = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_HR_SALCHBGT_DAT S WHERE S.GB_GROUP_ID = G.GB_GROUP_ID AND S.BUDGET_START_DT = G.BUDGET_START_DT AND S.BUDGET_ID = G.BUDGET_ID AND S.EFFDT = G.EFFDT AND S.HR_WF_STATUS <> ' ') AND NOT EXISTS ( SELECT 'X' FROM PS_GRP_INCR_BUDGET G1 WHERE G1.GB_GROUP_ID = G.GB_GROUP_ID AND G1.BUDGET_START_DT = G.BUDGET_START_DT AND G1.BUDGET_ID = G.BUDGET_ID AND (G1.EFFDT < G.EFFDT OR (G1.EFFDT = G.EFFDT AND G1.EFFSEQ < G.EFFSEQ)) AND NOT EXISTS ( SELECT 'X' FROM PS_HR_SALCHBGT_DAT S1 WHERE S1.GB_GROUP_ID = G1.GB_GROUP_ID AND S1.BUDGET_START_DT = G1.BUDGET_START_DT AND S1.BUDGET_ID = G1.BUDGET_ID AND S1.EFFDT = G1.EFFDT AND S1.HR_WF_STATUS <> ' ')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 3 | BUDGET_START_DT |
Date(10) | DATE NOT NULL |
Budget Start Date
Prompt Table: GROUP_INCR_CNTL |
| 4 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 9 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |