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 |