OPRIDGB_GROUP_IDPrompt Table: GB_GROUP_TBL
BUDGET_START_DTPrompt Table: GROUP_INCR_CNTL
BUDGET_IDLANGUAGE_CDEFFDTHR_SALBGT_S_LNG(SQL View) |
Index Back |
|---|---|
SalChg by Bdgt Srch - Rel LangRelated Language Record for the Search Record HR_SAL_BGT_SRCH of the Salary Change by Budget self service transactions. |
| SELECT O.OPRID , G.GB_GROUP_ID , G.BUDGET_START_DT , G.BUDGET_ID , GL.LANGUAGE_CD , G.EFFDT , GI.DESCR50 FROM PS_GRP_INCR_BUDGET G ,PS_GRP_INCR_BUDGT1 GI ,PS_GRP_INC_BUD_LNG GL ,PSOPRDEFN O WHERE GL.GB_GROUP_ID = GI.GB_GROUP_ID AND GL.BUDGET_START_DT = GI.BUDGET_START_DT AND GL.BUDGET_ID = GI.BUDGET_ID AND 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | EFFDT |
Date(10) | DATE | Effective Date |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |