ACA_DX_ALE_CH1D

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
4	ACA_ALE_DATA_ID	Character(4)	VARCHAR2(4) NOT NULL	ALE Member Monthly Data AGID=Aggregated Group Indicator EMCT=Total Employee Count FTCT=Full-Time Employee Count MECC=MEC Employee Offer Count MECF=Minimum Essential Coverage ID TRID=Sec 4980H Transition Relief ID
5	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
6	CHAR1_DEF	Character(1)	VARCHAR2(1) NOT NULL	Monthly Default Value Default Value: N
7	DEFAULT_IND	Character(1)	VARCHAR2(1) NOT NULL	An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default. Y/N Table Edit Default Value: N
8	ASOF_DAY_INMONTH	Character(4)	VARCHAR2(4) NOT NULL	Day month values used for ACA processing D1MN=First Day LDMN=Last Day MMDD=Specified Day
9	ACA_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	As of Day
10	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition) Prompt Table: ACA_DTEX_SQL_VW
11	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N