GPAU_STP_RFB_VW

(SQL View)
Index Back

STP RFB View

RFB View - Single Touch Payroll

SELECT STP.PROCESS_INSTANCE , STP.EMPLID , STP.CAL_RUN_ID , STP.CAL_ID , STP.ORIG_CAL_RUN_ID , STP.GP_PAYGROUP , STP.RSLT_SEG_NUM , STP.EMPLID_BGRP , STP.PAY_ENTITY , STP.GPAU_TAX_YEAR , STP.BALANCE_GRP_NUM , STP.GPAU_STP_CAT_8 , STP.GPAU_STP_SUB_CAT_8 , STP.GPAU_STP_RFB_CD , CASE WHEN STP.GPAU_RFB_TOTAL > 2000 THEN STP.GPAU_STP_AMOUNT ELSE 0 END FROM PS_GPAU_STP_TMPRFB STP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
5 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 EMPLID_BGRP Character(14) VARCHAR2(14) NOT NULL Emplid
9 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
10 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
11 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.
12 GPAU_STP_CAT_8 Character(30) VARCHAR2(30) NOT NULL Category Information - Single Touch Payroll
13 GPAU_STP_SUB_CAT_8 Character(30) VARCHAR2(30) NOT NULL STP Sub-Category to maintain Key Structure
14 GPAU_STP_RFB_CD Character(25) VARCHAR2(25) NOT NULL Supporting Element Character Value
15 GPAU_STP_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount of Iterative Categories - Single Touch Payroll