GPAU_FBT_SRCH (SQL View)	Index Back
State Payroll Tax FBT pin srch This record is used to retrieve relevent pins for the operator id.

GPAU_FBT_SRCH

(SQL View)

State Payroll Tax FBT pin srch

This record is used to retrieve relevent pins for the operator id.

SELECT B.OPRID , A.PIN_TYPE , A.PIN_NUM , A.PIN_NM , A.DESCR , A.COUNTRY FROM PS_GP_PIN A , PS_GP_OPR_RULE_PRF B WHERE (A.USED_BY = 'A' OR (A.USED_BY = 'C' AND B.USED_BY= 'A') OR (A.USED_BY = 'C' AND A.COUNTRY = B.COUNTRY))

# 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 GPAU_VAL_TYPE Character(2) VARCHAR2(2) NOT NULL Used in State Payroll Tax processing to determine whether an element is an Earnings, Deduction, or Expense.
DD=Deduction
ER=Earnings
EX=Expense

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

#	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	GPAU_VAL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used in State Payroll Tax processing to determine whether an element is an Earnings, Deduction, or Expense. DD=Deduction ER=Earnings EX=Expense
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
4	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country