ACA_CALENDAR_YEARPrompt Table: ACA_CAL_YEAR
ACA_FORM_TYPE1095=1095-C
Prompt Table: PSURLDEFN
Prompt Table: PSURLDEFN
Y/N Table Edit
Default Value: %DateTime
ACA_YE_OPT(SQL Table) |
Index Back |
|---|---|
Year-End Form OptionsYear-End Form Options by ACA form type. |
| # | 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
Prompt Table: ACA_CAL_YEAR |
| 2 | ACA_FORM_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
ACA Form Type. The default Value is 1095-C
1095=1095-C |
| 3 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 4 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 5 | ACA_YE_FILEURLID | Character(30) | VARCHAR2(30) NOT NULL |
URL ID used to store and retrieve year-end pdf forms.
Prompt Table: PSURLDEFN |
| 6 | ACA_YE_XMLURLID | Character(30) | VARCHAR2(30) NOT NULL |
URL ID used to store and retrieve year-end xml data files.
Prompt Table: PSURLDEFN |
| 7 | ACA_SSN_MASK | Character(1) | VARCHAR2(1) NOT NULL |
SSN Mask indicator.
Y/N Table Edit |
| 8 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | LASTUPDDTTM | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %DateTime |