ACA_DEP_DATA_IDCVRG=Months of Coverage
CHAR1_DEFACA_DEP_CH1_PVW(SQL View) |
Index Back |
|---|---|
ACA Dependent Prompt ViewACA Dependent Prompt View |
| SELECT DISTINCT A.ACA_DEP_DATA_ID , A.CHAR1_DEF FROM PS_ACA_DX_DEP_CH1D A , PS_ACA_EMPLOYEE B WHERE A.ACA_DAT_EXTRACT_ID = B.ACA_DAT_EXTRACT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACA_DEP_DATA_ID |
Character(4) | VARCHAR2(4) NOT NULL |
ID used for the dependent ACA data
CVRG=Months of Coverage |
| 2 | CHAR1_DEF |
Character(1) | VARCHAR2(1) NOT NULL | Monthly Default Value |