GPES_TAX345_AET

(SQL Table)
Index Back

Tax Generation AET

Tax Generation 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
6 PAY_END_DT Date(10) DATE Pay Period End Date
7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
8 CONTACT_PHONE Character(12) VARCHAR2(12) NOT NULL Contact Phone
9 YEARCD Character(4) VARCHAR2(4) NOT NULL Calendar Year
10 GPES_FILE_NAME Character(250) VARCHAR2(250) NOT NULL Name of a file, according to the process scheduler server.
11 GPES_AEAT_DEVICE Character(1) VARCHAR2(1) NOT NULL Device code
C=Compact Disk
D=Floppy Disk
D=Floppy Disk
T=Electronic Transmission
12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
13 SIGNATURE_CITY Character(30) VARCHAR2(30) NOT NULL Signature City
14 SIGNATURE_DT Date(10) DATE Signature Date
15 GPES_FILE_PATH Character(250) VARCHAR2(250) NOT NULL Output / Input file path
16 GPES_PYE_SELCT_OPT Character(1) VARCHAR2(1) NOT NULL Payee Select Option
A=All Payees
L=Listed Payees