GP_RSLT_PIN

(SQL Table)
Index Back

Results for "other" PINs

Result table for PINs other than ERN, DED and ACUM

  • Parent record: GP_PYE_SEG_STAT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
    9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    10 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    11 SLICE_END_DT Date(10) DATE Element Slice End Date
    12 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    13 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
    14 DATE_PIN_VAL Date(10) DATE Calculation Date Result
    15 PIN_VAL_NUM Number(8,0) INTEGER NOT NULL Calculation Element Number Result