GPIT_RP_004_HST

(SQL Table)
 Index Back

WA vacation from GP

This is the Archive (shadow) table used in Data Archiving for the record: GPIT_RP_0004.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

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