ACA_DX_ALE_CNTD(SQL Table) |
Index Back |
|---|---|
ACA Form Code Series 1 RankingACA Form Code Series 1 Ranking |
| # | 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 | COUNT12_DEF | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 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 | ACA_SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQLID Criteria
Prompt Table: ACA_DTEX_SQL1VW |
| 11 | ACA_SQLID2 | Character(30) | VARCHAR2(30) NOT NULL |
SQLID Update
Prompt Table: ACA_DTEX_SQL2VW |
| 12 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |