ACA_ALE_MEMBEREFFDTDefault Value: %date
ACA_ENTITY_TYPEALE=Applicable Large Employer
DGE=Designated Governmental Entity
XMT=Transmitter
LANGUAGE_CDACA_ALE_ADR_LNG(SQL Table) |
Index Back |
|---|---|
ACA_ALE_TBL_ADR-Rel lang tableACA ALE Entity definition related language table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACA_ALE_MEMBER |
Character(3) | VARCHAR2(3) NOT NULL | Used to contain value of ALE Member name |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | ACA_ENTITY_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Field used to differentiate ALE Member and its DGE Company. ALE Member has value as ALE, DGE company has value as DGE.
ALE=Applicable Large Employer DGE=Designated Governmental Entity XMT=Transmitter |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | ACA_DESCR | Character(75) | VARCHAR2(75) NOT NULL | Name |