ACA_BAC020_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
6	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
7	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
8	ACA_SOURCEFILE	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs.
9	ACA_SOURCELOC	Character(254)	VARCHAR2(254) NOT NULL	Location where source XML file generated by one of the year end SQR programs is stored.
10	ACA_SRC_FILENAME	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs, including file path.
11	ACA_FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	ACA_EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
14	ACA_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Process type. C=Correction O=Original P=Replace Transmission Q=Replace Submission R=Reissue
15	ACA_FINAL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether final run or not. Y/N Table Edit
16	ACA_YE_RPT_BURST	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report bursting is required. Y/N Table Edit
17	ACA_COPY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Copy Type 1=Employee Copy
18	BURST_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Burst Field Name
19	ACA_BURST_ID	Character(40)	VARCHAR2(40) NOT NULL	Stores the value used for bursting a PDF file into separate employee-level files.
20	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
21	CONTENTID	Number(15,0)	DECIMAL(15) NOT NULL	Report ID
22	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
23	SEARCH_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Search Field Name
24	ACA_RPT_DEFN_ID_SS	Character(12)	VARCHAR2(12) NOT NULL	Report Definition to be used for Self-Sevice.
25	ACA_RPT_TMPL_ID_SS	Character(30)	VARCHAR2(30) NOT NULL	Report Template to be used for Self-Sevice.
26	ACA_YE_RPT_SS	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report destination is a self-service application.
27	ACA_SOURCEFILE2	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs.
28	ACA_SRC_FILENAM2	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs, including file path.
29	ACA_NOTIFY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether notification of availability for viewing a year-end form has been sent to employee. Y - notification already sent to employee N - notification not yet sent to employee
30	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
31	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
32	ACA_YE_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve year-end pdf forms.
33	ACA_FORM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	ACA Form Type. The default Value is 1095-C 1095=1095-C
34	ACA_CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	1094-C/1095-C Calendar Year