RUN_CNTL_WTHD

(SQL Table)
Index Back

Run Control for 1099

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

Default Value: OPR_DEF_TBL_AP.OPRID

Prompt Table: OPR_DEF_TBL_AP

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID

Prompt Table: WTHD_RPT_DFN_VW

5 WTHD_FILE_TYPE Character(1) VARCHAR2(1) NOT NULL Type of File/Return
O=Original/Correction
R=Replacement
T=Test
6 WTHD_RPT_OPT Character(1) VARCHAR2(1) NOT NULL Reporting Option
B=Report and File
F=File Only
R=Report Only

Default Value: F

7 REPLACE_CHAR Character(2) VARCHAR2(2) NOT NULL Replacement Character
8 FILE_NAME_SHORT Character(30) VARCHAR2(30) NOT NULL File Name
9 ORIGINAL_SENT_MODE Character(1) VARCHAR2(1) NOT NULL Original Submission Mode
D=Magnetic/Disk
E=Electronic
T=Magnetic/Tape
10 MEDIA_TYPE Character(1) VARCHAR2(1) NOT NULL Media Type
D=Magnetic/Disk
E=Electronic
T=Magnetic/Tape
11 NIL_RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL NIL_RETURN_FLAG
12 EMPL_STATUS_FLAG Character(1) VARCHAR2(1) NOT NULL EMPL_STATUS_FLAG
13 SUBC_VERIFY_FLAG Character(1) VARCHAR2(1) NOT NULL SUBC_VERIFY_FLAG
14 INFO_CORRECT_FLAG Character(1) VARCHAR2(1) NOT NULL INFO_CORRECT_FLAG
15 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: WTHD_CAL_VW3

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

Prompt Table: WTHD_CAL_VW1

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

Prompt Table: WTHD_CAL_VW2

19 JPN_CPY_FLAG Character(1) VARCHAR2(1) NOT NULL Copy

Default Value: N