PI_IC_CHK_VW

(SQL View)
 Index Back

WEB-Paychk Rvw Check Data(PI)

View created to support WEB-enabled Paycheck Review. It is based on the PI_CHECK record. It contains Payroll Interface Import Check Data.

select B.OPRID , A.PAY_END_DT , A.PI_CHECK_NBR , A.PI_TOTAL_GROSS , A.PI_TOTAL_TAXES , A.PI_TOTAL_DEDUCT , A.PI_NET_PAY , A.CURRENCY_CD , C.EMPLID , A.PI_RUN_NUM , A.PI_SYSTEM_ID , A.PI_CONFIG_ID , A.PI_PAY_GROUP1 , A.PI_PAY_GROUP2 , A.PI_EMPLID , A.PAY_END_DT , A.PI_CHECK_TYPE , A.PI_CHECK_CODE , A.PI_VOID_IND , A.PI_TAX_METHOD , A.PI_PAY_FREQUENCY , A.PI_NAME_LAST , PI_NAME_FIRST , A.CHECK_DT from PS_PI_CHECK A , PSOPRDEFN B , PS_PI_EMPLID_TBL C where A.PI_EMPLID = C.PI_EMPLID and C.EMPLID = B.EMPLID

# 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 PAY_END_DT_ALT Date(10) DATE Pay Period End Date

Prompt Table: PI_IC_CHK_DT_VW

3 PI_CHECK_NBR Character(10) VARCHAR2(10) NOT NULL Payroll Check Number
4 PI_TOTAL_GROSS Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Gross
5 PI_TOTAL_TAXES Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Taxes
6 PI_TOTAL_DEDUCT Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Deductions
7 PI_NET_PAY Signed Number(20,3) DECIMAL(18,3) NOT NULL Net Pay
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 PI_RUN_NUM Number(4,0) SMALLINT NOT NULL Payroll Interface Run Number

Prompt Table: PI_RUN_TBL

11 PI_SYSTEM_ID Character(4) VARCHAR2(4) NOT NULL Payroll Interface System ID

Prompt Table: PI_SYSTEM_TBL

12 PI_CONFIG_ID Character(6) VARCHAR2(6) NOT NULL PI Configuration ID
13 PI_PAY_GROUP1 Character(6) VARCHAR2(6) NOT NULL PI Paygroup 1
14 PI_PAY_GROUP2 Character(6) VARCHAR2(6) NOT NULL PI Paygroup 2
15 PI_EMPLID Character(20) VARCHAR2(20) NOT NULL Payroll Interface EMPLID
16 PAY_END_DT Date(10) DATE Pay Period End Date
17 PI_CHECK_TYPE Character(4) VARCHAR2(4) NOT NULL Payroll Check Type
18 PI_CHECK_CODE Character(4) VARCHAR2(4) NOT NULL Payroll Check Code
19 PI_VOID_IND Character(4) VARCHAR2(4) NOT NULL Payroll Void Check Indicator
20 PI_TAX_METHOD Character(4) VARCHAR2(4) NOT NULL Payroll Tax Calc Method
21 PI_PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Payroll Pay Frequency
22 PI_NAME_LAST Character(30) VARCHAR2(30) NOT NULL PI Employee Last Name
23 PI_NAME_FIRST Character(30) VARCHAR2(30) NOT NULL PI Employee First Name
24 CHECK_DT Date(10) DATE Check date.