ACA_ALE_MEMBER (SQL Table)	Index Back
ACA ALE Member ALE Member Infromation

ACA_ALE_MEMBER

(SQL Table)

ACA ALE Member

ALE Member Infromation

# 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
Prompt Table: ACA_DATEXTR_DEF

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

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

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

5 ACA_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Process flag for ACA
C=Replaced with Data Load
E=Merge Error
F=Finalized for Transmittal
I=PeopleSoft Extracted
M=Merged with Data Load
T=Transmittal Created
U=User Modified
V=Created in Error
Default Value: U

6 ACA_CORRECTION Character(1) VARCHAR2(1) NOT NULL Form 1094-C or Form 1095-C Correction.
Y/N Table Edit
Default Value: N

7 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

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.

#	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 Prompt Table: ACA_DATEXTR_DEF
2	ACA_ALE_MEMBER	Character(3)	VARCHAR2(3) NOT NULL	Used to contain value of ALE Member name Prompt Table: ACA_ALE_TBL
3	ACA_CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	1094-C/1095-C Calendar Year
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ACA_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Process flag for ACA C=Replaced with Data Load E=Merge Error F=Finalized for Transmittal I=PeopleSoft Extracted M=Merged with Data Load T=Transmittal Created U=User Modified V=Created in Error Default Value: U
6	ACA_CORRECTION	Character(1)	VARCHAR2(1) NOT NULL	Form 1094-C or Form 1095-C Correction. Y/N Table Edit Default Value: N
7	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
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.