WTHD_POST_RPT

(SQL Table)
Index Back

Withholding Post Run Control

09/11/2002 - LLie - ICE 28473000 Remove the related language record.. WTHDPOSTAP_LANG

# 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 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 REQUEST_DT Date(10) DATE Request Date
5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 PROCESS_ORIGIN Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Process Origin in Other
P=Process Origin in PeopleSoft

Default Value: P

9 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

10 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID

Prompt Table: WTHD_RPT_DFN

11 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

Prompt Table: SP_SETID_NONVW

12 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: WTHD_CAL_VW3

13 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

Prompt Table: WTHD_CAL_VW1

14 PERIOD Number(3,0) SMALLINT NOT NULL Period

Prompt Table: WTHD_CAL_VW2

15 FROM_DT Date(10) DATE From Date

Default Value: %date

16 THRU_DATE Date(10) DATE Through Date

Default Value: %date

17 RPT_DT Date(10) DATE NOT NULL Report Date

Default Value: %date

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

Prompt Table: SP_SETID_NONVW

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

Prompt Table: WTHD_CNTL

20 WTHD_CERT_FLG Character(1) VARCHAR2(1) NOT NULL Withhold Certificate
21 WTHD_QRETURN_FLG Character(1) VARCHAR2(1) NOT NULL Field used to check whether to run TDS Quarterly Return process or not