RC_XTAX_TYP_CAN (SQL Table)	Index Back
RC for Tax Dedn Extract (CAN) Run Control table used to store the tax types to include in the Tax Deduction Extract process.

RC_XTAX_TYP_CAN

(SQL Table)

RC for Tax Dedn Extract (CAN)

Run Control table used to store the tax types to include in the Tax Deduction Extract process.

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 TAX_TYPE_CAN Character(4) VARCHAR2(4) NOT NULL Tax Type
Prompt Table: CAN_TAX_TYPE

4 PERIOD_END_DT Date(10) DATE Period End Date

5 PAYMENT_DT Date(10) DATE NOT NULL Payment Date

#	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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	TAX_TYPE_CAN	Character(4)	VARCHAR2(4) NOT NULL	Tax Type Prompt Table: CAN_TAX_TYPE
4	PERIOD_END_DT	Date(10)	DATE	Period End Date
5	PAYMENT_DT	Date(10)	DATE NOT NULL	Payment Date