ACA_ALE_MEMBERPrompt Table: ACA_ALE_TBL
ACA_CALENDAR_YEARPrompt Table: ACA_CAL_YEAR
Y/N Table Edit
Default Value: N
Default Value: %datetime
ACA_FORM_OPTS(SQL Table) |
Index Back |
|---|---|
ACA Common OptionACA Form Options by Company and Calendar Year. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACA_ALE_MEMBER |
Character(3) | VARCHAR2(3) NOT NULL |
Used to contain value of ALE Member name
Prompt Table: ACA_ALE_TBL |
| 2 | ACA_CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL |
1094-C/1095-C Calendar Year
Prompt Table: ACA_CAL_YEAR |
| 3 | ACA_ONLINE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Electronic ACA Form in Self Service (Y/N).
This option indicates whether or not the employees are able to view their ACA forms from the Self-Service.
Y/N Table Edit Default Value: N |
| 4 | 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. |
| 5 | 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 |