ACA_RPT_OPT_VW1

(SQL View)
 Index Back

Year-End Form Report Options

Year-End Form Report Options by ACA Form Type.

SELECT ACA_CALENDAR_YEAR , ACA_FORM_TYPE , REPORT_DEFN_ID , TMPLDEFN_ID , ACA_COPY_TYPE , ACA_YE_RPT_BURST , ACA_YE_RPT_SS , ACA_RPT_BATCH_SIZE FROM PS_ACA_YE_OPT_RPT WHERE ACA_FORM_TYPE = '1095'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACA_CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL 1094-C/1095-C Calendar Year
2 ACA_FORM_TYPE Character(4) VARCHAR2(4) NOT NULL ACA Form Type. The default Value is 1095-C
1095=1095-C

Prompt Table: ACA_YE_OPT

3 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

Prompt Table: ACA_RPT_DEFN_VW

4 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

Prompt Table: ACA_RPT_TMPL_VW

5 ACA_COPY_TYPE Character(1) VARCHAR2(1) NOT NULL Copy Type
1=Employee Copy
6 ACA_YE_RPT_BURST Character(1) VARCHAR2(1) NOT NULL Indicates if report bursting is required.

Y/N Table Edit

7 ACA_YE_RPT_SS Character(1) VARCHAR2(1) NOT NULL Indicates if report destination is a self-service application.

Y/N Table Edit

Default Value: N

8 ACA_RPT_BATCH_SIZE Number(5,0) INTEGER NOT NULL Indicates the batch sizes for breaking down a large report.