GPIT_RP_0004

(SQL Table)
 Index Back

WA vacation from GP

WA Record. It stores YTD amount calculated during the payroll run.

  • Parent record: PERSON

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

    Prompt Table: PERSON

    2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
    7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
    8 SLICE_END_DT Date(10) DATE Element Slice End Date
    9 GPIT_FER_VACATION Character(3) VARCHAR2(3) NOT NULL Vacation type for reports
    10 GPIT_FER_PREV_YEAR Signed Number(8,2) DECIMAL(6,2) NOT NULL Previous year vacation for reports
    11 GPIT_FER_ENTITL Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation entitlement for reports
    12 GPIT_FER_ACCRUED Signed Number(8,2) DECIMAL(6,2) NOT NULL Accrued vacation for reports
    13 GPIT_FER_USED Signed Number(8,2) DECIMAL(6,2) NOT NULL Used vacations for reports
    14 GPIT_FER_BALANCE Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation balance for reports
    15 GPIT_ROL_VACATION Character(3) VARCHAR2(3) NOT NULL Vacation type for reports
    16 GPIT_ROL_PREV_YEAR Signed Number(8,2) DECIMAL(6,2) NOT NULL Previous year vacation for reports
    17 GPIT_ROL_ENTITL Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation entitlement for reports
    18 GPIT_ROL_ACCRUED Signed Number(8,2) DECIMAL(6,2) NOT NULL Accrued vacation for reports
    19 GPIT_ROL_USED Signed Number(8,2) DECIMAL(6,2) NOT NULL Used vacations for reports
    20 GPIT_ROL_BALANCE Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation balance for reports
    21 GPIT_VAC_VACATION Character(3) VARCHAR2(3) NOT NULL Vacation type for reports
    22 GPIT_VAC_PREV_YEAR Signed Number(8,2) DECIMAL(6,2) NOT NULL Previous year vacation for reports
    23 GPIT_VAC_ENTITL Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation entitlement for reports
    24 GPIT_VAC_ACCRUED Signed Number(8,2) DECIMAL(6,2) NOT NULL Accrued vacation for reports
    25 GPIT_VAC_USED Signed Number(8,2) DECIMAL(6,2) NOT NULL Used vacations for reports
    26 GPIT_VAC_BALANCE Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation balance for reports
    27 GPIT_ABS_VACATION Character(3) VARCHAR2(3) NOT NULL Vacation type for reports
    28 GPIT_ABS_PREV_YEAR Signed Number(8,2) DECIMAL(6,2) NOT NULL Previous year vacation for reports
    29 GPIT_ABS_ENTITL Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation entitlement for reports
    30 GPIT_ABS_ACCRUED Signed Number(8,2) DECIMAL(6,2) NOT NULL Accrued vacation for reports
    31 GPIT_ABS_USED Signed Number(8,2) DECIMAL(6,2) NOT NULL Used vacations for reports
    32 GPIT_ABS_BALANCE Signed Number(8,2) DECIMAL(6,2) NOT NULL Vacation balance for reports