GPBR_TERM_WA_VW

(SQL View)
 Index Back

Transf. w/Term Accum Values

Transfers with Termination accumulator values

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.PIN_NUM , A.INSTANCE , A.BGN_DT , A.END_DT , A.AMOUNT , A.CURRENCY_CD , A.COMPANY , A.ESTABID , B.PIN_USER_KEY1_NUM , B.PIN_USER_KEY2_NUM , B.PIN_USER_KEY3_NUM , B.PIN_USER_KEY4_NUM , B.PIN_USER_KEY5_NUM , B.PIN_USER_KEY6_NUM FROM PS_GPBR_TERM_E_WA A , PS_GPBR_ACTER_VW B WHERE A.PIN_NUM = B.PIN_NUM

# 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 Record
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 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
10 BGN_DT Date(10) DATE Begin Date
11 END_DT Date(10) DATE end date
12 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
15 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
16 PIN_USER_KEY1_NUM Number(8,0) INTEGER NOT NULL Element number field
17 PIN_USER_KEY2_NUM Number(8,0) INTEGER NOT NULL Element number field
18 PIN_USER_KEY3_NUM Number(8,0) INTEGER NOT NULL Element number field
19 PIN_USER_KEY4_NUM Number(8,0) INTEGER NOT NULL Element number field
20 PIN_USER_KEY5_NUM Number(8,0) INTEGER NOT NULL Element number field
21 PIN_USER_KEY6_NUM Number(8,0) INTEGER NOT NULL Element number field