WTHD_SENT_RC

(SQL Table)
Index Back

IRS file sent process request

IRS file sent process request record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPR_DEF_TBL_AP

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 PROCESS_DTTM DateTime(26) TIMESTAMP Process Date Time
5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
8 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID

Prompt Table: WTHD_RPT_DFN

9 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

10 WTHD_CNTL_ID Character(10) VARCHAR2(10) NOT NULL Control ID

Prompt Table: WTHD_CNTL

11 INCL_NON_COMP_AMT Character(1) VARCHAR2(1) NOT NULL Include Box &
A=All
E=Exclude Non Employee Compensat
I=Include Non Employee Compensat

Default Value: A

12 IRS_FILE_SENT Character(1) VARCHAR2(1) NOT NULL IRS FILE SENT

Default Value: N