HR_SAL_CHG_E_VW

(SQL View)
 Index Back

Salary Change Employees View

HR_SAL_CHG_E_VW is a view used in the Salary Change for Group without Allocated Budget - self service transaction. It is used to scroll in the Employees of a Group.

SELECT S.GB_GROUP_ID ,S.VERSIONGBQDM ,S.EMPLID ,S.EMPL_RCD ,S.JOB_EFFDT ,S.JOB_EFFSEQ ,J.COMPRATE ,J.CURRENCY_CD ,J.COMP_FREQUENCY ,J.ANNUAL_RT ,J.COMPANY ,J.REG_REGION ,J.STD_HOURS ,J.STD_HRS_FREQUENCY ,J.FTE ,J.PAID_HOURS ,J.PAID_HRS_FREQUENCY ,J.PAID_FTE ,J.SETID_JOBCODE ,J.JOBCODE ,J.SETID_SALARY ,J.SAL_ADMIN_PLAN ,J.GRADE ,J.STEP ,J.BUSINESS_UNIT ,J.HR_STATUS FROM PS_SAL_PLN_GRP_RES S ,PS_JOB J WHERE S.EMPLID = J.EMPLID AND S.EMPL_RCD = J.EMPL_RCD AND S.JOB_EFFDT = J.EFFDT AND S.JOB_EFFSEQ = J.EFFSEQ AND J.HR_STATUS = 'A'

  • Parent Record Of HR_SAL_CHG_C_VW

    • # 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 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    5 EFFDT Date(10) DATE Effective Date
    6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    7 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Prompt Table: COMP_FREQ_VW

    10 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    12 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    13 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    14 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    15 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    16 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
    17 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period
    18 PAID_FTE Number(8,6) DECIMAL(7,6) NOT NULL This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.
    19 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    20 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    21 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
    22 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    23 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    24 STEP Number(2,0) SMALLINT NOT NULL Step
    25 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    26 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive