AP_TIN_EXT_AET

(SQL Table)
Index Back

Extract TIN File AET

Extract TIN File AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
5 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
9 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
10 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL TIN Type
F=Federal Employer ID Number
S=Social Security Number
11 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number
12 NAME1_WTHD Character(40) VARCHAR2(40) NOT NULL Name 1
13 NAME2_WTHD Character(40) VARCHAR2(40) NOT NULL Name 2
14 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
15 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
16 FL_TIN_NUMBER Character(9) VARCHAR2(9) NOT NULL File Layout TIN NUMBER
17 FL_NAME Character(40) VARCHAR2(40) NOT NULL File Layout TIN NAME
18 FL_ACCOUNT Character(20) VARCHAR2(20) NOT NULL File Layout TIN ACCOUNT
19 AP_TIN_STATUS_CD Character(1) VARCHAR2(1) NOT NULL TIN Status Matching process
E=Error
F=Format Error
M=Matched
N=New
P=Pending
20 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
21 AP_TINLOAD_CNT1 Number(8,0) INTEGER NOT NULL Numbers of IRS File rows returned.
22 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
23 AP_TIN_ERROR_FLG Character(1) VARCHAR2(1) NOT NULL TIN Extract File Error Flag
24 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause