HPY_ADL_PY_VW

(SQL View)
 Index Back

Additional Pay Detail

This record is used for Component Search For Creating Additional Pay for getting earning codes and effdt.

SELECT EMPLID , EMPL_RCD , ERNCD , EFFDT , ADDL_SEQ , DEPTID , JOBCODE , POSITION_NBR , ACCT_CD , GL_PAY_TYPE , ADDL_PAY_SHIFT , OTH_HRS , HOURLY_RT , OTH_PAY , ADDLPAY_REASON , SEPCHK , EARNINGS_END_DT , GOAL_AMT , GOAL_BAL , OK_TO_PAY , DISABLE_DIR_DEP , PRORATE_ADDL_PAY , PRORATE_CUI_WEEKS , PAY_PERIOD1 , PAY_PERIOD2 , PAY_PERIOD3 , PAY_PERIOD4 , PAY_PERIOD5 , STATE , LOCALITY , TAX_PERIODS , TAX_METHOD , ADDL_PAY_FREQUENCY , DED_TAKEN , DED_SUBSET_ID , DED_TAKEN_GENL , DED_SUBSET_GENL , PLAN_TYPE , BUSINESS_UNIT , COMP_RATECD , RECORD_SOURCE FROM PS_ADDL_PAY_DATA B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_ADDL_PAY_DATA B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B.ERNCD = B_ED.ERNCD AND B_ED.EFFDT <= %CurrentDateIn)

  • Parent record: ADDL_PAY_EFFDT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: PER_ORG_ASGN_VW

    3 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: EARNINGS_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 ADDL_SEQ Number(2,0) SMALLINT NOT NULL Additional Pay Sequence Number
    6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    8 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: %RECNAME_EDIT

    9 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: %EDITTABLE

    10 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    11 ADDL_PAY_SHIFT Character(1) VARCHAR2(1) NOT NULL Additional Pay Shift
    1=1
    2=2
    3=3
    J=Use Job Shift
    N=Not Applicable

    Default Value: J

    12 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other hours.
    13 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    14 OTH_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay
    15 ADDLPAY_REASON Character(3) VARCHAR2(3) NOT NULL Reason for Additional Pay
    A=Anniversary Award
    AWD=Award Data
    BAS=Benefits Administration Credit
    C=Contract Pay
    JOB=Job Other Pay
    N=Not Specified
    O=Outstanding Contribution
    P=Performance Award
    Q=President's Award
    S=Productivity Award

    Default Value: N

    16 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    17 EARNINGS_END_DT Date(10) DATE Earnings End Date
    18 GOAL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Amount
    19 GOAL_BAL Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Balance
    20 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL Okay to pay indicator.

    Y/N Table Edit

    Default Value: N

    21 DISABLE_DIR_DEP Character(1) VARCHAR2(1) NOT NULL Disable Direct Deposit

    Y/N Table Edit

    Default Value: N

    22 PRORATE_ADDL_PAY Character(1) VARCHAR2(1) NOT NULL Prorate Additional Pay

    Y/N Table Edit

    Default Value: N

    23 PRORATE_CUI_WEEKS Character(1) VARCHAR2(1) NOT NULL Prorate EI Weeks

    Y/N Table Edit

    Default Value: N

    24 PAY_PERIOD1 Character(1) VARCHAR2(1) NOT NULL First Pay Period

    Y/N Table Edit

    Default Value: Y

    25 PAY_PERIOD2 Character(1) VARCHAR2(1) NOT NULL Second Pay Period

    Y/N Table Edit

    26 PAY_PERIOD3 Character(1) VARCHAR2(1) NOT NULL Third Pay Period

    Y/N Table Edit

    27 PAY_PERIOD4 Character(1) VARCHAR2(1) NOT NULL Fourth Pay Period

    Y/N Table Edit

    28 PAY_PERIOD5 Character(1) VARCHAR2(1) NOT NULL Fifth Pay Period

    Y/N Table Edit

    29 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TAX_TBL

    30 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_TBL

    31 TAX_PERIODS Number(2,0) SMALLINT NOT NULL Tax Periods

    Default Value: 1

    32 TAX_METHOD Character(1) VARCHAR2(1) NOT NULL Tax method.
    A=Annualized
    B=Bonus
    C=Cumulative
    G=Aggregate
    L=Lump Sum
    M=Commission
    P=Specified on Paysheet
    S=Supplemental
    X=Special Supplemental

    Default Value: A

    33 ADDL_PAY_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Tax Frequency
    A=Annually
    B=Biweekly
    D=Daily
    M=Monthly
    P=Use Pay Group Frequency
    Q=Quarterly
    S=Semimonthly
    W=Weekly

    Default Value: P

    34 DED_TAKEN Character(1) VARCHAR2(1) NOT NULL Deductions Taken
    D=Deduction Table Governs
    N=None
    R=No Override
    S=Deduction Table Subset Governs

    Default Value: R

    35 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID

    Prompt Table: DED_SUBSET_TBL

    36 DED_TAKEN_GENL Character(1) VARCHAR2(1) NOT NULL Specify how general deduction is to be taken.
    D=Deduction Table Governs
    N=None
    R=No Override
    S=Deduction Table Subset Governs

    Default Value: R

    37 DED_SUBSET_GENL Character(3) VARCHAR2(3) NOT NULL Subset ID for general deductions.

    Prompt Table: DED_SUBSET_TBL

    38 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
    39 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    40 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RT_REG_VW

    41 RECORD_SOURCE Character(1) VARCHAR2(1) NOT NULL Record Source
    B=Batch
    O=On-line

    Default Value: O