HR_SALCHBGT_VW

(SQL View)
Index Back

View Status Search for Sal Chg

This is the search record used for the Approve Salary Change for Group with Allocated Budget transaction.

SELECT DISTINCT A.GB_GROUP_ID , A.BUDGET_START_DT , A.BUDGET_ID , A.EFFDT , A.HR_WF_STATUS , C.EMPLID_TO FROM PS_HR_SALCHBGT_DAT A , PS_HR_SALCHBGT_STA C WHERE A.GB_GROUP_ID=C.GB_GROUP_ID AND A.BUDGET_START_DT = C.BUDGET_START_DT AND A.BUDGET_ID = C.BUDGET_ID AND A.EFFDT = C.EFFDT AND C.HR_WF_ACTION = ' ' AND C.CURRENT_STEP > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
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

Default Value: %date

5 HR_WF_STATUS Character(30) VARCHAR2(30) NOT NULL Status
6 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To