EMPLIDLASTUPDDTTMDefault Value: %datetime
C=Consent Granted
N=No Consent Received
R=Consent Reset by Employer
W=Consent Withdrawn
N=Email Notification Not Sent
Y=Email Notification Sent
ACA_RESET_TA0(SQL Table) |
Index Back |
|---|---|
Employee ConsentUsed in Self-Service Form 1095-C. This record stores employee consent information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | 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 |
| 3 | 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. |
| 4 | ACA_SS_CON_CURRENT | Character(1) | VARCHAR2(1) NOT NULL |
Employee 1095-C Consent. This field stores the employees� current consent status.
C=Consent Granted N=No Consent Received R=Consent Reset by Employer W=Consent Withdrawn |
| 5 | ACA_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
ACA Email Notification Flag
N=Email Notification Not Sent Y=Email Notification Sent |