ACA_FORM_RCTL

(SQL Table)
 Index Back

ACA Form Run Control

Run information to be passed to XML Publisher.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
5 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
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_OSPLATFORM Character(4) VARCHAR2(4) NOT NULL Operating System Platform. Valid Values are: UNIX, MVS, NT
12 ACA_FORM_TYPE Character(4) VARCHAR2(4) NOT NULL ACA Form Type. The default Value is 1095-C
1095=1095-C
13 ACA_FINAL_PRINT Character(1) VARCHAR2(1) NOT NULL Identifies whether final run or not.
14 ACA_COPY_TYPE Character(1) VARCHAR2(1) NOT NULL Copy Type
1=Employee Copy
15 ACA_YE_RPT_BURST Character(1) VARCHAR2(1) NOT NULL Indicates if report bursting is required.
16 ACA_YE_RPT_SS Character(1) VARCHAR2(1) NOT NULL Indicates if report destination is a self-service application.
17 ACA_RPT_DEFN_ID_SS Character(12) VARCHAR2(12) NOT NULL Report Definition to be used for Self-Sevice.
18 ACA_RPT_TMPL_ID_SS Character(30) VARCHAR2(30) NOT NULL Report Template to be used for Self-Sevice.
19 ACA_SOURCEFILE2 Character(254) VARCHAR2(254) NOT NULL Filename of XML file generated by one of the year end forms SQR programs.
20 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.
21 ACA_FILE_COUNT Number(3,0) SMALLINT NOT NULL File count.
22 ACA_YE_XMLURLID Character(30) VARCHAR2(30) NOT NULL URL ID used to store and retrieve year-end xml data files.
23 ACA_CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL 1094-C/1095-C Calendar Year