GPBR_PARM_GRRF1

(SQL Table)
 Index Back

GRRF Finacial Information TRCT

GRRF Finacial Information from TRCT, used to store element map from elements to report target values.

  • Parent record: GPBR_PARM_GRRF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 GPBR_GRRF_RT41 Character(3) VARCHAR2(3) NOT NULL GRRF Layout Field, used to keep layout field mapping.
    010=Worked Days w/Right of Balance
    020=Balance of Salary - Value
    030=13th Salary /12th
    040=13th Salary - Value
    050=13th Indemnified Salary /12th
    060=13th Indemnified Salary - Val
    070=Expired Vacations - Value
    080=Proportional Vacations /12th
    090=Proportional Vacations - Value
    100=1/3 Salary - Vacations
    110=Family Allowance - Days
    120=Family Allowance - Value
    130=Nightly Additional - Value
    140=Commissions - Value
    150=Bonus - Value
    160=Overtime - Quantity
    170=Overtime - Value
    180=Risk/Unhealthy Additional Val
    190=Social Security Deduction
    200=Soc Sec13th Salary Deduction
    210=Payment Advances Deduction
    220=Income Tax Deduction - IRRF
    4 GPBR_ENTRY_TYPE Character(2) VARCHAR2(2) NOT NULL Entry type element
    10=Earnings
    20=Deductions
    5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %EDITTABLE