ACA_DEP_DATA_IDCVRG=Months of Coverage
CHAR1_DEFACA_DEP_CH1DV(SQL View) |
Index Back |
|---|---|
ACA Dependent Data LoadACA Dependent Data Load prompt view |
| SELECT DISTINCT A.ACA_DEP_DATA_ID , A.CHAR1_DEF FROM PS_ACA_DX_DEP_CH1D A , PS_ACA_ALE_LOAD B WHERE A.ACA_DAT_EXTRACT_ID = B.ACA_DAT_EXTRACT_ID AND A.EFFDT = ( SELECT MAX(M.EFFDT) FROM PS_ACA_DX_DEP_CH1D M WHERE A.ACA_DAT_EXTRACT_ID = M.ACA_DAT_EXTRACT_ID AND M.EFFDT <= %DateIn(%NumToChar(B.ACA_CALENDAR_YEAR) %CONCAT '-12-31')) AND B.ACA_CALENDAR_YEAR = ( SELECT MAX(B1.ACA_CALENDAR_YEAR) FROM PS_ACA_ALE_LOAD B1 WHERE B.ACA_DAT_EXTRACT_ID = B1.ACA_DAT_EXTRACT_ID ) AND A.EFFSEQ = ( SELECT MAX(M.EFFSEQ) FROM PS_ACA_DX_DEP_CH1D M WHERE A.ACA_DAT_EXTRACT_ID = M.ACA_DAT_EXTRACT_ID AND M.EFFDT = A.EFFDT) |
| # | 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 |