GPES_TAX_RSL_VW

(SQL View)
Index Back

View to inquire Tax Results

View to inquire Tax Results

SELECT DISTINCT SEC.OPRID , A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , SEC.ROWSECCLASS FROM PS_GPES_TAX_RSLT A , PS_EMPLMT_SRCH_GBL SEC WHERE A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
5 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security