ACA_ALE_MO_CNT(SQL Table) |
Index Back |
|---|---|
ACA ALE Monthly CountACA ALE Monthly Count |
| # | 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 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | 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 |
| 6 | ACA_DATA_SRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ACA Data Source Type
C=Replaced with Data Load E=Error M=Merged with Data Load P=PeopleSoft Generated T=Third Party Data U=Updated U=Updated |
| 7 | ACA_BOX_ID | Character(10) | VARCHAR2(10) NOT NULL | Box Identifier |
| 8 | COUNT12_ALL | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 9 | COUNT12_01 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 10 | COUNT12_02 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 11 | COUNT12_03 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 12 | COUNT12_04 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 13 | COUNT12_05 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 14 | COUNT12_06 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 15 | COUNT12_07 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 16 | COUNT12_08 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 17 | COUNT12_09 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 18 | COUNT12_10 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 19 | COUNT12_11 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 20 | COUNT12_12 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |