GP_RSLT_ACUM_VL

(SQL View)
Index Back

RelLng Payee Results Accum Vw

Related Language View for Payee Results Accumulator View

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.PIN_NUM , A.EMPL_RCD_ACUM , A.ACM_FROM_DT , A.ACM_THRU_DT , A.SLICE_BGN_DT , A.SLICE_END_DT , A.SEQ_NUM8 , B.LANGUAGE_CD , A.USER_KEY1 , A.USER_KEY2 , A.USER_KEY3 , A.USER_KEY4 , A.USER_KEY5 , A.USER_KEY6 , B.PIN_NM FROM PS_GP_RSLT_ACUM A , PS_GP_PIN_LANG B WHERE A.PIN_NUM = B.PIN_NUM

  • Related Language Record for GP_RSLTAD_AA_VW GP_RSLTAD_AC_VW GP_RSLT_ACUM_VW
  • # 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 Record
    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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    9 EMPL_RCD_ACUM Number(3,0) SMALLINT NOT NULL Accumulator Empl record
    10 ACM_FROM_DT Date(10) DATE From Date
    11 ACM_THRU_DT Date(10) DATE Through Date
    12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    13 SLICE_END_DT Date(10) DATE Element Slice End Date
    14 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
    15 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    16 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
    17 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
    18 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
    19 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
    20 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
    21 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6
    22 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field