ACA_ALE_DATA_IDAGID=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
CHAR1_DEFACA_ALE_CH1_PVW(SQL View) |
Index Back |
|---|---|
ALE Member Prompt ViewALE Member Monthly Data Prompt View |
| SELECT DISTINCT A.ACA_ALE_DATA_ID , A.CHAR1_DEF FROM PS_ACA_DX_ALE_CH1D A , PS_ACA_ALE_MEMBER B WHERE A.ACA_DAT_EXTRACT_ID = B.ACA_DAT_EXTRACT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | CHAR1_DEF |
Character(1) | VARCHAR2(1) NOT NULL | Monthly Default Value |