ACA_ALE_MEM_SUB (SQL Table)	Index Back
ACA ALE Member Transmittal ALE Member Transmittal/Submission Information.

ACA_ALE_MEM_SUB

(SQL Table)

ACA ALE Member Transmittal

ALE Member Transmittal/Submission Information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACA_DAT_EXTRACT_ID Character(10) VARCHAR2(10) NOT NULL Extract ID for the ACA data

2 ACA_ALE_MEMBER Character(3) VARCHAR2(3) NOT NULL Used to contain value of ALE Member name

3 ACA_CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL 1094-C/1095-C Calendar Year

4 ACA_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Process type.
C=Correction
O=Original
P=Replace Transmission
Q=Replace Submission
R=Reissue
Default Value: O

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

6 ACA_1094_SUBID Number(12,0) DECIMAL(12) NOT NULL Use to store 1094-C Submission ID number. Restriction:

7 ACA_RECEIPT_ID Character(30) VARCHAR2(30) NOT NULL ACA Receipt ID

8 ACA_TOT_PER_XMIT Number(12,0) DECIMAL(12) NOT NULL Total number of Forms submitted with this transmittal

9 ACA_AUTH_TRANSMIT Character(1) VARCHAR2(1) NOT NULL Authoritative Transmittal

10 ACA_TOT_FORMS_ALE Number(12,0) DECIMAL(12) NOT NULL Total number of Forms submitted with this transmittal

11 ACA_MEM_AGGREG_GRP Character(1) VARCHAR2(1) NOT NULL Is ALE Member a member of an Aggregated Group
Y/N Table Edit

12 ACA_UUID Character(36) VARCHAR2(36) NOT NULL UUID

13 ACA_XMIT_FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

14 ACA_XMIT_STATUS Character(1) VARCHAR2(1) NOT NULL Transmittal status.
A=Accepted
E=Accepted with Error
N=Not Transmitted
O=Created in Error
R=Rejected
Default Value: N

15 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

16 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACA_DAT_EXTRACT_ID	Character(10)	VARCHAR2(10) NOT NULL	Extract ID for the ACA data
2	ACA_ALE_MEMBER	Character(3)	VARCHAR2(3) NOT NULL	Used to contain value of ALE Member name
3	ACA_CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	1094-C/1095-C Calendar Year
4	ACA_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Process type. C=Correction O=Original P=Replace Transmission Q=Replace Submission R=Reissue Default Value: O
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	ACA_1094_SUBID	Number(12,0)	DECIMAL(12) NOT NULL	Use to store 1094-C Submission ID number. Restriction:
7	ACA_RECEIPT_ID	Character(30)	VARCHAR2(30) NOT NULL	ACA Receipt ID
8	ACA_TOT_PER_XMIT	Number(12,0)	DECIMAL(12) NOT NULL	Total number of Forms submitted with this transmittal
9	ACA_AUTH_TRANSMIT	Character(1)	VARCHAR2(1) NOT NULL	Authoritative Transmittal
10	ACA_TOT_FORMS_ALE	Number(12,0)	DECIMAL(12) NOT NULL	Total number of Forms submitted with this transmittal
11	ACA_MEM_AGGREG_GRP	Character(1)	VARCHAR2(1) NOT NULL	Is ALE Member a member of an Aggregated Group Y/N Table Edit
12	ACA_UUID	Character(36)	VARCHAR2(36) NOT NULL	UUID
13	ACA_XMIT_FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
14	ACA_XMIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transmittal status. A=Accepted E=Accepted with Error N=Not Transmitted O=Created in Error R=Rejected Default Value: N
15	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
16	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.