GP_RSLT_PIN_VW

(SQL View)
Index Back

Results - "Other" PINs

Results - Other PINs

SELECT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.INSTANCE , A.PIN_NUM , A.SLICE_BGN_DT , A.SLICE_END_DT , B.PIN_TYPE , B.FLD_FMT , A.CALC_RSLT_VAL , A.CHR_PIN_VAL , A.DATE_PIN_VAL , A.PIN_VAL_NUM , B.PIN_NM FROM PS_GP_RSLT_PIN A , PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM

  • Related Language Record: GP_RSLT_PIN_VL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    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 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    13 FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field format for Global Payroll elements
    1=Character
    2=Date
    3=Monetary
    4=Decimal
    5=Element Pointer
    6=Not Applicable
    14 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    15 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
    16 DATE_PIN_VAL Date(10) DATE Calculation Date Result
    17 PIN_VAL_NUM Number(8,0) INTEGER NOT NULL Calculation Element Number Result
    18 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field